Job Summary

We are seeking an experienced PostgreSQL Database Administrator (DBA) with 6-8 years of experience in database administration, performance tuning, backup and recovery, and high availability environments. The candidate will be responsible for managing enterprise PostgreSQL databases, ensuring optimal performance, security, availability, and operational excellence.

Key Responsibilities

- Install, configure, administer, and maintain PostgreSQL database environments.
- Perform database upgrades, patching, and migrations.
- Monitor database performance and optimize queries, indexes, and configurations.
- Manage backup, restore, and disaster recovery processes.
- Implement and support High Availability (HA) and replication solutions.
- Perform database capacity planning and storage management.
- Troubleshoot database performance issues and conduct root cause analysis.
- Implement database security, user management, and access controls.
- Support application teams during deployments and database changes.
- Automate routine DBA activities using Shell, Python, or PowerShell scripting.
- Manage database health monitoring and alerting tools.
- Participate in incident, problem, change, and release management processes.
- Create and maintain technical documentation and operational procedures.

Required Skills

- 6-8 years of experience in Database Administration.
- Strong hands-on experience with PostgreSQL 11/12/13/14/15 and above.
- Database Installation Configuration




- Backup Recovery (pg_dump, pg_restore, PITR)
- Performance Tuning
- Query Optimization
- Partitioning
- Index Management
- Vacuum Analyze Operations
- PostgreSQL Replication
- Streaming Replication
- Logical Replication
- Failover Management
- Strong knowledge of Linux Administration.
- Monitoring Tools such as pgAdmin, Prometheus, Grafana, Nagios
- Knowledge of SQL, PL/pgSQL, and database scripting.

Preferred Skills

- Experience with PostgreSQL on AWS RDS, Azure Database for PostgreSQL, or GCP.
- Knowledge of HA solutions such as Patroni, Pgpool-II, or RepMgr.
- Containerization experience using Docker and Kubernetes.
- Understanding of DevOps and CI/CD practices.
- Experience with automation scripting (Python, Shell).

Soft Skills

- Strong troubleshooting and analytical skills.
- Excellent communication and stakeholder management.
- Ability to manage critical production issues independently.
- Strong documentation and coordination skills.
- Customer-focused and proactive approach.

Certifications (Preferred)

- PostgreSQL Certified Qualified
- AWS/Azure Database Certifications
- ITIL Foundation Certification

Educational Requirement

Bachelor of Engineering

Technology

- Technology->Database Technologies->PostgreSQL
- Technology->DevOps->Azure Devops
- Technology->Infra_ToolAdministration-Automation->Microsoft

Service Line

Cloud Infrastructure Services

📌 PostgreSQL admin_Jl4 (Pune)
🏢 Infosys
📍 Pune