SQL Server Lead

Salary: £40,000 - 65,000 per year

Requirements:

• Senior SQL Server developer with experience in programming, design, and integration of data warehouse and data distribution platforms.
• Own end-to-end delivery of SQL Server components for security, risk, control, and records management use cases, including requirements capture, technical design, build, code review, deployment, and documentation aligned to engineering standards.
• Implement robust testing and quality controls such as T-SQL unit tests, data quality checks, and reconciliations, and support SIT/UAT release cycles.
• Ensure database solutions meet security and records management requirements including classification, retention, access controls, segregation of duties, logging, and audit trails.
• Design and evolve data models and physical schemas that support security metrics, control monitoring, and MI with clear lineage and interfaces to upstream and downstream data products.
• Provide operational support for production services including monitoring, incident triage, problem management, remediation, and performance optimisation.
• Experience in performance tuning and capacity considerations for SQL Server workloads, including query plans, indexing strategy, partitioning, statistics, and IO/CPU optimisation to meet SLAs.
• Experience in working with engineers, analysts, and control owners to translate security, risk, and records management requirements into robust schemas, data quality rules, lineage, and reconciliations.
• Experience leading by example through peer reviews, coding standards, release discipline, mentoring, and proactive management of delivery risks and dependencies.
• Experience driving continuous improvement through automation.

Responsibilities:

• Design, manage, optimize, and secure Microsoft SQL Server database environments while leading a team of database professionals.
• Ensure high availability, performance, data integrity, and compliance of enterprise database systems that support critical business applications.
• Design, build, and optimise T-SQL code, stored procedures, functions, views, and data models to produce trusted security, risk, and records management datasets.
• Engineer resilient batch and near real-time data processing with strong data profiling, root cause analysis, and incident/problem management.
• Own performance tuning and capacity considerations for SQL Server workloads to meet SLAs.
• Translate security, risk, and records management requirements into robust schemas, data quality rules, lineage, and reconciliations.
• Lead by example through peer reviews, coding standards, release discipline, mentoring, and proactive management of delivery risks and dependencies.
• Support database solutions through monitoring, incident triage, remediation, and performance optimisation.
• Drive continuous improvement through automation.

Technologies:

• AI
• Data Warehouse
• Support
• SQL
• Security
• AWS
• Cloud
• TSQL

More:

The role is hybrid, with day-to-day working split between our offices, client sites, and home, with home working not available 100% of the time. We are a Disability Confident Employer (Level 2) and will offer an interview to candidates who declare a disability and meet the minimum essential criteria, with opt-in during the application process. We are a Great Place to Work for Wellbeing in 2024 and support employee wellbeing through Mental Health Champions, Thrive and Peppy apps, and extensive learning and development opportunities including access to 250,000 courses and external certifications. You would be joining Capgemini, an AI-powered global business and technology transformation partner with nearly 60 years of heritage, around 420,000 team members in more than 50 countries, and 2024 global revenues of €22.1 billion. We are a collective of free-thinkers, entrepreneurs, and industry experts focused on helping clients innovate, grow, and build a more sustainable and inclusive future.

last updated 34 week of 2026