[3120] DV Lead SQL DBA

Duration: 6 Months Initially
Location: Hemel Hempstead - 5 days onsite
Rates: Negotiable (Inside IR35)
Clearance: DV Active

Role Overview

The Lead Database Administrator (LDA) will be responsible for the design, implementation, configuration, maintenance and performance of new, business critical SQL-based database services, being responsible for the end-to-end design, implementation, facilitating the availability and consistent performance of the core) applications. This is a “hands-on” position requiring solid technical, as well as excellent interpersonal and communications skills. The Lead Infrastructure Engineer will be responsible for resolving defects / issues and implementing design changes as directed by the Technical leadership and / or project managers as may applicable.

Key Responsibilities:
• Be responsible for designing greenfield database services based upon Microsoft SQL Enterprise and Standard editions
• Produce and maintain design artifacts, such as but not limited to Low-Level Designs, Release Notes, database service related fail-over / disaster recovery instruction
• Document new procedures and review/update as required thought the delivery
• Be the main point of contact (PoC) for all MS SQL related matter
• Manage SQL Server databases through multiple product life-cycle environments, from development to mission-critical production systems
• Provide input into the Event and Protective monitoring processes as relate to the Database Services work-stream
• Share technical expertise, providing technical mentorship and cross-training to other peers and team members
• Independently analyse, solve and correct issues; performing problem resolution end-to-end; providing feedback using Client provided service management tools
• Liaise with external agencies to resolve issues with 3rd party domains
• Attend Client facing meetings as required
• Develop and maintain Client and third party supplier relationships as may be necessary
• Provide regular updates to the Technical leadership regarding all aspects of the delivery.
• Quickly escalate any issues which impact the delivery of the Database Services components

Essential Skills Experience
• Vocational/Diploma/Associate Degree (technical field) or relevant Microsoft certification (MCTS, MCITP and /or MVP Certified) or relevant demonstrable experience with a Minimum of 3 years’ experience as a SQL DBA
• Expertise in multi-site Always-On High Availability Groups (HAG) and Disaster Recovery (DR) options for SQL Server
• Expertise in database encryption techniques, such as but not limited to Transparent Data Encryption (TDE)
• Knowledge of Microsoft Windows Fail-Over clusters
• Experience with database backup, restores and recovery models
• Experience of creating and modifying Transact-SQL (TSQL) scripts
• A working Knowledge of PowerShell scripting
• Experience of SQL Server Reporting Services (SSRS)
• Experience of working with Microsoft Windows Server operating systems including but not limited to Server 2019 or later
• Have a working knowledge of Microsoft Active Directory (AD) and AD group policies
• UK Passport holder.
• The role requires HMG security clearance

Desirable
• Knowledge of Microsoft SQL Server analysis Services (SSAS)
• Knowledge of Microsoft SQL Server Integration Services (SSIS)
• Knowledge of PowerShell Desired State Configuration (DSC)
• Experience of Microsoft Endpoint Configuration Manager (MECM)
• Experience of Microsoft System Centre Operations Manager (SCOM)
• Understanding of the SQL Server storage requirements
• Familiarity with the MoD and their design guidence and policies to align delivery with MoD Joint Service Publications (JSP) 440, 604, including Joining Rules.