Senior Enterprise Database Administrator

Dentons Canada; Chicago (IL); Hybrid; USD 125,000 - 163,000; Full time

Benefits offered by this job

Medical insurance

Dental insurance

Vision insurance

401(k) plan

Discretionary bonuses

Tuition reimbursement

Paid time off

Job summary

Dentons US LLP is seeking a Senior Enterprise Database Administrator in the Chicago area to ensure reliability, security, and performance of database platforms and enterprise apps. You will drive modernization and cloud migration to Azure SQL services, while owning production issue resolution and platform lifecycle.

You will lead high-availability implementations, backups, disaster recovery, and security controls across on-premises and Azure environments, collaborating with data owners and

Qualifications

• Bachelor’s degree in business, computer science, information systems, or a related field, or equivalent relevant certifications.
• 5+ years of experience in a 24x7 global support environment; law firm or professional services preferred.
• Expert knowledge of SQL clustering, high-availability, backup, recovery, and DR concepts.

Responsibilities

• Assess database platform needs and implement initiatives for production databases with stakeholders.
• Design, secure, and manage on-premises and cloud database environments, including HA clusters, mirroring, backup, and DR.
• Partner with Infrastructure and application teams to protect databases and data according to security and retention policies.
• Provide day-to-day administration and advanced support for SQL systems and related applications, monitoring performance and resolving issues.
• Plan data migrations, upgrades, and modernization across on-premises and cloud environments.
• Develop and maintain Azure SQL Managed Instance and Azure SQL Database configurations and connectivity.
• Maintain testing and change-control processes for database, application, and patching activities.
• Support enterprise applications from initiation through completion with installation of middle-tier components when needed.
• Provide third-line support for escalated database/application issues, backups, replication, and availability requests.
• Participate in lifecycle maintenance, patching, documentation, and on-call rotation.

Skills

SQLServer administration

SQL performance tuning

Azure migration

Database security

T-SQL

SSRS

Windows Server

IIS

Active Directory

Backup and disaster recovery

Education

Bachelor’s degree or equivalent certifications

Tools

Azure SQL Managed Instance

Azure SQL Database

SQL Server 2019+

Job description

Chicago, IL, US Kansas City, MO, US Dallas, TX, US Washington DC, DC, US Atlanta, GA, US

Dentons US LLP is currently recruiting for a Senior Enterprise Database Administrator. This position reports to the Enterprise Business Systems team and is responsible for the reliability, modernization, security, and performance of the Firm’s database platforms and the enterprise applications that depend upon them.

This is a hybrid database platform and enterprise application support role. The successful candidate will provide advanced SQL Server administration, support application troubleshooting and implementation activities, and help lead the transition of appropriate database workloads from traditional infrastructure to Azure-managed database services, including Azure SQL Managed Instance and Azure SQL Database.

The role will take ownership of production issue resolution, database and application performance, cloud database migration, platform lifecycle management, technical documentation, and the implementation of tactical and strategic initiatives supporting core business functions.

Responsibilities

• Assess database platform needs and develop and implement tactical and long-term strategic initiatives for production databases in collaboration with data owners and business stakeholders.
• Design, implement, secure, and manage resilient on-premises and cloud database environments, including SQL high-availability clusters, mirroring, synchronization, backup, recovery, disaster recovery, data archiving, access controls, and retention requirements.
• Partner with Infrastructure teams and application stakeholders to ensure databases and critical data are protected in accordance with business requirements and the Firm’s security, disaster recovery, compliance, and data retention policies.
• Provide day-to-day administration and advanced support for the Firm’s SQL systems and dependent applications, proactively monitoring and tuning database and application performance and taking ownership of production issues through resolution.
• Plan and coordinate data migrations, database upgrades, and platform modernization initiatives across on-premises and cloud environments.
• Design, implement, administer, secure, and optimize Azure SQL Managed Instance and Azure SQL Database environments, including connectivity, resiliency, backup, recovery, and compliance configurations.
• Develop and maintain testing and change-control processes for database, application, infrastructure, and patching activities, ensuring proposed changes are appropriately tested and include rollback plans.
• Support enterprise application implementations from initiation through completion, including installation and configuration of middle-tier application components when required.
• Provide timely third-line support by troubleshooting and resolving escalated database and application issues and fulfilling backup, restore, mirroring, synchronization, access, and availability requests.
• Participate in platform lifecycle maintenance, patching activities, technical documentation, and the on-call rotation supporting the Firm’s operations.
• Perform other duties as assigned to fully meet the requirements of the position.

Experience & Qualifications

• Bachelor’s degree in business, computer science, information systems, or a related field, or equivalent relevant certifications.
• At least five years of experience serving as a technical subject-matter expert in a 24 x 7 global support environment; law firm or professional services experience is preferred.
• Expert knowledge of SQL clustering, high-availability implementations, backup, recovery, and disaster recovery concepts for database systems.
• Hands-on experience implementing, administering, securing, optimizing, and migrating workloads to Microsoft Azure SQL Managed Instance and Azure SQL Database.
• Demonstrated expertise in SQL Server security administration, including permissions, access controls, authentication, auditing, and compliance across on-premises and cloud environments.
• Strong SQL Server and application performance-tuning skills, including query analysis, proactive monitoring, and resolution of complex performance issues.
• Working knowledge of Transact-SQL, stored procedures, SQL Mail, SSRS, triggers, and the client/server application stack.
• Working knowledge of Windows Server, IIS, DNS, DHCP, and Active Directory.
• SQL Server administration experience with versions 2019 and later, including database upgrades and migrations to newer versions.
• Ability to develop and maintain clear processes, procedures, technical diagrams, and organizational data-flow documentation.
• Strong analytical and problem-solving skills, with the ability to clearly explain technical issues, present options, independently take ownership of complex production issues, and drive them through effective resolution.
• Excellent written, verbal, interpersonal, and client-service skills, with the ability to collaborate tactfully and effectively with individuals at all levels.
• Sound judgment, accuracy, adaptability, and resilience, with the ability to work independently, remain calm under pressure, prioritize competing demands, meet tight project deadlines, and participate in an on-call rotation.

Pursuant with states' laws, the salary range for this position is $125,000 - $163,000, based on experience and local market.

Dentons US LLP offers a competitive salary and benefits package including medical, dental, vision, 401k, profit sharing, short-term/long-term disability, life insurance, tuition reimbursement, paid time off, paid holidays and discretionary bonuses.

Dentons US LLP is an Equal Opportunity Employer - Disability/Vet. Pursuant to local ordinances, we will consider for employment qualified applicants with arrest and conviction records.

About Dentons

Redefining possibilities. Together, everywhere. For more information visit www.dentons.com