Job Title

PostgreSQL Database Administrator (L2) BSE Ltd. | Mumbai (Fort)

We are looking for an experienced PostgreSQL Database Administrator (L2) to join our team for supporting mission-critical PostgreSQL database environments at BSE Ltd. The ideal candidate should have 46 years of hands-on experience in PostgreSQL administration, database clustering, performance tuning, migration, troubleshooting, and security hardening. The role involves managing production databases, ensuring high availability, and providing 247 onsite support.

Key Responsibilities

- Administer, monitor, and maintain PostgreSQL databases.
- Perform database troubleshooting, performance tuning, and optimization.
- Configure and manage PostgreSQL database clusters.
- Execute database migrations and version upgrades.
- Implement database hardening, patching, and security best practices.
- Manage database users, roles, and permissions.
- Configure and maintain Foreign Data Wrappers (FDW).
- Monitor database health, capacity, and availability.
- Plan and execute backup, recovery, and disaster recovery activities.
- Collaborate with infrastructure and application teams to resolve database issues.




- Automate routine database administration tasks.
- Maintain database documentation and operational standards.

Required Skills (Mandatory)

- PostgreSQL Database Administration
- Database Troubleshooting
- PostgreSQL Cluster Setup (PCS Cluster)
- Database Migration & Version Upgrade
- Database Hardening & Security
- Database Patching
- Foreign Data Wrappers (FDW)
- Database Performance Tuning & Optimization
- User & Role Management
- Database Maintenance Jobs
- Linux Administration
- Backup & Recovery

Good to Have

- PostgreSQL Replication (Streaming/Logical)
- Disaster Recovery Planning
- Shell Scripting/Automation
- Monitoring Tools (pgAdmin, pg_stat_activity, Prometheus, Grafana)

Experience

- 4–6 years of relevant PostgreSQL Database Administration experience.

Education

- Full time B.E./B.Tech/Diploma (Computer Science, IT, Electronics & Telecommunication)
- B.Sc. (IT)
- BCA/MCA (Full-time)
- No gap in education.

Location

- Mumbai (Fort)

Work Mode

- Onsite

Support

- 247 Production Support

📌 Postgresql Database Administrator (Mumbai)
🏢 Visara Human Capital Services
📍 Mumbai