Back to jobs

Lead Database Administrator

Pay
$123,000–169,000/yearAnnual period assumed. Location-specific pay — pay source
The target salary range for this role is: $123,000 - $169,000 if located in Illinois. Salaries vary by location and are based on numerous factors, including, but not limited to, the relevant market, skills, experience, and education of the selected candidate. Our compensation package also includes bonus eligibility and a comprehensive benefits program. Benefits information can be found at Sidley.com/Benefits.
Read the full posting
Work setting
Not stated
Employment
Full-time — employment source
Employment type in the employer’s posting: Full time
From the employer’s posting

What you’ll work on

Full posting
  • Resolve complex SQL Server performance, replication, and availability issues as the top escalation point

  • Design and maintain the hub-and-spoke data distribution architecture and its sync procedures

  • Mentor DBAs on query tuning, ETL design, and troubleshooting

  • Build enterprise reporting and integration solutions with SSRS, SSIS, and PowerShell

  • Pilot Azure and Databricks solutions and database migrations to cloud

From the employer’s posting
Serve as the primary technical escalation point for complex SQL Server performance, replication, availability, and database infrastructure issues
Design, maintain, and enhance the firm's hub-and-spoke data distribution architecture
Mentor and provide technical leadership to Database Administrators through guidance on query tuning, performance optimization, ETL design, troubleshooting, and best practices
Develop, implement, and support enterprise reporting, data integration, and automation solutions using SSRS, SSIS, Visual Studio, PowerShell
Evaluate and support modernization initiatives by piloting Azure-native and Databricks-based solutions
Education & alternatives
Required: - Bachelor’s degree in Computer Science or related field, or equivalent experience - A minimum of 6 years of experience administering Microsoft SQL Server (2016–2022) in enterprise environments, including at least 3 years in a senior or lead technical capacity
Apply at Sidley Partners

Posting record

Report an error

Open 3 monthsWe first saw this posting 96 days ago and it is still up. Roles open this long are often slow to fill or kept open to collect applications.

Status in our records
Live
First seen by us
Aug 18, 202696 days ago
Recorded sightings
105
Last seen by us
Nov 17, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Pay

In line with similar jobs

$123K–$169K against $127K–$189K, the middle half of what similar US postings state.

From 2,448 postings in the last year. Stated ranges, not salaries paid.

Time since we first saw it

Day 96

Up longer than most. Similar jobs usually come down between day 6 and day 56.

At Sidley Partners, jobs usually come down by about day 69.

From 14,771 similar postings that came down, and 10 of Sidley Partners’s. Coming down is not always a hire.

Sidley Partners is hiring

3 open jobs

Open jobs by the week we first saw them, last 12 weeks.

  • Hiring has slowed
  • Takes jobs down at a usual pace
Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • SQL
  • Azure
  • Databricks
  • Power BI
  • SQL Server
  • SSIS
  • SSRS
Where the posting names them
Duties and Responsibilities: - Serve as the primary technical escalation point for complex SQL Server performance, replication, availability, and database infrastructure issues, including support of the firm's hub-and-spoke data distribution framework. - Design, maintain, and enhance the firm's hub-and-spoke data distribution architecture, including staging tables, MERGE-based sync procedures, intermediary databases, and related SQL Server ETL/data integration solutions
- Serve as the primary technical escalation point for complex SQL Server performance, replication, availability, and database infrastructure issues, including support of the firm's hub-and-spoke data distribution framework. - Design, maintain, and enhance the firm's hub-and-spoke data distribution architecture, including staging tables, MERGE-based sync procedures, intermediary databases, and related SQL Server ETL/data integration solutions - Mentor and provide technical leadership to Database Administrators through guidance on query tuning, performance optimization, ETL design, troubleshooting, and best practices.
- Lead root cause analysis for recurring database issues, recommend long-term improvements, and participate in database capacity planning and infrastructure roadmap initiatives. - Develop, implement, and support enterprise reporting, data integration, and automation solutions using SSRS, SSIS, Visual Studio, PowerShell, and related SQL Server technologies. - Monitor, optimize, and maintain database performance, availability, backup and recovery, security, and disaster recovery technologies, including replication, log shipping, failover clustering, and SQL Server Availability Groups.
- Develop, implement, and support enterprise reporting, data integration, and automation solutions using SSRS, SSIS, Visual Studio, PowerShell, and related SQL Server technologies. - Monitor, optimize, and maintain database performance, availability, backup and recovery, security, and disaster recovery technologies, including replication, log shipping, failover clustering, and SQL Server Availability Groups. - Perform SQL Server administration, including patching, cumulative updates, version upgrades, documentation, and support for Azure-based SQL Server environments.
- Monitor, optimize, and maintain database performance, availability, backup and recovery, security, and disaster recovery technologies, including replication, log shipping, failover clustering, and SQL Server Availability Groups. - Perform SQL Server administration, including patching, cumulative updates, version upgrades, documentation, and support for Azure-based SQL Server environments. - Evaluate and support modernization initiatives by piloting Azure-native and Databricks-based solutions, including database migrations across on-premises and cloud environments in partnership with database leadership.
- Bachelor’s degree in Computer Science or related field, or equivalent experience - A minimum of 6 years of experience administering Microsoft SQL Server (2016–2022) in enterprise environments, including at least 3 years in a senior or lead technical capacity - Expert-level SQL Server performance tuning and troubleshooting experience, including execution plans, indexing strategies, and root-cause analysis of recurring or systemic issues
- A minimum of 6 years of experience administering Microsoft SQL Server (2016–2022) in enterprise environments, including at least 3 years in a senior or lead technical capacity - Expert-level SQL Server performance tuning and troubleshooting experience, including execution plans, indexing strategies, and root-cause analysis of recurring or systemic issues - Demonstrated experience designing, maintaining, and troubleshooting large-scale ETL and data distribution architectures (e.g., hub-and-spoke, staging/MERGE-based sync patterns, or equivalent)
- Demonstrated experience designing, maintaining, and troubleshooting large-scale ETL and data distribution architectures (e.g., hub-and-spoke, staging/MERGE-based sync patterns, or equivalent) - Strong hands-on experience with, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Visual Studio for SSIS/SSRS development, SQL Server replication technologies, and SQL Server Availability Groups, including setup, maintenance, and troubleshooting - Experience with SQL Server monitoring tools (e.g., SQL Sentry or equivalent)
- Strong hands-on experience with, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Visual Studio for SSIS/SSRS development, SQL Server replication technologies, and SQL Server Availability Groups, including setup, maintenance, and troubleshooting - Experience with SQL Server monitoring tools (e.g., SQL Sentry or equivalent) - Experience performing and overseeing SQL Server patching, cumulative updates, and upgrades, including change management governance
- Experience with SQL Server monitoring tools (e.g., SQL Sentry or equivalent) - Experience performing and overseeing SQL Server patching, cumulative updates, and upgrades, including change management governance - Advanced proficiency in PowerShell scripting for SQL Server administration and automation
- Experience performing and overseeing SQL Server patching, cumulative updates, and upgrades, including change management governance - Advanced proficiency in PowerShell scripting for SQL Server administration and automation - Demonstrated experience mentoring or providing technical guidance to junior or mid-level database administrators
- Strong knowledge of Windows Server - Strong knowledge of physical and VMware-based SQL Server configurations - Azure SQL Server administration experience, including hybrid on-prem/Azure environments
- Strong knowledge of physical and VMware-based SQL Server configurations - Azure SQL Server administration experience, including hybrid on-prem/Azure environments Preferred:
- Experience modernizing legacy SSRS reporting to Power BI - Experience automating SQL Server administration using PowerShell and CI/CD practices - Experience supporting large-scale, mission-critical SQL Server environments in regulated enterprises
- Experience automating SQL Server administration using PowerShell and CI/CD practices - Experience supporting large-scale, mission-critical SQL Server environments in regulated enterprises - Demonstrated ability to mentor and influence the technical work of others without direct management authority
- Demonstrated ability to mentor and influence the technical work of others without direct management authority - Exposure to Azure-native data platforms (Azure SQL Managed Instance, Azure Synapse, or similar) or Databricks - Experience leading or contributing to architecture/modernization roadmap discussions
The Lead Database Administrator is a senior member of the database team responsible for the advanced operational support, performance optimization, and architectural maintenance of the firm's database environments, including the legacy hub-and-spoke data distribution framework. This role independently resolves complex, high-impact issues, mentors other database administrators, and serves as a key technical escalation point for the team. The Lead Database Administrator also helps guide the team's transition toward cloud-native and modern data platforms (Azure, Databricks) as those initiatives mature. Duties and Responsibilities:
- Perform SQL Server administration, including patching, cumulative updates, version upgrades, documentation, and support for Azure-based SQL Server environments. - Evaluate and support modernization initiatives by piloting Azure-native and Databricks-based solutions, including database migrations across on-premises and cloud environments in partnership with database leadership. - Participate in a rotating 24x7 on-call schedule and provide off-hours support as required to ensure the availability and reliability of critical database systems.
- Demonstrated experience mentoring or providing technical guidance to junior or mid-level database administrators - Experience with Power BI for reporting and analytics (preferred for enterprise reporting modernization) - Strong knowledge of Windows Server
Preferred: - Experience modernizing legacy SSRS reporting to Power BI - Experience automating SQL Server administration using PowerShell and CI/CD practices

Your next step

Complete your application on sidley.wd501.myworkdayjobs.com. The employer’s form will show what is required.

Applying through Workday

  • You create an account with each employer before you can upload anything. Every Workday employer has its own account, so one sign-up doesn’t carry over.
  • “Autofill with Resume” comes right after sign-in, before the My Information and My Experience steps. Check every field it fills in those steps, since that’s what recruiters see.
  • Your application status lives in that employer’s Candidate Home, under the same sign-in.

Already applied? Track this application

Job description

View original posting ↗

The Lead Database Administrator is a senior member of the database team responsible for the advanced operational support, performance optimization, and architectural maintenance of the firm's database environments, including the legacy hub-and-spoke data distribution framework. This role independently resolves complex, high-impact issues, mentors other database administrators, and serves as a key technical escalation point for the team. The Lead Database Administrator also helps guide the team's transition toward cloud-native and modern data platforms (Azure, Databricks) as those initiatives mature.

Duties and Responsibilities: 

  • Serve as the primary technical escalation point for complex SQL Server performance, replication, availability, and database infrastructure issues, including support of the firm's hub-and-spoke data distribution framework.

  • Design, maintain, and enhance the firm's hub-and-spoke data distribution architecture, including staging tables, MERGE-based sync procedures, intermediary databases, and related SQL Server ETL/data integration solutions

  • Mentor and provide technical leadership to Database Administrators through guidance on query tuning, performance optimization, ETL design, troubleshooting, and best practices.

  • Lead root cause analysis for recurring database issues, recommend long-term improvements, and participate in database capacity planning and infrastructure roadmap initiatives.

  • Develop, implement, and support enterprise reporting, data integration, and automation solutions using SSRS, SSIS, Visual Studio, PowerShell, and related SQL Server technologies.

  • Monitor, optimize, and maintain database performance, availability, backup and recovery, security, and disaster recovery technologies, including replication, log shipping, failover clustering, and SQL Server Availability Groups.

  • Perform SQL Server administration, including patching, cumulative updates, version upgrades, documentation, and support for Azure-based SQL Server environments.

  • Evaluate and support modernization initiatives by piloting Azure-native and Databricks-based solutions, including database migrations across on-premises and cloud environments in partnership with database leadership.

  • Participate in a rotating 24x7 on-call schedule and provide off-hours support as required to ensure the availability and reliability of critical database systems.

 

Education and/or Experience: 

Required:

  • Bachelor’s degree in Computer Science or related field, or equivalent experience

  • A minimum of 6 years of experience administering Microsoft SQL Server (2016–2022) in enterprise environments, including at least 3 years in a senior or lead technical capacity

  • Expert-level SQL Server performance tuning and troubleshooting experience, including execution plans, indexing strategies, and root-cause analysis of recurring or systemic issues

  • Demonstrated experience designing, maintaining, and troubleshooting large-scale ETL and data distribution architectures (e.g., hub-and-spoke, staging/MERGE-based sync patterns, or equivalent)

  • Strong hands-on experience with, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Visual Studio for SSIS/SSRS development, SQL Server replication technologies, and SQL Server Availability Groups, including setup, maintenance, and troubleshooting

  • Experience with SQL Server monitoring tools (e.g., SQL Sentry or equivalent)

  • Experience performing and overseeing SQL Server patching, cumulative updates, and upgrades, including change management governance

  • Advanced proficiency in PowerShell scripting for SQL Server administration and automation

  • Demonstrated experience mentoring or providing technical guidance to junior or mid-level database administrators

  • Experience with Power BI for reporting and analytics (preferred for enterprise reporting modernization)

  • Strong knowledge of Windows Server

  • Strong knowledge of physical and VMware-based SQL Server configurations

  • Azure SQL Server administration experience, including hybrid on-prem/Azure environments

Preferred:

  • Experience modernizing legacy SSRS reporting to Power BI

  • Experience automating SQL Server administration using PowerShell and CI/CD practices

  • Experience supporting large-scale, mission-critical SQL Server environments in regulated enterprises

  • Demonstrated ability to mentor and influence the technical work of others without direct management authority

  • Exposure to Azure-native data platforms (Azure SQL Managed Instance, Azure Synapse, or similar) or Databricks

  • Experience leading or contributing to architecture/modernization roadmap discussions

Other Skills and Abilities:

The following will also be required of the successful candidate:

  • Strong organizational skills

  • Strong attention to detail

  • Good judgment

  • Strong interpersonal communication skills

  • Strong analytical and problem-solving skills

  • Able to work harmoniously and effectively with others

  • Able to preserve confidentiality and exercise discretion

  • Able to work under pressure

  • Able to manage multiple projects with competing deadlines and priorities

#LI-KG2

#LI-Hybrid 

The target salary range for this role is:

$123,000 - $169,000 if located in Illinois.

Salaries vary by location and are based on numerous factors, including, but not limited to, the relevant market, skills, experience, and education of the selected candidate. Our compensation package also includes bonus eligibility and a comprehensive benefits program. Benefits information can be found at Sidley.com/Benefits.

To perform this job successfully, an individual must be able to perform the Duties and Responsibilities above satisfactorily and meet the requirements. The requirements listed above are representative of the minimum knowledge, skill, and/or ability required. Reasonable accommodations will be made to enable individuals with disabilities to perform the essential functions of the job. If you need such an accommodation, please email sidleytalentacquisition@sidley.com (current employees should contact Human Resources).

Sidley Austin LLP is an Equal Opportunity Employer.

Demand for Data Engineer roles

New Data Engineer postings at the employers we follow are up 13% over the last 6 weeks compared with the 6 before.

Weekly new Data Engineer postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 845, the most 1,344, and the latest week had 1,007.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Data Engineer, by the work the posting describes.

Data engineers build and run the pipelines that copy data out of apps and outside services into a warehouse or lake, and fix them when a source changes or a load fails.

Expect SQL, Python, a cloud platform, a scheduler such as Airflow, and often tools for large data such as Spark or Kafka.

An analytics engineer works one step later, turning the raw data a data engineer lands into clean tables people can query.

US government figures for database architects

Median yearly pay, May 2025
$139,500
Expected change, 2025 to 2035
9.4% more jobsagainst 3.5% for all jobs

The government has no code for data engineers, so these figures are for the closest group, database architects, which includes data integration and data warehousing specialists.

Source: US Bureau of Labor Statistics, Occupational Employment and Wage Statistics (May 2025) and Employment Projections (2025 to 2035). Occupation code 15-1243.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay
The target salary range for this role is: $123,000 - $169,000 if located in Illinois. Salaries vary by location and are based on numerous factors, including, but not limited to, the relevant market, skills, experience, and education of the selected candidate. Our compensation package also includes bonus eligibility and a comprehensive benefits program. Benefits information can be found at Sidley.com/Benefits.
Location & working pattern

Chicago

- Strong knowledge of physical and VMware-based SQL Server configurations - Azure SQL Server administration experience, including hybrid on-prem/Azure environments Preferred:
More source context
#LI-KG2 #LI-Hybrid The target salary range for this role is:
Work authorization

No clear work-authorization passage found. Eligibility is unconfirmed.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.