Microsoft SQL Server DBA

Location(s): UK, Europe & Africa : UK : London
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.
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.
Key Responsibilities
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
• Ability to be proactive, multi-task and stay organized in a dynamic work environment
• Good oral and written communication skills in English

Required Skills
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

Life at BAE Systems Digital Intelligence
We are embracing Hybrid Working. This means you and your colleagues may be working in different locations, such as from home, another BAE Systems office or client site, some or all of the time, and work might be going on at different times of the day.
By embracing technology, we can interact, collaborate and create together, even when we're working remotely from one another. Hybrid Working allows for increased flexibility in when and where we work, helping us to balance our work and personal life more effectively, and enhance well-being.
Diversity and inclusion are integral to the success of BAE Systems Digital Intelligence. We are proud to have an organisational culture where employees with varying perspectives, skills, life experiences and backgrounds - the best and brightest minds - can work together to achieve excellence and realise individual and organisational potential.