RemoteLeaf Logo
Log in Sign up

Lead Database Migration Engineer

1 month, 3 weeks 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 35

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

CI&T

[Job - 31308] AWS Database, Brasil

CI&T 5K-10K Internet Software & Services

A CI&T busca uma referência em dados para apoiar a modernização de um core bancário, garantindo integridade, equivalência e reconciliação entre sistemas legados e uma nova plataforma.

Brazil Full-time Senior Database Administrator
AWS MongoDB MySQL PostgreSQL
3 days, 17 hours ago
Multi Media

Staff Database Engineer

Multi Media 51-250 Internet Software & Services

Multi Media, LLC is seeking a Staff Database Engineer to own the reliability, availability, performance, and recoverability of Chaturbate’s large-scale PostgreSQL infrastructure supporting millions of real-time users.

United States Full-time Lead Database Administrator
$195k-$228k
Django Linux PostgreSQL Python
3 days, 18 hours ago
TWO95 International

Database Administrator - SAP HANA / SAP Basis

TWO95 International 51-250 Internet Software & Services

Remote Database Administrator on a 1+ year contract supporting enterprise SAP HANA, SAP S/4HANA, SAP Basis, and cloud-connected SAP environments to maintain availability, security, integrations, and operational reliability.

United States Contract Lead Database Administrator
DNS
3 days, 18 hours ago
Pingwind

Senior DBA / Data Modeler / Data Engineer

Pingwind 51-250 Internet Software & Services

PingWind is seeking a remote DBA/Data Modeler/Data Engineer to manage, secure, and optimize data supporting FSA IAM systems during migration from legacy platforms to a modern cloud-based solution and throughout operations.

Anywhere Full-time Lead Database Administrator Data Engineer
$121k-$168k
Cybersecurity
4 days, 17 hours 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