Description

Experience: 5 to 10 years

Key Highlights: PostgreSQL Database Administration
 

Position Overview:
We are seeking a skilled and experienced PostgreSQL Database Administrator to join our team. The ideal candidate will have 5 to 10 years of hands-on experience in managing, maintaining, and optimizing PostgreSQL databases in mission-critical environments. 

Required Skills & Qualifications
· 5 to 10 years of PostgreSQL DBA experience in production environments.
Expertise in:
· Streaming/logical replication, WAL archiving
· Failover orchestration (Patroni, repmgr)
· PgBouncer, HAProxy
· Column-level encryption (pgcrypto)
· Deep understanding of PostgreSQL internals, query planner, system catalogs.
· Proficient in Linux system administration (RHEL/Ubuntu).
· Strong shell scripting and task automation experience.
· Hands-on with server health diagnostics, resource utilization analysis, and OS tuning.

Key Responsibilities
Database Administration & Performance:
· Install, configure, upgrade, and maintain PostgreSQL(V 12–15).
· Monitor performance and tune PostgreSQL databases.
· Analyze query plans and optimize slow queries and indexing.
· Manage PostgreSQL system catalogs, logs, and storage.
 

Server Maintenance & Troubleshooting:
· Perform OS-level and DB-level diagnostics to resolve service disruptions or performance issues.
· Analyze and troubleshoot CPU, memory, disk I/O bottlenecks, and DB lock/contention problems.
· Maintain and tune PostgreSQL instances across on-premise and containerized deployments.
· Ensure system uptime, availability, and capacity planning for database servers.
· Maintain and update server-level configurations.
· Coordinate with infrastructure/DevOps teams to handle VM/container patching, upgrades, and reboots.
· Perform root cause analysis (RCA) for recurring issues or incidents.
· Develop incident response and mitigation playbooks.
 

Replication & High Availability:
Security & Encryption:
· Implement pgcrypto, Vault/KMS for column-level encryption.
· Enforce RBAC, RLS, and secure data access policies.
· Ensure SSL/TLS encryption, key management, and access auditing.
· Assist with compliance efforts (GDPR, HIPAA, etc.).
 

Backup & Disaster Recovery:
· Design PITR and full backup solutions using pgBackRest, Barman, or custom tools.
 

Automation & Scripting:
· Automate recurring tasks with Shell scripting, Ansible, or equivalent tools.
· Set up monitoring and alerting via scripts and third-party tools.
 

 Documentation & Collaboration:
· Maintain architecture diagrams, SOPs, and knowledge base entries.
· Experience of integration, deployment, and release planning

Key Skills

Education

Any Graduate