Source description
About the role
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 postgo-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. 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 postgo-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.
More at Mactores