Senior SQL Server DBA — Cloud-Scale HA/DR Architect

Aderant North America, Inc.; United States; Remote; USD 140,000 - 190,000; Full time

Job summary

Aderant is seeking a Principal Database Administrator to lead SQL Server architecture, HA/DR, and multi‑tenant resilience across Sierra cloud operations. This senior, hands‑on role requires ownership of design decisions and direct engagement with client‑side DBAs to maintain robust database platforms.

You will mentor the DBA team, drive incident analysis, and optimize performance at scale while ensuring security and reliability across global tenants.

Qualifications

• 7+ years of hands‑on SQL Server DBA experience (2016+).
• Experience with Always On Availability Groups and Distributed AGs.
• Strong design, admin, and performance troubleshooting skills.
• Proficient in T-SQL, SSMS, and SQL Server Agent.
• Proven DR/backup architecture with multi‑tenant environments.
• Experience with CDC and transactional replication.
• Cloud experience on AWS and Azure preferred.
• Automation using PowerShell and Ansible.
• Mentor/guide other engineers; strong client communication.

Responsibilities

• Act as technical authority for SQL Server operations, HA, DR, and replication across Sierra platform.
• Lead root‑cause analysis for complex incidents and drive remediation.
• Make architecture tradeoffs and identify systemic risks.
• Design and maintain Always On and cross‑region topologies; DR validation.
• Own CDC lifecycle management and teardown/reinstatement during upgrades.
• Engage with client DBAs and IT teams for data integration and migrations.
• Monitor and tune performance across a multi‑tenant environment.
• Ensure security, integrity, and availability of tenant databases.
• Build automation for routine DBA tasks (PowerShell, Ansible).
• Create architecture standards and documentation for the DBA team.
• Collaborate on service delivery within a global operations team.

Skills

SQL Server

Always On AGs

Disaster Recovery

CDC

T-SQL

PowerShell

Ansible

Mentoring

Communication

Client engagement

Education

Bachelor's degree or higher in CS/IT

Tools

SSMS

SQL Server Agent

PowerShell Scripting

Job description

Aderant is seeking a Principal Database Administrator to lead SQL Server architecture, HA/DR, and multi‑tenant resilience across Sierra cloud operations. This senior, hands‑on role requires ownership of design decisions and direct engagement with client‑side DBAs to maintain robust database platforms.

You will mentor the DBA team, drive incident analysis, and optimize performance at scale while ensuring security and reliability across global tenants.