Postgresql Database Administrator

Elite Exceed; Chennai District; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Elite Exceed is seeking a PostgreSQL DBA with 5-7 years of hands-on experience to manage and optimize PostgreSQL databases. The role emphasizes Linux proficiency, replication-based high availability, and extensive SQL/query tuning across on-prem and cloud environments (Azure/GCP).

The candidate should be adept at troubleshooting performance issues, automating tasks with Ansible, and implementing robust backup/HA strategies while leveraging PostgreSQL internals for advanced optimization.

Qualifications

• 5-7 years of experience on PostgreSQL databases.
• Good Understanding on Linux OS
• Expertise on troubleshooting db performance issue
• Understanding of Ansible to automate task.
• Advanced knowledge on PostgreSQL internals.
• Experience implementing high availability by setting up streaming replication or logical replication and good understanding of troubleshooting replication issue.
• Know how to optimize queries/schemas.
• Knows backup solution and strategies.
• Knows HA solution and its strategies.
• Experience on Azure & GCP cloud environment

Skills

PostgreSQL

Linux OS

Performance Troubleshooting

Ansible

PostgreSQL internals

High availability

Query optimization

Backup strategies

HA strategies

Azure & GCP cloud

Tools

Streaming replication

Logical replication

Cloud environments (Azure/GCP)

Ansible automation

Job description

Role Description: PostgreSQL DBA JD

Technical Expertise: 5-7 years of experience on PostgreSQL databases.

Good Understanding on Linux OS
Expertise on troubleshooting db performance issue
Understanding of Ansible to automate task.
Advanced knowledge on Postgresql internals.
Experience implementing high availability by setting up either streaming replication or logical replication and good understanding of troubleshooting replication issue.
Know how to optimize queries/schemas.
Knows backup solution and strategies.
Knows HA solution and its strategies.
Experience on Azure & GCP cloud environment