PostgresDBA

Position Title: PostgresDBAReporting 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

LanguageProficiency 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.