AX 2009 ERP & SQL Server Admin | Stability & Security Lead

MDC Precision, LLC; Hayward (CA); On-site; USD 120,000 - 150,000; Full time

Job summary

MDC Precision, LLC is seeking a hands-on Microsoft Dynamics AX 2009 ERP & SQL Server Administrator to own day-to-day stability, security, availability, and support of the AX 2009 environment in Hayward, CA.Responsibilities include managing AX/ AOS, SQL Server, Citrix-based access, and integrations with a strong focus on data integrity and disaster-recovery readiness.

The role requires collaboration with developers, infrastructure teams, and external vendors to ensure smooth operation and future

Qualifications

• 5+ years of hands-on technical experience supporting Microsoft Dynamics AX, including production support for AX 2009.
• Proven AX 2009 administration experience: AOS, client config, user security, and batch processing.
• 3+ years of practical Microsoft SQL Server experience supporting production ERP databases.
• Strong SQL skills: complex queries, views, stored procedures, SQL Agent, data validation.
• Experience with SQL Server backup/restore, maintenance, and monitoring.
• Experience troubleshooting AX/SQL performance: long-running queries, blocking, indexing.
• Experience supporting ERP interfaces, file-based integrations, SFTP workflows.
• Windows Server/Active Directory/DNS, service accounts, NTFS permissions.
• Experience with Citrix Workspace or published apps.
• Knowledge of change management, testing, release management, and incident management.

Responsibilities

• Administer and support AX 2009 production, test, development, and disaster recovery environments.
• Own routine AX technical administration: AOS, configuration, client connectivity, environment health, service accounts.
• Monitor and troubleshoot AX performance, sessions, batch jobs, alerts, workflows, and availability.
• Analyze AX/SQL performance; partner with developers and infra on root-cause fixes.
• Administer AX users, groups, roles, permissions, and access reviews.
• Support AX client access via Citrix Workspace or published applications.
• Manage SQL Server environments hosting AX databases: backups, restores, maintenance, and monitoring.
• Develop and maintain SQL queries, stored procedures, and data extracts.
• Apply strict data-integrity practices and approved change processes.
• Coordinate patching, disaster-recovery exercises, and release validation with infra and security teams.
• Maintain comprehensive technical documentation: runbooks, architecture diagrams, dependencies.

Skills

AX 2009 administration

SQL Server administration

Citrix Workspace

Windows Server/AD/DNS

Change/release management

Education

Bachelor's degree in IT/CS or related field

Tools

Microsoft Dynamics AX 2009

AOS

SSRS/SSIS/SSAS

Job description

MDC Precision, LLC is seeking a hands-on Microsoft Dynamics AX 2009 ERP & SQL Server Administrator to own day-to-day stability, security, availability, and support of the AX 2009 environment in Hayward, CA.Responsibilities include managing AX/ AOS, SQL Server, Citrix-based access, and integrations with a strong focus on data integrity and disaster-recovery readiness.

The role requires collaboration with developers, infrastructure teams, and external vendors to ensure smooth operation and future