Microsoft Senior SQL Database Administrator

This job is with Capgemini, an inclusive employer and a member of my Gwork – the largest global platform for the LGBTQ+ business community. Please do not contact the recruiter directly.

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)

• 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.

• 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…