Summary

The Database Administrator will be a part of the team responsible for the operational support of project initiatives surrounding the firm’s Database environments. This position will play an integral role in the maintenance, support, and enhancements of business critical applications.

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
• Implement, create reports, and provide general support for SQL Server Reporting services
• Implement, create integrations, and provide general support for SQL Server Integration services
• Monitor relational databases to optimize performance, resource use, backup/recovery, and physical implementation
• Review database objects and create and maintain change controls
• Monitor and maintain database security
• Migrate databases between servers and various platforms
• Analyze and resolve SQL Server faults
• Document data flows, application specifications from a DB perspective and system procedures
• Implement and maintain data distribution and disaster recovery solutions, such as mirroring, replication, and log shipping
• Support highly-available and disaster recovery (HA/DR) database technologies (such as SQL Clustering and SQL Server Availability Groups across multiple data centers)
• Investigate and resolve reported application issues, escalating issues as necessary to the application owners
• Provide 24x7 on-call support on a rotating basis
• Flexible to work off-hours, as required

Qualifications

To perform this job successfully, an individual must be able to perform the Duties and Responsibilities (the “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. Employees or applicants who need an accommodation should contact Human Resources. If you need such an accommodation, please email staffrecruiting@sidley.com (current employees should contact Human Resources).

Education and/or Experience:

Required:

• Bachelor’s degree in Computer Science or a related field or related experience
• A minimum of 5 years of experience with SQL Server 2016 and SQL Server 2019
• Expert with SQL Server performance management and tuning, including identifying solutions that optimize SQL execution plans
• SQL Server Administration experience including:
  • Triggers
  • Stored Procedure Code Development and Standardization
  • Data Integration and Migration
  • Management Studio
  • SQL XML
  • Database Auditing and Controls
• Strong knowledge of Windows 2019
• Strong knowledge of physical and VMWare SQL configuration from an infrastructure perspective
• Strong understanding of security implementation
• Proven troubleshooting abilities
• Strong planning and analysis skills
• Strong documentation skills
• Azure database administration experience

Preferred:

• Ability to translate Logical Data Models into physical structures

Other Skills and Abilities:

The following will also be required of the successful candidate:

• 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
• A self-starter who desires to show ownership and commitment to the job
• Proofreads accurately

Sidley Austin LLP is an Equal Opportunity/Affirmative Action Employer