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:
- You must apply online on LinkedIn.
- 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