Postgres Admin

Full time | Work From Office This Position is Currently Open Department / Category: Admin Listed on Apr 16, 2024 Work Location: Chennai Kolkata Bangalore Job Descritpion of Postgres Admin 6+ Years Relevant Experience We are seeking an experienced PostgreSQL Database Administrator (DBA) with strong expertise in database administration, performance tuning, high availability, and cloud-based deployments. The ideal candidate will be responsible for managing complex PostgreSQL environments, ensuring system reliability, scalability, and performance, as well as supporting migration and automation initiatives. Key Responsibilities: 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 Required Skills for Postgres Admin Job Postgres Admin PostgreSQL Cloud Our Hiring Process Screening (HR Round) Technical Round 1 Technical Round 2 Final HR Round .