Microsoft Dynamics AX 2009 ERP & SQL Server Administrator

MDC Precision is seeking a hands-on Microsoft Dynamics AX 2009 ERP & SQL Server Administrator to own the day-to-day stability, security, availability, and technical support of our Dynamics AX 2009 environment.

This role spans the AX application, Application Object Server (AOS), Microsoft SQL Server database, Citrix-published application environment, integrations, reporting, user access, and business operations. The successful candidate will troubleshoot production issues, administer environments and security, coordinate releases, protect data integrity, and partner closely with business users, developers, infrastructure teams, and external vendors.

This role also responsible for security controls, technical documentation, disaster-recovery readiness, and contributions to future ERP modernization planning.

Candidates must be legally authorized to work in the United States without employer sponsorship. We are unable to sponsor or transfer employment-based visas (including H-1B, OPT/STEM OPT extensions requiring future sponsorship, TN, or similar) for this position, either at the time of hire or at any point in the future.

Position Description

• Administer and support Microsoft Dynamics AX 2009 production, test, development, and disaster recovery environments.
• Own routine AX technical administration, including AOS services, configuration, client connectivity, environment health, service accounts, and related Windows services.
• Monitor and troubleshoot AX performance, user sessions, batch jobs, alerts, workflow processes, integrations, application errors, and availability issues.
• Analyze AX and SQL performance problems using AX tracing, long-running-query analysis, SQL Server monitoring, logs, and event data; partner with developers and infrastructure teams on root-cause fixes.
• Administer AX users, groups, roles, permissions, segregation-of-duties controls, service accounts, and periodic access reviews.
• Support AX client access delivered through Citrix Workspace, Citrix Virtual Apps and Desktops, or comparable published-application technology.
• Administer and support the SQL Server environment hosting AX databases: health checks, job monitoring, backup verification, restore testing, capacity planning, index/statistics maintenance, SQL Agent jobs, permissions, and performance troubleshooting.
• Develop and maintain SQL queries, stored procedures, scripts, views, and controlled data extracts for investigation, reporting, reconciliation, and integration support.
• Apply strict data-integrity practices: avoid unapproved direct SQL changes to AX transactional data; use approved AX processes, tested scripts, or vendor-supported methods with documented change approval and rollback plans.
• Support AX data imports, exports, migration activities, reconciliation, master-data validation, and issue remediation.
• Support integrations between AX 2009 and third-party systems, including payment platforms, EDI, SFTP, warehouse systems, reporting tools, custom applications, APIs, and scheduled processes.
• Troubleshoot AX customizations, X++ code issues, MorphX objects, labels, configurations, and deployment packages in coordination with developers or external AX partners.
• Coordinate code promotion and deployments across development, test, UAT, and production environments using disciplined release-management, testing, approval, rollback, and documentation practices.
• Manage environment refreshes, database restores, test-data handling, configuration changes, and release validation.
• Maintain comprehensive technical documentation: architecture diagrams, database dependencies, integration inventories, service accounts, support runbooks, recovery procedures, and change records.
• Coordinate patching, vulnerability remediation, endpoint protection compatibility, backup operations, disaster recovery exercises, and recovery validation with infrastructure and cybersecurity teams.