Job Description

Install, configure, and upgrade PostgreSQL and YugabyteDB clusters across environments (on-premises and cloud). Set up replication, clustering, and high availability (HA) environments. Manage database objects such as schemas, tables, indexes, sequences, and partitions. Apply regular patches, version upgrades, and maintenance releases. Ensure continuous database uptime and minimal downtime during upgrades. Design and implement robust backup and recovery strategies using pg_dump, pg_basebackup, pgBackRest, or yb_backup.py. Schedule and monitor backups to ensure data integrity and recovery readiness. Develop and test disaster recovery (DR) procedures with RPO/RTO objectives. Manage database parameters, memory settings, and connection tuning. Implement multi-node YugabyteDB architecture for distributed SQL workloads. Perform daily database health checks, maintenance tasks, and performance reviews. Manage off-site or cross-region replication for fault tolerance. Monitor database performance and system resources using pg_stat_activity, EXPLAIN ANALYZE, Prometheus, and Grafana. Analyze slow queries, optimize indexing, and adjust query plans. Tune PostgreSQL configurations (e.g., autovacuum, shared_buffers, work_mem). Balance YugabyteDB tablets and optimize read/write distribution across nodes. Create and manage users, roles, and access privileges securely. Enforce database authentication and authorization policies. Implement SSL/TLS encryption and audit logging for compliance. * Monitor and respond to security vulnerabilities or unauthorized access.