Role: Database Engineer – GCP Migration
Location: Toronto, ON
Work Model: Onsite
Experience: 6–10+ Years
Job Summary
We are looking for an experienced Database Engineer with strong hands-on expertise in DB2 and/or PostgreSQL, along with Google Cloud Platform (GCP) database services. The ideal candidate will be responsible for migrating databases from CDP to GCP Atlas, ensuring minimal downtime, data integrity, performance optimization, and seamless application connectivity throughout the migration process.
Key Responsibilities
•
Lead end-to-end database migration activities from CDP to GCP Atlas across multiple applications and microservices.
•
Design and implement zero or minimal-downtime database migration, replication, synchronization, cutover, and rollback strategies.
•
Perform database assessments, schema validation, data migration, reconciliation, and post-migration verification.
•
Plan and coordinate migration activities based on application dependencies, microservices, and downstream systems.
•
Support phased and canary migrations where legacy and cloud environments operate in parallel.
•
Perform SQL performance tuning, query optimization, indexing, and execution-plan analysis.
•
Troubleshoot database connectivity, performance, data integrity, and migration-related issues.
•
Implement database backup, recovery, monitoring, security, and access-control mechanisms.
•
Prepare migration runbooks, validation checklists, cutover procedures, and rollback plans.
•
Collaborate with GCP architects, application developers, DevOps, infrastructure, security, and business teams during migration and post-migration support.
Required Technical Skills
•
Strong hands-on experience with DB2 and/or PostgreSQL.
•
Good knowledge of Google Cloud Platform (GCP) and cloud database technologies.
•
Experience with Cloud SQL for PostgreSQL and database migration to GCP.
•
Strong SQL skills, including query optimization, indexing, and performance tuning.
•
Hands-on experience with database migration, replication, and data synchronization.
•
Strong understanding of zero-downtime or near-zero-downtime database migration strategies.
•
Knowledge of database backup, recovery, high availability, and disaster recovery concepts.
•
Experience with production database troubleshooting and performance optimization.
Good to Have
•
Understanding of Java, Spring Boot, and microservices architecture.
•
Exposure to GKE (Google Kubernetes Engine) and Kubernetes environments.
•
Experience with database connectivity in cloud-native applications.
•
Banking or financial services industry experience.
•
Experience working on large-scale enterprise cloud migration programs.
Experience Requirements
•
6–10+ years of experience in Database Engineering or Database Administration.
•
Strong production experience in database migration and cloud database environments.
•
Experience handling enterprise-scale database migration projects.