[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.

Contract
United Kingdom
Negotiable
GPC003120
Tommy Woodward
tommyw@gpc.work
+44 203 154 5032