Jobless Developer
Mactores logo
Mactores

Posted 4 months ago

Open

Senior Database Developer (Oracle & PostgreSQL)

MumbaiOn-siteFull-time

AI Summary

Senior database developer responsible for leading Oracle to PostgreSQL/Aurora PostgreSQL migrations, including SQL refactoring, schema conversion, DMS operations, performance tuning, and post-go-live stabilization.

About this role

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.

What you will do?

  • 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.

    • What are we looking for?

  • 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).

    • You will be preferred if:

  • 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.

    • Skills

    ADBAnsibleAurora PostgreSQLAWS CloudWatchAWS DMSAWS RDSCI/CD ToolsCloudFormationData ValidationDMS CDCDMS TroubleshootingExecution PlansFlywayIAMIndexingLiquibaseOracle DatabasePL/pgSQLPostgreSQLQuery OptimizationSchema Conversion Tool (AWS SCT)SQLTerraform

    Explore related jobs

    More jobs at Mactores

    Similar ADB jobs

    Jobs in Mumbai

    Browse these categories

    Ansible JobsCloudFormation JobsData Validation JobsIAM JobsPostgreSQL Jobs