Senior SQL Server DBA

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...