Description

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:

•         Bachelor’s degree in Computer Science, Information Systems,

Accounting, or a related field.

•         7+ years of experience in SQL Server database administration in

enterprise environments.

•         5+ years of direct experience with Microsoft Dynamics GP, with an

emphasis on General Ledger system administration.

•         Advanced expertise in T-SQL, query optimization, and performance

tuning.

•         Demonstrated knowledge of accounting principles and financial data

workflows.

•         Strong experience with backup/recovery strategies, high availability

configurations, and database security practices.

•         Proven ability to collaborate cross-functionally with Finance, IT, and

executive stakeholders.

Preferred Qualifications:

•         Experience with Dynamics GP integration tools (e.g., eOne

SmartConnect, Integration Manager).

•         Familiarity with additional GP modules such as Payables, Receivables,

and Fixed Assets.

•         Power BI or other business intelligence tools for financial reporting.

•         Experience working in a SOX-compliant or audited environment

Key Skills

Education

Bachelor's degree