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., 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., * 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.

Microsoft SQL Server, AWS RDS

DBA / Client Tools

SQL Server Management Studio (SSMS), DBeaver

Privileged Access

CyberArk

ITSM / Inventory

ServiceNow

HA / DR

SQL Server Always On Availability Groups

Microsoft Data Stack

SSIS, SSRS, SSAS

Database Development

T-SQL, stored procedures, * 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.