Role Overview
ThoughtFocus is hiring a Senior SQL DBA (Great Plains). This is a full-time role in IN. Part of ThoughtFocus's Security hiring. Full responsibilities, required qualifications, and the apply link are listed in the description below.
Resume Keywords to Include
Make sure these keywords appear in your resume to improve ATS scoring
Job Description
As a Senior SQL Database Administrator (DBA) specializing in Microsoft Dynamics GP, your role will be crucial in maintaining a high-performing and secure SQL Server environment. You will play a key part in optimizing ERP data workflows and providing strategic support for financial operations and reporting. Your expertise in General Ledger (GL) administration within Great Plains will be essential for this position.
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 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 setting.
Required Qualifications:
- Bachelors 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.
In addition to the above job requirements, working experience in a SOX-compliant or audited environment would be beneficial for this role. As a Senior SQL Database Administrator (DBA) specializing in Microsoft Dynamics GP, your role will be crucial in maintaining a high-performing and secure SQL Server environment. You will play a key part in optimizing ERP data workflows and providing strategic support for financial operations and reporting. Your expertise in General Ledger (GL) administration within Great Plains will be essential for this position.
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 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 setting.
Required Qualifications:
- Bachelors 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 wit
Frequently Asked Questions
How do I apply for the Senior SQL DBA (Great Plains) position at ThoughtFocus?
Use the Apply button above to submit your application directly to ThoughtFocus. Most applications take less than 5 minutes if your resume and contact details are ready, and you'll be routed to the employer's official application system to finish.
Where is the Senior SQL DBA (Great Plains) position at ThoughtFocus located?
This position is based in IN. ThoughtFocus has not indicated remote or hybrid options for this role, so candidates should plan for on-site work.
What does a Senior SQL DBA (Great Plains) at ThoughtFocus earn?
ThoughtFocus has not disclosed a salary range in this posting. Many employers share specifics later in the interview process; you can also ask during a recruiter screen if compensation transparency is important to you.
When was the Senior SQL DBA (Great Plains) role at ThoughtFocus posted?
This role was posted on April 6, 2026 (70 days ago). It's still listed as actively hiring; we re-confirm openings against the source system multiple times per day and remove closed roles.
How much experience does the Senior SQL DBA (Great Plains) role at ThoughtFocus require?
This is a senior-level position. Most senior roles call for 5+ years of directly relevant experience. ThoughtFocus lists their specific requirements in the description below, so review the must-have qualifications closely before applying.
AI-powered job search
Get every job scored to your resume
Upload your resume and get jobs ranked, your resume tailored, and employee contacts found automatically.
Get Started FreeNo credit card to start