Subject Matter Expert (Support&Ops)
India
Apply now
Job Description
Subject Matter Expert (Support&Ops)
Madurai, Tamil Nadu

Job Summary

 SME for Oracle Database

Key Responsibilities

? Excellent communication and conversation skills (Verbal and Written) ? Good working knowledge of MS OFFICE ? Evaluate the Database Server Hardware. ? Define/Recommend/Maintain database Standards and Architecture. ? Future Release management for database/instance and Impact Analysis. ? 3rd Party Vendor Support and Interaction (including TAR and OS) and can handle Client Independently ? Should be able to mentor L1 and L2 DBAs. Should be able to diagnose clustered environment. ? Advance Database Performance Tuning Tuning Applications, Instance/Kernel Parameters and Tuning Memory. ? Usage of AWR and ADDM, translate this and suggest the improvement based on this. ? Recommend and Review Backup and Recovery Strategies using RMAN or tools. ? Knowledge of Advanced Replication, Queuing and Streams. ? Good Working experience of Installation & administration of RAC(Real Application Clusters) 11g & 12c. ? Flash Recovery Features & Flash back query. ? Having experience of DR setup through various synch methods. ? Designing strategy towards Capacity Management (Growth) for DB tracks. ? Designing/Recommending Database Security Policy. ? Knowledge of Data warehousing and Other Technologies (RDBMS). ? Knowledge on AWS/Oracle/Azure/Gooogle Cloud Technologies. ? Experience on Sun / Veritas / Microsoft Cluster. Experience with Database Migration, Installation, Upgrades and Patching. ? OCP(Essential), OCE(Desired),ITIL(Essential)

Skill Requirements

 Excellent communication and conversation skills (Verbal and Written) ? Good working knowledge of MS OFFICE ? Evaluate the Database Server Hardware. ? Define/Recommend/Maintain database Standards and Architecture. ? Future Release management for database/instance and Impact Analysis. ? 3rd Party Vendor Support and Interaction (including TAR and OS) and can handle Client Independently ? Should be able to mentor L1 and L2 DBAs. Should be able to diagnose clustered environment. ? Advance Database Performance Tuning Tuning Applications, Instance/Kernel Parameters and Tuning Memory. ? Usage of AWR and ADDM, translate this and suggest the improvement based on this. ? Recommend and Review Backup and Recovery Strategies using RMAN or tools. ? Knowledge of Advanced Replication, Queuing and Streams. ? Good Working experience of Installation & administration of RAC(Real Application Clusters) 11g & 12c. ? Flash Recovery Features & Flash back query. ? Having experience of DR setup through various synch methods. ? Designing strategy towards Capacity Management (Growth) for DB tracks. ? Designing/Recommending Database Security Policy. ? Knowledge of Data warehousing and Other Technologies (RDBMS). ? Knowledge on AWS/Oracle/Azure/Gooogle Cloud Technologies. ? Experience on Sun / Veritas / Microsoft Cluster. Experience with Database Migration, Installation, Upgrades and Patching. ? OCP(Essential), OCE(Desired),ITIL(Essential)

Other Requirements

NA
Apply now
Information at a Glance

Why HCLTech?

At HCLTech, you'll supercharge your potential. You'll find your career. And you'll find your spark. All at a place that knows that helping its customers stay on top starts by putting its people first.

HCLTech is a global technology company, home to more than 223,000 people across 60 countries, delivering industry-leading capabilities centered around digital, engineering, cloud and AI, powered by a broad portfolio of technology services and products. We work with clients across all major verticals, providing industry solutions for Financial Services, Manufacturing, Life Sciences and Healthcare, Technology and Services, Telecom and Media, Retail and CPG, and Public Services. Consolidated revenues as of 12 months ending June 2026 totaled $14.8 billion.