Location
stockport
Job Type
Full-time
Posted
May 31, 2026
Job Description
PH Jones is looking for an experienced Senior SQL Server DBA to join our IS function on a contract basis. The contract is for 6 months, hybrid (home and Stockport office as required), 40 hours per week between 08:00-18:00 Monday to Friday, and will be engaged via our preferred agency partner.
Responsibilities
- Diagnose and remediate HA issues: quorum, witness migration, AOAG configuration and validation.
- Design and implement batching, lock‑order alignment, and indexing/partitioning to stabilise maintenance jobs.
- Tune high‑usage queries and stored procedures for Pilot/PilotArchive/PilotDocumentManagement; manage plan stability.
- Establish observability: XE deadlock capture, blocked process reports, Query Store baselines and dashboards.
- Harden backup/restore/DR; create and socialise detailed runbooks; coordinate failover tests with Ops.
- Support Rise features: schema reviews, migration scripts, performance advic...