Senior SQL Server DBA: HA/DR & Performance Expert

Infinite Computer Solutions; Campus (IL); On-site; USD 27,000 - 33,000; Full time

Job summary

Infinite Computer Solutions in Illinois seeks a hands-on SQL Server DBA to install, configure, and upgrade SQL Server instances (2016/2019/2022). You will monitor performance, ensure backup/restore strategies, and support high availability and disaster recovery setups.

Responsibilities include managing security, maintenance plans, performance troubleshooting with DMVs and execution plans, and collaborating with app, infra, and security teams to meet SLAs.

Qualifications

• Hands-on experience as a SQL Server DBA
• Strong MS SQL Server knowledge (2016/2019/2022)
• Proficiency in T-SQL, stored procedures, and query optimization
• Experience with backup/recovery models and HA/DR technologies
• Knowledge of SQL Server Agent jobs, maintenance plans, and DBCC commands
• Familiarity with monitoring tools (SQL Sentry, Redgate, SCOM, Idera, or DMVs)
• Basic understanding of Windows Server, storage, and networking fundamentals
• Good communication, troubleshooting, and documentation skills
• Ability to work independently as well as collaboratively in a team environment

Responsibilities

• Install, configure, and upgrade SQL Server instances (2016/2019/2022)
• Monitor database performance, health, and capacity; proactively identify and resolve issues
• Implement and manage backup/restore strategies; ensure disaster recovery readiness
• Manage database security: logins, roles, permissions, and auditing
• Perform routine maintenance: index rebuilds, statistics updates, integrity checks (DBCC)
• Monitor SQL Server Agent jobs, alerts, and scheduled tasks; troubleshoot job failures
• Perform query tuning and performance troubleshooting using execution plans and DMVs
• Support and maintain High Availability/Disaster Recovery setups (Always On, Log Shipping, Replication, Clustering)
• Execute and validate backup/restore, failover, and DR drill procedures
• Implement schema changes, deployments, patches, and minor upgrades
• Troubleshoot and resolve incidents within defined SLAs; document root cause analysis
• Maintain documentation of database configurations, processes, and runbooks
• Participate in on call/rotational shift support (24x7 environment, if applicable)
• Collaborate with application, infrastructure, and security teams on database-related requirements
• Assist in capacity planning, storage management, and growth forecasting

Skills

SQL Server DBA

MS SQL Server 2016/2019/2022

T-SQL

Stored procedures

Query optimization

HA/DR technologies

Backups & Recovery

DBCC

Monitoring tools (SQL Sentry, Redgate,

Windows Server basics

Communication & documentation

Education

Any degree

Tools

SQL Sentry

Redgate

SCOM

Idera

DMVs

Job description

Infinite Computer Solutions in Illinois seeks a hands-on SQL Server DBA to install, configure, and upgrade SQL Server instances (2016/2019/2022). You will monitor performance, ensure backup/restore strategies, and support high availability and disaster recovery setups.

Responsibilities include managing security, maintenance plans, performance troubleshooting with DMVs and execution plans, and collaborating with app, infra, and security teams to meet SLAs.