Postgresql Database Administrator

Wipro; Bengaluru, Pune District; On-site; INR 900,000 - 1,300,000; Full time

Job summary

Wipro in Bengaluru is seeking a PostgreSQL DBA to administer, maintain and support production PostgreSQL databases. Responsibilities include installation, configuration, upgrades, migrations, backups, recovery, replication setup, HA/DR, and system health monitoring.

You will troubleshoot incidents, optimize performance, enforce security, and collaborate with cross-functional teams in a production environment.

Qualifications

• Strong hands-on PostgreSQL administration experience.
• Solid understanding of PostgreSQL architecture.
• Experience with installation, configuration and upgrades.
• Experience in replication setup and troubleshooting.
• Experience with backup and recovery using pg_dump and pg_basebackup.
• Knowledge of HA/DR solutions for PostgreSQL.
• Strong troubleshooting and performance tuning skills.
• Experience on Linux/Unix environments.
• Knowledge of pg_hba.conf and postgresql.conf.
• Production support experience.

Responsibilities

• Administer, maintain, and support PostgreSQL databases in production environments.
• Perform database installation, configuration, upgrades, and migrations.
• Manage database backup, recovery, and restoration activities.
• Configure and support PostgreSQL Replication and High Availability.
• Monitor database health, capacity, performance, and availability.
• Troubleshoot database incidents and performance bottlenecks.
• Implement security controls using PostgreSQL roles, and configurations.
• Perform routine DBA activities, including patching, maintenance, and health checks.
• Work closely with application, infrastructure, and support teams.
• Participate in on-call support, incident management, and RCA activities.

Skills

PostgreSQL Administration

PostgreSQL Architecture

Installation & Upgrades

Replication Setup

Backup & Recovery

HA/DR for PostgreSQL

Performance Tuning

Linux/Unix

pg_hba.conf & postgresql.conf

Production Support

Tools

PGAdmin

Grafana

Prometheus

Job description

Roles & Responsibilities

• Administer, maintain, and support PostgreSQL databases in production environments.
• Perform database installation, configuration, upgrades, and migrations.
• Manage database backup, recovery, and restoration activities.
• Configure and support PostgreSQL Replication and High Availability solutions.
• Monitor database health, capacity, performance, and availability.
• Troubleshoot database-related incidents and resolve performance bottlenecks.
• Implement security controls using PostgreSQL roles, privileges, and configurations.
• Perform routine DBA activities, including patching, maintenance, and health checks.
• Work closely with application, infrastructure, and support teams.
• Participate in on-call support, incident management, and RCA activities.

Mandatory Skills

• Strong hands-on experience in PostgreSQL Administration.
• Good understanding of PostgreSQL Architecture.
• Experience in Installation, Configuration, and Upgrades.
• Experience in Replication Setup and Troubleshooting (Streaming/Logical Replication).
• Experience in Backup & Recovery using pg_dump, pg_basebackup, etc.
• Knowledge of HA/DR solutions for PostgreSQL.
• Strong troubleshooting and Performance Tuning skills.
• Experience working on Linux/Unix environments.
• Knowledge of pg_hba.conf, postgresql.conf, and database security.
• Production Support experience.

Preferred Skills

• Oracle DBA or MySQL DBA Administration.
• PostgreSQL Migration projects.
• AWS RDS PostgreSQL/Aurora PostgreSQL.
• Monitoring tools such as PGAdmin, Grafana, Prometheus.
• Exposure to MongoDB, Redis, or other open-source databases.
• ITIL process knowledge