- Pay Rate:
Up to £387.89 per day PAYE depending on experience
- Hours per Week:
36 Monday – Friday, normal working hours
This opening assignment is for 6 months
- West Brompton, London,
Interim Database Migration Engineer - Counter Terrorism Policing
Reference no: MPS 0005 6E57 / 1
Pay Rate: Up to £387.89 per day PAYE depending on experience
This opening assignment is for 6 months
DV/STRAP vetting required for this role
Candidates with current SC/DV clearances will go through their vetting processes, currently this is taking up to 6 months. If you are already in a contract that potentially is not ending for a few months and this role is of interest, do let us know, we would be happy to discuss further.
The Database Migration Engineer will work with database administrators and the project manager on a national data migration project. This is an essential role supporting the delivery of a key application and demands an awareness of the unique challenges of working within a secure domain.
The project is already in progress and designs, processes and scripts are in place. Pilot migrations are currently in progress. The role requires the migration engineer to assist in the implementation of migrations across a number of regions.
- Work with the project manager, suppliers, regional IT leads and database administrators to migrate legacy data from multiple sources to a single, national database
- Assist in the management of the server infrastructure and software for the staging and test environments, including Oracle and SQL Server databases.
- Managing the export of regional extracts with regional IT units.
- Running supplier scripts to ingest and merge data into the national solution.
- Running data verification and transformation scripts and working with end users and suppliers to resolve any issues.
- Assisting end users with data mapping of source and target fields ahead of the data migration to enable imported data to be mapped to the relevant fields using the software tools provided.
- Testing of data migration and schema transfers during migration events. Supporting end users during testing activities.
- Ensuring that all security aspects are met for the purposes of transferring the data to the national solution.
A career in Counter Terrorism Policing (CT Policing) is like no other. Every day offers a variety of exciting challenges and exceptional opportunities played out on a regional, national and international stage. Your skills could help protect the UK. With the ongoing terrorist threat, there has never been a more important time to be working alongside some of the best and brightest to help keep people safe. Counter Terrorism Policing is a collaboration of UK police forces working with the UK intelligence community to help protect the public and our national security by preventing, deterring and investigating terrorist activity. We do this by working in local to global partnerships, from policing teams on the beat and on the streets; supported by a national network of specialist officers and staff across the UK, to our investigators and expert advisors in every corner of the world.
Uniquely the police service, and specifically the Counter Terrorism network contributes to all four Pillars of the governments National Counter Terrorism (CONTEST) strategy. The Counter Terrorism Policing headquarters, on behalf of government and the National Police Chiefs’ Council (NPCC), ensures that the CT network has the funding, capabilities and resources it needs to deliver CONTEST effectively and to keep people safe from terrorism. It does this through the provision of corporate services, as well as national operational tasking and coordination. It houses a number of unique national CT capabilities that support the entire network, as well as overseeing delivery of CT policing across the regions to ensure that it operates in a way that is both effective and efficient. Crucially CTPHQ represents CT policing’s interest within government and with wider stakeholders, ensuring that the policing contribution to CONTEST is both understood and appreciated. Hosted by the Metropolitan Police, Counter Terrorism Policing oversees the UK’s National Counter Terrorism Policing Network.
“Role Requirements” – to give yourself the maximum chance of success please try and ensure your CV addresses the following essential criteria:
***Qualification details and any other experience/skills relevant to the job role to help support your application (and help us to help you!) – please give full details within your CV document.
- Minimum of 12 months recent experience in a similar role, or context and ideally within a public sector organisation.
- Experience of working with Microsoft SQL Server;
- Experience of working with Oracle
- Experience of Oracle schema exports.
- Experience in building queries and stored procedures in SQL;
- Experience of complex database migrations (e.g. Legacy Oracle to MS SQL);
- Experience of testing migrations and working with test resource
- Conduct investigations to support defect root cause analysis of migration issues.
Experience/Qualifications – Desirable
- SQL Certification
- ITIL v3+ Foundation
NB: Please feel free to apply to us direct via [email protected] by quoting the job reference and job title exactly. SEE DETAILS AT THE BOTTOM OF THIS AD.
If you have previously applied to one of our vacancies and have already sent the required supporting documentation to us, please make this clear when you re-apply as this will help speed up your application.
Please quote the Job Title & Vacancy Reference No. in your application, or we will be unable to match your CV to the role being applied for.
Other “Essential Requirements” – Please check to ensure that your CV addresses the following items:
- Our clients are generally seeking applicants who are reasonably local, so on that basis we would ideally like you to supply us with your address (or at least your post code) and a telephone number so that we can reach you during working hours.
- Your recent UK working experience going back at least 5 years, or full employment history if you have been working for fewer years than this.
- Your availability to work either immediately, or at short notice.
- DV/STRAP vetting required for this role
- Please refer to the Role Requirements section above - your CV must address the requirements listed.
Other preferable/desirable details to include on your CV, if applicable:
- Any local authority/public sector experience
- Any relevant qualifications held or being studied for.
Give yourself the best chance of success - View our CV Tip
Email Job Reminder
If you do not have a CV available right now please use this form to send yourself a reminder. When your CV is available, simply click the link in the email or alternatively reply to that email with your attached your CV.
Database Migration Engineer - Counter Terrorism Policing
Your CV needs to be current with your most recent role. We won’t be able to submit it with any unexplained gaps in employment. It will save time and improve your chances of success if we can put your CV forward immediately without having to ask for revisions.
Your CV must cover the “Essential Requirements” of the role. Ideally you will address the “Essential Requirements” on each job description page directly, in a bullet point list. Please include any DBS details and other qualifications called for.
Your CV should clearly state that you are available to start work either immediately, or at short notice. In general, our clients are unable to work with notice periods of more than 1 week from the point at which a role is offered, 2 weeks at the very most.
We do not put forward covering letters, so please ensure that your CV in contains all relevant information being called for.
We recommend that you consider sending us a CV suitably tailored CV for each role that you apply for. Job board aggregator sites will generally store only one version of your CV, which can be a bit limiting, so this is to your advantage.