Senior Database Administrator (Freelancer)

What you will do?

• 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.

What are we looking for?

• 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|

You will be preferred if

• 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…