MS SQL Server DBA

Role: MS SQL Server DBA

Location: Chicago IL (Onsite)

Duration: Long Term

Contract Role

Role name:

• Provide support for a large footprint of Microsoft SQL Server instances including Always On availability groups and failover clustering configurations.
• Support SQL Server 2016/2019 on Physical and VMware Hypervisor.
• Responsible for database backup and recovery methods database access security and integrity physical data storage design and database storage administration.
• Involved in disaster recovery planning.
• Participate in several Business Continuity DR tests per year in coordination with the Business Continuity team.
• Document DR processes.
• Understand SOC1/SOC2/Internal Audit/Yearly Audit requirements for compliance reporting.
• Participate in 24x7 follow the sun oncall rotation shared between 3 regions (US Ireland and India)Provide Production support including Saturday Deployment support.
• Support DB and OS Patching initiatives on a monthly/quarterly basis.
• Remediate MSSQL vulnerabilities identified by the Vulnerability Mitigation Team.
• Participate in continuous process improvement focussing on reduction of manual tasks via automation.
• Implements and maintains configuration of each database instance to baseline standard access controls.
• Make recommendations for database system architecture per Microsoft SQL Server best practice.
• Deploy and manage updates to scheduled jobs within UC4 Scheduler and SQL Server Agent.
• Proactively monitor SQL Server maintenance tasks troubleshoot failed processes and address issues promptly.
• Troubleshoot and investigate application performance issues as they relate to the database.
• Provide appropriate guidance and solutions.
• Tune TSQL queries and provide guidance to developers on best practice.
• Manage and coordinate database migrations and database software and hardware upgrades.
• Create documentation and training for routine database administration activities as well as train server operations employees on them
• Support standard DBA security processes such as password rotation TDE SSL and DB Auditing
• Attend Standup/Planning/Issues review/Change Control and Customer facing meetings as representative of the team.
• Experience with Onprem to Cloud DB Migration on Compute Engine and Managed Services.
• Windows Powershell Microsoft SQL Server 2019 Communication.

Essential Skills:

• SQL Server DBA Infrastructure Support (Always ON Password rotations of SQL server)
• Backup and recovery
• Performance tuning and troubleshooting
• Windows Server & Clustering
• PowerShell Scripting
• Good to have Chef/Chocolatey packaging experience.
• Exposure to cloud services (GCP AWS Microsoft Azure)
• Knowledge on the GitOps and CI/CD Process
• Strong analysis/troubleshooting skills is required

Desirable Skills:

• Good communication
• Excellent analytical & troubleshooting skills