Hybrid Azure SQL & Enterprise DB Admin

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

Benefits offered by this job

Medical benefits

Dental benefits

Vision benefits

401k

Profit sharing

Disability insurance

Tuition reimbursement

Job summary

Dentons US LLP is seeking a Senior Enterprise Database Administrator to ensure the reliability, modernization, security, and performance of the Firm’s SQL platforms, including on-premises and Azure managed services.

Responsibilities include leading production issue resolution, planning cloud migrations to Azure SQL, and collaborating with Infrastructure and business teams to maintain robust database environments and comprehensive documentation.

Qualifications

• Bachelor's degree in computer science, information systems, or related field, or equivalent certifications.
• At least five years of experience in 24x7 global enterprise support, preferably in a professional services environment.
• Expert knowledge of SQL clustering, high-availability, backup, recovery, and disaster recovery concepts.
• Hands-on experience migrating workloads to Azure SQL Managed Instance and Azure SQL Database.
• Strong SQL Server security administration, including permissions, authentication, auditing and compliance.
• Experience tuning SQL Server performance and proactively resolving issues.
• Proficient in Transact-SQL, stored procedures, SSRS, and related stack.
• Knowledge of Windows Server, IIS, DNS, DHCP, and AD.
• Ability to document processes, data flows, and diagrams clearly.
• Excellent communication and problem-solving skills; able to handle production issues independently.

Responsibilities

• Assess platform needs and implement strategic initiatives for production databases.
• Design, secure, and manage on-premises and cloud database environments with HA, backup, and DR.
• Collaborate with Infrastructure and app teams to protect data per security and retention policies.
• Provide day-to-day administration and performance tuning for SQL systems and apps.
• Plan migrations, upgrades, and modernization across on-premises and cloud environments.
• Develop and maintain testing and change-control processes for changes and rollbacks.
• Support enterprise app implementations through installation and config of components as needed.
• Offer third-line support for escalated database/app issues and requests.
• Participate in lifecycle maintenance, patching, documentation, and on-call rotation.
• Perform additional duties to fully meet the role requirements.

Skills

SQL Server

Azure SQL

High Availability

Backup & DR

Security Administration

Performance Tuning

Windows Server

Stored Procedures

On-call Rotation

Migration to Azure

Education

Bachelor's degree in CS/IS

Tools

SSMS

Azure Portal

Active Directory

Job description

Dentons US LLP is seeking a Senior Enterprise Database Administrator to ensure the reliability, modernization, security, and performance of the Firm’s SQL platforms, including on-premises and Azure managed services.

Responsibilities include leading production issue resolution, planning cloud migrations to Azure SQL, and collaborating with Infrastructure and business teams to maintain robust database environments and comprehensive documentation.