Job Description

Posted 1 week ago

My client is looking for a Data Migration Consultant to come on board for an initial 3 months contract to help on a SQL migration project.  

Essential

Data Migration Experience – Full System Migration Lifecycle experience  – Non Negotiable – lots of SQL Migration and Modelling
Experience in SQL Development – Heavy SQL background is needed with lots of experience in this space and proved experience
Desirable

Previous CRM/Billing migration experience 
SQL JSON processing – Non Negotiable (please make sure this is mentioned in your CV and if not a supporting statement on where you have used this)Responsibilities include: 

Requirements Gathering: Collaborate with stakeholders to understand the scope of the SQL migration project, including data sources, target databases, performance requirements, and any special considerations.
Database Analysis: Analyze the existing SQL databases to identify data structures, dependencies, stored procedures, functions, triggers, and other database objects that need to be migrated.
SQL Scripting: Write SQL scripts to extract data from the source databases, transform it as necessary, and load it into the target databases. This may involve data cleansing, normalization, denormalization, and other data manipulation tasks.
Data Validation: Develop and execute test cases to validate the accuracy, completeness, and consistency of the migrated data. Compare data between source and target databases to identify discrepancies and reconcile any differences.
Documentation: Maintain documentation detailing the migration process, including data mappings, transformation rules, migration scripts, configuration settings, and testing procedures.
Collaboration: Collaborate with other team members, including database administrators, developers, testers, and project managers, to ensure the successful completion of the SQL migration project within the defined timeline
Communication: Communicate regularly with stakeholders to provide updates on the progress of the migration project, address any issues or concerns, and solicit feedback for continuous improvement.
This role will be outside of IR35 paying from £300-£400 per day. With the ideal candidate willing to come onsite 1 -2 time a month to their Bath office but this is NOT an essential fully remote is being considered

If you are interested please send me your updated CV to becca. coombes  Opusrs. com