Skip to content
Search jobs inside your AI agent. Claude, ChatGPT, Claude Code, Codex, Gemini, Cursor and Grok
Connect

careers.hcltech.com

NewBe an early applicant

Subject Matter Expert (Support&Ops)

Posted Updated

Description

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

Skills

Apply

See also

Support jobs by country — openings, pay and top skills →