Sr Subject Matter Expert (Support&Ops) (IN)

HCLTech

Fresher India Full Time Hybrid (office + remote)
HCLTech logo
Posted : today
Actively hiring

Job description

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.

Responsibilities

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.

Qualifications

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.

Essential Skills

PostgreSQLDatabase AdministrationShell ScriptingAnsibleDisaster RecoveryPerformance TuningITIL

Good to Have

AWS RDSPythonPerlBanking Domain

Highlights

  • Actively hiring

More Details

RoleSr Subject Matter Expert (Support&Ops) (IN)
DepartmentOperations
Employment TypeFull Time, Hybrid (office + remote)

About the Company

HCLTech logo

HCLTech

IT Consulting