Cloud Migration Engineer

Role: Database Migration Engineer

Experience:4-6 years

Location: BNG

Skills: RDBMS: Oracle, SQL Server, PostgreSQL, MySQL, DB2 (exposure to Snowflake, Redshift, BigQuery a plus), AWS DMS/SCT, Azure DMS, Google DMS, OCI GoldenGate.

JD:

Role Overview We are hiring a Database Migration Engineer to lead end-to-end database migrations with strong emphasis on migration design, strategy, and architecture. You will define optimal approaches (lift-and-shift, refactor, heterogeneous), architect zero-downtime solutions, select tools, and execute complex migrations (on-prem cloud, cross-cloud, Oracle PostgreSQL/Snowflake, etc.) while ensuring data integrity, performance, security, compliance, and minimal business disruption. This senior role combines deep technical leadership in migration design with hands-on execution for high-impact 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

46+ 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

Bachelors/Masters in Computer Science/IT or equivalent.

Exceptional problem-solving, stakeholder communication, and risk-mitigation mindset.