SQL Server Database Administrator

Are you passionate about working with cutting-edge technology and self-motivated to find innovative solutions to complex challenges as part of a team who help keep the UK safe?

Job Description:
We are seeking an Enhanced DV Cleared Microsoft SQL Server DBA to join our team in London on an initial 10 month contract, 4-5 days in office.

Duties and Responsibilities:
Provide DBA support on all aspects of Microsoft SQL Server including design, administration, backup/recovery, Availability Groups, deployment and real-time production troubleshooting responsibilities for SQL versions SQL2014 upwards.
Install and configure Windows Clusters, Microsoft SQL Servers and Availability Groups.
Maintain and troubleshoot High Availability/DR including Windows Clustering and Always On Availability Groups.
Conduct root cause analysis, database performance monitoring, and capacity planning.
Performance tuning of databases/queries.
Implementing and managing monitoring/proactive alerting processes.
Automation via SQL Server Agent and PowerShell scripting etc.
Participate in key periodic operations tasks including high availability and disaster recovery testing, operating system and database patching, database upgrades and migrations.
Provide comprehensive and clear documentation for all new database builds, redevelopments, enhancements, for standard operational procedures.
Collaborate with Developers to architect DB solutions for core platform initiatives.
Working independently and within a wider team with minimal supervision.
Attend and actively participate in SCRUM ceremonies and events.
Able to be proactive, multi-task and stay organized in a dynamic work environment.
Requirements:
Experience in a similar position.
Strong knowledge of SQL Server High Availability technologies - such as Windows Clustering, Availability Groups and Distributed Availability Groups.
Windows Clustering.
Enterprise scale mission critical SQL Server implementations, VLDB, multiple databases with Availability Groups.
Implementing and troubleshooting SQL Server High Availability groups.
Troubleshooting SQL Server Database Engine.
Root cause analysis, database performance monitoring, and capacity planning.
SQL Server migration and upgrade.
SQL Server backup and recovery.
Indexes and Statistics.
SQL Server patch management.
Powershell Scripting.
Good oral and written communication skills in English.
Note:
Please note that due to security and urgency for this role, we can only consider those with live and transferrable Enhanced DV clearance. Read more