Sr Subject Matter Expert (Support&Ops) (IN)
HCLTech
HCLTech
Join our dynamic team as a Senior Subject Matter Expert in Support & Operations. This role focuses on ensuring the stability and performance of our database infrastructure, providing comprehensive support, and driving key projects.
We are seeking a proactive individual to manage 24x7 database operations, including incident resolution, request fulfillment, and change management. The position involves on-call duties to ensure continuous service availability. You will play a crucial role in delivering client and infrastructure projects, planning and executing database patching, upgrades, and migrations.
Your responsibilities will extend to managing database tools, operational scripts, and performing primary DBA duties for various applications. A key aspect of this role is automating recurring tasks to enhance efficiency and reduce ticket volumes through structured problem management. You'll also be responsible for managing disaster recovery tests and identifying opportunities for innovation with new RDBMS features and emerging technologies.
Collaboration is essential as you'll work closely with application and infrastructure teams to provide solutions, resolve technical issues, optimize performance, and prevent incidents. Demonstrating strong crisis-management skills and a proactive approach to risk mitigation will be vital for success in this challenging yet rewarding position.
- Ensure 24x7 database support, handling incidents, requests, problems, and changes. - Provide on-call database support during weekends and outside business hours. - Own and deliver client and infrastructure projects, including database patching, upgrades, and migrations. - Manage database tools, operational scripts, and perform primary DBA responsibilities. - Automate recurring operational tasks and reduce ticket volumes through problem management. - Conduct disaster recovery tests and identify opportunities for innovation. - Collaborate with application and infrastructure teams to resolve issues and optimize performance. - Proactively identify risks and implement solutions to prevent outages.
- Proven hands-on experience with database standards and end-user applications. - Expertise in PostgreSQL 12, 13, 14, and 15 administration. - Deep understanding of PostgreSQL RDBMS architecture, design, backup, recovery, Point-in-Time Recovery, replication, and performance tuning. - Proficiency with tools such as pg_dump, pg_dumpall, WAL archiving, repmgr, pgBackRest, pg_repack, pgcrypto, pgaudit, Foreign Data Wrapper, and PgBouncer. - Strong grasp of pg_hba.conf and postgresql.conf configurations. - Experience with scripting and automation using Ansible and Shell. - Ability to troubleshoot complex performance problems and manage patching, upgrades, and migrations. - Experience with monitoring and performance analysis using open-source tools. - Experience managing disaster-recovery tests and exercises. - Certification or hands-on experience with Amazon RDS for PostgreSQL on AWS. - Experience supporting large-scale environments with numerous databases. - Expert knowledge of ITIL processes (Incident, Problem, Change Management). - Excellent coordination, communication, and interpersonal skills for global collaboration. - Demonstrable crisis-management skills in a distributed environment. - Experience in automated operations and managing core/cloud infrastructure.
HCLTech
IT Consulting