Database Administrator

Summary

The Database Administrator is a member of the database team responsible for providing operational support for the firms 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.

Duties and 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

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. If an estimated salary range for this role is available it will be provided in our Target Salary Range section. Our compensation package also includes bonus eligibility and a comprehensive benefits program. Benefits information can be found at Salary Range

125000 - $150000 if located in Illinois

Qualifications

To perform this job successfully an individual must be able to perform the Duties and Responsibilities (Duties) above satisfactorily and meet the requirements below. The requirements listed below 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 (current employees should contact Human Resources).

Education and / or Experience :

Required :

SQL Server Reporting Services (SSRS)

Preferred :

Other Skills and Abilities :

The following will also be required of the successful candidate :

Sidley Austin LLP is an Equal Opportunity Employer

#LI-Hybrid

#LI-OE1

Required Experience :

Unclear Seniority

Key Skills

Databases,Disaster Recovery,SQL,High Availability,Microsoft SQL Server,ssrs,Database Design,Performance Tuning,SSIS,Database Administration,Sybase,Oracle

Employment Type : Full Time

Experience : years

Vacancy : 1