Apply for this job now
- Hemel Hempstead, Hertfordshire
- 23 Sep 2022
Apply for this job now
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 where Sopra Steria is responsible for providing Support* 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 managementEssential 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 clearanceDesirable * 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.Due to the nature and urgency of this post, candidates holding or who have held high level security clearance in the past are most welcome to apply. Please note successful applicants will be required to be security cleared prior to appointment which can take up to a minimum 18 weeks. LA International is a HMG approved ICT Recruitment and Project Solutions Consultancy, operating globally from the largest single site in the UK as an IT Consultancy or as an Employment Business & Agency depending upon the precise nature of the work, for security cleared jobs or non-clearance vacancies, LA International welcome applications from all sections of the community and from people with diverse experience and backgrounds.Award Winning LA International, winner of the Recruiter Awards for Excellence, Best IT Recruitment Company, Best Public Sector Recruitment Company and overall Gold Award winner, has now secured the most prestigious business award that any business can receive, The Queens Award for Enterprise: International Trade, for the second consecutive period.