Mactores is an agent‑native AWS modernization firm that helps organizations ship production systems, retire legacy databases, and measure outcomes. The company uses its proprietary Aedeon platform to automate repetitive engagement work, allowing forward‑deployed engineers to focus on architecture, judgment, and cutover on committed dates. We are seeking an experienced Senior Database Developer to lead Oracle to PostgreSQL/Aurora PostgreSQL migration initiatives, handling SQL refactoring, schema conversion, DMS operations, performance tuning, and post‑go‑live stabilization while collaborating closely with application teams and stakeholders.
Responsibilities
- Refactor and convert Oracle SQL, PL/SQL, and database objects to PostgreSQL-compatible SQL/PLpgSQL.
- Analyze and remediate AWS SCT 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.
Nice to have
- Familiarity with automation and configuration management tools such as Ansible, Chef, or Puppet.
- Familiarity with infrastructure‑as‑code tools such as Terraform or CloudFormation.
- Familiarity with CI/CD implementation tools like Liquibase or Flyway.
- AWS Certified Database – Specialty.
- AWS Certified Solutions Architect.
Additional details
- Mactores is the agent‑native AWS modernization firm that focuses on shipping production systems, retiring legacy, and measuring outcomes.
- Delivery is built on Aedeon, an agent platform that absorbs repetitive 60–70% of engagement work such as discovery, dependency mapping, validation, and test generation.
- Forward‑deployed engineers own architecture, judgment, and cutover on committed dates.
- Company emphasizes a culture defined by 10 Core Leadership Principles including Be one step ahead, Deliver the best, Be bold, Pay attention to the detail, Enjoy the challenge, Be curious and take action, Take leadership, Own it, Deliver value, Be collaborative.
- Mactores provides equal opportunity employment and does not discriminate based on protected categories.
- Recruitment process includes Pre‑Employment Assessment, Managerial Interview, and HR Discussion.
- Application is originally posted on Himalayas.
Zobhira
