Senior Database Developer (Oracle & PostgreSQL)

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.