Lead Database Migration Engineer

16 hours, 7 minutes ago
Full-time
Lead
DevOps and Infrastructure
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-200
Founded 2003

Description

  • Lead database migrations from assessment and planning through schema conversion, execution, cutover, and post-migration validation.
  • Design, configure, and manage AWS Database Migration Service (DMS) and AWS Schema Conversion Tool (SCT) environments.
  • Own migration quality, performance, reliability, and production readiness.
  • Author and execute migration runbooks, including validation checkpoints, rollback plans, and operational procedures.
  • Conduct dependency analysis, compatibility reviews, and migration strategy recommendations.
  • Convert and refactor Oracle PL/SQL and SQL Server T-SQL procedures, functions, triggers, and related logic into PostgreSQL/Aurora PostgreSQL PL/pgSQL.
  • Resolve SCT action items and manual conversion gaps in procedural business logic.
  • Lead functional, regression, performance, and failover testing for migrated databases.
  • Collaborate with customer, infrastructure, application, security, and platform teams to deliver migration outcomes.
  • Provide technical leadership and uphold AWS migration best practices and governance standards.

Requirements

  • 8–12 years of professional experience in database architecture and migration delivery.
  • Hands-on expertise with AWS DMS and AWS SCT for enterprise-scale migrations.
  • Deep experience with Oracle, SQL Server, PostgreSQL, and Aurora PostgreSQL migration planning, execution, and optimization.
  • Proven experience delivering heterogeneous migrations across on-premises, cloud, and AWS environments.
  • Experience converting Oracle PL/SQL and SQL Server T-SQL business logic into PL/pgSQL.
  • Knowledge of exception handling, cursor semantics, autonomous transactions, sequences/identity columns, data type conversions, and proprietary database packages and functions.
  • Ability to remediate SCT action items and manual conversion gaps involving DBMS_* packages, UTL_* utilities, system procedures, dynamic SQL, and nested or recursive calls.
  • Experience with database backup and restore strategies, parameter tuning, performance optimization, and failover testing.
  • Experience creating migration runbooks, validation plans, cutover procedures, rollback strategies, and post-migration stabilization plans.
  • Experience working directly with enterprise customers and migration stakeholders; migration team leadership, mentoring, and broader AWS cloud migration experience are preferred.

Interested in this position?

Apply directly on the company website

Apply Now

Similar Roles

Database Developer

Skyward 51-200 Internet Software & Services

Skyward is hiring a Database Developer to build and support healthcare data solutions for the CMS Chronic Conditions Data Warehouse, enabling research to improve care quality and costs for Medicare and Medicaid beneficiaries.

HTML JavaScript Machine Learning Oracle Python Snowflake SQL
16 hours, 7 minutes ago

Database Administrator

Accanto Health 1-10 Health Care Providers & Services

Accanto Health is seeking a remote Database Administrator to build, secure, and optimize its Azure data platform supporting enterprise analytics and evidence-based eating-disorder care.

Azure HIPAA Power BI Salesforce SFTP SQL SQL Server
16 hours, 22 minutes ago

Senior Database Administrator

Xsolla 201-500 Internet Software & Services

Xsolla is hiring a Database Administrator to manage and optimize RDBMS and NoSQL platforms that support its global commerce services for video game developers.

AWS Bash Datadog GCP Grafana Linux MySQL PostgreSQL Prometheus Puppet Python SQL Terraform Zabbix
1 day, 16 hours ago

Senior Database Administrator

Xsolla 201-500 Internet Software & Services

Xsolla is seeking a Database Administrator to manage and optimize RDBMS and NoSQL infrastructure supporting its global commerce platform for the video game industry.

AWS Bash Datadog GCP Grafana Linux MySQL PostgreSQL Prometheus Puppet Python SQL Terraform Zabbix
1 day, 16 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