Lead Database Administrator

Job Description

Are you a Lead Database Administrator looking for your next challenge?

Sopra Steria’s Aerospace and Defence division works on a number of projects aimed at improving people’s ability to access digital information and services. We are looking for a Lead Database Administrator to join our team on a new project delivering essential support services to the UK’s Armed Forces.

As our new Lead Database Administrator (LDA) will be responsible for the end-to-end design, implementation, configuration, maintenance and performance of a new business critical SQL-based database services.

This is a “hands-on” office-based position in Hemel Hempstead, requiring solid technical, as well as excellent interpersonal and communications skills.

What you’ll be doing:

• 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
• 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

What you’ll bring:

• Experience as a SQL Database Administrator
• Vocational/Diploma/Associate Degree (technical field) or relevant Microsoft certification (MCTS, MCITP and /or MVP Certified)
• 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

It would be great if you had:

• 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

If you are interested in this role but not sure if your skills and experience are exactly what we’re looking for, please do apply, we’d love to hear from you!
Employment Type: Permanent
Location: Office based – Hemel Hempstead
Security Clearance Level: DV
Internal Recruiter: Carolyne Capstick
Salary: £70,000.00
Benefits: £5,400 car allowance, 25 days annual leave with the option to buy additional days, private medical, life assurance, pension, and generous flexible benefits fund

Although this role is advertised as full-time, we believe that flexibility at work can promote work/life balance, increase your motivation, reduce stress and improves performance and productivity. We support different ways of working and can offer a range of flexible working arrangements. So, if you’re interested and need to work flexibly, we encourage you to apply and talk to us about what might be possible.

Loved reading about this job and want to know more about us?
Sopra Steria’s Aerospace, Defence and Security business designs, develops and deploys digital solutions to Central Government clients. The work we do makes a real difference to the client’s goal of National Security, and we operate in a unique and privileged environment. We are given time for professional development activities, and we coach and mentor our colleagues, sharing knowledge and learning from each other. We foster a culture in which employees feel valued and supported and have pride in their work for the customer, delivering outstanding rates of customer satisfaction in the UK’s most complex safety- and security-critical markets.
We embrace difference as a source of creativity, innovation and competitive advantage and are striving to become a more diverse organisation. We welcome applications from people with a diverse variety of backgrounds and identities. We are committed to equality of opportunity for all and do not discriminate on the basis of race, religion, colour, gender, age, disability, sexual orientation or marital status. We have partnered with Vercida, the UK’s largest diversity and inclusion focused careers site, where all our vacancies are available in an accessible format.
If you require any adjustments to the recruitment process, to enable you to perform to the best of your ability, please let us know when completing your application. We participate in the Disability Confident scheme and are committed to offering an interview to any candidate with a disability, who meets the minimum criteria for the role. If you believe this could apply to you, please let us know when completing your application.