Senior Database Administrator

eimagine; Indianapolis (IN); Hybrid; USD 105,000 - 145,000; Full time

Job summary

eimagine is seeking a SQL Server Database Administrator (DBA) to manage on-premises SQL Server environments. The role focuses on performance, availability, security, reliability, and recovery across mission-critical systems.

The ideal candidate has extensive SQL Server experience, tuning skills, and a track record of high-availability implementations. Responsibilities include backups, disaster recovery planning, security management, and collaboration with developers to optimize queries and

Qualifications

• 8+ years of experience in enterprise SQL Server environments.
• Strong knowledge of T-SQL, stored procedures, indexing and query tuning.
• Experience with Always On Availability Groups, clustering and replication.
• Proficiency with SSMS, PowerShell and monitoring/diagnostics tools.
• Windows Server and storage concepts, disaster recovery planning.

Responsibilities

• Install, configure and maintain on-prem SQL Server 2019/2022 instances.
• Monitor performance, tune queries, manage backups and restore tests.
• Design HA/DR solutions including Always On and replication.
• Manage security, roles, encryption, and data protection policies.
• Collaborate with developers to optimize queries and schemas.
• Plan capacity, perform routine maintenance, and respond to incidents.

Job description

At eimagine, we know that your best work happens when you live your best life and share your unique talents, so we do everything we can to be intentional in a remote enabled environment to make that possible. Recognized as a Best Places to Work since 2015, we are a team of humbly confident people who are proud of their craft, continuous learners, and have been known to cheer loudly for our teammates. For over 24 years we have been helping clients navigate technology and business change, while staying committed to delivering value & outcomes that enables their success.

Due to our growth, we are seeking a SQL Server Database Administrator (DBA) to manage and support on-premises Microsoft SQL Server environments. This role ensures database performance, availability, security, reliability, and recovery across mission-critical systems. The ideal candidate brings strong experience in SQL Server administration, performance tuning, backup and recovery, and high availability in enterprise environments. Are you ready to eimagine better and partner with our clients to create business value through IT solutions?

Description of Duties

• Install, configure, maintain, patch, and upgrade on-premises SQL Server 2022 instances across development, QA, and production environments.
• Monitor database performance, identify bottlenecks, and tune queries, indexes, execution plans, CPU, memory, and I/O utilization.
• Design and maintain full, differential, and transaction log backup strategies, and regularly test restore procedures.
• Implement and support high availability and disaster recovery solutions, including Always On Availability Groups, clustering, and replication.
• Manage database users, roles, permissions, encryption, and security policies in alignment with corporate and regulatory standards.
• Monitor database health, logs, alerts, storage, and growth trends to maintain reliability and support capacity planning.
• Perform routine maintenance, including index rebuilds, statistics updates, and integrity checks.
• Automate recurring database administration tasks using PowerShell, SQL Server Agent, or other approved tools.
• Respond to production incidents and outages, provide troubleshooting, and complete root cause analysis for complex database issues.
• Partner with developers to optimize queries and database design, and support deployments, releases, and schema changes.
• Plan and implement scaling strategies that support business growth and evolving system demands.
• 8+ years of experience as a SQL Server DBA in enterprise environments.
• Strong experience administering SQL Server 2019 and SQL Server 2022 in on-premises enterprise environments.
• Proven ability to upgrade and migrate legacy SQL Server versions (2012/2016) to currently supported releases.
• Deep knowledge of T-SQL, stored procedures, triggers, indexing, backup and recovery models, and query optimization.
• Experience with high availability technologies, including Always On Availability Groups, clustering, and replication.
• Proficiency with SQL Server Management Studio (SSMS), monitoring tools, and performance diagnostics.
• Solid understanding of Windows Server, storage concepts, database security, access control, and disaster recovery planning, including RPO and RTO concepts.
• Experience automating database administration tasks with PowerShell, SQL Server Agent, or comparable scripting tools.
• Proven ability to troubleshoot complex production issues and communicate clearly with technical and non-technical stakeholders.
• Experience supporting enterprise, multi-server environments and hybrid on-premises and cloud architectures preferred.
• Exposure to SSIS, SSRS, data warehousing concepts, or relevant Microsoft Azure and SQL certifications preferred.
• Bachelor’s degree in computer science, information systems, or a related field, or equivalent job-related experience required.