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.

- Solid 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.

📌 Architect – Cloud Migration || Toronto, ON || Fulltime FTE
🏢 AceStack
📍 Toronto