Database Administrator

Sidley Austin LLP • Chicago, IL

1d • Hybrid

About The Position

The Database Administrator is a member of the database team responsible for providing operational support for the firm’s database environments and related project initiatives. This role plays an integral part in the ongoing maintenance, support, and enhancement of business-critical applications, ensuring their reliability, performance, and availability.

Requirements

• 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), SQL Server Integration Services (SSIS), Visual Studio for SSIS/SSRS development, SQL Server replication technologies, 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
• 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
• 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

Nice To Haves

• 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

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

Benefits

• Our compensation package also includes bonus eligibility and a comprehensive benefits program.
• Benefits information can be found at Sidley.com/Benefits.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level