Microsoft SQL Server DBA

ROLE PROFILE - MICROSOFT SQL SERVER DBA

• Working for National Security
• UK Enhanced DV cleared only
• London based, willing to work up to 4-5 days in the office, but there is flexibility depending on the scope of the work at various stages of the project
A DV Security Cleared Microsoft SQL Server DBA required to 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., Responsibilies include, but not limited to:
• 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
• Attending and actively participating in SCRUM ceremonies and events
  
  It is essential that candidates can demonstrate prior experience of being an MS SQL Server DBA, in areas such as:
• 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, Ability to be proactive, multi-task and stay organized in a dynamic work environment
• Good oral and written communication skills in English
  
  BAE Systems Digital Intelligence is home to 4,500 digital, cyber and intelligence experts. We work collaboratively across 10 countries to collect, connect and understand complex data, so that governments, nation states, armed forces and commercial businesses can unlock digital advantage in the most demanding environments.