Senior SQL Database Admin - Hybrid & Cloud Pro

CAPGEMINI; Wales; Hybrid; GBP 60,000 - 100,000; Full time

Benefits offered by this job

Hybrid working

Flexible working arrangements

Disability Confident Employer

Job summary

Capgemini UK is seeking a Senior SQL Server Database Administrator to manage mission-critical SQL Server estates across development, test and production environments. You will ensure security, high availability and performance while collaborating with development, infrastructure and production support teams.

Hybrid working is offered, blending Capgemini offices, client sites, and your home. A series of pre-employment checks including DBS/SC clearance will apply.

Qualifications

• Proven MS SQL Server administration experience across development to production.
• Experience with monitoring, performance tuning, and optimisation using native SQL Server tools (e.g. DMVs, Extended Events, Query Store).
• Experience with backups, restores, and recovery models, including designing recovery strategies aligned to business RPO/RTO requirements.
• Experience of High Availability, replication, and Disaster Recovery options for SQL Server, such as Always On Availability Groups, failover clustering, and log shipping.
• Experience of securing data, including encryption (e.g. TDE, Always Encrypted), role-based access control, and auditing.
• Experience working with Windows Server, including Active Directory.
• Knowledge of Azure SQL Database and Azure SQL Managed Instance.
• Knowledge of Microsoft Azure storage options, such as Blob Storage, Azure Files, and Managed Disks.
• Experience with PowerShell scripting for database administration and automation.
• Familiarity with Infrastructure as Code tools (e.g. Terraform, Bicep, ARM templates) for provisioning database infrastructure.
• Knowledge of DevOps/CI-CD practices for database change management (e.g. SQL Server Data Tools, Azure DevOps Pipelines, e.g. Flyway).
• Awareness of security and compliance frameworks such as ISO 27001, SOC 2, and GDPR as applicable to data handling.

Responsibilities

• Manage SQL Server databases across multiple environments, from development through to production.
• Configure and maintain database servers and processes, monitoring system health, performance, security.
• Lead in diagnosing and resolving issues in real time, liaising with other teams for end-to-end resolution.
• Feedback with development teams on issues requiring application or schema changes.
• Refine and automate regular database processes and maintenance tasks.
• Assist production support with investigation into live issues and act as escalation point for complex incidents.
• Assist developers with complex query tuning, indexing strategy, and schema refinement.
• Provide ongoing support for production systems, including on-call/out-of-hours where required.
• Perform scheduled maintenance and support release deployments, including risk assessment for high-impact changes.
• Maintain and monitor database security, including access control, auditing and data protection compliance.
• Apply data modeling techniques to ensure integration and performance alignment.
• Support and manage Power BI environments, including data source configuration and gateway management.
• Share expertise with peers and mentor junior DBAs and developers.

Skills

SQL Server

Azure SQL

Power BI

Performance tuning

High availability

Security & compliance

PowerShell

CI/CD for databases

Tools

SQL Server DMVs

Extended Events

Query Store

Backups & DR

Azure DevOps Pipelines

Flyway

Job description

Capgemini UK is seeking a Senior SQL Server Database Administrator to manage mission-critical SQL Server estates across development, test and production environments. You will ensure security, high availability and performance while collaborating with development, infrastructure and production support teams.

Hybrid working is offered, blending Capgemini offices, client sites, and your home. A series of pre-employment checks including DBS/SC clearance will apply.