Job Description

PostgreSQL DBA

Location: Navi Mumbai/ Pune

Job Role:

We are seeking an experienced Database Administrator with strong PostgreSQL expertise and knowledge of containerized environments and distributed database systems. The ideal candidate will bring extensive DBA experience with a focus on PostgreSQL administration, along with working knowledge of Kubernetes orchestration and Cassandra.

Experience:

5+ years of PostgreSQL DBA Experience
Key Responsibilities:

PostgreSQL Administration

Design, implement, and maintain PostgreSQL database systems across development, staging, and production environments. Perform database performance tuning, query optimisation, and capacity planning. Manage database security, including user access controls, authentication, and encryption. Implement backup and recovery strategies to ensure high availability and disaster recovery readiness. Monitor database health, proactively identify issues, and implement preventive and corrective solutions. Upgrade and patch PostgreSQL instances while minimising downtime and impact on users.
Database Operations & Automation

Develop and maintain automation scripts using Bash for routine database operations. Automate backup processes, monitoring alerts, and routine maintenance procedures. Create and maintain comprehensive database documentation, runbooks, and standard operating procedures. Collaborate closely with development teams on database design, performance tuning, and optimisation. Participate in on-call rotation to provide timely response and resolution for database incidents.
Kubernetes & Containerization

Support PostgreSQL deployments in Kubernetes-based environments. Work with containerised database solutions and understand their operational requirements. Collaborate with DevOps teams on database deployment strategies within Kubernetes.
Cassandra Support

Provide support and routine maintenance for Apache Cassandra clusters. Assist with Cassandra performance monitoring and basic troubleshooting. Collaborate on data modelling and replication strategies.
Technical Skills

Databases:

PostgreSQL (required), Cassandra (working knowledge), SQL

Scripting:

Bash (required), Python or other scripting languages (preferred)

Container Orchestration:

Kubernetes (working knowledge), Docker

Monitoring:

Prometheus, Grafana, pgBadger, or similar tools

Operating Systems:

Linux (RHEL, Ubuntu, CentOS)

Version Control:

Git

Cloud Platforms:

AWS, GCP, or Azure (preferred)
Required Qualifications

Minimum 5 years of experience as a Database Administrator across multiple database platforms. At least 2 years of hands-on experience with PostgreSQL administration. Strong expertise in PostgreSQL performance tuning, replication, and high availability solutions. Proficiency in Bash scripting for database automation and operations. Working knowledge of Kubernetes and containerised environments. Working knowledge of Apache Cassandra architecture and operations. Strong SQL skills with a focus on query optimisation. Experience with database backup and recovery tools such as pg_dump, pg_basebackup, and WAL archiving. Experience with database monitoring and alerting tools. * Solid understanding of Linux/Unix operating systems.