Database Administrator

Role Summary

Walker Digital Table Systems (WDTS) is looking for a PostgreSQL Database Developer with 3–4 years of experience to join the Platform Engineering Database Team. The role involves supporting mission-critical PostgreSQL databases powering the Perfect Pay platform by contributing to database development, administration, performance tuning, reporting, automation, and production support in a high-availability environment.

Key Responsibilities

• Develop and maintain SQL, PL/pgSQL procedures, functions, triggers, views, and optimize database queries.

• Develop and maintain JasperReports for operational and business reporting.

• Support both OLTP and reporting database workloads to ensure optimal performance and availability.

• Develop Shell and Python scripts to automate routine database administration, monitoring, and reporting tasks.

• Monitor database health, troubleshoot performance issues, and provide production support.

• Collaborate with Development, DevOps, and Platform Engineering teams to support database deployments and application releases.

• Maintain operational documentation and contribute to continuous improvement through automation and best practices.

Required Qualifications

• Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field.

• 3–4 years of experience in PostgreSQL database development and administration.

• Strong knowledge of PostgreSQL, SQL, and PL/pgSQL.

• Experience with query optimization, database performance tuning, backup & recovery, and replication concepts.

• Experience with JasperReports and report development.

• Proficiency in Shell and/or Python scripting.

• Working knowledge of Linux (RHEL/Rocky).

• Good analytical, troubleshooting, and communication skills.

Preferred Skills

• Exposure to PostgreSQL high-availability solutions such as Pgpool-II, PgBouncer, or pgBackRest.

• Familiarity with GitHub, Jenkins, and CI/CD-based database deployment processes.

• Knowledge of Liquibase or Flyway for database version management.

• Exposure to Kafka, HashiCorp Vault, or cloud-based PostgreSQL environments is an added advantage.

Technical Stack

• Database: PostgreSQL

• Languages: SQL, PL/pgSQL, Shell, Python

• Reporting: JasperReports

• High Availability: Replication, pgBackRest, Pgpool-II, PgBouncer

• Operating System: Linux (RHEL/Rocky)

• DevOps: GitHub, Jenkins, CI/CD

• Additional Technologies: Liquibase, Flyway, Kafka, HashiCorp Vault

Key Competencies

• PostgreSQL Development & Administration

• SQL & Query Optimization

• Database Performance Tuning

• Production Support

• Automation & Scripting

• Reporting & Analytics

• Problem Solving & Troubleshooting

• Team Collaboration

• Continuous Learning & Ownership