Senior SQL Server DBA | Remote-First SaaS Reliability Lead

Lead Forensics; United States; Remote; USD 120,000 - 173,000; Full time

Job summary

Lead Forensics is seeking a Senior SQL Server DBA to own and optimise the core Microsoft SQL Server estate and cloud databases, including SingleStore. You will collaborate with software engineering, infrastructure, and security teams to ensure high availability, performance, and security across production and analytics workloads.

The role is remote-first with occasional onsite collaboration in the UK. Relevant MS, cloud, or database certifications are welcomed, with hands-on expertise taking

Qualifications

• 8+ years of experience administering production databases, with senior DBA experience.
• Strong expertise with Microsoft SQL Server including installation, configuration, backups, security, and performance tuning.
• Experience supporting high-traffic SaaS workloads in 24x7 environments.
• Experience with HA/DR options (Always On, clustering, log shipping).
• Experience with cloud databases (Azure or AWS) and managed services.
• Experience with SingleStore or distributed SQL platforms.
• Ability to automate tasks via scripting, source control, and CI/CD.
• Excellent collaboration with software engineering, security, and architecture teams.

Responsibilities

• Administer, monitor, and support production and non-production SQL Server instances and cloud services including SingleStore.
• Ensure high availability, reliability, performance, and security for SaaS workloads.
• Lead proactive monitoring, capacity planning, and health reporting; address risks before impacting customers.
• Diagnose and resolve complex issues including queries, blocking, deadlocks, and resource contention.
• Tune queries, indexes, execution plans, and configurations with developers to optimize performance.
• Design, manage, and test backup, restore, HA, and disaster-recovery processes.
• Protect security through least-privilege access, encryption, auditing, and ISO27001-aligned controls.
• Plan and lead installations, upgrades, patching, migrations, and decommissioning with controlled change management.
• Automate routine admin and deployment tasks using T-SQL, scripting, and CI/CD pipelines.
• Support database changes throughout the software delivery lifecycle with DevOps practices.
• Maintain runbooks and architecture docs; promote knowledge sharing.
• Participate in on-call/out-of-hours rota to support critical services.

Skills

Microsoft SQL Server

Always On Availability Groups

SQL performance tuning

Azure or AWS

SingleStore

T-SQL

CI/CD pipelines

Security and auditing

Database migration/modernization

Tools

Monitoring tools

Backup/DR tooling

Job description

Lead Forensics is seeking a Senior SQL Server DBA to own and optimise the core Microsoft SQL Server estate and cloud databases, including SingleStore. You will collaborate with software engineering, infrastructure, and security teams to ensure high availability, performance, and security across production and analytics workloads.

The role is remote-first with occasional onsite collaboration in the UK. Relevant MS, cloud, or database certifications are welcomed, with hands-on expertise taking