Online Database Lead SQL Server Express (Outside IR35) at Public Sector Resourcing, Remote, £450 per day

£450 per day
  • Outside Spy
  • Sep 16, 2020
Duration not stated

Contract Description

*Authority: * Cabinet Office Infrastructure and Projects Authority
*Contract: * 3 Months
*Location: * Home based

*Are you a specialist in Database Management Systems (DBMS) and specifically an expert in Microsoft SQL Server Express? Do you have experience of merging databases ideally on government projects? If so PSR would like to speak to you!*

*As Online Database Lead, you will: *

* Be responsible for upgrading two important central government databases, both with the following deliverables:
* Transition GMPP Database from Microsoft Access to Microsoft SQL Server Express
* Develop a semi-automated ETL process from Oscar Extracts to the Database, with Built in Data Quality Checks
* Reconcile Q2 GMPP Online Returns with Excel Versions (for initial phased departments)
* Develop update processes for amending old data
* Create all calculated fields (from Headline Dataset) in new Database
* Draft Backup and Recovery Plan
* Create Full Documentation for the new Database
* Train team in using the new Database

*Youll have: *

* Specialist skills in Database Management Systems
* Expert in Microsoft SQL Server Express
* Experience of transitioning Microsoft Access Databases to Microsoft SQL Server Express
* Experience of setting up and documenting new DBMS Processes
* SC Clearance

*It would be great to also have: *

* Experience working on DBMS within central government or the public sector

Job Types: Full-time, Contract

Salary: Up to £450.00 per day

* Work from home
* Monday to Friday

* Microsoft SQL Server : 2 years (Required)

* current SC clearance (Required)

Flexible Working Options Available:
* Work from home

Work remotely:
* Yes