Senior Database Migration Engineer (Oracle & PostgreSQL)

16 hours, 7 minutes ago
Full-time
Senior
Software Development
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

  • Refactor Oracle SQL, PL/SQL, and database objects into PostgreSQL-compatible SQL and PL/pgSQL.
  • Analyze and remediate AWS Schema Conversion Tool (SCT) findings and limitations.
  • Manage Flyway migration code, including versioned scripts, repeatable migrations, and rollbacks.
  • Troubleshoot and resolve database-related application defects.
  • Optimize PostgreSQL queries through execution-plan analysis, indexing strategies, and query rewrites.
  • Support and monitor AWS Database Migration Service (DMS) during full-load and change data capture phases.
  • Diagnose and resolve AWS DMS data-quality and performance issues.
  • Validate and reconcile data between Oracle and PostgreSQL.
  • Collaborate with application teams, cloud engineers, and stakeholders to align SQL behavior and performance expectations.
  • Support post-go-live database stabilization and performance tuning.

Requirements

  • Bachelor’s degree in Computer Science or a related field.
  • 5+ years of experience as an Oracle/PostgreSQL DBA and database developer.
  • Strong experience with Oracle Database and PostgreSQL or Aurora PostgreSQL.
  • Hands-on experience migrating Oracle databases to PostgreSQL.
  • Advanced SQL development and query-performance tuning skills.
  • Experience with AWS SCT and AWS DMS.
  • Knowledge of Flyway, Liquibase, or similar schema migration tools.
  • Knowledge of PostgreSQL internals, including indexing, statistics, and execution plans.
  • Experience with AWS RDS/Aurora, CloudWatch, and IAM (preferred).
  • Familiarity with Ansible, Chef, Puppet, Terraform, CloudFormation, CI/CD tooling, or AWS Database Specialty/Solutions Architect certifications (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