Prev vacancy

SQL Database Administrator - SC Cleared

Next vacancy
  • UK, London
  • to £450 per day
  • Contract , 3 months
  • Full time

Our client a central government department are currently looking for an SC Cleared SQL DBA to join their team on 3 month contract based in London and paying £450pd outside IR35.

CV Deadline: Thursday 17th September at 5pm

Looking for experience with the following:

1) Experience of using Microsoft SQL Server

2) Experience of upgrading an existing database to a server based SQL database

3) Experience of providing technical documentation of the new database and processes

Description:

Following an upgrade of our data collections tool for Government Major Projects Portfolio (GMPP), an improved Database Management Systems is required to manage and automate the regular data extracts, whilst also bringing together Government Major Projects Portfolio (GMPP) data with Major Project Assurance Review Data. Storing, linking and therefore analysing these two datasets together is cumbersome and slow with the current database.

The upgrade will also improve the speed of our internal data transformations and allow regular semi-automated updates. It will also enable future growth, enabling the database to be connected straight to Business Intelligence tools and other analytical software – improving the accessibility and potential for the data.

We require specialist skills in Database Management Systems (DBMS), specifically an expert in Microsoft SQL Server Express with experience of transitioning Microsoft Access Databases to Microsoft SQL Server Express and setting up and documenting the new DBMS processes.

The contractor will be responsible for upgrading two databases, both with the following deliverables:

1. Transition GMPP Database from Microsoft Access to Microsoft SQL Server Express

2. Develop a semi-automated ETL process from Oscar Extracts to the Database, with Built in Data Quality Checks

3. Reconcile Q2 GMPP Online Returns with Excel Versions (for initial phased departments)

4. Develop update processes for amending old data

5. Create all calculated fields (from Headline Dataset) in new Database

6. Draft Backup and Recovery Plan

7. Create Full Documentation for the new Database

8. Train team in using the new Database

And repeat the above for Assurance Review Database

  • Quote ref: 990014/21759

Similar jobs

Assistant Project Manager
Anglo Technical Recruitment , Inverness-shire, UK
to £330 per day, Contract

Assistant Project Manager

Our client a central government department are currently looking for an Assistant Project Manager to join their team on...
Researcher
UK Central Government, London, UK
to £210 per day, Contract

Researcher

Our central government client are currently looking for a Researcher to join their team on a 6 month contract based in...
This website uses cookies to enhance your user experience. By continuing to use this site, you consent to our use of these cookies. See our Cookie Policy.