Database Administrator - Postgresql

Team Computers; Mumbai; On-site; INR 900,000 - 1,300,000; Full time

Job summary

Team Computers in Mumbai is seeking a PostgreSQL DBA to administer production databases, ensuring high availability and optimal performance. You will install, configure, monitor, back up, and recover PostgreSQL servers while addressing security and capacity planning.

You will also implement replication, perform tuning, and automate routine tasks with shell scripts or Ansible, collaborating with engineering and operations teams.

Qualifications

• Proven experience administering PostgreSQL in production environments.
• Strong backup, recovery, replication, and disaster recovery practices.
• Ability to optimize queries and maintenance tasks with best practices.

Responsibilities

• Install, configure, upgrade and patch PostgreSQL servers.
• Monitor database health, performance, storage, CPU and memory.
• Perform backup, restore and disaster recovery testing using pgBackRest or similar tools.
• Administer replication and high availability solutions.
• Troubleshoot locks, slow queries, blocking sessions and incidents.
• Optimize SQL queries, indexes and execution plans using EXPLAIN/ANALYZE.
• Manage users, roles, privileges and database security.
• Monitor WAL, autovacuum, bloat and routine maintenance.
• Support production incidents and change deployments.
• Automate routine DBA tasks using shell scripting, SQL or Ansible.

Skills

PostgreSQL 12/13/14/15/16

SQL

PL/pgSQL

Streaming Replication

Logical Replication

Performance Tuning

EXPLAIN / ANALYZE

VACUUM / AUTOVACUUM

Partitioning / Indexing

Linux Administration

Shell Scripting

Monitoring tools: pgAdmin / Prometheus

Tools

pgBackRest

Barman

pgAdmin

Prometheus

Grafana

Ansible (automation)

Job description

Role Summary

Responsible for administering, monitoring, securing, tuning, backing up, recovering, and supporting PostgreSQL databases in production environments while ensuring highavailability and performance.

Key Responsibilities

• Install, configure, upgrade and patch PostgreSQL servers.
• Monitor database health, performance, storage, CPU and memory.
• Perform backup, restore and disaster recovery testing using pgBackRest or similar tools.
• Administer replication (streaming/logical) and high availability solutions.
• Troubleshoot locks, slow queries, blocking sessions and database incidents.
• Optimize SQL queries, indexes and execution plans using EXPLAIN/ANALYZE.
• Manage users, roles, privileges and database security.
• Monitor WAL, autovacuum, bloat and routine maintenance.
• Support production incidents, root cause analysis and change deployments.
• Automate routine DBA tasks using shell scripting, SQL or Ansible (preferred).

Required Skills

• PostgreSQL 12/13/14/15/16
• SQL and PL/pgSQL
• Backup & Recovery (pgBackRest/Barman)
• Streaming & Logical Replication
• Performance Tuning and Query Optimization
• EXPLAIN / EXPLAIN ANALYZE
• VACUUM, ANALYZE, Autovacuum
• Partitioning and Index Management
• Linux Administration
• Shell Scripting
• Monitoring tools (pgAdmin, Prometheus, Grafana)