Sr Subject Matter Expert (Support&Ops) (IN)
HCLTech
HCLTech
This role focuses on advanced administration, performance enhancement, ensuring high availability, security, and operational support for PostgreSQL databases critical to business applications. You will act as the primary technical escalation point for PostgreSQL-related issues, guaranteeing database reliability, scalability, disaster recovery preparedness, and ongoing service improvements.
Key responsibilities include comprehensive PostgreSQL administration, from installation and configuration to upgrades and maintenance across production, non-production, and DR environments. You'll manage provisioning, schema management, and environment setup, ensuring database integrity and optimal performance.
Expect to dive deep into performance tuning by analyzing slow queries, optimizing SQL, and configuring PostgreSQL parameters for peak CPU, memory, and storage utilization. This involves fine-tuning indexes, partitions, vacuum processes, and query execution plans, alongside regular health checks and performance assessments.
Key duties involve maintaining high availability through advanced replication configurations, including Streaming, Logical, and Synchronous Replication. You will manage automatic failover solutions like Patroni, PgPool-II, RepMgr, and Pacemaker to ensure minimal downtime.
Backup and recovery are crucial, requiring the design and implementation of robust strategies using tools such as pgBackRest, Barman, and native PostgreSQL utilities, alongside regular recovery testing and DR drills to meet RPO/RTO objectives.
As an L3 support specialist, you'll handle complex PostgreSQL incidents, perform Root Cause Analysis for critical issues, and resolve challenges like replication failures, corruption, locking conflicts, and deadlocks, actively participating in Major Incident Management processes.
Security is paramount, encompassing the implementation of database controls, user/role management, SSL/TLS encryption, vulnerability remediation, and ensuring compliance with organizational and regulatory standards through audits and access reviews.
Monitoring and capacity planning involve tracking database availability, query performance, replication status, resource utilization, and connection usage. You'll develop dashboards, alerts, and forecast growth to ensure scalability.
Support extends to cloud database environments on AWS (RDS, Aurora), Azure, and Google Cloud, covering provisioning, optimization, security, backup/recovery, and cost management.
Automation and DevOps integration are key, involving the development of operational scripts using Python, Shell, or PowerShell, supporting CI/CD pipelines, and implementing Infrastructure as Code (IaC) with tools like Terraform and Ansible.
Finally, you will be responsible for creating and maintaining comprehensive documentation, including SOPs, runbooks, recovery procedures, and architecture diagrams, while also facilitating knowledge transfer to L1/L2 support teams.
The core technical expertise lies in advanced PostgreSQL versions (12/13/14/15/16+). You should be proficient in various replication technologies (Logical, Streaming, WAL Management) and database optimization techniques like partitioning, query optimization, and performance tuning.
Experience with High Availability (HA) and Clustering tools such as Patroni, PgPool-II, RepMgr, Pacemaker, and Keepalived is essential. Proficiency in backup technologies including pgBackRest, Barman, WAL Archiving, and Point-in-Time Recovery (PITR) is also required.
A strong foundation in operating systems, specifically Linux and Unix platforms, is necessary. Familiarity with monitoring tools like Prometheus, Grafana, Zabbix, Datadog, Splunk, and Nagios is expected.
Furthermore, expertise in automation and DevOps practices using Python, Shell Scripting, Terraform, Ansible, Jenkins, and Git is crucial. Experience supporting PostgreSQL environments on major cloud platforms (AWS, Azure, Google Cloud) and container platforms (Docker, Kubernetes, OpenShift) is highly desirable.
HCLTech
IT Consulting