The L3 PostgreSQL Engineer is responsible for the administration, performance optimization, high availability, security, and operational support of PostgreSQL databases supporting mission-critical business applications. The role serves as the highest level of technical escalation for PostgreSQL-related incidents and is responsible for ensuring database reliability, scalability, disaster recovery readiness, and continuous service improvement.
1. PostgreSQL Administration & Maintenance • Install, configure, upgrade, and maintain PostgreSQL database environments. • Manage production, non-production, and disaster recovery environments. • Configure and maintain PostgreSQL clusters. • Perform database provisioning, schema management, and environment setup. • Ensure database availability, integrity, and optimal performance. 2. Performance Tuning & Optimization • Analyze slow-running queries and optimize SQL performance. • Configure PostgreSQL parameters for optimal CPU, memory, and storage utilization. • Optimize indexes, partitions, vacuum processes, and query execution plans. • Monitor database workload and recommend performance improvements. • Conduct regular health checks and performance assessments. 3. High Availability & Replication • Configure and manage PostgreSQL replication environments. • Implement: o Streaming Replication o Logical Replication o Synchronous Replication • Manage automatic failover solutions such as: o Patroni o PgPool-II o RepMgr o Pacemaker • Ensure minimal downtime and maximum availability. 4. Backup & Recovery Management • Design and implement backup strategies. • Manage backup solutions using: o pgBackRest o WAL Archiving o Barman o Native PostgreSQL utilities • Perform recovery testing and validation. • Ensure compliance with RPO and RTO requirements. • Conduct periodic DR drills. 5. Incident & Problem Management (L3 Support) • Serve as the escalation point for complex PostgreSQL issues. • Troubleshoot database outages and performance degradation. • Perform Root Cause Analysis (RCA) for critical incidents. • Resolve replication failures, corruption issues, locking conflicts, and deadlocks. • Support Major Incident Management processes. 6. Security & Compliance • Implement database security controls. • Manage users, roles, and privileges. • Configure SSL/TLS encryption. • Perform vulnerability remediation and security patching. • Ensure compliance with organizational and regulatory standards. • Conduct periodic access reviews and security audits. 7. Monitoring & Capacity Planning • Monitor: o Database availability o Query performance o Replication status o Disk space utilization o Connection usage o Lock contention • Develop monitoring dashboards and alert mechanisms. • Forecast growth trends and perform capacity planning. 8. Cloud Database Management Support PostgreSQL environments hosted on: • AWS RDS PostgreSQL • AWS Aurora PostgreSQL • Azure Database for PostgreSQL • Google Cloud SQL PostgreSQL Responsibilities include: • Database provisioning • Performance optimization • Security management • Backup and recovery • Cost optimization 9. Automation & DevOps Integration • Automate database administration tasks. • Develop operational scripts using: o Python o Shell Scripting o PowerShell • Support CI/CD integration. • Implement Infrastructure as Code (IaC) solutions using: o Terraform o Ansible o CloudFormation 10. Documentation & Knowledge Management • Create and maintain: o SOPs o Runbooks o Recovery procedures o Architecture diagrams o Operational documentation • Provide knowledge transfer to L1 and L2 support teams. • Participate in technical reviews and governance meetings. ________________________________________ Required Technical Skills PostgreSQL Technologies • PostgreSQL 12/13/14/15/16+ • Replication Technologies • Logical Replication • Streaming Replication • WAL Management • Partitioning • Query Optimization • Performance Tuning • Database Migration HA & Clustering Tools • Patroni • PgPool-II • RepMgr • Pacemaker • Keepalived Backup Technologies • pgBackRest • Barman • WAL Archiving • PITR (Point-in-Time Recovery) Operating Systems • Linux • Unix Platforms Monitoring Tools • Prometheus • Grafana • Zabbix • Datadog • Splunk • Nagios Automation & DevOps • Python • Shell Scripting • Terraform • Ansible • Jenkins • Git Cloud Platforms • AWS • Azure • Google Cloud Container Platforms • Docker • Kubernetes • OpenShift
The L3 PostgreSQL Engineer is responsible for the administration, performance optimization, high availability, security, and operational support of PostgreSQL databases supporting mission-critical business applications. The role serves as the highest level of technical escalation for PostgreSQL-related incidents and is responsible for ensuring database reliability, scalability, disaster recovery readiness, and continuous service improvement.
The L3 PostgreSQL Engineer is responsible for the administration, performance optimization, high availability, security, and operational support of PostgreSQL databases supporting mission-critical business applications. The role serves as the highest level of technical escalation for PostgreSQL-related incidents and is responsible for ensuring database reliability, scalability, disaster recovery readiness, and continuous service improvement.
Source: HCLTech careers — Read the original posting and apply
This role is listed by the employer on its own careers site. Kaam Ki Khoj does not process applications for it.
Make a free profile in a minute — no CV needed — and we score every job against it.
Make my profileFrom the employer's own careers site. Kaam Ki Khoj reads this job from careers.hcltech.com. You apply there, on the employer's own website.
Applying is free. A genuine employer never asks you to pay: no registration fee, deposit, training fee or kit charge, and never your OTP or bank PIN. If anyone asks for money for this job, it is a scam.
How to spot a fake job · Check an offer free
Upload your CV once — we read it, build your profile and put you in front of every employer hiring on Kaam Ki Khoj. No forms, no fees.