Data Migration Specialist

Data Migration Specialist

Location:

Oakville, Ontario - Hybrid (Open to remote for an exceptional candidate)

Employment Type:

Contract to hire

Contract Duration: 1 year

Experience Level: Intermediate to Senior

The Raise has partnered with our client, an innovative technology organization undergoing significant modernization and digital transformation initiatives. As part of their continued growth, they are seeking a highly skilled Data Migration Specialist to support the migration of critical business data from legacy systems into modern application and database platforms.

This is an exciting opportunity for a hands‑on data professional who enjoys solving complex data challenges, working with modern database technologies, and leveraging emerging AI‑assisted development tools to accelerate engineering productivity.

You are a highly analytical and technically strong Data Migration Specialist who thrives on understanding complex data ecosystems and transforming legacy data into modern, scalable platforms.

You have extensive experience working with Oracle and PostgreSQL databases and are comfortable investigating source systems, analyzing database schemas, understanding business rules, and building reliable migration solutions. You can think like both a Database Administrator and a Software Developer, combining technical expertise with strong problem‑solving skills.

You are also comfortable using modern AI‑assisted engineering tools such as Claude Code, OpenAI Codex, Git Hub Copilot, Cursor, or similar technologies to improve productivity while applying sound engineering judgment to ensure accuracy, security, and reliability.

As a Data Migration Specialist, you will support the analysis, design, development, testing, and execution of data migration activities from legacy systems into modern target platforms.

Practically speaking, you will:

• Work closely with engineering, product, and database teams to understand source and destination data models.
• Analyze legacy and source data repositories to identify database structures, relationships, constraints, indexes, data quality issues, and migration dependencies.
• Design and implement data migration scripts, procedures, and tools to convert source data into required destination formats.
• Develop and maintain migration logic using SQL, PL/SQL, PostgreSQL functions and procedures, Java, and Python.
• Build repeatable and auditable migration processes, including extraction, transformation, loading (ETL), validation, rollback, reconciliation, and reporting.
• Perform data mapping between source and target systems while documenting transformation rules, assumptions, and business logic.
• Optimize migration performance for large datasets through indexing strategies, database tuning, transaction management, and batching techniques.
• Validate migrated data using reconciliation reports, automated validation checks, and exception handling processes.
• Troubleshoot migration issues including schema mismatches, data integrity problems, performance bottlenecks, encoding issues, and failed migration runs.
• Collaborate with software engineers to understand how source data is utilized by applications and how it should be represented within target systems.
• Create and maintain migration documentation, technical specifications, validation procedures, and operational runbooks.
• Follow secure coding practices, privacy requirements, audit controls, and data governance standards when handling sensitive or production data.

The successful candidate will be comfortable leveraging modern AI‑assisted development tools as part of their daily workflow.

Responsibilities include:

• Using Claude Code, OpenAI Codex, Git Hub Copilot, Cursor, or similar tools to analyze SQL scripts, database structures, migration logic, and application code.
• Generating initial drafts of migration scripts, validation routines, SQL queries, and technical documentation.
• Accelerating source code exploration and identifying application dependencies associated with migrated data structures.
• Reviewing, validating, testing, and refining AI‑generated outputs…