Technical Lead - PostgreSQL Database Administration

As a PostgreSQL Database Administrator with over 8 years of experience, you have demonstrated expertise in various aspects of database administration. Your key responsibilities include: - Performance tuning, security hardening, and PL/pgSQL scripting - Performance tuning and query optimization using EXPLAIN/EXPLAIN ANALYZE, pg_stat_statements, auto_explain, pgBadger, Kubernetes-native monitoring tools (Prometheus, Grafana), and pod-level resource analysis - Collaborating with application developers to implement efficient database designs, indexing strategies, and query optimization - Integrating CI/CD pipelines for database changes in Kubernetes environments - Implementing HA/DR solutions using streaming replication, Patroni, and repmgr - Running PostgreSQL on containerized and cloud-native platforms using Kubernetes - Designing infrastructure, HA/DR with Postgres operators or managed services, and integration with Kubernetes tools for optimization and scalability - Working with large data sets and designing scalable PostgreSQL solutions optimized for containerized deployments The job also requires a robust understanding of PostgreSQL administration, query optimization, HA/DR solutions, and Kubernetes-native monitoring tools. As a PostgreSQL Database Administrator with over 8 years of experience, you have demonstrated expertise in various aspects of database administration. Your key responsibilities include: - Performance tuning, security hardening, and PL/pgSQL scripting - Performance tuning and query optimization using EXPLAIN/EXPLAIN ANALYZE, pg_stat_statements, auto_explain, pgBadger, Kubernetes-native monitoring tools (Prometheus, Grafana), and pod-level resource analysis - Collaborating with application developers to implement efficient database designs, indexing strategies, and query optimization - Integrating CI/CD pipelines for database changes in Kubernetes environments - Implementing HA/DR solutions using streaming replication, Patroni, and repmgr - Running PostgreSQL on containerized and cloud-native platforms using Kubernetes - Designing infrastructure, HA/DR with Postgres operators or managed services, and integration with Kubernetes tools for optimization and scalability - Working with large data sets and designing scalable PostgreSQL solutions optimized for containerized deployments The job also requires a robust understanding of PostgreSQL administration, query optimization, HA/DR solutions, and Kubernetes-native monitoring tools.