Data Migration / Application Retirement Consultant
Contract: 6 months
IR35: Inside IR35
Location: Preston (on-site as required)
Clearance: UK National, SC cleared or eligible for SC transfer
Why Join This Opportunity?
* Work on a high-profile, secure programme focused on enterprise application retirement
* Tackle large-scale, complex datasets in a regulated environment
* Training on a modern data archiving / application retirement platform
* Influence runbooks, validation approaches and BAU processes
* Join a hands‑on, technically strong team of engineers and SMEs
The Role
You’ll lead end‑to‑end data migration and application retirement activities: from discovery and analysis, through build and validation, to cutover and hypercare.
You’ll work closely with platform SMEs, DBAs, BAs and test teams to ensure accurate, auditable, and secure migration of data from legacy applications into a long‑term archive.
Key Responsibilities
* Set up and validate migration environments, connectivity and schema access
* Analyse source system structures, dependencies and data lineage for planning
* Build and run repeatable migration workflows, optimising performance using SQL and scripting
* Deliver structured data validation and reconciliation (row counts, checksums, RI checks, exception handling)
* Support UAT, helping test teams recreate issues and debug SQL/configuration defects
* Prepare detailed cutover runbooks and support production cutover and hypercare
* Produce clear technical documentation and handover to BAU teams
What We’re Looking For
* 10+ years’ experience in data engineering, ETL, DBA or large-scale data migration
* Strong SQL on Oracle and/or SQL Server (debugging, tuning, profiling)
* Deep understanding of relational database design (PK/FK, indexes, constraints, stored procedures)
* Proven data reconciliation and audit experience in complex environments
* Confident in Linux, including shell scripting and basic automation
* Experience with secure connectivity (SFTP, JDBC, ODBC) and scheduled workloads
* Strong stakeholder skills – able to work with BAs, testers, engineers and project leadership
* UK National with active SC or eligible for SC transfer
Advantageous
* Experience with data archiving / application retirement tools
* Background in Defence, Aerospace or other regulated sectors
* Exposure to enterprise application decommissioning and long‑term data retention strategies
Pre‑Screening Questions
Please confirm briefly when applying:
* Are you a UK National with current SC or previous SC that can be transferred?
* How many years’ hands‑on data migration / ETL / DBA experience do you have, and with which databases (e.g. Oracle, SQL Server)?
* Are you happy working inside IR35 and attending the Preston site as required?
If you’re an experienced Data Migration Consultant, Data Engineer or DBA who enjoys complex, secure data work and wants to lead critical application retirement projects, we’d like to hear from you.
Please apply with your CV, SC status, core database skills and earliest start date.
#J-18808-Ljbffr