SQL Database Administrator

Job Description

We are seeking an experienced Senior SQL Database Administrator (DBA) with specialized expertise in Microsoft Dynamics GP (Great Plains) and deep functional knowledge of the General Ledger (GL) module. This role will serve as a key technical leader, responsible for maintaining a high-performing and secure SQL Server environment, optimizing ERP data workflows, and providing strategic support for financial operations and reporting.

This position is ideal for a seasoned professional who thrives at the intersection of database engineering and financial systems administration , and is passionate about enabling data-driven decision-making across the enterprise.

Job Title : Senior SQL Database Administrator – Great Plains General Ledger Administration

Location : [Insert Location]

Department : IT / Financial Systems

Reports To : Director of IT or CIO

Employment Type : Full-Time OR Contract (Open to Both)

Key Responsibilities :

• Oversee and optimize all aspects of Microsoft SQL Server infrastructure supporting Microsoft Dynamics GP.
• Serve as the subject matter expert for General Ledger administration within Great Plains, including account structures, journal entries, posting routines, and year-end processes.
• Design, implement, and fine-tune SQL objects (stored procedures, views, functions, indexes) to improve system performance and financial data accuracy.
• Lead complex troubleshooting efforts for both technical (database) and functional (GL) issues, collaborating with Finance and IT stakeholders.
• Support monthly, quarterly, and annual financial close processes by ensuring ERP data availability and integrity.
• Monitor database performance and proactively address capacity, security, and availability issues.
• Manage data integrations between Dynamics GP and other financial or reporting systems.
• Develop and maintain robust reporting solutions (using SSRS, Management Reporter, or Power BI) to support financial analysis and compliance requirements.
• Maintain documentation for database architecture, data flows, and system configurations.
• Provide leadership and mentorship to junior DBAs and analysts, fostering a high-performance data environment.

Required Qualifications :

Preferred Qualifications :

We are an Equal Opportunity Employer