DB2 Architect – Cloud Migration : Toronto, ON : Onsite : FTE

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.