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

Who is the Employer?
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.

Who Are You?
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 contemporary AI‑assisted engineering tools such as Claude Code, OpenAI Codex, GitHub Copilot, Cursor, or similar technologies to improve productivity while applying sound engineering judgment to ensure accuracy, security, and reliability.

What You'll Be Doing
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.

GenAI & Agentic Engineering Responsibilities
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, GitHub 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 before production implementation.

Applying strong engineering judgment to ensure security, correctness, maintainability, and compliance.

What You Will Bring
Education & Experience

Bachelor's Degree in Computer Science, Software Engineering, Information Technology, Data Engineering, or a related discipline.

4-6 years of proven IT experience including delivering data migration projects involving enterprise‑scale databases.

Strong experience migrating data between Oracle and PostgreSQL environments.

Experience supporting large‑scale, business‑critical, or production data migration initiatives.

Experience with application modernization, legacy system replacement, or database modernization projects.





Experience interpreting application source code to understand business rules, data usage patterns, and hidden dependencies.

Experience using GenAI or agentic coding tools such as Claude Code, OpenAI Codex, GitHub Copilot, Cursor, or similar tools.

Experience with Git, CI/CD pipelines, automated testing, and deployment processes.

Technical Skills

Strong expertise with:

Oracle Database

PostgreSQL

SQL and PL/SQL

Database schema analysis and design

Stored procedures, functions, triggers, and database programming

Data migration architecture and execution

ETL and data transformation processes

Data validation and reconciliation methodologies

Performance tuning and query optimization

Development experience using:

Java

Python

Shell scripting and automation tools

Experience working with:

Git version control

CI/CD pipelines

Automated testing frameworks

Deployment automation tools

Familiarity with:

Linux environments

Containerized development environments

Cloud and on‑premises infrastructure

Data governance and auditability requirements

Soft Skills

Exceptional analytical and problem‑solving abilities.

Strong communication and documentation skills.

Ability to independently investigate and understand unfamiliar systems.

Strong attention to detail and commitment to data quality.

Ability to manage multiple priorities in fast‑paced project environments.

Collaborative mindset with strong stakeholder engagement skills.

Ideal Candidate Profile
The ideal candidate is a hands‑on Data Migration Engineer who can independently investigate a source system, understand how data is structured and utilized, and build reliable migration solutions into a target platform.

You possess deep expertise in Oracle, PostgreSQL, SQL, Java, and Python while understanding both software development and database administration principles. You embrace modern AI‑assisted development tools as productivity enhancers while maintaining accountability for the quality, security, and reliability of your work.

Key Competencies

Data Migration

Database Development

Oracle

PostgreSQL

SQL Development

PL/SQL

Java

Python

ETL Processes

Performance Optimization

Data Validation

Problem Solving

Documentation

Collaboration

AI‑Assisted Development

Continuous Improvement

Equity & Diversity Statement
We encourage all qualified applicants to apply, including people from traditionally underrepresented groups such as women, visible minorities, Indigenous peoples, people identifying as LGBTQ2SI, veterans, and people with visible/nonvisible disabilities.

#J-18808-Ljbffr

📌 Data Migration Specialist (Ontario)
🏢 Raise - find a more meaningful working experience
📍 Ontario