Apply now

Posted last month

Upcoming Opportunity - Senior DB2/400 to Oracle Data Migration Architect

@ Aliant Resources

Ontario

Contract10+ years experience
Apply now
SIGNALS

Overview

Aliant Resources is hiring a senior Data Migration Architect on contract in Ontario for upcoming public-sector and enterprise opportunities. The role leads DB2/400-to-Oracle legacy database modernization, covering migration strategy, ETL, validation and cutover planning.

Responsibilities:

  • Design and execute DB2/400-to-Oracle data migration strategies
  • Develop source-to-target mappings, conversion rules and ETL processes
  • Support historical and transactional data migration
  • Perform data validation, reconciliation and performance optimization
  • Develop migration, cutover and rollback plans

Requirements summary:

  • 10+ years of database engineering or data migration experience
  • Strong IBM DB2 for i / DB2/400 and Oracle expertise
  • Advanced SQL, PL/SQL, ETL and data modeling skills
  • Experience with complex enterprise data migration
  • Knowledge of data reconciliation, migration testing and cutover

Tools & skills

Source and dates

Source type not verified · apify-linkedin

Employer posting date
2026-10-15
First seen by our source
2026-11-11
Source record updated
2026-11-11

These dates describe the source record, not a live verification that the employer is still hiring. Check the original posting.

Job details

SenioritySenior
DepartmentData & analytics
Experience10+ years
Work settingOffice
PositionMostly sitting
Physical demandsphysical low · computer high
LanguagesEnglish

Summary and details written by AI from the posting; the employer’s posting is the authority.

Aliant Resources

FieldValue
Open jobs on Jobsy17
Job description

Job ID: AR1066

Job Title: Upcoming Opportunity - Senior DB2/400 to Oracle Data Migration Architect

Location: Ontario, Canada (Hybrid/On-site as required)

Employment Type: Contract – Upcoming Opportunity

Compensation: Commensurate with experience

Consider your new role with Aliant Resources and our public-sector and enterprise clients.

About Us

Aliant Resources is a dedicated provider of professional staffing and workforce solutions, committed to promoting diversity, equity, inclusion, belonging, anti-racism, and accessibility in all facets of our operations.

About the Role:

We are seeking a Data Migration Architect to lead complex legacy database modernization initiatives involving IBM DB2/400 and Oracle.

Please note: This is an upcoming opportunity. Qualified applicants who apply will become part of Aliant Resources' Talent Community and may be considered for current and future contract opportunities with our public sector and enterprise clients.

Key Responsibilities:

  • Design and execute DB2/400-to-Oracle data migration strategies.
  • Develop source-to-target mappings, conversion rules and ETL processes.
  • Support historical and transactional data migration.
  • Perform data validation, reconciliation and performance optimization.
  • Develop migration, cutover and rollback plans.

Required Qualifications:

  • 10+ years of database engineering or data migration experience.
  • Strong IBM DB2 for i / DB2/400 and Oracle expertise.
  • Advanced SQL, PL/SQL, ETL and data modeling skills.
  • Experience with complex enterprise data migration.
  • Knowledge of data reconciliation, migration testing and cutover.

Preferred: Oracle 19c, financial data migration and public-sector experience.

At Aliant Resources, we value diversity and inclusion and we encourage candidates of all backgrounds to apply. We are an equal opportunity employer and we look forward to welcoming you to our team.

Diversity Statement:

At Aliant Resources, we are committed to building a workforce that reflects the communities we serve and to promoting a diverse, anti-racist, inclusive, accessible, merit-based, respectful, and equitable workplace.

Accessibility Statement:

Aliant Resources is dedicated to making our recruitment process accessible to everyone with or without a disability. We adhere to workplace accessibility standards to ensure that individuals with disabilities can fully participate in employment opportunities. We understand the importance of identifying and removing barriers, and we strive to provide an inclusive experience for all candidates.

Workplace Accommodations:

We offer workplace accommodations throughout the recruitment process and all aspects of employment consistent with the requirements of the AODA and OHRC.

If you require workplace accommodations due to a disability, injury, illness, or any other condition that may affect your ability to apply online or perform essential job functions, please reach out to us at [email protected]. Your request will be answered, and we will collaborate with you to provide appropriate workplace accommodations as required.

How to Apply:

1. You must apply online on LinkedIn.

2. Your resume should not exceed three (3) pages.

Note for all Applicants:

● We thank all applicants for their interest but advise that only those selected for further consideration will be contacted.

● Qualified applicants may be considered for other comparable positions.

● Please prepare your application in accordance with the qualifications posted in this job advertisement.

Similar jobs

  • Upcoming Opportunity – EMR Implementation Project Manager

    Ontario
    Contract

    Aliant Resources

    Candidates need a PMP or equivalent project management credential, proven experience managing complex IT implementations, and experience with EMR/EHR or clinical information systems. Strong stakeholder management, communication and change management skills are also required, with healthcare or regulated environment experience preferred.

    TELUS PS Suite, Accuro, Epic, Oracle Cerner, MEDITECH

    Upcoming Opportunity - Senior CA 2E / SYNON Developer – Reverse Engineering

    Ontario
    Contract

    Aliant Resources

    8+ YOEAliant Resources needs candidates with 8+ years of legacy application development, strong hands-on CA 2E/SYNON experience, and knowledge of IBM i / AS400, RPG/RPGLE, COBOL and DB2/400. Strong analytical skills and reverse engineering experience are also required.

    CA 2E, SYNON, IBM i, AS400, RPG, RPGLE

    Upcoming Opportunity - Senior IBM i / AS400 Solution Architect – Legacy Modernization

    Ontario
    Contract

    Aliant Resources

    12+ YOEAliant Resources asks for 12+ years of IT experience, strong IBM i / AS400, RPG/RPGLE, COBOL and DB2/400 skills, and experience with CA 2E/SYNON. Candidates need proven legacy modernization work and strong architecture, documentation and communication skills.

    IBM i, AS400, RPG, RPGLE, COBOL, DB2/400

    Upcoming Opportunity - Senior RPG / RPGLE / COBOL Developer – IBM AS400

    Ontario
    Contract

    Aliant Resources

    8+ YOECandidates need 8+ years of IBM i / AS400 development experience, strong RPG/RPGLE and/or COBOL skills, and experience with DB2/400, SQL and CL. Knowledge of batch processing, file handling, legacy integrations and application documentation is also required.

    IBM i, AS400, DB2/400, SQL, CL

    Upcoming Opportunity - Senior Legacy Application Business Analyst – Reverse Engineering

    Ontario
    Contract

    Aliant Resources

    8+ YOECandidates need 8+ years of business analysis experience and experience with legacy application modernization. Strong requirements gathering, process modeling and stakeholder communication skills are also required.

    IBM i, AS400

    Upcoming Opportunity - Senior Java / Spring Boot Microservices Architect

    Ontario
    Contract

    Aliant Resources

    10+ YOECandidates need 10+ years of enterprise application development, strong Java and Spring Boot skills, and experience with Oracle, REST APIs, Azure, AKS, Docker and Kubernetes. Application security and enterprise integration understanding is also required.

    Java, Spring Boot, Oracle, Azure, AKS, Docker

Locations & environments

Locations

All of CanadaRemote · Hybrid · On-site · Field

Pro tip: add remote jobs to widen your search.

Exclude locations

Workplace type

Company jobs in these results

These are this company’s jobs loaded in your current search. The company may have more openings.