SC Cleared Data Migration Consultant

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., * 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, At Robertson Sumner, we only obtain and store your data because we have a legitimate interest to do so - namely help you secure a new job opportunity. In order to provide the best possible employment opportunities that are tailored to you, we need to process certain information about you. We only ask for details that will genuinely help us to help you. We collect your information to assist us in securing you a new job opportunity. This data will be collected either directly from you or via third parties such as LinkedIn or job sites. All data and communications between yourselves and our business will be stored, in a secure onsite server, or external cloud environment, located within the UK/EU. We may share your personal data with various parties, in various ways and for various reasons. Primarily we will share your information with prospective employers to increase your chances of securing the job you want.

• Privacy Policy*, This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience. Necessary Necessary Always Enabled Necessary cookies are absolutely essential for the website to function properly. These cookies ensure basic functionalities and security features of the website, anonymously. Cookie Duration Description cookielawinfo-checkbox-advertisement 1 year Set by the GDPR Cookie Consent plugin, this cookie is used to record the user consent for the cookies in the "Advertisement" category . cookielawinfo-checkbox-analytics 1 year Set by the GDPR Cookie Consent plugin, this cookie is used to record the user consent for the cookies in the "Analytics" category . cookielawinfo-checkbox-functional 1 year The cookie is set by the GDPR Cookie Consent plugin to record the user consent for the cookies in the category "Functional". cookielawinfo-checkbox-necessary 1 year Set by the GDPR Cookie Consent plugin, this cookie is used to record the user consent for the cookies in the "Necessary" category . cookielawinfo-checkbox-others 1 year Set by the GDPR Cookie Consent plugin, this cookie is used to store the user consent for cookies in the category "Others". cookielawinfo-checkbox-performance 1 year Set by the GDPR Cookie Consent plugin, this cookie is used to store the user consent for cookies in the category "Performance". CookieLawInfoConsent 1 year Records the default button state of the corresponding category & the status of CCPA. It works only in coordination with the primary cookie. Functional Functional Functional cookies help to perform certain functionalities like sharing the content of the website on social media platforms, collect feedbacks, and other third-party features. Performance Performance Performance cookies are used to understand and analyze the key performance indexes of the website which helps in delivering a better user experience for the visitors. Analytics Analytics Analytical cookies are used to understand how visitors interact with the website. These cookies help provide information on metrics the number of visitors, bounce rate, traffic source, etc. Cookie Duration Description _ga 2 years The _ga cookie, installed by Google Analytics, calculates visitor, session and campaign data and also keeps track of site usage for the site's analytics report. The cookie stores information anonymously and assigns a randomly generated number to recognize unique visitors. _ga_19XV4SEMBV 2 years This cookie is installed by Google Analytics. _gat_gtag_UA_49681514_1 1 minute Set by Google to distinguish users. _gid 1 day Installed by Google Analytics, _gid cookie stores information on how visitors use a website, while also creating an analytics report of the website's performance. Some of the data that are collected include the number of visitors, their source, and the pages they visit anonymously. CONSENT 2 years YouTube sets this cookie via embedded youtube-videos and registers anonymous statistical data.

Essential

• 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, * 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.