Senior SQL DBA

McCann Partners is supporting a client based in Chicago hiring a SQL Server DBA for a 6+ month contract engagement with a high likelihood of extension. This is a Hybrid engagement with 1 day required in their downtown Chicago Office.

Overview
The Database Administrator (DBA) is responsible for the reliability, availability, security, performance, and operational support of bank’s database platforms. The role provides hands-on database administration and production support while supporting database lifecycle management, backup and recovery, high availability/disaster recovery, security controls, audit requirements, and technology modernization.
Key Responsibilities

• Administer and support Microsoft SQL Server and AWS RDS database environments.
• Provide ongoing production database and application support, including incident troubleshooting and resolution.
• Monitor SQL Server environments, perform performance tuning and optimization, and validate database maintenance activities.
• Install, configure, upgrade, and migrate SQL Server databases and instances.
• Configure and support Windows Server Failover Clustering and SQL Server Always On Availability Groups supporting HA/DR requirements.
• Administer database backup and restore processes using Rubrik, including scheduled and on-demand backups and database restoration.
• Support database security, access privileges, SQL Audit, and related controls.
• Support production patching validation and disaster recovery exercises.
• Implement database schema and data changes associated with approved projects and change requests.
• Support SSIS, SSRS, SSAS, stored procedures, T-SQL, and data-transformation activities.
• Support database-related audits and required reporting activities.
• Participate in after-hours and weekend database deployments and change activities where required.
• Develop and maintain database operational standards, procedures, capacity information, and supporting documentation.
• Participate in Business Continuity, Enterprise Architecture, and data-governance activities related to structured data management.

Tools & Technologies

Experience & Qualifications

• 6–8 years of DBA experience, with database architecture and implementation experience.
• Strong SQL Server administration and troubleshooting experience.
• Strong analytical, troubleshooting, communication, prioritization, and collaboration skills.
• Good experience in scripting and automation of recurring SQL Administrative duties
• Hands-on production support experience with backup/recovery, HA/DR, security, performance tuning, migrations, patching, and upgrades.
• Experience supporting Microsoft SQL and AWS RDS environments.
• Experience operating in a controlled environment involving incidents, changes, audit requirements, access controls, and business continuity.
• Bachelor's degree preferred; relevant Microsoft certifications are desirable.