Senior Database Administrator (Freelancer)

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.