Postgresql Database Administrator

TechBerry Infotech Pvt. Ltd.; Navi Mumbai; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

TechBerry Infotech Pvt. Ltd. in Navi Mumbai seeks an experienced PostgreSQL DBA to install, configure, upgrade, and maintain PostgreSQL databases while monitoring performance and troubleshooting production issues.

You will optimize SQL, perform backups and PITR, manage replication, and contribute to high availability. Strong shell scripting and familiarity with pgAdmin, pgBadger, Pgpool, PgBouncer, and Barman are required, with collaboration across DevOps and infrastructure teams.

Qualifications

• 3-6 years of hands-on PostgreSQL DBA experience.
• Strong knowledge of PostgreSQL architecture and SQL.
• Experience in query tuning, backup/recovery, and replication.
• Good Shell scripting and troubleshooting skills.
• Familiarity with tools such as pgAdmin, pgBadger, Pgpool, PgBouncer, and Barman.
• Experience supporting production databases.

Responsibilities

• Install, configure, upgrade, and maintain PostgreSQL databases.
• Monitor database performance and troubleshoot production issues.
• Perform SQL query optimization, indexing, and performance tuning.
• Manage backup, recovery, PITR, and replication.
• Configure and support high-availability and failover solutions.
• Develop Shell scripts for automation and database maintenance.
• Manage database users, roles, permissions, and security.
• Support database migrations, upgrades, and incident resolution.
• Collaborate with development, DevOps, and infrastructure teams.

Skills

PostgreSQL DBA

PostgreSQL architecture

SQL

Query tuning

Backup recovery

Replication

Shell scripting

Troubleshooting

production databases

PITR

Database performance

Tools

pgAdmin

pgBadger

Pgpool

PgBouncer

Barman

Job description

Key Responsibilities

• Install, configure, upgrade, and maintain PostgreSQL databases.


• Monitor database performance and troubleshoot production issues.


• Perform SQL query optimization, indexing, and performance tuning.


• Manage backup, recovery, Point-in-Time Recovery (PITR), and replication.


• Configure and support high-availability and failover solutions.


• Develop Shell scripts for automation and database maintenance.


• Manage database users, roles, permissions, and security.


• Support database migrations, upgrades, and incident resolution.


• Collaborate with development, DevOps, and infrastructure teams.

Required Skills

• 3-6 years of hands-on PostgreSQL DBA experience.


• Strong knowledge of PostgreSQL architecture and SQL.


• Experience in query tuning, backup/recovery, and replication.


• Good Shell scripting and troubleshooting skills.


• Familiarity with tools such as pgAdmin, pgBadger, Pgpool, PgBouncer, and Barman.


• Experience supporting production databases.

Preferred Qualifications

• Exposure to AWS RDS, Azure Database for PostgreSQL, or EDB.


• Knowledge of high availability, CI/CD, and DevOps practices.


• PostgreSQL or EDB certifications are an advantage.

Ideal Candidate

Candidates should have strong troubleshooting and analytical skills, the ability to manage production databases independently, and a focus on database performance, availability, and reliability.