PostgreSQL Database Administrator - L2 (Fixed Term Contract)

Carnation Infotech; Pune District, Coimbatore District, Bengaluru; Hybrid; INR 600.000 - 1.200.000; Vollzeit

Zusammenfassung

Carnation Infotech Pvt Ltd. is seeking a PostgreSQL Database Administrator to install, configure, and maintain PostgreSQL databases in Pune. The role focuses on database health, backups, user and access management, and performance optimization.

You will monitor replication status, handle incidents, and participate in on-call and routine maintenance, ensuring security compliance and well-documented SOPs.

Qualifikationen

• Experience with PostgreSQL administration, maintenance, and tuning.
• Linux administration skills and experience.
• Backup and recovery expertise for databases.
• Experience with replication and high availability setups.

Aufgaben

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

Kenntnisse

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

Jobbeschreibung

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