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