Mactores
Mactores3mo ago

Senior Database Developer (Oracle & PostgreSQL)

Mumbai · MumbaiRemoteFull time (Remote)senior
Database DeveloperSoftware Engineering
0 views0 saves0 applied
Apply Now

Quick Summary

Overview

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

Technical Tools
Database DeveloperSoftware Engineering
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.

    • Listing Details

    Posted
    January 19, 2026
    First seen
    March 26, 2026
    Last seen
    April 24, 2026

    Posting Health

    Days active
    29
    Repost count
    0
    Trust Level
    39%
    Scored at
    April 24, 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 17 jobs
    View company profile

    3 other jobs at Mactores

    View all →

    Explore open roles at Mactores.

    Mactores
    Senior Database Administrator (Freelancer)
    Freelancer (Remote)    Mactores
    Project Manager (Data Center Migration & Modernization)
    Full time (Remote)    Mactores
    AWS DevOps Engineer (Senior) - Migration Project (VMware to AWS)
    Full time (Remote)

    Similar Database Developer jobs

    View all →
    CgsfederalCgsfederal
    PostgreSQL Database Developer
    USD 106773.33–144906.66
    Full Time Hybrid
    CgsfederalCgsfederal
    PostgreSQL Database Developer
    USD 106773.33–144906.66
    Full Time Hybrid
    CgsfederalCgsfederal
    PostgreSQL Database Developer
    USD 106773.33–144906.66
    Full Time Hybrid
    CgsfederalCgsfederal
    PostgreSQL Database Developer
    USD 106773.33–144906.66
    Full Time Hybrid
    CgsfederalCgsfederal
    PostgreSQL Database Developer
    USD 106773.33–144906.66
    Full Time Hybrid
    CgsfederalCgsfederal
    PostgreSQL Database Developer
    USD 106773.33–144906.66
    Full Time Hybrid

    Browse Similar Jobs

    Software Engineer5.3kSolutions Architect421Full Stack Developer138Embedded Software Engineer103Firmware Engineer56Security Software Engineer53Search Engineer50Java Developer50Cloud Platform Software Engineer44Low-Code Developer44Salesforce Developer33Build Engineer32C++ Developer31Data Platform Software Engineer28Python Developer28Release Engineer26Android Developer22Robotics Software Engineer22Web Developer21Application Developer21
    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