RemoteLeaf Logo
Log in Sign up

Lead Database Migration Engineer

2 months, 1 week 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

Smile Digital Health

Database Administrator - Remote US

Smile Digital Health 251-1K IT Services

Smile Digital Health is seeking a Database Administrator to maintain and optimize data stores supporting its FHIR-based healthcare data platform, clients, and partners worldwide.

United States Full-time Senior Database Administrator
$110k-$125k
ActiveMQ Azure Kafka MongoDB NetSuite Oracle PostgreSQL Snowflake SQL SQL Server
23 hours, 42 minutes ago
K.L. Scott & Associates

SAP Basis and HANA Administrator

K.L. Scott & Associates 11-50 Professional Services

K.L. Scott & Associates, LLC is seeking an SAP Basis and HANA Administrator to maintain secure, reliable SAP environments supporting federal government clients.

Anywhere Full-time Lead Database Administrator Systems Administrator
1 day, 23 hours ago
BHG Financial

Databricks Administrator

BHG Financial 1K-5K Diversified Financial Services

BHG Financial is seeking an Azure Databricks Administrator to secure, govern, operate, and optimize Databricks environments supporting enterprise analytics in a regulated financial services organization.

United States Full-time Senior Cloud Engineer Database Administrator
Apache Spark Azure Encryption PowerShell Python REST API Secrets Management SQL Terraform
4 days ago
HITCONTRACT

Freelance Senior FLEXCUBE System Analyst (B2B Contract)

HITCONTRACT 11-50 Professional Services

Senior FLEXCUBE System Analysts will support a large banking client’s Core Banking team by developing, improving, and transforming the Oracle FLEXCUBE platform across technical and business domains.

Europe Freelance Senior Database Administrator Software Engineer
$86k-$106k
Linux REST API SOAP SQL Unix XML
4 days 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