Microsoft Senior SQL Database Administrator

Capgemini; Cardiff; Hybrid; GBP 60,000 - 95,000; Full time

Benefits offered by this job

Hybrid working

Flexible hours

Job summary

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

Lead troubleshooting, implement automation, and mentor junior team members. This role requires SC clearance and hybrid working across client sites, Capgemini offices, and home.

Qualifications

• Proven MS SQL Server administration experience across development to production environments.
• Experience with monitoring, performance tuning, and optimisation using SQL Server tools.

Responsibilities

• Manage SQL Server databases across development to production environments, ensuring standards and configuration are consistent.
• Configure and maintain DB servers, monitor health, performance, security and availability.
• Lead real-time issue diagnosis and resolution with cross-team collaboration.
• Automate regular maintenance tasks and optimise database processes.
• Support Power BI environments including data source configuration and gateway management.
• Mentor junior DBAs and developers, sharing best practices.

Skills

SQL Server admin

Azure SQL

Power BI

On-call support

Security & compliance

Education

DP-300 Azure Database Administrator Associate

DP-900 Azure Data Fundamentals

DP-600 Fabric Analytics Engineer Associate

AZ-500 Azure Security Engineer Associate

Tools

Terraform

Bicep

ARM templates

Azure DevOps

Flyway

PowerShell

Job description

About The Job You’re Considering

Our Senior SQL Server Database Administrators manage and support mission-critical database estates across some of the largest Microsoft projects on the market, spanning a wide range of industries. Working across development, test, and production environments, they ensure our clients' data platforms are secure, highly available, and performing at their best. As senior members of the team, they act as subject matter experts and trusted advisors on all things SQL Server, working closely with development, infrastructure, and production support teams to resolve issues end-to-end and to continuously refine and automate how the estate is managed. Their expertise is anchored in the Microsoft data platform - SQL Server, Azure SQL, and Power BI/Fabric - while also bringing broader awareness of the wider data platform landscape.

About The Job You’re Considering

Our Senior SQL Server Database Administrators manage and support mission-critical database estates across some of the largest Microsoft projects on the market, spanning a wide range of industries. Working across development, test, and production environments, they ensure our clients' data platforms are secure, highly available, and performing at their best. As senior members of the team, they act as subject matter experts and trusted advisors on all things SQL Server, working closely with development, infrastructure, and production support teams to resolve issues end-to-end and to continuously refine and automate how the estate is managed. Their expertise is anchored in the Microsoft data platform - SQL Server, Azure SQL, and Power BI/Fabric - while also bringing broader awareness of the wider data platform landscape.

Hybrid working:

The places that you work from day to day will vary according to your role, your needs, and those of the business; it will be a blend of Company offices, client sites, and your home; noting that you will be unable to work at home 100% of the time.

If you are successfully offered this position, you will go through a series of pre-employment checks, including:

• identity, nationality (single or dual) or immigration status, employment history going back 3 continuous years, and unspent criminal record check (known as Disclosure and Barring Service)
• employment history going back 3 continuous years, and unspent criminal record check (known as Disclosure and Barring Service)
• unspent criminal record check (known as Disclosure and Barring Service)

Your role

• Manage SQL Server databases across multiple environments, from development through to production, ensuring consistent standards and configuration.
• Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
• Take a lead role in analysing, diagnosing, and resolving issues in real time, liaising with other teams to provide end-to-end problem resolution.
• Feed back and liaise with development teams on issues requiring application or schema changes.
• Identify opportunities to refine and automate regular database processes and maintenance tasks.
• Assist production support with investigation into live issues, acting as an escalation point for complex incidents.
• Assist developers with complex query tuning, indexing strategy, and schema refinement.
• Provide ongoing support for production systems, including participation in on-call/out-of-hours support rotas where required.
• Perform scheduled maintenance and support release deployments, including planning and risk assessment for high-impact changes.
• Maintain and monitor database security, including access control, auditing, and compliance with data protection requirements.
• Apply data modelling techniques to ensure development and implementation efforts meet integration and performance expectations.
• Support and manage Power BI environments, including data source configuration, gateway management, and performance.
• Share technical expertise with peers and team members, providing mentoring and guidance to junior DBAs and developers.

You can bring your whole self to work. At Capgemini building an inclusive future is part of everyday life and will be part of your working reality. We have built a representative and welcoming environment, for everyone.

Your Skills And Experience

• Proven MS SQL Server administration experience across multiple environments, from development to production.
• Experience with monitoring, performance tuning, and optimisation using native SQL Server tools (e.g. DMVs, Extended Events, Query Store) and other monitoring/troubleshooting tools.
• 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.

Preferred Qualifications

• Microsoft Certified: Azure Database Administrator Associate (DP-300).
• Microsoft Certified: Azure Data Fundamentals (DP-900).
• Microsoft Certified: Fabric Analytics Engineer Associate (DP-600), reflecting the growing use of Microsoft Fabric.
• Knowledge of security best practices in cloud environments, such as Azure Security Engineer Associate (AZ-500).

We are a Disability Confident Employer

Capgemini is proud to be a Disability Confident Employer (Level 2) under the UK Government’s Disability Confident scheme.

As part of our commitment to inclusive recruitment, we will offer an interview to all candidates who:

• Declare they have a disability, and
• Meet the minimum essential criteria for the role.

Please opt in during the application process.

Your Security Clearance

To be successfully appointed to this role, it is a requirement to obtain Security Check (SC) clearance. To obtain SC clearance, the successful applicant must have resided continuously within the United Kingdom for the last 5 years, along with other criteria and requirements. Throughout the recruitment process, you will be asked questions about your security clearance eligibility such as, but not limited to, country of residence and nationality. Some posts are restricted to sole UK Nationals for security reasons; therefore, you may be asked about your citizenship in the application process.

Make it real – what does it mean for you?

You will be encouraged to have a positive work-life balance. Our hybrid-first way of working means we embed hybrid working in all that we do and make flexible working arrangements the day-to-day reality for our people. All UK employees are eligible to request flexible working arrangements.

Why you should consider Capgemini

Growing clients’ businesses while building a more sustainable, more inclusive future is a tough ask. When you join Capgemini, you’ll join a thriving company and become part of a collective of free-thinkers, entrepreneurs and industry experts. We find new ways technology can help us reimagine what’s possible. It’s why, together, we seek out opportunities that will transform the world’s leading businesses, and it’s how you’ll gain the experiences and connections you need to shape your future. By learning from each other every day, sharing knowledge, and always pushing yourself to do better, you’ll build the skills you want. You’ll use your skills to help our clients leverage technology to innovate and grow their business. So, it might not always be easy, but making the world a better place rarely is.

About Capgemini

Capgemini is an AI-powered global business and technology transformation partner, delivering tangible business value. We imagine the future of organisations and make it real with AI, technology and people. With our strong heritage of nearly 60 years, we are a responsible and diverse group of 420,000 team members in more than 50 countries. We deliver end-to-end services and solutions with our deep industry expertise and strong partner ecosystem, leveraging our capabilities across strategy, technology, design, engineering and business operations. The Group reported 2024 global revenues of €22.1 billion.

Make it real | www.capgemini.com