SQL Dba

**Our mission is simpleto help the world Love Mondays.**

Reed Secure are working with a major counter terrorism unit who are looking for a **SC or DV cleared** **Database Administrator** to support a national policing team with the support of its business-critical system.
- This is a temporary role for an initial 6 months, working full-time
- Pay Rate is up to **£500 - £536 per day Umbrella** (inside IR35) depending on the level of experience - PAYE option is also available.
- The role is based in the **West Brompton ( Office Based )**, but this role requires a flexible working approach and may on occasion require travel to sites around the UK, as well as working on-call.

**Job summary**:
This role will be responsible for the maintenance of multiple MS-SQL databases within a live support environment. Working within the Applications Management team the daily duties of this job will include daily health checks, responding to SQL related issues,helping to interface SQL databases with other systems or report queries and developing the use and accessibility of service related data for internal reports. Experience of installing and maintaining SQL databases is essential as is an understanding of complexmaintenance and high availability setups such as Always on HA, Mirroring, log shipping and Microsoft Clustering.

**Main duties include**:

- The SME and point of escalation for all database related issues within the Application Support function.
- Managing the database layer across the estate supporting multiple high priority instances of SQL Server in some cases hosting multiple databases
- Resolving issues with databases, working with third party suppliers to alter schemas, update indexes and plan updates.
- Performing daily checks and maintenance duties.
- Facilitating changes to the data layer and managing daily duties such as SQL queries and bulk data imports.
- Ensuring the all database instances are patched up to date in line with Microsoft patch release scheduling work with minimum supervision.

**Essential**:

- Understanding of ITIL process, incident management, change management and problem management including working to strict SLAs.
- Experience of querying MS-SQL databases using T-SQL on a regular basis, as well as an understanding of program-oriented SQL functions.
- Experience of installing and maintaining SQL databases.
- An understanding of complex maintenance and high availability setups such as Always on HA, Mirroring, log shipping and Microsoft Clustering.
- Previous experience of Incident and Service Request Resolution using Service Management Tools.

**Desirable**:

- Currently or progressing towards being MCSA (SQL) certified.
- Previous experience of working in a SQL Database Administrator Role.
- ITIL v3 - Foundation Certification