Postgresql Database Administrator (Location: Mumbai)

Worldline; Mumbai; On-site; INR 1,200,000 - 2,000,000; Full time

Job summary

Worldline in Mumbai seeks a Senior PostgreSQL Database Administrator to manage enterprise PostgreSQL environments, optimize performance, and ensure high availability. The role includes diskless backup/recovery, security controls, automation, and production support for mission‑critical systems.

The ideal candidate has deep PostgreSQL experience, Linux administration skills, and strong scripting abilities. You will work within SLA-driven environments and coordinate with cross‑functional teams to

Qualifications

• Bachelor's degree in CS/IT or related field required.
• Experience in production PostgreSQL environments with 68 years? (note: keep from HTML)
• Strong expertise in PostgreSQL performance tuning, replication, backup/recovery, and Linux administration.
• Proficiency in Bash/Shell scripting.
• Experience handling incidents under SLA-driven environments.
• Strong analytical, troubleshooting, and communication skills.

Responsibilities

• Install, configure, upgrade, patch, and maintain PostgreSQL databases.
• Manage high‑availability environments with streaming and logical replication.
• Implement and support connection pooling tools such as PgBouncer.
• Manage backups, recovery, and PITR testing using pgBackRest and PostgreSQL utilities.
• Monitor and optimize performance (WAL, memory, vacuuming, indexing, partitioning).
• Implement security controls including RLS, SSL/TLS, and audit logging.
• Automate tasks with Bash/Shell scripting.
• Participate in DR drills and ensure business continuity.
• Handle incident, change, and problem management through ticketing systems.
• Conduct root cause analysis (RCA) and maintain documentation.
• Coordinate with internal teams and product support for issue resolution.

Skills

PostgreSQL

Performance tuning

Replication

Backup/Recovery

Linux administration

Bash/Shell scripting

Incident management

Root cause analysis

Communication skills

Education

Bachelor's degree in Computer Science / IT

Tools

PgBouncer

pgBackRest

Job description

The Opportunity:

We are looking for a Senior Database Administrator (PostgreSQL) to manage and optimize enterprise PostgreSQL environments. The role involves database administration, high availability, performance tuning, disaster recovery, security, automation, and production support for mission‑critical systems.

Key Responsibilities:

• Install, configure, upgrade, patch, and maintain PostgreSQL databases.
• Manage high‑availability environments, including streaming and logical replication.
• Implement and support connection pooling tools such as PgBouncer.
• Manage backups, recovery, and Point‑in‑Time Recovery (PITR) testing using pgBackRest and PostgreSQL utilities.
• Monitor and optimize database performance, including WAL, memory, vacuuming, indexing, and partitioning.
• Implement database security controls, including RLS, SSL/TLS encryption, and audit logging.
• Automate operational tasks using Bash/Shell scripting.
• Participate in DR drills and ensure business continuity readiness.
• Handle incident, change, and problem management through ticketing systems.
• Conduct root cause analysis (RCA), process audits, and maintain documentation.
• Coordinate with internal teams and product support for issue resolution.

Required Qualifications:

• Bachelor's degree in Computer Science, IT, or a related field.
• 68 years of hands‑on PostgreSQL Database Administration experience in production environments.
• Strong expertise in PostgreSQL performance tuning, replication, backup/recovery, and Linux administration.
• Proficiency in Bash/Shell scripting.
• Experience managing incidents under strict SLA‑driven environments.
• Strong analytical, troubleshooting, and communication skills.