Senior SQL BDA
Hire Resolve
Overview
The Senior SQL BDA will oversee the management and upkeep of critical SQL Server database platforms, ensuring their configuration, performance, security, and reliability. This includes working collaboratively with development teams to resolve complex performance issues, maintain disaster recovery readiness, and ensure that the database estate is secure and compliant.
Responsibilities
- Manage SQL Server databases through all lifecycle environments (development, UAT, production).
- Install, configure, maintain, patch, and upgrade SQL Server instances and related components.
- Configure and maintain SQL Server services, Agent jobs, maintenance plans, linked servers, operators, alerts, and database mail.
- Monitor SQL Server health, performance, capacity, availability, storage, jobs, backups, and replication.
- Investigate and resolve production incidents, service outages, performance degradation, blocking, deadlocks, and corruption risks.
- Maintain operational documentation, runbooks, inventory, and change records.
- Participate in planned maintenance windows, after-hours support, release deployments, and on-call rotations.
- Design, configure, maintain, and troubleshoot HA/DR solutions (Always On Availability Groups, Failover Cluster Instances, replication, log shipping).
- Monitor and validate HA components (replicas, listeners, quorum, failover behavior, synchronization health).
- Maintain log shipping configuration, backup copy schedules, and failover readiness.
- Perform DR testing, failover validation, and recovery validation.
- Define and support RPO and RTO objectives in partnership with business and risk teams.
- Maintain documented recovery procedures for restore, failover, and rollback scenarios.
- Ensure production and DR environments remain aligned (logins, permissions, jobs, etc.).
- Design and maintain backup strategies (full, differential, transaction log, copy-only).
- Maintain transaction log backup frequency and retention aligned to business requirements.
- Perform regular restore tests to validate backup integrity and recoverability.
- Troubleshoot backup/restore failures, including VSS/application-aware backup issues.
- Work with enterprise backup platforms (e.g., Veeam) for application-aware backups.
How to apply
Verify before you apply
SpanSam summarises opportunities for easier discovery. Always confirm the closing date, eligibility requirements and submission instructions on the original source before sending personal information or documents.
About this listing: SpanSam is an opportunity discovery service and is not the hiring employer unless explicitly stated. Application decisions and source-listing changes are controlled by the employer or institution.