PostgreSQL Database Administrator | Fulltime (Fixed term)

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.

Job Description

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