Cloud Migration Engineer

We are seeking a skilled Database Migration Engineer with 4-6 years of experience for our Greater Bengaluru Area location. This role focuses on leading end-to-end database migrations, emphasizing design, strategy, and architecture. You will define optimal migration approaches (lift-and-shift, refactor, heterogeneous), architect zero-downtime solutions, select appropriate tools, and execute complex migrations (on-premise to cloud, cross-cloud, Oracle to PostgreSQL/Snowflake, etc.). Your responsibilities include ensuring data integrity, performance, security, compliance, and minimizing business disruption. This senior position demands deep technical leadership in migration design and hands-on execution for critical transformation programs.

Key Responsibilities:

• Lead migration design & architecture: Develop comprehensive strategies, roadmaps, reference architectures, patterns, and decision frameworks for homogeneous/heterogeneous migrations.
• Perform discovery, compatibility analysis, schema mapping, gap identification, and risk assessment to select lift-and-shift vs. refactor vs. re-platform paths.
• Design schema conversions, data transformations, mapping rules, cleansing/enrichment logic, and security/compliance controls (encryption, masking, GDPR/DPDP alignment).
• Architect data movement solutions: batch/CDC pipelines, dual-write, blue-green, phased cutover for zero/near-zero downtime.
• Select and integrate tools; customize replication/ETL frameworks to project scale and requirements.
• Create detailed designs (HLD/LLD), runbooks, validation frameworks, rollback plans, and dry-run simulations.
• Execute migrations: schema conversion, data transfer/sync, validation, reconciliation, cutover, and troubleshooting.
• Collaborate with app teams, DBAs, cloud architects, security, and stakeholders to align designs and execution.
• Build repeatable patterns, accelerators, and best practices; mentor team members.

Must-Have Skills & Experience:

• 4–6+ years in database engineering/migrations, with proven leadership in migration design/architecture for 4+ large-scale projects.
• Expertise in 2+ RDBMS: Oracle, SQL Server, PostgreSQL, MySQL, DB2 (exposure to Snowflake, Redshift, BigQuery a plus).
• Hands-on with cloud migration services: AWS DMS/SCT, Azure DMS, Google DMS, OCI GoldenGate.
• Strong CDC/replication: Debezium, Oracle GoldenGate, Qlik, Striim.
• Schema conversion & ETL: AWS SCT, ora2pg, SSMA, Informatica/Talend/dbt/Spark/Python pipelines.
• Advanced SQL + scripting (Python/Bash/PowerShell) for prototyping, validation, automation.
• Deep knowledge of zero-downtime patterns, data consistency, partitioning, indexing, performance tuning.

Strong Differentiators:

• Track record as migration architect on cloud-bound / heterogeneous projects.
• Cloud certs: AWS Database Specialty, Azure Data Engineer, Google Professional Data Engineer.
• Experience with modern platforms: Snowflake, Databricks, BigQuery.
• IaC familiarity (Terraform) and mainframe/legacy ERP migrations.

Qualifications:

• Bachelor’s/Master’s in Computer Science/IT or equivalent.
• Exceptional problem-solving, stakeholder communication, and risk-mitigation mindset.