Database Administrator New Delhi (India)

Role Summary

Walker Digital Table Systems (WDTS) is seeking an experienced PostgreSQL Database Developer & 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 robust expertise in database development, performance tuning, replication, backup & recovery, production support, and reporting solutions to ensure the reliability, scalability, and availability of our Perfect Pay platform.

Key Responsibilities ·

• Develop and maintain SQL, PL/pgSQL procedures, functions, triggers, views, and optimize complex database queries.
• Administer and support high-availability PostgreSQL production settings, ensuring performance, reliability, and uptime.
• Manage PostgreSQL replication, backup & 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, operational procedures, and support continuous improvement through automation and best practices.

Required Qualifications

• Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field.
• 6–7 years of experience in PostgreSQL database administration and development.
• Robust experience managing high-availability PostgreSQL clustered