Subject Matter Expert (Support&Ops)

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