Principal Consultant

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

. Schedule and monitor backups to ensure data integrity and recovery readiness.

. Develop and test disaster recovery (DR) procedures with RPO/RTO objectives.

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