Postgresql Database Administrator

Job Title: PostgreSQL Database Administratorr

Experience: 5-10Years

Interview Mode: Virtual

Interview Date: To be Announced

Work Location-Chennai,

Job Summary

We are looking for an experienced PostgreSQL Database Administrator (DBA) with strong expertise in PostgreSQL administration, database upgrades, backup & recovery, performance tuning, and troubleshooting. The candidate will provide L3 support, manage production databases, and ensure database availability, performance, and security.

a { text-decoration: none; color: #464feb; } tr th, tr td { border: 1px solid #e6e6e6; } tr th { background-color: #f5f5f5; }

Required Skills

• PostgreSQL Database Administration
• Installation, Upgrade & Migration
• Backup & Recovery
• Database Corruption Troubleshooting
• Performance Tuning & Query Optimization
• SQL & PL/pgSQL Scripting
• Database Maintenance (Vacuum, Reindexing, Archiving)
• ITIL Processes (Incident, Change & Problem Management)

Good to Have

• PostgreSQL Replication
• PowerShell Scripting
• Windows-Based PostgreSQL Administration
• High Availability & Disaster Recovery Solutions

Key Responsibilities

• Administer PostgreSQL databases including installation, configuration, upgrade, and decommissioning.
• Perform database backup, recovery, restoration, and disaster recovery activities.
• Troubleshoot database corruption, performance issues, and production incidents.
• Execute minor and major PostgreSQL version upgrades and database migrations.
• Manage database maintenance activities such as Vacuum, Reindexing, Archiving, and Health Checks.
• Monitor database performance and perform query tuning and resource optimization.
• Implement and support PostgreSQL replication solutions.
• Develop and maintain SQL, PL/pgSQL, and PowerShell scripts for automation.