RemoteLeaf Logo
Log in Sign up

Lead Database Migration Engineer

2 hours, 56 minutes 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 28

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

MetroStar

SQL Server Database Administrator (Tier 3 Production Support)(6669)

MetroStar 251-1K IT Services

MetroStar is hiring a SQL Server Database Administrator for Tier 3 production support to maintain mission-critical USCIS case management databases and ensure their performance, reliability, and availability.

United States Full-time Mid Level Database Administrator Technical Support Engineer
$101k-$121k
SQL SQL Server
2 hours, 11 minutes ago
Veeam Software

Sr. Director, Graph Databases

Veeam Software 1K-5K Internet Software & Services

Veeam is seeking a technical engineering leader to own the Knowledge Graph and hyperscale data lake integrations for Veeam Data Command Center, helping enterprise customers understand, secure, and trust sensitive data and AI systems at scale.

United States Full-time Lead Database Administrator Director of Engineering
$407k-$845k
Apache Spark AWS Flink GCP Go MLflow Neo4j Presto Pulumi Python Terraform Trino
2 hours, 11 minutes ago
Precision For Medicine

Senior Clinical System Administrator

Precision For Medicine 1K-5K Pharmaceuticals

The Senior Clinical Systems Administrator at Precision Medicine Group supports clinical system operations and adoption across the organization by partnering with Clinical Systems and IT teams.

India Senior Database Administrator
2 hours, 11 minutes ago
Y

Senior Database Administrator

Yuno 51-200 Payment Processing Software

Yuno is hiring a Senior Database Administrator to own and evolve the data layer behind its payment processing and AI agent platforms, with a focus on reliability, performance, and security in AWS-based production systems.

Chile Colombia Europe Netherlands Paraguay Peru Belgium Spain Mexico Germany Argentina Italy Brazil Full-time Senior Database Administrator
AWS Datadog Docker EC2 Kubernetes MongoDB PostgreSQL Python Redis Terraform
3 hours, 11 minutes 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