Skip to main content

Lead Database Administrator Job at Sidley Austin in chicago

Posted yesterday

sidley austinChicago (IL)

SENIORITY

Lead

Apply (opens in a new tab)

About the role

Overview: In this leadership role, you drive advanced operational support, performance optimization, and architectural maintenance for enterprise SQL Server environments, including legacy hub-and-spoke data distribution. You mentor DBAs, resolve complex issues, and steer cloud-native modernization (Azure, Databricks) as initiatives mature. You partner with leadership on capacity planning, architecture, and enterprise data solutions while ensuring availability and security. This role blends hands-on expertise with strategic guidance to elevate our data infrastructure and reporting capabilities. Compensation / Benefits bonus eligibility comprehensive benefits program
Responsibilities: Serve as primary escalation point for complex SQL Server performance, replication, availability, and infrastructure issues including hub-and-spoke data distribution framework Design, maintain, and enhance hub-and-spoke data distribution architecture and related ETL/data integration solutions Mentor and provide technical leadership to Database Administrators on query tuning, performance optimization, and best practices Lead root cause analysis, suggest long-term improvements, and participate in capacity planning and roadmap initiatives Develop and support enterprise reporting and data integration using SSRS, SSIS, Visual Studio, PowerShell, and related SQL Server tech Monitor and optimize database performance, availability, backups, security, and DR technologies (replication, log shipping, failover clustering, AGs) Perform SQL Server administration including patching and upgrades, with Azure-based SQL Server environments Evaluate and support modernization by piloting Azure-native and Databricks solutions and migrations between on-premises and cloud Participate in rotating 24x7 on-call schedule to ensure availability of critical systems
Key requirements: Bachelor’s degree in Computer Science or related field, or equivalent experience 6+ years of Microsoft SQL Server administration (2016–2022) in enterprise environments 3+ years in a senior or lead technical capacity Expert-level SQL Server performance tuning and troubleshooting experience Experience designing and maintaining large-scale ETL/data distribution architectures (hub-and-spoke, staging/MERGE-based) Hands-on with SSRS, SSIS, Visual Studio for SSIS/SSRS, replication technologies, and Availability Groups Experience with SQL Server monitoring tools (e.g., SQL Sentry) Experience with SQL Server patching, updates, and change management governance Advanced PowerShell scripting for SQL Server administration and automation Experience mentoring junior/mid-level DBAs Experience with Power BI for reporting and analytics (preferred) Strong knowledge of Windows Server Strong knowledge of physical and VMware-based SQL Server configurations Azure SQL Server administration experience (hybrid on-prem/Azure) Strong interpersonal communication Good judgment Attention to detail SQL Server performance tuning and root-cause analysis Hub-and-spoke data distribution architecture and ETL (MERGE-based) SSRS/SSIS development and maintenance

Before you apply

Applying takes about a minute. These four things decide how fast it moves after that.

Your profile is current

It's what we read first. Occupations, seniority and locations matter more than a long history.

Two examples you can talk through

Not a portfolio — just two pieces of work where you can explain the decisions and what you'd change.

A number in mind

What you're on now and what would make you move. We negotiate better when we know both.

Your notice period

Employers plan around it, and it's the question that stalls offers most often.

Once you apply, someone reads it and calls you before anything reaches the employer — usually within two working days.

More like this