Position Title: PostgresDBA Reporting to:
Department / Function: Infrastructure Business Unit:
Date of Profile: Profile Approved by:
Position Summary - Purpose and Objectives of the Role
We are seeking an experienced PostgreSQL DBA to join our team with 5-7 years of experience. The ideal candidate will be responsible for the maintenance and performance tuning of PostgreSQL databases in high-availability environments. You will work closely with development, DevOps, and infrastructure teams to ensure data integrity, security, and scalability.
Main Focus and Key Areas of Responsibilities
Administer, maintain, tune, and troubleshoot PostgreSQL databases across development, testing, and production environments.
Plan and implement database backup and recovery strategies.
Monitor database performance, implement changes, and apply new patches and versions when required.
Design and implement high-availability and disaster recovery strategies (e.g., replication, clustering, failover).
Ensure database security and compliance with internal and external standards.
Automate routine tasks using scripting (e.g., Bash, Python, Ansible).
Work closely with software developers to optimize SQL queries and database schema design.
Perform data migrations, upgrades, and capacity planning.
Support CI/CD processes related to database deployments.
Candidate Profile
Knowledge / Experience
Divisional or BU Experience The ideal candidate should have worked closely with cross-functional teams in technology-driven environments and supported database needs across multiple business functions.
Experience / Track Record Education and Experience:
Educational Qualifications:
Bachelor s degree in Computer Science, Information Technology, Engineering, or a related technical field is required.
Master s degree or relevant Postgraduate qualification is a plus.
Industry certifications (preferred but not mandatory):
- PostgreSQL Certified Professional
- Linux Administration Certifications (e.g., RHCE)
- Cloud Cloud certifications (i.e Azure,AWS)
Technical Expertise:
Expert-level experience in PostgreSQL administration, configuration, tuning, and troubleshooting.
In-depth knowledge of PostgreSQL internals, query planner, execution strategies, and indexing techniques.
Strong experience in replication methods (streaming replication, logical replication) and clustering/failover solutions.
Familiarity with tools like pgAdmin, psql, pgBackRest, , and Patroni, Appdynamics
Backup and recovery planning, implementation, and testing in business-critical environments.
Experience in PostgreSQL version upgrades, migrations, and capacity planning
Industries Experience One or more of the following:
Medical device
FMCG
Retail
Geographical Experience Exposure to global infrastructure teams environments, particularly in high-availability, multi-region database architectures.
Management Experience
Qualifications
Education / Qualification / Certification Computer Science degree
Language Proficiency in English and local language. Multilingual will be advantage.
Pre-requisites and Next Career Steps
Psychometrics/ Behavioral Traits Demonstrates high energy
Strong ability to influence, drive change amongst ambiguity
Goal driven and result-oriented
Clear and fact-based decision making
Diverse and able to work well in teams and across functions
Communication & Influencing: Must clearly convey information and ideas through a variety of media to individuals or groups in a manner that engages the audience and helps them understand and retain the message. An individual with excellent interpersonal skills and influencing ability who can win the confidence of individuals at all levels, both inside and outside of the organization. Must have excellent written and verbal communication skills.
Teamwork: An individual who can work effectively in a collaborative environment and foster teamwork across all levels of the organization.