Sr Subject Matter Expert (Support&Ops) (IN)
HCLTech
HCLTech
Join our dynamic team as a Senior Subject Matter Expert in Support & Operations, focusing on database management. This role is crucial for ensuring the 24x7 availability and performance of our critical database systems.
We are looking for an experienced professional to manage and maintain our PostgreSQL environments, driving operational excellence and proactive issue resolution. You will be instrumental in delivering robust database solutions and supporting business continuity.
This position offers the opportunity to work with cutting-edge technologies and contribute significantly to a leading financial institution. If you possess deep expertise in database administration and a passion for innovation, we encourage you to apply.
Key responsibilities include providing round-the-clock database support for incidents, requests, and changes, along with on-call duties during off-hours and weekends. You will spearhead client and infrastructure projects, including planning and executing database patching, upgrades, and migrations.
This role also involves managing database tools and operational scripts, performing primary DBA functions for multiple applications, and automating recurring tasks to enhance efficiency. A significant part of the job will be reducing ticket volumes through effective problem management and conducting disaster recovery tests.
Furthermore, you will explore and implement new RDBMS features and emerging technologies. Collaboration with application and infrastructure teams is essential for providing technical solutions, optimizing performance, and proactively preventing incidents and outages.
We require hands-on experience with database standards and end-user applications, specifically with PostgreSQL administration across versions 12 through 15. A deep understanding of PostgreSQL RDBMS architecture, design, backup, recovery, Point-in-Time Recovery, replication, and performance tuning is essential.
Proficiency with tools such as pg_dump, pg_dumpall, WAL archiving, repmgr, pgBackRest, pg_repack, pgcrypto, pg_audit, Foreign Data Wrapper, and PgBouncer is expected. Strong knowledge of pg_hba.conf and postgresql.conf is also necessary. Scripting and automation using Ansible and Shell are mandatory.
Experience in troubleshooting complex performance issues, managing patching, upgrades, migrations, and utilizing open-source monitoring and performance analysis tools is required. Experience with AWS RDS for PostgreSQL and supporting large-scale environments (1,000+ databases) is highly desirable. Expertise in ITIL processes and excellent communication and crisis-management skills are also key.
HCLTech
IT Consulting