Data Migration Specialist

Raise; Oakville; On-site; CAD 85,000 - 110,000; Full time

Job summary

Raise is seeking an experienced Data Migration Specialist in Oakville, Ontario. This role involves migrating critical data from legacy systems to modern platforms, requiring strong SQL skills and experience with Oracle and PostgreSQL. The ideal candidate will excel at solving complex data challenges while leveraging AI-assisted tools.

You will work with engineering teams, develop data migration scripts, and ensure accuracy and security of data. The position is hybrid, allowing some remote flexibility.

Qualifications

• 4-6 years of IT experience in data migration projects.
• Strong experience in migrating data between Oracle and PostgreSQL.
• Experience using AI-assisted coding tools like Claude Code and OpenAI Codex.
• Proven ability to create migration scripts and validate data.
• Good understanding of secure coding practices and data governance.

Responsibilities

• Analyze and design data migration activities from legacy systems.
• Develop and maintain migration logic using SQL and PL/SQL.
• Optimize migration performance through tuning and batching techniques.
• Collaborate with teams to understand data models and transformation needs.
• Create technical documentation and validation procedures.

Skills

Data Migration

Database Development

Oracle

PostgreSQL

ETL Processes

Java

Python

SQL Development

PL/SQL

Performance Optimization

Education

Bachelor's Degree in Computer Science or related field

Tools

Git

CI/CD pipelines

Automated testing frameworks

Job description

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 modern 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.