Find your next job. Start today.

From the employer's own careers site

Sr Subject Matter Expert (Support&Ops)

Date Posted: Nov 07, 2026
Apply on company website
Sign in to keep track of your applications.
Get jobs like this sent to you
Your own AI Job Agent checks every new job against your CV and sends only the ones that fit, on WhatsApp. ₹199 a month, GST included. Full refund if it does nothing.
Start my Job Agent on WhatsApp

Job Detail

  • location_on
    Location Noida, Uttar Pradesh, India
  • desktop_windows
    Job Type: Full Time/Permanent
  • schedule
    Shift:
  • analytics
    Career Level:
  • group
    Positions:
  • calendar_view_day
    Experience:
  • male
    Gender: No Preference
  • school
    Degree:
  • calendar_month
    Apply Before: Dec 31, 2026

Job Description

Job Summary

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.

Key Responsibilities

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 

Skill Requirements

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.

Other Requirements

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.

See how well you match this job

Make a free profile in a minute — no CV needed — and we score every job against it.

Make my profile

Already registered? Sign in

Company Overview

HCLTech
HCLTech · Noida, Uttar Pradesh, India
12,152 open roles

HCLTech is an employer in the IT/Computers - Software, Software Services sector with operations in India. This is a directory listing maintained by Kaam Ki Khoj so that candidates can find the organisation; it is not an official company page and Kaam... Read More

Apply safely

From 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

Report this job

Related Jobs

One upload, every employer

Let the right employer find you

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.

Upload your CV Browse jobs