Mactores is an agent-native AWS modernization firm focused on delivering production-ready systems, retiring legacy infrastructure, and ensuring measurable outcomes. This role, within the Application & Database Modernization pillar, centers on running Amazon Aurora PostgreSQL environments for an active Oracle-to-PostgreSQL migration program. The Senior Database Administrator will handle cluster design, DMS replication, post-go-live stabilization, and L3 escalation for production systems, leveraging Aedeon (an agent platform) to automate repetitive tasks while owning critical judgment calls for production stability and incident resolution. The position is a remote, freelance engagement serving as the L3 escalation point for real business systems.
Responsibilities
- Design, set up, configure, and manage Amazon Aurora PostgreSQL clusters.
- Configure parameters, maintenance windows, monitoring, and scaling strategies.
- Keep the environments highly available, fault tolerant, and operationally ready — before go-live, not after.
- Map users, roles, and privileges from Oracle to PostgreSQL.
- Implement least-privilege access, role hierarchies, and security best practices, and support audit and compliance requirements.
- Configure, run, monitor, and optimize AWS DMS tasks (Full Load and CDC).
- Troubleshoot DMS latency, data mismatches, and performance issues, and tune DMS settings for large-volume, high-throughput workloads.
- Tune server and database performance — CPU, memory, I/O, connections — plus PostgreSQL parameters, autovacuum, indexing, and query behavior.
- Find performance bottlenecks before the customer does, and resolve them.
- Design and implement backup and restore strategies; define and test DR and failover procedures; support cross-region replication and recovery drills.
- Lead post–go-live stabilization: monitor production workloads, resolve incidents, and act as the L3 escalation point for database-related production issues.
- Deliver operational documentation and handover support, so what you stabilized stays stable after you.
Requirements
- 5+ years of experience administering Amazon Aurora PostgreSQL.
- Proven expertise supporting Oracle-to-PostgreSQL migrations.
- Hands-on experience with AWS DMS.
- Advanced PostgreSQL performance tuning and troubleshooting skills.
- Strong knowledge of backup, restore, and DR planning in AWS.
- Experience with AWS monitoring tools (CloudWatch, Performance Insights).
- Strong problem-solving and root-cause analysis abilities.
- Experience working in production and post–go-live environments.
- The ability to work independently as an L3 escalation engineer.
- Clear communication and documentation skills.
Nice to have
- 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
Additional details
- This is a freelance engagement, remote.
- Mactores carries delivery overage risk for delays they cause.
- Aedeon absorbs the repetitive majority schema conversion, test generation, regression harnesses.
- Engineers absorb the judgment: risk tradeoffs, production cutover, post-cutover optimization.
- Mactores' 10 Core Leadership Principles: Decision-making, Leadership, Collaboration, and Curiosity drive how they work (1. Be one step ahead, 2. Deliver the best, 3. Be bold, 4. Pay attention to the detail, 5. Enjoy the challenge, 6. Be curious and take action, 7. Take leadership, 8. Own it, 9. Deliver value, 10. Be collaborative).
- Recruitment process: Pre-Employment Assessment (technical evaluations), Managerial Interview (30-60 min discussions on skills, experience, leadership, communication), HR Discussion (30-minute offer/next steps session).
- Mactores provides equal opportunities in all employment practices without discrimination based on race, religion, gender, national origin, age, disability, marital status, military status, genetic information, or any other protected category.
- Originally posted on Himalayas.
Zobhira
