Job Description :

- 8+ years of hands-on PostgreSQL database administration experience, including performance tuning, security hardening and PL/SQL scripting.

- 7+ years of performance tuning and query optimization experience using EXPLAIN/EXPLAIN ANALYZE, pg_stat_statements, auto_explain, pgBadger, Kubernetes-native monitoring (Prometheus, Grafana), and pod-level resource analysis.

- 4+ years of experience collaborating closely with application developers to implement efficient database designs, indexing strategies, and query optimization, while also integrating CI/CD pipelines for database changes in Kubernetes environments.

- Skills in implementing HA/DR solutions using streaming replication, Patroni, and repmgr.

- Robust understanding of running PostgreSQL on containerized and cloud-native platforms using Kubernetes.

- Proficiency in infrastructure design, HA/DR with Postgres operators or managed services, and integration with Kubernetes tools for optimization and scalability.

- Proven ability to work with large data sets and design scalable PostgreSQL solutions optimized for containerized deployments.

Key Responsibilities :

- Architect and implement robust PostgreSQL database solutions to support high-traffic applications, ensuring optimal performance and scalability for our global user base.

- Lead complex database migration, upgrade, and patching projects to maintain system security and leverage the latest features for improved operational efficiency.

- Design and execute comprehensive backup, recovery, and disaster recovery strategies to protect critical business data and ensure business continuity.

- Mentor junior database administrators and provide technical guidance to development teams on query optimization, indexing strategies, and schema design to enhance application throughput.

- Automate routine database maintenance and monitoring tasks using scripting languages to reduce manual intervention and minimize the risk of human error.

- Collaborate with cross-functional stakeholders to troubleshoot performance bottlenecks and resolve complex production incidents, maintaining high service level agreements.