Mactores is a trusted leader among businesses in providing modern data platform solutions.
Lead Database Migration Engineer
Location
India
Posted
2 days ago
Salary
0
Seniority
Senior
Job Description
Lead Database Migration Engineer
Mactores
• 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.
Job 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.
Related Guides
Related Job Pages
More Backend Engineer Jobs
• Design, build, and maintain scalable backend services for our AI Payments Intelligence platform. • Develop data pipelines, ETL processes, and cloud-native infrastructure that process large volumes of payment transaction data. • Build the backend services that power analytics, dashboards, AI-driven insights, and customer-facing reporting. • Collaborate with enterprise customers to integrate payment data from PSPs, acquirers, and other external systems. • Develop secure, reliable APIs and integration services for payment gateways, reporting APIs, webhooks, and other data sources. • Optimize backend systems for performance, scalability, security, and high availability. • Partner with Product, Data Science, and Engineering teams to design new platform capabilities and contribute to architectural decisions. • Stay current with emerging technologies and contribute to engineering best practices across the platform.
• Hands-on engineering and testing of the product • Hands-on engineering and testing of the internal agent’s framework • Stay updated with the latest in AI and AI Agents and provide insights
Senior Python Engineer
OpenVPN Inc.OpenVPN® helps businesses of all sizes create secure, virtualized, reliable networks that scale with your team.
• Collaborating with product manager to refine feature specifications • Development and support of Linux-based server software (Python mainly) • Development of a web-based API (XML-RPC and REST mainly) • Collaboration with other developers on development and deployment • A working knowledge of python asynchronous programming
Senior Software Engineer, Scala, Python
Espeo SoftwareYour Partner in Financial Technology Development
• Develop and maintain robust backend services using Scala and Python • Design, implement, and scale AI-powered features across the platform • Integrate internal and external AI services via APIs (including LLMs and similar AI platforms) • Contribute to the continuous improvement of backend architecture and AI capabilities
