RemoteLeaf Logo
Log in Sign up

Lead Database Migration Engineer

1 month ago
India
Full-time
Lead
Database Administrator
DevOps and Infrastructure
AWS Oracle PostgreSQL SQL Server
Apply Now
Mactores

Mactores

Mactores provides data analytics solutions and services that empower businesses to enhance their operational efficiency and value through automation and advanced technologies such as AI, Big Data, and cloud computing.

IT Services
51-250
Founded 2003
View All Jobs 33

Description

  • Lead end-to-end database migration initiatives, including assessment, planning, schema conversion, execution, and post-migration validation.
  • Design, configure, and manage AWS DMS and SCT environments to support migration quality, performance, and reliability.
  • Author migration runbooks covering execution procedures, validation checkpoints, rollback plans, and operational readiness activities.
  • Perform migration assessments, dependency analysis, compatibility reviews, and recommend migration strategies.
  • Collaborate with infrastructure, application, security, and platform teams to deliver successful migrations.
  • Drive migration testing activities, including functional validation, performance testing, failover testing, and production readiness reviews.
  • Provide technical leadership and guidance to migration teams while following AWS migration best practices and governance standards.
  • Convert and refactor Oracle PL/SQL and SQL Server T-SQL procedural code into PostgreSQL/Aurora PostgreSQL PL/pgSQL, resolving semantic and behavioral differences.
  • Identify and remediate SCT action items and manual conversion gaps in procedural code, then validate converted logic through functional and regression testing.

Requirements

  • 8–12 years of professional experience in database architecture and migration delivery.
  • Hands-on expertise with AWS Database Migration Service (DMS) and AWS Schema Conversion Tool (SCT) for enterprise-scale migrations.
  • Deep proficiency in Oracle, SQL Server, PostgreSQL, and Aurora PostgreSQL environments.
  • Proven experience delivering heterogeneous database migrations across on-premises, cloud, and AWS environments.
  • Knowledge of production database operations, including backup and restore strategies, parameter tuning, performance optimization, and failover testing.
  • Experience authoring and executing migration runbooks, validation plans, cutover procedures, rollback strategies, and post-migration stabilization activities.
  • Strong understanding of AWS database services, migration best practices, and broader cloud migration programs.
  • Experience working directly with enterprise customers, architecture teams, and migration stakeholders.
  • Strong hands-on experience converting Oracle PL/SQL and SQL Server T-SQL business logic to PL/pgSQL, including exception handling, cursor semantics, autonomous transactions, sequences/identity columns, implicit data type conversions, and proprietary built-in packages/functions.
  • Ability to identify and remediate SCT action items and manual conversion gaps in procedural code and validate converted logic through functional and regression testing.
  • Preferred: experience tuning production database performance, backup/restore strategy, and failover testing in high-stakes environments.
  • Preferred: experience leading migration teams or mentoring engineers through complex conversions.
  • Preferred: experience with broader AWS cloud migration programs beyond the database layer.

Interested in this position?

Apply directly on the company website

Apply Now

Similar Roles

MongoDB

Staff Engineer, Query Optimization

MongoDB 1K-5K Internet Software & Services

MongoDB is hiring a senior engineer for its Server Query Optimization team to help build and evolve the core query lifecycle for a distributed document database.

United States North America Full-time Lead Database Administrator
$151k-$297k
AWS Azure C++ GCP MongoDB
3 days, 16 hours ago
Celerion

Veeva Clinical Database Programmer

Celerion 251-1K Pharmaceuticals

Celerion is hiring a full-time remote Veeva Clinical Database Programmer to support clinical research by building, validating, and administering EDC databases for client study projects.

United States Full-time Junior Database Administrator
SQL
3 days, 16 hours ago
AHEAD

Data Governance Lead

AHEAD 1K-5K IT Services

AHEAD is seeking a hands-on Data Governance Lead to build and operate governance within its Data Platform Team, embedding controls across data products, pipelines, and platform services.

United States Full-time Lead Data Architect Database Administrator
$150k-$175k
Kafka Snowflake
6 days, 16 hours ago
Pathward

Data Governance Senior Advisor

Pathward 251-1K Diversified Financial Services

Pathward is hiring a Data Governance professional to define and maintain enterprise data policies, standards, and stewardship practices that improve data quality, compliance, and business alignment.

Anywhere Full-time Lead Database Administrator
$104k-$174k
1 week ago

You're on a roll! Sign up now to keep applying.

Sign Up

Already have an account? Log in

Used by 14,729+ remote workers