Postgresql Database Administrator

Orcapod Consulting Services; Pune District, Coimbatore District, Bengaluru; Hybrid; INR 600,000 - 900,000; Full time

Job summary

Orcapod Consulting Services in Pune, India invites a PostgreSQL Administrator to join our on-site team. You will install, configure, and manage PostgreSQL databases, handle backups and restores, and monitor performance and security across environments.

The role requires strong Linux administration skills, hands-on experience with replication and query troubleshooting, and the ability to participate in on-call and scheduled maintenance activities. Cloud knowledge is a plus.

Qualifications

• PostgreSQL Administration
• Linux Administration
• Backup & Recovery
• User and Role Management
• Query Troubleshooting
• Replication Fundamentals
• Performance Monitoring
• Shell Scripting Basics
• Incident and Change Management

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.

Skills

PostgreSQL Administration

Linux Administration

Backup & Recovery

User and Role Management

Query Troubleshooting

Replication Fundamentals

Performance Monitoring

Shell Scripting Basics

Incident and Change Management

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.

Preferred candidate profile

• 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