Role: PostgreSQL Database Administrator L2

Location – Pune & Coimbatore (Preferred) / Bangalore & Hyderabad (Secondary)

Exp:- 5 to 8 years (4+ years)

Employment type: Fulltime (Fixed Term)

Mandatory skills: PostgreSQL Database Install, configure, maintain and patching

Primary Skills (Technical Skill): PostgreSQL 12.x, 13.x, 14.x, 15.x, 16.x

Secondary Skills (optional): MySQL, MSSQL.

Role & Responsibilities

- Install, configure, and maintain PostgreSQL databases.
- Create and manage databases, schemas, tables, users, roles, and privileges.
- Monitor database health, availability, CPU, memory, storage, and replication status.
- Perform database backup, restore, and recovery operations.
- Handle user requests, access management, and database changes.
- Troubleshoot database-related incidents and service requests.
- Execute routine maintenance activities such as VACUUM, ANALYZE, and reindexing.




- Monitor long-running queries, blocked sessions, and database alerts.
- Support vulnerability remediation and security compliance requirements.
- Maintain operational documentation, SOPs, and knowledge articles.
- Participate in on-call support and scheduled maintenance activities.

Technical Skills Required

- PostgreSQL Administration
- Linux Administration
- Backup & Recovery
- User and Role Management
- Query Troubleshooting
- Replication Fundamentals
- Performance Monitoring
- Shell Scripting Basics
- Incident and Change Management
- Cloud knowledge is preferable

Secondary Skills (Optional)

- MySQL ,MSSQL
- Specific Domain/Technical/Functional skills
- DBA background

📌 PostgreSQL Database Administrator | Fulltime (Fixed term) (Bengaluru)
🏢 Carnation Infotech
📍 Bengaluru