PostgreSQL Database Administrator - L2 (Fixed Term Contract)

Role and 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