6th July 2026
SQL Server Automation Engineer
Engineering
London
£75,000 - £85,000 per annum
SQL Server Automation Engineer
City of London (hybrid)
£75,000 – £85,000 per annum
On behalf of a market leading organisation, I am seeking a SQL Server Automation Engineer. You will hold strong SQL Server experience to join a high-performing team managing a hybrid data platform including SQL Server (2019-2025), Azure SQL, Cosmos DB, Azure Data Factory, and Power BI.
You’ll still work closely with databases day to day, but you’ll also get involved in automation, cloud platform work, and data pipelines, helping shape how the organisation modernises its data platform over time. It’s a good fit for someone who wants to move beyond keeping the lights on and into building and improving systems at scale.
The organisation is pleased to offer this on a hybrid working basis with 3 days per week in their City of London offices, therefore you must be within commutable reach of London.
Responsibilities:
- Manage and support SQL Server environments (including Always On, upgrades, performance tuning, HA/DR)
- Improve how data moves through the platform using Azure Data Factory and related tools
- Build automation and CI/CD for database and platform changes using PowerShell, Terraform, and Azure DevOps
- Improve monitoring, reliability, and operational efficiency across the data platform
- Support cloud adoption and modernisation of data infrastructure
- Work closely with engineers and analysts to make data more reliable and easier to use.
Experience/Skills required:
- Strong SQL Server experience in production environments including migration to SLQ Server 2025 is essential
- Good understanding of performance tuning, indexing, and high availability
- Experience with upgrades, backups, and disaster recovery
- Experience in Scripting eg PowerShell
- Knowledge at a basic level of Terraform would be highly advantageous
- Some exposure to Azure SQL or cloud data platforms
- Interest in automation, Scripting, or CI/CD practices
- Curiosity about data engineering and platform engineering (growth mindset is important here).
Consultant - Brendan Connolly
Telephone: 0207 392 7512
Email: brendan.connolly@spencer-rose.com
Share This Position