Database Administrator
Share
Job Location:
Chicago, IL - USA
Monthly Salary:
Not Disclosed
Posted on:
Yesterday
Vacancies:
1 Vacancy
Job Summary
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 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: 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-OE1Qualifications
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
About Company
Sidley is a global law firm, collaborating across disciplines and borders to help clients in more than 70 countries achieve business objectives.
