SQL Server DBA (Microsoft SQL Server)

TL;DR

SQL Server DBA (Microsoft SQL Server): Architecting, administering, and optimizing enterprise Microsoft SQL Server database environments with an accent on high availability, security, and operational excellence. Focus on performance tuning, disaster recovery design, complex incident troubleshooting, and modernization/automation across on-prem and AWS-hosted platforms.

Location: Chicago, Illinois; Downers Grove, Illinois (onsite)

Salary: $111,000–$186,700 per year

Company

hirify.global is a specialized insurer providing property & casualty insurance solutions.

What you will do

• Serve as a principal technical authority for Microsoft SQL Server architecture, administration, performance, security, and operational support.
• Design, install, configure, upgrade, patch, and maintain SQL Server environments across development, test, staging, and production.
• Administer advanced SQL Server technologies including Always On Availability Groups, Failover Cluster Instances, replication, SQL Agent, SSIS, and SSRS.
• Implement high availability and disaster recovery solutions (backup/restore, restore procedures, replication, failover testing, recovery planning).
• Perform advanced performance tuning (query optimization, execution plan analysis, indexing, statistics, configuration tuning, workload analysis) and proactive monitoring.
• Lead SQL Server modernization/migration and build automation using PowerShell, Python, and Infrastructure as Code (IaC) tools; support production incidents and on-call response.

Requirements

• 10+ years of hands-on experience administering enterprise databases with a strong focus on Microsoft SQL Server.
• Extensive experience with SQL Server installation, configuration, upgrades, patching, security, and support in large-scale enterprise environments, including AWS.
• Advanced knowledge of SQL Server architecture and capabilities: Database Engine, Always On Availability Groups, Failover Cluster Instances, replication, backup/recovery, and performance tuning.
• Experience with performance troubleshooting and tuning: query optimization, execution plan analysis, indexing strategies, and database troubleshooting.
• Experience supporting SQL Server across on-premises, hybrid, and AWS cloud platforms.
• Onsite work at the hirify.global office.

Culture & Benefits

• Annual discretionary bonus eligibility.
• Benefits include Medical, Dental, Vision, PTO, and 401k.
• Onsite role with a focus on operational excellence and continuous improvement.

Hiring process

• Interviews and evaluation of SQL Server DBA expertise, architecture decisions, and incident/performance problem-solving.
• Discussion of experience with AWS/hybrid SQL Server environments and automation/IaC practices.