Senior Database Administrator - PostgreSQL

Walker Digital Table Systems; Gurugram District; On-site; INR 3,200,000 - 4,800,000; Full time

Job summary

Walker Digital Table Systems (WDTS) seeks an experienced PostgreSQL Database Developer and Administrator to join the Platform Engineering Database Team. You will develop, administer, and support mission-critical PostgreSQL databases in high-availability production clusters to ensure reliability and performance.

Responsibilities include SQL/PL/pgSQL development, replication, backups, disaster recovery, and JasperReports for operational and regulatory reporting.

Qualifications

• 6-7 years of PostgreSQL database administration and development.
• Strong experience in high-availability PostgreSQL clustered production environments.
• Expertise in SQL, PL/pgSQL, query optimization, replication, pgBackRest, Pgpool-II/PgBouncer.
• Experience with JasperReports, Shell/Python scripting and Linux (RHEL/Rocky).

Responsibilities

• Develop and maintain SQL, PL/pgSQL, triggers, and views; optimize queries.
• Administer and support high-availability PostgreSQL production environments.
• Manage PostgreSQL replication, backup/recovery, DR, and health monitoring.
• Design, develop, and maintain JasperReports for reporting.
• Support OLTP and reporting workloads with performance isolation.
• Create Shell and Python scripts for automation and scheduling.
• Troubleshoot performance issues and incidents; ensure timely resolution.
• Collaborate with Development, DevOps, and Platform Engineering teams.
• Maintain documentation and promote automation and best practices.

Skills

PostgreSQL

SQL

PL/pgSQL

Query optimization

Replication

Shell scripting

Python scripting

Linux

Education

Bachelor's degree in computer science/IT/engineering

Tools

pgBackRest

Pgpool-II

PgBouncer

JasperReports

Liquibase

Flyway

GitHub

Jenkins

Kafka

HashiCorp Vault

Job description

Walker Digital Table Systems (WDTS) is seeking an experienced PostgreSQL Database Developer and Administrator to join the Platform Engineering Database Team. This role is responsible for developing, administering, and supporting mission-critical PostgreSQL databases running in high-availability clustered production environments. The ideal candidate will have strong expertise in database development, performance tuning, replication, backup and recovery, production support, and reporting solutions to ensure the reliability, scalability, and availability of our Perfect Pay platform.

Responsibilities:

• Develop and maintain SQL, PL/pgSQL, triggers, and views and optimize complex database queries.
• Administer and support high-availability PostgreSQL production environments, ensuring performance, reliability, and uptime.
• Manage PostgreSQL replication, backup and recovery, disaster recovery, and database health monitoring.
• Design, develop, and maintain JasperReports for operational, business, and regulatory reporting.
• Support both transactional (OLTP) and reporting database workloads while ensuring optimal performance and workload isolation.
• Develop Shell and Python scripts to automate database administration, monitoring, report scheduling, backup validation, and operational tasks.
• Troubleshoot database performance issues, production incidents, and reporting problems, ensuring timely resolution.
• Collaborate with Development, DevOps, and Platform Engineering teams to support database deployments and operational excellence.
• Maintain database documentation and operational procedures and support continuous improvement through automation and best practices.

Requirements:

• Bachelor's degree in computer science, information technology, engineering, or a related field.
• 6-7 years of experience in PostgreSQL database administration and development.
• Strong experience managing high-availability PostgreSQL clustered production environments.
• Expertise in SQL, PL/pgSQL, query optimization, replication, pgBackRest, and Pgpool-II/PgBouncer.
• Experience with JasperReports, Shell/Python scripting, and Linux (RHEL/Rocky).
• Solid understanding of OLTP systems, reporting databases, backup and recovery, and production support.
• Strong analytical, troubleshooting, and communication skills.

Preferred Skills:

• Experience with GitHub, Jenkins, and CI/CD-based database deployment processes.
• Knowledge of Liquibase or Flyway for database version control.
• Exposure to Kafka, HashiCorp Vault, and cloud-based PostgreSQL platforms.
• Experience implementing database automation, monitoring, and operational best practices.

Technical Stack:

• Database: PostgreSQL.
• Languages: SQL, PL/pgSQL, Shell, Python.
• Reporting: JasperReports.
• HA and Performance: Replication, Pgpool-II, PgBouncer, and pgBackRest.
• Operating System: Linux (RHEL/Rocky).
• DevOps: GitHub, Jenkins, CI/CD.
• Additional Technologies: Liquibase, Flyway, Kafka, HashiCorp Vault.

Key Competencies:

• PostgreSQL Administration and Development.
• Database Performance Tuning.
• High Availability and Disaster Recovery.
• Automation and Scripting.
• Production Support and Incident Management.
• Reporting and Analytics.
• Problem Solving and Troubleshooting.
• Collaboration and Communication.
• Ownership and Continuous Improvement.