Senior Database Developer

Role Overview

Mactores is the agent-native AWS modernization firm dedicated to shipping production systems rather than letting projects stall. Our delivery leverages Aedeon, an internal agent platform that automates repetitive engagement work like discovery and test generation.

We are seeking a Senior Database Developer to lead Oracle to PostgreSQL/Aurora PostgreSQL migration initiatives involving SQL refactoring, schema conversion, DMS operations, performance tuning, and post-go-live stabilization.

Key Responsibilities

• Refactor and convert Oracle SQL/PL/SQL to PostgreSQL-compatible code (PLpgSQL).
• Analyze remediate AWS SCT findings and limitations.
• Manage the Flyway migration codebase including versioned scripts, migrations, and rollbacks.
• Troubleshoot database-related application bugs and optimize PostgreSQL query performance via execution plans and indexing.
• Support and monitor AWS DMS during full load and CDC phases to ensure data integrity.
• Perform rigorous data validation and reconciliation between Oracle and PostgreSQL environments.

Required Qualifications

• Bachelor's degree in Computer Science or related field.
• 5+ years of experience as an Oracle/PostgreSQL DBA and developer.
• Strong expertise with AWS SCT, AWS DMS, RDS/Aurora, CloudWatch, IAM.
• Advanced knowledge of Flyway/Liquibase for schema management.