Mactores

Senior Database Administrator – Freelancer

Mactores

full-time

Posted on:

Location Type: Remote

Location: India

Visit company website

Explore more

✨ AI Apply
Apply

Job Level

Senior

Tech Stack

AWSOraclePostgres

About the role

  • Design, set up, configure, and manage Amazon Aurora PostgreSQL clusters.
  • Configure parameters, maintenance windows, monitoring, and scaling strategies.
  • Ensure high availability, fault tolerance, and operational readiness.
  • Perform user, role, and privilege mapping from Oracle to PostgreSQL.
  • Implement least-privilege access, role hierarchies, and security best practices.
  • 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.
  • Tune DMS settings for large-volume and high-throughput workloads.
  • Perform server and database performance tuning (CPU, memory, I/O, connections).
  • Tune PostgreSQL parameters, autovacuum, indexing, and query behavior.
  • Proactively identify and resolve performance bottlenecks.
  • Design and implement backup and restore strategies.
  • Define and test disaster recovery (DR) and failover procedures.
  • Support cross-region replication and recovery drills.
  • Lead post–go-live stabilization activities.
  • Monitor production workloads and resolve incidents.
  • Act as L3 escalation point for database-related production issues.
  • Provide operational documentation and handover support.

Requirements

  • 5+ years of experience administering Amazon Aurora PostgreSQL
  • Proven expertise in Oracle to PostgreSQL migration support
  • 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
  • Ability to work independently as an L3 escalation engineer
  • Clear communication and documentation skills|
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
Amazon AuroraPostgreSQLOracleAWS DMSperformance tuningbackup and restoredisaster recoverydata migrationmonitoringscaling strategies
Soft Skills
problem-solvingroot-cause analysiscommunicationdocumentationindependent workleadershipincident resolutionoperational readinesscollaborationstabilization activities