Mactores

Senior Database Developer, Oracle, PostgreSQL

Mactores

full-time

Posted on:

Location Type: Remote

Location: India

Visit company website

Explore more

✨ AI Apply
Apply

Job Level

Senior

Tech Stack

AWSOraclePostgresSQL

About the role

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

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 / 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).
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
Oracle SQLPL/SQLPostgreSQLPLpgSQLAWS SCTFlywayquery optimizationdata validationquery performance tuningdatabase migration