Senior Database Administrator (SQL Server DBA) – FTSE250 client - Hybrid

Overview
I am currently recruiting for a SQL DBA for one of my clients who are a FTSE250 financial services organisation. This role offers the chance to work in a dynamic environment, managing a diverse SQL Server and Azure SQL database estate, and contributing to cutting-edge database solutions.


Role Responsibilities
*Administer and manage the SQL Server and PaaS estate across live and non-live environments.
*Perform database performance analysis and tuning.
*Develop and enforce best practices in database management.
*Collaborate with data development, Infosec, and Infrastructure teams.
*Plan and execute database capacity strategies.
*Ensure high availability and security standards across the database infrastructure.
*Provide technical support to developers and end users.
*Lead database-related projects, including upgrades and migrations.
*Automate processes using tools such as SPADE and DBATools.
*Participate in on-call and disaster recovery support rotations.

Essential Skills and Experience
*Proficiency in SQL Server versions 2016/2017/2019/2022 (Enterprise, Standard, and Express).
*Strong troubleshooting and problem-resolution skills.
*Experience with SQL Server Availability Groups and performance tuning.
*Proficiency in SSRS, SSIS, and SSAS administration and deployment.
*Knowledge of replication techniques, CDC, table tracking, partitioning, and auditing.
*Ability to design and implement database platforms, including capacity planning, patching, and migrations.
*Effective communication skills with technical and non-technical stakeholders.

Desirable Skills
*Basic understanding of PowerShell scripting.
*Exposure to SQL Azure DevOps (CI/CD, Repos, Pipelines).
*Familiarity with non-relational databases like Cosmos DB.
*Experience in high availability environments and cloud platforms like Azure.
*Mentoring and team development experience.

Package:
*Up to £75,000
*+ Excellent benefits
*Hybrid (3x week in Central London)