Sidley Austin LLP · 20 hours ago
Database Administrator
Chicago, IL
Full-time
Hybrid
Senior Level
$125K/yr - $150K/yr
5+ years expSidley Austin LLP is a prestigious law firm seeking a Database Administrator to provide operational support for their database environments. The role involves optimizing database performance, implementing reporting solutions, and ensuring the reliability and availability of business-critical applications.
FinanceConsultingLegalProfessional ServicesAdviceFinancial Services
Responsibilities
Optimize stored procedures, functions, and ad-hoc SQL
Design, develop, and implement internal data feeds, data reporting extracts, and ETL processes between disparate systems using SSIS and Visual Studio
Implement, develop, and support enterprise reporting solutions using SQL Server Reporting Services (SSRS), including datasets, reports, dashboards, and scheduled refreshes
Implement, develop, and support integrations using SQL Server Integration Services (SSIS), including deployment, configuration, and troubleshooting
Monitor relational databases to optimize performance, resource utilization, backup/recovery, and physical implementation using SQL monitoring tools such as SQL Sentry (or equivalent)
Perform SQL Server patching, cumulative updates, and version upgrades, ensuring minimal downtime and adherence to change management processes
Review database objects and create and maintain change controls
Monitor and maintain database security, including authentication, authorization, auditing, and encryption
Migrate databases between servers, storage platforms, and environments (on-premises and Azure)
Analyze, troubleshoot, and resolve SQL Server performance issues, replication issues, and availability failures
Document data flows, application specifications from a database perspective, and system procedures
Implement, configure, and maintain data distribution and disaster recovery solutions, including replication, log shipping, failover clustering, and SQL Server Availability Groups, and troubleshoot issues across multiple data centers
Develop and maintain PowerShell scripts to automate administrative tasks, monitoring, deployments, patching, and health checks
Support and administer Azure-based SQL Server environments, including IaaS SQL Server, Azure SQL, or Managed Instances (as applicable)
Provide 24x7 on-call support on a rotating basis
Flexible to work off-hours as required
Qualification
Required
Bachelor's degree in Computer Science or related field, or equivalent experience
A minimum of 5 years of experience administering Microsoft SQL Server (2016–2022) in enterprise environments
Expert-level SQL Server performance tuning and troubleshooting experience, including execution plans and indexing strategies
Strong hands-on experience with SQL Server Reporting Services (SSRS)
Strong hands-on experience with SQL Server Integration Services (SSIS)
Strong hands-on experience with Visual Studio for SSIS/SSRS development
Strong hands-on experience with SQL Server replication technologies
Strong hands-on experience with SQL Server Availability Groups, including setup, maintenance, and troubleshooting
Experience with SQL Server monitoring tools (e.g., SQL Sentry or equivalent)
Experience performing SQL Server patching, cumulative updates, and upgrades
Proficiency in PowerShell scripting for SQL Server administration and automation
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 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
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
Benefits
Bonus eligibility
Comprehensive benefits program
Company
Sidley Austin LLP
Sidley is an elite global law firm.
1001-5000 employees
H1B Sponsorship
Sidley Austin LLP has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (51)
2024 (36)
2023 (17)
2022 (33)
2021 (20)
2020 (23)
Funding
Current Stage
Late StageLeadership Team
Anne Falvey
Chief Knowledge Officer
CARTER G. PHILLIPS
Partner
Recent News
2025-12-15
bloomberglaw.com
2025-12-12
Company data provided by crunchbase