Mactores
Mactores3mo ago

Senior Database Developer (Oracle & PostgreSQL)

Marshall Islands·MumbaiRemoteFull time (Remote)senior
Database DeveloperSoftware Engineering
4 views0 saves0 applied
Apply Now

Quick Summary

Overview

Mactores is a trusted leader among businesses in providing modern data platform solutions. Since 2008, Mactores have been enabling businesses to accelerate their value through automation by providing End-to-End Data Solutions that are automated, agile, and secure.

Technical Tools
ansibleawspostgresqlsqlterraformagileci-cdperformance-optimizationsql-optimization
Mactores is a trusted leader among businesses in providing modern data platform solutions. Since 2008, Mactores have been enabling businesses to accelerate their value through automation by providing End-to-End Data Solutions that are automated, agile, and secure. We collaborate with customers to strategize, navigate, and accelerate an ideal path forward with a digital transformation via assessments, migration, or modernization.

We are seeking an experienced  Senior Database Developer to lead and support Oracle to PostgreSQL/Aurora PostgreSQL migration initiatives. The role involves deep hands-on work across SQL refactoring, schema conversion, DMS operations, performance tuning, and post–go-live stabilization. The candidate will work closely with application teams, cloud engineers, and stakeholders to ensure a smooth, performant, and compliant migration.

  • Refactor and convert Oracle SQL, PL/SQL, and database objects to PostgreSQL-compatible SQL/PLpgSQL.
  • Analyze and remediate AWS SCT (Schema Conversion Tool) findings and limitations.
  • Manage and maintain Flyway migration codebase (versioned scripts, repeatable migrations, rollbacks).
  • Identify, troubleshoot, and fix database-related application bugs.
  • Perform query optimization for PostgreSQL (execution plans, indexing strategies, query rewrites).
  • Support and monitor AWS DMS during full load and CDC phases.
  • Diagnose and resolve DMS data and performance issues.
  • Perform data validation and reconciliation between Oracle and PostgreSQL.
  • Collaborate with application teams to align SQL behavior and performance expectations.
  • 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 / Aurora PostgreSQL.
  • Hands-on expertise in Oracle to PostgreSQL migration.
  • Advanced SQL and query performance tuning skills.
  • Experience with AWS SCT and AWS DMS.
  • Knowledge of Flyway/Liquibase or similar schema migration tools.
  • PostgreSQL internals: indexing, statistics, execution plans.
  • AWS services: RDS/Aurora, CloudWatch, IAM (preferred).
  • Familiarity with automation and configuration management tools, such as Ansible, Chef, or Puppet.
  • Familiarity with IAAC tools such as Terraform, CloudFormation.
  • Familiarity with CI/CD implementation tools like Liquibase/Flyway.
  • AWS Certified Database – Specialty.
  • AWS Certified Solutions Architect.

    • Location & Eligibility

    Where is the job
    Mumbai, Marshall Islands
    Remote within one country
    Who can apply
    MH
    Listed under
    Marshall Islands

    Listing Details

    Posted
    January 19, 2026
    First seen
    March 26, 2026
    Last seen
    May 14, 2026

    Posting Health

    Days active
    49
    Repost count
    0
    Trust Level
    39%
    Scored at
    May 14, 2026

    Signal breakdown

    freshnesssource trustcontent trustemployer trust
    Apply for this position
    Mactores
    Mactores
    lever

    Mactores is a trusted leader among businesses in providing modern data platform solutions.

    Employees
    125
    Founded
    2008
    Domain
    mactores.com
    Jobs
    View 21 jobs
    View company profile

    3 other jobs at Mactores

    View all →

    Explore open roles at Mactores.

    Mactores
    Business Development Representative
    Full time (Remote)    Mactores
    Full Stack Product Engineer, Agent Native
    Full time (Remote)    Mactores
    Senior Database Administrator (Freelancer)
    Freelancer (Remote)

    Similar Database Developer jobs

    View all →
    confluenceconfluence
    Database Developer
    Permanent - Full Time
    confluenceconfluence
    Database Developer
    Permanent - Full Time
    ardentprinciplesardentprinciples
    Database Developer
    Full Time
    confluenceconfluence
    Database Developer
    Permanent - Full Time
    confluenceconfluence
    Database Developer
    Permanent - Full Time
    arrisearrise
    Senior Database Developer

    Browse Similar Jobs

    Software Engineer9kSolutions Architect544Java Developer230Full Stack Developer154Salesforce Developer131Security Software Engineer106Embedded Software Engineer106.Net Developer105Python Developer80Application Developer79Build Engineer61Firmware Engineer59Search Engineer56Cloud Platform Software Engineer48Low-Code Developer46C++ Developer43Php Developer41Data Platform Software Engineer40Robotics Software Engineer39Wordpress Developer37
    Newsletter

    Stay ahead of the market

    Get the latest job openings, salary trends, and hiring insights delivered to your inbox every week.

    A
    B
    C
    D
    Join 12,000+ marketers

    No spam. Unsubscribe at any time.

    MactoresSenior Database Developer (Oracle & PostgreSQL)
    Apply Now