Back to results

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

  • ON, Canada
  • Ontario, Canada, Canada

Contract

Applications open in a new tab.

Job details

Job type
Contract
Apply by
Experience
10+ years of database engineering or data migration experience.
Posting language
English
Posted

Original 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 accommodations@aliantresources.com. 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.
  1. 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.
More about this job

Responsibilities

Design and lead DB2/400-to-Oracle migration strategies, including source-to-target mappings, conversion rules, and ETL processes for historical and transactional data. Validate and reconcile migrated data, optimize performance, and develop migration, cutover, and rollback plans.

Requirements

Requires 10+ years of database engineering or data migration experience, with strong IBM DB2 for i/DB2/400 and Oracle expertise. Advanced SQL, PL/SQL, ETL, data modeling, enterprise migration, reconciliation, testing, and cutover experience are required; Oracle 19c, financial data migration, and public-sector experience are preferred.

Skills

  • IBM DB2 for i
  • DB2/400
  • Oracle
  • SQL
  • PL/SQL
  • ETL
  • Data Modeling
  • Data Migration
  • Source-to-Target Mapping
  • Data Conversion
  • Data Validation
  • Data Reconciliation
  • Migration Testing
  • Performance Optimization
  • Cutover Planning
  • Rollback Planning

Visa sponsorship

Not detected in the job text

Categories

  • Technology
  • Data & Analytics
  • Government & Public Sector

Keywords

  • IBM DB2 for i
  • DB2/400
  • Oracle
  • Oracle 19c
  • SQL
  • PL/SQL
  • ETL
  • Data Modeling
  • Database Engineering
  • Data Migration
  • Legacy Database Modernization
  • Source-to-Target Mapping
  • Conversion Rules
  • Historical Data
  • Transactional Data
  • Data Validation
  • Data Reconciliation
  • Migration Testing
  • Performance Optimization
  • Cutover Planning
  • Rollback Planning
  • Enterprise Data Migration
  • Financial Data Migration
  • Public Sector

Report this job