Salary: £90,000 - 90,000 per year
Requirements:
- Expert-level T‑SQL and SQL Server internals (5 years) including partitioning, indexing strategy, query plan analysis, dynamic SQL, and stored procedure design at scale.
- Experience with Redgate tooling (Monitor, SQL Prompt, SQL Source Control).
- Hands‑on data warehouse design and build Kimball‑style dimensional modelling (fact/dim schemas), incremental and full‑load patterns, slowly changing dimensions, ETL/ELT framework design.
- Production ETL development with SSIS for understanding/decommissioning legacy work, plus modern alternatives (custom T‑SQL frameworks, ADF, dbt, or equivalent) for new builds.
- Operational SQL Server experience as the senior responsible person (backups, restore, security, monitoring, performance triage, replication).
- Multi‑instance estate experience is essential; not a single‑database background.
- Proficiency in Azure SQL...