Subject Matter Expert (Support&Ops) (IN)
HCLTech
HCLTech
Seeking a Subject Matter Expert (SME) with deep expertise in Oracle Database administration and support operations. This role involves managing and optimizing database environments, providing technical leadership, and ensuring high availability and performance.
The ideal candidate will leverage extensive knowledge of Oracle Database features and best practices to drive operational excellence. You will be instrumental in defining standards, managing releases, and resolving complex database issues.
Key responsibilities include evaluating database server hardware, defining and maintaining database standards and architecture, and managing future release impacts. You will also handle third-party vendor interactions, mentor junior DBAs, and diagnose clustered environments. Significant focus will be placed on advanced database performance tuning, analyzing AWR/ADDM reports, and recommending improvements.
Further duties involve reviewing backup and recovery strategies, managing replication and queuing technologies, and administering RAC environments. The role also encompasses designing capacity management strategies, recommending database security policies, and contributing to data warehousing initiatives. Experience with cloud platforms like AWS, Azure, and Google Cloud is essential.
Essential qualifications include excellent verbal and written communication skills, and proficiency in MS Office. A strong understanding of database server hardware, standards, and architecture is required. The role demands expertise in release management, impact analysis, and independent client interaction. Mentoring capabilities for L1 and L2 DBAs are crucial.
Advanced skills in performance tuning, AWR/ADDM analysis, and backup/recovery strategies using RMAN are mandatory. Knowledge of advanced replication, queuing, streams, RAC installation and administration (11g & 12c), flash recovery features, and DR setup is expected. Experience with capacity management, security policies, data warehousing, and cloud technologies (AWS, Azure, Google Cloud) is vital.
Experience with Sun, Veritas, or Microsoft Cluster is required, alongside proficiency in database migration, installation, upgrades, and patching. Essential certifications include OCP and ITIL, with OCE being desired.
HCLTech
IT Consulting