Postgresql Database Administrator

Visara Human Capital Services; Mumbai; On-site; INR 1,500,000 - 2,100,000; Full time

Job summary

BSE Ltd. in Mumbai (Fort) is seeking an experienced PostgreSQL Database Administrator (L2) to support mission-critical database environments. You will manage production PostgreSQL databases, ensure high availability, and provide 247 onsite support.

Ideal candidates have 4–6 years of PostgreSQL DBA experience, with strong skills in clustering, migrations, performance tuning, and security hardening. Onsite work is required in Mumbai.

Qualifications

• 4–6 years of PostgreSQL DB Administration experience.
• Hands-on with PostgreSQL, clustering, migration, and security hardening.
• Onsite production support experience preferred.

Responsibilities

• Administer, monitor, and maintain PostgreSQL databases.
• Perform troubleshooting, performance tuning, and optimization.
• Configure and manage PostgreSQL clusters.
• Execute migrations and version upgrades.
• Implement hardening, patching, and security best practices.
• Manage users, roles, and permissions.
• Configure Foreign Data Wrappers (FDW).
• Monitor health, capacity, and availability.
• Plan backup, recovery, and DR activities.
• Collaborate with infra and app teams to resolve issues.
• Automate routine admin tasks.
• Maintain documentation and standards.

Skills

PostgreSQL DBA

Database Troubleshooting

Cluster Setup (PCS)

Migration & Upgrades

Security Hardening

Patching & Maintenance

FDW

Performance Tuning

User & Role Management

Linux Administration

Backup & Recovery

Education

B.E./B.Tech/Diploma (CS/IT/ET)

B.Sc. IT

BCA/MCA (Full-time)

Tools

pgAdmin

pg_stat_activity

Prometheus

Grafana

Job description

Job Title

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

Job Description

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