05 Nov
|
Carnation Infotech
|
Bengaluru
05 Nov
Carnation Infotech
Bengaluru
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