Lead Database Migration Engineer

Mactores

Lead Database Migration Engineer at Mactores managing database migrations to PostgreSQL for enterprise customers. Involved in assessment, planning, execution, and validation of migrations.

Posted 7/8/2026full-timeRemote • 🇮🇳 IndiaSeniorWebsite

Tech Stack

Tools & technologies

AWSCloudOraclePostgresSQL

About the role

Key responsibilities & impact

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 while ensuring migration quality, performance, and reliability.
Author comprehensive migration runbooks that define execution procedures, validation checkpoints, rollback plans, and operational readiness activities.
Perform database migration assessments, dependency analysis, compatibility reviews, and migration strategy recommendations.
Collaborate with infrastructure, application, security, and platform teams to ensure successful migration outcomes.
Drive migration testing activities, including functional validation, performance testing, failover testing, and production readiness reviews.
Provide technical leadership and guidance to migration teams while ensuring adherence to AWS migration best practices and governance standards.
Lead conversion and refactoring of procedural database code — Oracle PL/SQL (packages, procedures, functions, triggers, cursors) and SQL Server T-SQL (stored procedures, functions, triggers) — into PostgreSQL/Aurora PostgreSQL PL/pgSQL, resolving semantic and behavioral differences identified by SCT.

Requirements

What you’ll need

8–12 years of professional experience in database architecture and migration delivery
Hands-on expertise in AWS Database Migration Service (DMS) and AWS Schema Conversion Tool (SCT) for enterprise-scale database migrations
Deep proficiency in Oracle, SQL Server, PostgreSQL, and Aurora PostgreSQL environments, including migration planning, execution, and optimization
Proven background in 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
Skills in 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 integration with broader cloud migration programs
Experience engaging directly with enterprise customers, architecture teams, and migration stakeholders to drive successful delivery outcomes
Strong hands-on experience converting Oracle PL/SQL and SQL Server T-SQL business logic to PL/pgSQL, including handling of exception handling models, cursor semantics, autonomous transactions, sequences/identity columns, implicit data type conversions, and proprietary built-in packages/functions with no native PostgreSQL equivalent
Ability to identify and remediate SCT action items and manual conversion gaps in procedural code (e.g., DBMS_* packages, UTL_* utilities, SQL Server system procedures, dynamic SQL, and nested/recursive procedure calls) and validate converted logic through functional and regression testing.

Benefits

Comp & perks

🌐 Worldwide ❌ Jobs You've Hidden ⭐️ Saved Jobs ✅ Applied Jobs ✉️ Email Alerts 👤 Account Mactores Website LinkedIn All Job Openings 51 - 200 employees Founded 2008 🏢 Enterprise Enterprise
Data Mactores is a company that provides end-to-end data platform solutions aimed at accelerating business value through automation. Since 2008, Mactores has been helping businesses with digital transformation, offering services like Enterprise Data Lakes, Scalable Databases, Modern Data Warehouses, Automated DataOps, MLOps, and Generative AI solutions. They focus on enabling faster and cost-effective migrations and modernizations in data analytics, partnering with leading platforms to drive innovation and success. Mactores works alongside tech teams to strategize and implement the right data solutions timely and efficiently. Lead Database Migration Engineer Job not on LinkedIn 🔥 24 minutes ago 🇮🇳 India – Remote ⏰ Full Time 🟠 Senior 🔙 Backend Engineer AWS Cloud Oracle Postgres SQL Apply Now Find Hiring Managers Customize resume + cover letter Report problem ☆ Save ☑️ Mark as applied ❌ Hide 📋 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 while ensuring migration quality, performance, and reliability.
Author comprehensive migration runbooks that define execution procedures, validation checkpoints, rollback plans, and operational readiness activities.
Perform database migration assessments, dependency analysis, compatibility reviews, and migration strategy recommendations.
Collaborate with infrastructure, application, security, and platform teams to ensure successful migration outcomes.
Drive migration testing activities, including functional validation, performance testing, failover testing, and production readiness reviews.
Provide technical leadership and guidance to migration teams while ensuring adherence to AWS migration best practices and governance standards.
Lead conversion and refactoring of procedural database code — Oracle PL/SQL (packages, procedures, functions, triggers, cursors) and SQL Server T-SQL (stored procedures, functions, triggers) — into PostgreSQL/Aurora PostgreSQL PL/pgSQL, resolving semantic and behavioral differences identified by SCT. 🎯 Requirements
8–12 years of professional experience in database architecture and migration delivery
Hands-on expertise in AWS Database Migration Service (DMS) and AWS Schema Conversion Tool (SCT) for enterprise-scale database migrations
Deep proficiency in Oracle, SQL Server, PostgreSQL, and Aurora PostgreSQL environments, including migration planning, execution, and optimization
Proven background in 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
Skills in 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 integration with broader cloud migration programs
Experience engaging directly with enterprise customers, architecture teams, and migration stakeholders to drive successful delivery outcomes
Strong hands-on experience converting Oracle PL/SQL and SQL Server T-SQL business logic to PL/pgSQL, including handling of exception handling models, cursor semantics, autonomous transactions, sequences/identity columns, implicit data type conversions, and proprietary built-in packages/functions with no native PostgreSQL equivalent
Ability to identify and remediate SCT action items and manual conversion gaps in procedural code (e.g., DBMS_* packages, UTL_* utilities, SQL Server system procedures, dynamic SQL, and nested/recursive procedure calls) and validate converted logic through functional and regression testing. Apply Now 📊 Check your resume score for this job Improve your chances of getting an interview by checking your resume score before you apply. Check Resume Score Similar Jobs Senior Backend Engineer 🔥 4 hours ago MRSOOL | مرسول 201 - 500 🚗 Transport 🛍️ eCommerce Website LinkedIn All Job Openings Software Development Engineer III at Mrsool developing robust backend solutions. Join a leading delivery platform in the MENA region with a focus on innovation and technology. 🇮🇳 India – Remote ⏰ Full Time 🟡 Mid-level 🟠 Senior 🔙 Backend Engineer Distributed Systems GRPC Microservices Postgres Redis Ruby Ruby on Rails Go Backend Developer – Java 🔥 18 hours ago Kyndryl 10,000+ employees 🏢 Enterprise 🔒 Cybersecurity ☁️ SaaS Website LinkedIn All Job Openings Software Developer at Kyndryl designing and implementing cutting-edge software solutions for complex projects. Ensuring quality through documentation, unit testing, and innovative practices in a supportive and collaborative environment. 🇮🇳 India – Remote ⏰ Full Time 🟡 Mid-level 🟠 Senior 🔙 Backend Engineer AWS Docker DynamoDB EC2 Java JUnit Kubernetes Microservices Mockito MySQL NoSQL Postgres Python Redis Spring Spring Boot SpringBoot Kubernetes Platform Architect 🔥 18 hours ago Broadcom 10,000+ employees 🔧 Hardware 📡 Telecommunications ☁️ SaaS Website LinkedIn All Job Openings Application Engineer helping enterprise customers adopt VMware Kubernetes Service on VMware Cloud Foundation. Responsible for guiding design, validation, deployment, and customer success with Kubernetes platforms. 🇮🇳 India – Remote 💰 Post-IPO Equity on 2017-10 ⏰ Full Time 🟠 Senior 🔴 Lead 🔙 Backend Engineer AWS Azure Cloud Google Cloud Platform Kubernetes OpenShift VMware Senior Fullstack Engineer, .NET 🕒 Yesterday 3Pillar Global 1001 - 5000 ☁️ SaaS 🏢 Enterprise 🤖 Artificial Intelligence Website LinkedIn All Job Openings Senior Fullstack Engineer at 3Pillar, collaborating on AI-native products for global clients. Focus on agile software development and mentoring within a remote-first culture. 🇮🇳 India – Remote 💰 Private Equity Round on 2021-10 ⏰ Full Time 🟠 Senior 🔙 Backend Engineer SQL .NET Full Stack Engineer, Backend Heavy 🕒 Yesterday Simbian 11 - 50 🤖 Artificial Intelligence 🔒 Cybersecurity Website LinkedIn All Job Openings Design and build foundational pieces of our agentic AI security platform at Simbian. Collaborate with founders and leaders to deliver and improve essential features in security operations. 🇮🇳 India – Remote ⏰ Full Time 🟡 Mid-level 🟠 Senior 🔙 Backend Engineer AWS Azure Cloud Cyber Security Distributed Systems Google Cloud Platform Microservices Node.js Python Go View More Backend Engineer Jobs 🌐 Worldwide Built by Lior Neu-ner. I'd love to hear your feedback — Get in touch via DM or support@remoterocketship.com Search Search Jobs by country Search jobs by city Search jobs by job title Search entry-level jobs Search junior-level jobs Search senior-level jobs Search jobs by tech stack Search jobs by contract type Search remote internships Search remote part-time jobs Remote jobs Anywhere in the World Companies Hiring Anywhere in the World Companies Hiring Sales People Anywhere in the World Companies Hiring Software Engineers Anywhere in the World Resources Advice Tips for finding remote jobs Interview questions and answers Resume examples Cover letter examples Post a job Affiliates Privacy policy Terms of service Job board SEO course AI Apply Copilot OpenClaw job finder Find jobs using your resume Jobs by Country Remote jobs anywhere in the world (Worldwide remote jobs) Remote jobs United States Remote jobs Australia Remote jobs Brazil Remote jobs Canada Remote jobs France Remote jobs Ireland Remote jobs Germany Remote jobs Netherlands Remote jobs Spain Remote jobs UK Popular Jobs Remote data analyst jobs Remote customer support jobs Remote executive assistant jobs Remote marketing jobs Remote product designer jobs Remote product manager jobs Remote project manager jobs Remote recruiter jobs Remote sales jobs Remote software engineer jobs Jobs by Type Remote full-time jobs Remote part-time jobs Remote contract jobs Remote internship jobs Remote entry-level jobs Remote jobs with no experience required Remote junior jobs (1-3 years of experience) Digital nomad jobs Remote jobs with no degree required Freelance remote jobs Temporary remote jobs Remote jobs hiring now Stay at home mom jobs

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

Database ArchitectureDatabase Migration DeliverySchema ConversionPerformance OptimizationBackup and Restore StrategiesFunctional ValidationPerformance TestingFailover TestingMigration Runbook AuthoringDependency Analysis

Soft Skills

Technical LeadershipCollaborationCustomer EngagementCommunication