Database Administrator

Summary

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.

• 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 Power Shell 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

125,000 - $150,000 if located in Illinois

Education and/or

Experience:

• 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 Power Shell 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

• Experience modernizing legacy SSRS reporting to Power BI
• Experience automating SQL Server administration using Power Shell and CI/CD practices
• Experience supporting large‑scale, mission‑critical SQL Server environments in regulated enterprises

• 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

Sidley Austin LLP is an Equal Opportunity Employer