Sr Subject Matter Expert (Support&Ops) (IN)
HCLTech
HCLTech
Join our dynamic team as a Senior Subject Matter Expert, focusing on Support and Operations. This role is crucial for ensuring the 24/7 availability and optimal performance of our database systems.
You will be instrumental in managing incidents, requests, problems, and changes, while also providing essential on-call support during off-hours and weekends. The position involves leading client and infrastructure projects, including planning and executing database patching, upgrades, and migrations.
This is an exciting opportunity to contribute to automating operational tasks, reducing ticket volumes through effective problem management, and maintaining robust disaster recovery capabilities. You'll also explore and implement new RDBMS features and emerging technologies, collaborating closely with application teams to resolve technical challenges and prevent outages.
Key responsibilities include owning 24x7 database support, encompassing incidents, requests, problems, and changes. Provide on-call database support during weekends and outside business hours.
Lead and deliver client and infrastructure projects, including planning and executing database patching, upgrades, and migration projects. Manage database tools and operational scripts effectively.
Perform primary DBA responsibilities for multiple applications, and automate recurring operational tasks to enhance efficiency. Reduce ticket volumes through structured problem management and manage disaster recovery tests and exercises.
Identify and deliver proofs of concept for new RDBMS features, open-source products, and emerging technologies. Work with application teams to provide solutions for technical requirements and problems, proactively identifying and mitigating risks to prevent incidents and application outages. Collaborate with infrastructure teams to optimize database performance.
Mandatory skills include hands-on experience with database standards and end-user applications, with specific administration experience in PostgreSQL versions 12 through 15. You should possess excellent knowledge of PostgreSQL RDBMS architecture and design, coupled with strong understanding of backup, recovery, Point-in-Time Recovery, replication, and performance tuning.
Proficiency with tools like pg_dump, pg_dumpall, WAL archiving, repmgr, pgBackRest, pg_repack, pgcrypto, pgaudit, Foreign Data Wrapper, and PgBouncer is essential. Experience with scripting and automation using Ansible and Shell is required. The ability to troubleshoot and resolve complex performance issues is critical.
Candidates must have experience managing patching, upgrades, and migrations, along with monitoring and performance analysis using open-source tools. Experience handling disaster-recovery tests, supporting large-scale environments (1,000+ databases), and expert knowledge of ITIL processes are vital. Strong communication, coordination, and crisis-management skills are necessary for collaborating with global teams and clients. Experience in automated operations and cloud infrastructure management is desirable.
HCLTech
IT Consulting