Postgres Admin

As a PostgreSQL Database Administrator (DBA) with 6+ years of relevant experience, you will be responsible for managing complex PostgreSQL environments, ensuring system reliability, scalability, and performance. Your key responsibilities will include: - **Database Architecture & Design**: - Design and maintain complex database schemas and architecture to meet business and application needs. - **Performance Tuning & Optimization**: - Conduct advanced performance tuning, query optimization, and indexing using tools like EXPLAIN, ANALYZE, pg_stat_statements, etc. - **Backup and Recovery**: - Implement and manage robust backup strategies using tools like pgBackRest or Barman. - Perform disaster recovery planning, documentation, and testing. - **High Availability & Replication**: - Set up and maintain HA environments using streaming replication, Patroni, repmgr, or Pgpool-II. - Support logical replication and change data capture (CDC) strategies. - **Security & Compliance**: - Implement role-based access control (RBAC), SSL/TLS encryption, and auditing mechanisms. - Ensure database environments comply with security and industry best practices. - **Monitoring & Maintenance**: - Proactively monitor database health using Prometheus, Grafana, or similar tools. - Perform routine database maintenance such as VACUUM, REINDEX, and ANALYZE. - **Upgrades & Migrations**: - Plan and execute PostgreSQL version upgrades with minimal downtime. - Lead migration initiatives from on-premise to cloud platforms like AWS RDS/Aurora, Azure PostgreSQL, or GCP Cloud SQL. Required Skills: - 6+ years of hands-on experience with PostgreSQL (v11 and above). - Strong expertise in PL/pgSQL scripting, Linux/Unix-based systems. - Experience with HA tools (Patroni, repmgr), backup tools (pgBackRest, Barman). - Knowledge of cloud-native PostgreSQL deployments (AWS, GCP, Azure). - Familiarity with database automation and monitoring best practices. Good-to-Have Skills: - Experience with other databases (Oracle, MySQL, MongoDB, etc.). - Familiarity with PostgreSQL Operators for Kubernetes (e.g., Zalando, Crunchy). - Understanding of Infrastructure as Code tools like Terraform, Ansible. - CI/CD practices for database release automation. - Clustering, sharding, and advanced replication setups. - Network monitoring, database auditing, and vulnerability management. Certifications (Preferred, but Not Mandatory): - AWS Certified Database Specialty - Other relevant PostgreSQL or cloud certifications Soft Skills: - Strong analytical and troubleshooting skills - Excellent verbal and written communication skills - Proven ability to work in a cross-functional and collaborative environment - Effective stakeholder and project management skills Please note that the hiring process for this position includes: - Screening (HR Round) - Technical Round 1 - Technical Round 2 - Final HR Round If you are interested in this challenging role, apply now to be a part of our dynamic team.,