DB2 Architect – Cloud Migration

Tasks

• 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.
• Work with application, cloud, infrastructure, security, DevOps, and business teams throughout the migration lifecycle.
• Drive database automation and CI/CD using tools such as Terraform, Azure DevOps, GitHub, Ansible, PowerShell, or Python.

Requirements

• 10+ years of database engineering and architecture experience.
• Strong expertise in IBM DB2.
• Hands-on exposure to cloud migration and modernization.
• Please apply only if you are currently in Canada.

Schedule

• Full-time, permanent role.

How to apply

• Apply.

Location

• Toronto, ON