RemoteLeaf Logo
Log in Sign up

Lead Database Migration Engineer

3 months 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

BHG Financial

Associate Database Administrator

BHG Financial 1K-5K Diversified Financial Services

BHG Financial is hiring an early-career Database Administrator to support SQL Server databases across on-premises and Azure environments, maintaining reliable, secure, and high-performing systems for a financial services organization.

United States Full-time Junior Database Administrator
Azure PowerShell SQL SQL Server
2 hours, 37 minutes ago
CI&T

[Job-31961] Data Developer Sênior - Cloud DB Specialist, Brazil

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

A CI&T busca um Cloud Data Developer Sênior para liderar a arquitetura e execução da migração de bancos de dados on-premises para o Azure em um projeto estratégico de modernização de infraestrutura para um cliente do setor de saúde.

Brazil Full-time Senior Cloud Engineer Database Administrator
Agile Azure CI/CD Kanban Microservices Scrum
2 hours, 37 minutes ago
Banyan Software

Application Support Analyst – SQL & Data

Banyan Software 51-250 Internet Software & Services

TechGrove, Banyan Software’s Chennai-based technology centre, is hiring a Technical Support and Data Analyst to support TotalCtrl, a field service management platform, by resolving customer issues, managing data, and improving support through AI-enabled processes.

India Full-time Junior Database Administrator Technical Support Engineer
C# Git HubSpot JIRA JSON Laravel Metabase MySQL .NET PHP PostgreSQL Postman Power BI SQL SQL Server
1 day, 3 hours ago
TEHORA

Administrateur(trice) de bases de données MySQL (Support 24/7)

TEHORA 1-10 Construction & Engineering

TEHORA recherche un(e) administrateur(trice) de bases de données MySQL pour assurer la disponibilité, la stabilité et le support opérationnel de services critiques, incluant une astreinte de production 24/7 et le respect de SLA stricts.

Canada Full-time Senior Database Administrator Technical Support Engineer
MySQL
2 days, 3 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