SQL Server DBA (Senior)

Alpac Inc; Ann Arbor (MI); On-site; USD 120,000 - 180,000; Full time

Job summary

Alpac Inc in Michigan is seeking a senior SQL-Server DBA to lead design, development, and consolidation of SQL Server environments across on-prem, cloud, and hybrid deployments. Candidate must have deep expertise in SQL Server 2022 and Windows Server 2022, with a proactive mindset for automation.

You will oversee performance tuning, HA/DR, migrations, and modernizing processes, using PowerShell, SQL Agent Jobs, and CI/CD.

Qualifications

• Senior SQL-Server DBA with deep SQL Server 2022 expertise.
• Experience with high availability, disaster recovery, and migrations.
• Strong automation, scripting, and CI/CD skills.
• Ability to work with on-prem, cloud, and hybrid SQL environments.
• Excellent communication and problem-solving abilities.

Responsibilities

• Administer, monitor, and optimize large SQL Server 2022 environments (on-prem, hybrid, cloud).
• Ensure HA/DR using Always On, clustering, replication, backups.
• Performance tuning, index optimization, and query plan analysis.
• Design and execute migrations and version upgrades with minimal downtime.
• Automate tasks with PowerShell and SQL Agent Jobs; integrate with CI/CD.
• Support Azure SQL and Managed Instance deployments.
• Collaborate with application teams for scalable DB architectures.
• Troubleshoot blocking, deadlocks, and resource contention.
• Maintain documentation of configurations, SOPs, and recovery plans.

Skills

SQL Server

Performance tuning

Index optimization

Query plan analysis

PowerShell

CI/CD pipelines

Cloud deployments

Cross-functional collaboration

Tools

SQL Agent

SSIS

Job description

Need senior SQL-Server DBA to assist with development and implementation of SQL-Server consolidation strategy.

DBA to oversee the design, implementation, and optimization of mission-critical SQL Server environments — on-premises and in the cloud. This position requires deep expertise in SQL Server 2022, Windows Server 2022, and a proactive mindset for automation and modernization.

Key Responsibilities:

• Administer, monitor, and optimize large-scale SQL Server 2022 environments (on-prem, hybrid, and cloud).
• Ensure HA/DR (High Availability / Disaster Recovery) using Always On Availability Groups, clustering, replication, and backups.
• Perform advanced performance tuning, index optimization, and query plan analysis.
• Design and execute database migrations and version upgrades with minimal downtime.
• Automate routine tasks using PowerShell and SQL Agent Jobs and integrate with CI/CD pipelines.
• Support Azure SQL, Managed Instance, and hybrid deployments as needed.
• Collaborate with application teams to design scalable and efficient database architectures.
• Troubleshoot escalated database issues, including blocking, deadlocks, and resource contention.
• Maintain detailed documentation of database configurations, SOPs, and recovery plans.

Some programming experience, exposure to SSIS is good to have.

NOTE: This is not an operational level position.

Strong oral and written communication skills along with problem resolution skills is highly desirable. Must be able to work independently with minimum supervision as well as with cross-functional teams.