K&K Global Talent Solutions Inc is an International recruiting agency that has been providing technical resources in Canada region since 1993.
This position is with one of our clients in Canada, who is actively hiring candidates to expand their teams.
Role: DB2 Architect – Cloud Migration
Employment type: Full time
Technology: DB2, Cloud Migration
Location Toronto, ON
Job Description-
- 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.
Required Skill Set:
- 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 role will be responsible for assessing existing DB2 environments, defining target-state database architecture, developing migration strategies, and supporting end-to-end migration from on-premises platforms to Azure/AWS.
Note: Applicants for employment in Canada should possess work authorization which does not require sponsorship by the employer for a visa.