Job Role: MS SQL DBA
Location: Rosemont, IL (Onsite - Local candidates only)
Job Type: Contract C2C/W2
Experience: 8+ Years
Job Description:
· 6–12 years of hands-on experience as MSSQL DBA
· Strong expertise in Microsoft SQL Server 2016, 2017, and 2019
· Database installation and configuration on standalone and Always On clusters
· Day-to-day database administration: monitoring, backups, restores, and routine maintenance
· Strong understanding of database architecture and design principles
· Performance tuning and query optimization
· Troubleshooting performance bottlenecks and connectivity issues
· High Availability (HA) and Disaster Recovery (DR) implementation (Always On Availability Groups, clustering, failover)
· Database security management (user roles, access controls, encryption)
· Database patching, upgrades, and migrations
· Schema design and collaboration with development teams for performance optimization
· Capacity planning and resource forecasting
· Familiarity with database monitoring and maintenance tools
· PowerShell scripting for automation
· Strong problem-solving and communication skills