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)

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

📌 Postgresql Database Administrator (Chennai)
🏢 Tata Consultancy Services
📍 Chennai