Microsoft Senior SQL Database Administrator

Capgemini; United Kingdom; On-site; GBP 75,000 - 105,000; Full time

Benefits offered by this job

Hybrid working

Disability Confident Employer

Job summary

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

You will also support Azure SQL Database, Power BI, and related data platforms, mentoring junior DBAs and contributing to automation and CI/CD practices.

Qualifications

• Proven MS SQL Server administration across development to production.
• Experience with backups/restores, HA, DR for SQL Server (Always On/Log Shipping).
• Knowledge of Azure SQL Database/Managed Instance and Power BI integration.

Responsibilities

• Manage SQL Server databases across environments with high availability and security.
• Configure and maintain database servers and performance monitoring.
• Lead real-time issue resolution with cross-functional teams.
• Support Power BI environments, data sources, gateways, and performance.

Skills

SQL Server administration

Azure SQL

Power BI

Query tuning

PowerShell scripting

CI/CD for databases

Education

Bachelor's degree in IT or related field

Tools

SQL Server

DMVs

Extended Events

Query Store

Terraform

ARM templates

Job description

# Microsoft Senior SQL Database AdministratorBirmingham, Cardiff Capital Tower, London, Manchester, WokingApply for this job* Permanent* Experienced Professionals* Software Engineering* ID 532286-en\_GB## **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)## **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. You will be joining one of the World’s Most Ethical Companies, as recognised by Ethisphere for 12 consecutive years. We live our values by making ethical business choices every day. Working ethically is at the centre of our culture at Capgemini, meaning you will be helping to create a future we can all be proud of. Capgemini. Make it real.