PostgreSQL DBA

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.