Senior Database Administrator (Freelancer)
Mumbai, MHFull-TimeSeniorOther
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
- AWS Certified Database – Specialty
- AWS Certified Solutions Architect
