Address
Form of work
Salary My client is looking for a SQL Data Migration Consultant / Developer 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
• 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)
• Experience in SQL Development
Desirable
• Previous CRM/Billing migration experience
Responsibilities include:
1. 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.
2. 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.
3. 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.
4. 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.
5. Documentation: Maintain documentation detailing the migration process, including data mappings, transformation rules, migration scripts, configuration settings, and testing procedures.
6. 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
7. 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 time a week 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
