Job Description

Job Title: PostgreSQL Database Administrator

Location: Pune, India

Experience Range: 5 to 10 years

Job Summary

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, andoptimizing PostgreSQL databases in mission-critical environments. You will be responsible for ensuring database performance, high availability, data security, and infrastructure reliability through proactive monitoring and rapid troubleshooting.

Key Responsibilities


Database Administration & Performance:


Install, configure, upgrade, and maintain PostgreSQL (versions 12-15).


Monitor performance and tune PostgreSQL databases to ensure high efficiency.


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 (kernel parameters, limits, cron jobs).


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:


Set up and manage streaming, logical, and synchronous replication.


Implement automated failover using Patroni, repmgr, pg_auto_failover, etc.


Configure HAProxy, PgBouncer for load balancing and pooling.


Document and test failover, switchovers, and recovery procedures.


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.


Schedule and test backups and disaster recovery processes regularly.


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, standard operating procedures (SOPs), and knowledge base entries.


Work closely with developers, SREs, DevOps, and QA teams for integration, deployment, and release planning.

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.

Job Types: Full-time, Permanent

Pay: ₹1,500,000.00 - ₹2,000,000.00 per year

Schedule:

Day shift
Work Location: In person