Senior Database Administrator (Freelancer)

Mactores, a trusted leader in modern data platform solutions, is looking for an experienced Senior DBA to lead and support Amazon Aurora PostgreSQL environments as part of a major Oracle to PostgreSQL migration program. The role requires deep hands-on expertise in AWS DMS, performance tuning, security, and post–go-live stabilization.

Key Responsibilities

• Migration Strategy: Perform user, role, and privilege mapping from Oracle to PostgreSQL and implement least-privilege access.
• AWS DMS Management: Configure, run, and optimize AWS DMS tasks (Full Load and CDC); troubleshoot latency and data mismatches.
• Cluster Management: Design, set up, and manage Amazon Aurora PostgreSQL clusters, including high availability and fault tolerance.
• Performance Tuning: Tune PostgreSQL parameters, autovacuum, indexing, and query behavior; resolve performance bottlenecks.
• L3 Support: Act as the L3 escalation point for database-related production issues and lead post–go-live stabilization.
• Disaster Recovery: Define and test DR, failover procedures, and cross-region replication.

Requirements

• Experience: 5+ years of experience administering Amazon Aurora PostgreSQL.
• Migration Expertise: Proven expertise in Oracle to PostgreSQL migration support.
• AWS DMS: Hands-on experience with AWS DMS is mandatory.
• Tuning Skills: Advanced PostgreSQL performance tuning and troubleshooting skills.
• Production Support: Experience working in production and post–go-live environments as an L3 engineer.

Nice to Have

• Familiarity with IaC tools (Terraform, CloudFormation) and CI/CD tools (Liquibase, Flyway).
• AWS Certifications: AWS Certified Database – Specialty or Solutions Architect.

Hiring Process

1. Pre-Employment Assessment: Evaluations to assess technical proficiency.
2. Managerial Interview: 30-60 minute discussion to assess technical skills and hands-on experience.
3. HR Discussion: Final discussion regarding the offer.