DB2 Architect – Cloud Migration || Toronto, ON || Fulltime FTE
- Temps plein
- Quick Apply
Job Title: DB2 Architect Cloud Migration
Job Location: Toronto, ON
Work Mode: Onsite
Employment Type: Full-Time (FTE) Permanent
Total Experience: 10+ Years
Must have experience of Database Migration, from DB2 to Azure Cloud.
Job Description
We are seeking an experienced DB2 Architect with 10+ years of database engineering and architecture experience, strong expertise in IBM DB2, and hands-on exposure to cloud migration and modernization. The candidate will be responsible for assessing existing DB2 environments, defining target-state database architecture, developing migration strategies, and supporting end-to-end database migration from on-premises platforms to Azure/AWS.
Key Responsibilities
-
Define and govern DB2 database architecture, engineering standards, and best practices.
-
Assess existing DB2 environments, including database size, schemas, stored procedures, performance, integrations, and application dependencies.
-
Design highly available and resilient DB2 solutions covering HADR, backup/recovery, replication, security, RPO/RTO, and disaster recovery.
-
Lead DB2 performance tuning, SQL/query optimization, indexing, capacity planning, and database troubleshooting.
-
Define cloud migration strategies using Rehost, Replatform, Refactor, and Modernize patterns.
-
Develop source-to-target architecture, database migration patterns, sizing, connectivity, security, and HA/DR designs.
-
Evaluate DB2 modernization options, including migration to Azure SQL, Azure Database for PostgreSQL, AWS RDS/Aurora, or DB2 hosted on cloud infrastructure.
-
Develop migration runbooks covering data migration, synchronization, validation, cutover, rollback, and hypercare.
-
Support migration wave planning, dependency analysis, migration rehearsals, production cutover, and post-migration stabilization.
-
Collaborate with application, cloud, infrastructure, security, DevOps, and business teams throughout the migration lifecycle.
-
Drive database automation and CI/CD using Terraform, Azure DevOps, GitHub, Ansible, PowerShell, or Python.
Required Skills & Qualifications
-
10+ years of experience in database engineering and architecture.
-
Strong hands-on expertise in IBM DB2 database architecture and administration.
-
Proven experience with DB2 cloud migration and database modernization.
-
Strong understanding of DB2 performance tuning, SQL optimization, indexing, HADR, backup/recovery, and disaster recovery.
-
Experience designing and implementing database migration strategies across Azure and/or AWS.
-
Knowledge of Azure SQL, Azure Database for PostgreSQL, AWS RDS, and Aurora.
-
Experience with migration planning, data validation, cutover, rollback, and production stabilization.
-
Exposure to database automation and CI/CD tools such as Terraform, Azure DevOps, GitHub, Ansible, PowerShell, or Python.
-
Strong stakeholder management, technical leadership, and architectural documentation skills.