Loading...

MS Dynamics AX Administrator / SQL DBA

 

 

If you like change, change to us

 

We are an international mid sized group with appetite for innovations, approachable management, lead by objectives / targets which give the opportunity of a wide range of empowerment. We as a growth oriented market leader invite you to join us on our journey from good to great!

 

MS Dynamics AX Administrator / SQL DBA

 

As a part of the international team of AX Admins you will act as the 2nd support line for Dynamics AX environments with a knowledge of:

  •  
  • Dynamics AX 2012 performance monitoring and analysis
  • Dynamics 365 Finance and Operations performance monitoring and analysis
  • MS SQL Server performance monitoring and analysis
  • Diagnose and troubleshoot MS SQL Server databases errors.
  • Control access permissions and privileges on MS SQL Server
  • Preparation of AX 2012/ D365 build and deployments
  • Produce technical documentation in relation to the above
  • communicate regularly with technical, applications and operational staff to ensure database integrity and security
     

Requirements:

  • Working experience with MS Dynamics 2012 / D365 on the administrator/developer level
  • Advanced knowledge of SQL Server data stores: row store and column store.
  • Advanced knowledge of indexes, index management, index design, index optimisation and index statistics.
  • Advanced Knowledge of SQL Server performance tuning, especially around query statements
  • Advanced knowledge of query and query parallelism in SQL Server
  • Advanced knowledge of database tuning
  • Good knowledge of SQL Server DMV’s especially around statistics, data store and performance
  • Good knowledge of SQL Server settings and database setting and the impact on performance
  • Good knowledge of SQL Server partitioning and file and filegroup design
  • Experience with SQL Server H/A and AO clustering solutions
  • Experience with Database Administration in general for MS SQL Server on both on-premise & cloud platforms (MS Azure preferred).
  • Impeccable attention to detail

  • Strong command of TSQL and SQL server tools
  • Monitoring the performance of hardware and database

  • Monitoring performance and manage aprameters of AX environment
  • Experience in troubleshooting and resolving general database problems for a high transaction volume
  • Experience in testing/validating database components.
  • Experience in maintaining AX environments

 

Matching profile skills:

  • Strong communication skills
  • Excellent written and verbal communication skills in English
  • Used to work in cross divisional teams
  • Team player
  • Sense for urgency
  • Experience with HA installations for SQL / SSRS / SSAS / WMDP
  • Experience in Team Foundation Server / Build and release process
  • Experience with LCS / Azure Dev Ops / Azure Portal

 

 

 

Contact for this position: Marta Celina Rachwał 

 

NORMA Group Human Resources
Edisonstraße 4
63477 Maintal, Germany

 

www.normagroup.com