{bc}
Apply
workday

Principal Database Administrator

Aderant
Remote, USA
Full-time
Senior · 7+ years experience
Remote
Discovered 1 weeks ago

Full Job Posting

Responsibilities:

  • Serves as the DBA team's technical authority for SQL Server operations, high availability, disaster recovery and replication architecture across the Sierra platform
  • Acts as the escalation point for complex or high-severity SQL Server incidents, leading root-cause analysis and remediation (connectivity loss, memory pressure, blocking/deadlocks, storage exhaustion)
  • Exercises independent judgment on architectural tradeoffs (e.g., edition-aware maintenance strategy, recovery-chain integrity) and proactively identifies systemic risk before it becomes an incident
  • Design, configure, and maintain SQL Server Always On Availability Groups and Distributed Availability Groups across the Sierra tenant fleet, including DR read-node validation and cross-region replica topology
  • Own transactional replication and Change Data Capture (CDC) lifecycle management, including coordinated teardown and reinstatement around client upgrade and go-live events
  • Serve as the direct technical point of contact with client-side DBA and IT teams on complex data integration, migration, and cutover activities
  • Monitor and tune database performance (queries, indexes, resource usage) at scale across a multi-tenant environment
  • Ensure database security, integrity, stability, and system availability across the tenant fleet
  • Build and maintain automation (PowerShell, Ansible) for routine and complex database maintenance tasks
  • Create and maintain architecture-level documentation, standards, and procedures for the DBA team
  • Collaborate on service delivery within a global operations team
  • Skills & Qualifications:
  • 7+ years of hands-on experience as a SQL Server DBA (2016 or later versions), with demonstrated ownership at a principal or lead level
  • Deep expertise in SQL Server Always On Availability Groups and Distributed Availability Groups — design, configuration, and troubleshooting
  • Strong database design and administration skills
  • Proficient in T-SQL, SSMS, and SQL Server Agent
  • Proven disaster recovery and backup architecture experience, including recovery-chain integrity across full/differential/log backup strategies
  • Advanced database troubleshooting, tuning, and performance triage experience
  • Experience with transactional replication and Change Data Capture (CDC)
  • Experience with MSSQL on cloud platforms (AWS and Azure preferably)
  • Experience leveraging PowerShell, and ideally Ansible, for DBA automation at scale
  • Solid understanding of version control systems (e.g., git) for managing operational scripts
  • Demonstrated ability to mentor and upskill other engineers
  • Excellent oral and written communication skills, including direct client/firm-facing technical engagement
  • Ability to convey technical content clearly to audiences with varying levels of technical depth
  • Ability to balance multiple deliverables with prioritization and responsiveness in a fast-moving environment
  • Experience with any of the following is a plus:
  • Experience with SQL Server Reporting Services
  • Experience with SQL Server Integration Services
  • Agile Software Development including Scrum
  • Microsoft Certifications (SQL, DBA, etc.).

Qualifications

  • Experience with transactional replication and Change Data Capture (CDC)
  • Experience with MSSQL on cloud platforms (AWS and Azure preferably)
  • Experience with SQL Server Reporting Services
  • Experience with SQL Server Integration Services

Apply for this job in 1 click

Skip the repetitive application forms

Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.

Sarah M.James T.Maya R.

Trusted by over 500,000 job seekers on Base Career

Start Free Today

More from this employer

More jobs at Aderant

IT Business Analyst

Atlanta, USA

Discovered 2 days agoFull-time

Talent Management Partner

Atlanta, USA

Discovered 6 days agoFull-time

Manager, Sales Operations

Atlanta, USA

Discovered 2 weeks agoFull-time

Chief Architect, Product Engineering

, USA

Discovered 2 weeks agoFull-time

People Generalist

Atlanta, USA

Discovered 2 weeks agoFull-time

Solutions Platform Engineer

, USA

Discovered 3 weeks agoFull-time

Director, Brand Marketing

Atlanta, USA

Discovered 3 weeks agoFull-time

Project Manager

Atlanta, USA

Discovered 3 weeks agoFull-time