• Design, implement, and optimize SQL queries, stored procedures, and indexes to achieve low-latency performance. • Fine-tune PostgreSQL configurations for maximum throughput and minimal resource utilization. • Collaborate with backend and infrastructure engineers to diagnose and resolve performance issues. • Manage and optimize large-scale database clusters, including replication, sharding, and partitioning. • Ensure database uptime, backup, recovery, and disaster recovery objectives (RTO/RPO) are consistently met. • Set up and monitor performance metrics, alerts, and dashboards (e.g., using pg_stat_statements, Prometheus, Grafana). • Conduct capacity planning and load testing to prepare for traffic spikes and data growth. • Partner with Security and Compliance teams to ensure database access, data encryption, and retention policies meet regulatory standards. • Develop and maintain documentation for database configurations, maintenance routines, and operational procedures. • Support query performance reviews and educate developers on best practices for writing efficient SQL. • Optimize integrations between relational (PostgreSQL) and document-based (OpenSearch, Elasticsearch, MongoDB) systems. • Participate in incident response and postmortem analysis to continuously improve reliability.