Lead DBA - DV Cleared

  • Job ref:


  • Location:

    Hemel Hempstead, Hertfordshire

  • Sector:


  • Job type:


  • Salary:

    £700 - £800 per day

  • Contact:

    Tom McParland

  • Email:

  • Published:

    3 months ago

  • Duration:

    12 Months

  • Start date:


  • Consultant:


Lead Database Administrator

12 Months

Hemel Hempstead

DV Cleared

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.

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
* Work in a disciplined and structured
* 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
* Proactive problem management

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
* Strong written, communication, troubleshooting and analytical skills
* Ability to organise and plan work independently
* Flexible team player, "get it done" attitude
* Ability to multi-task and context-switch effectively between different activities and teams
* Strong Client facing skills, focused upon meeting delivery deadlines.
* UK Passport holder.
* The role requires HMG security clearance


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