Subject Matter Expert (Support&Ops) (IN)
HCLTech
HCLTech
Join our Operations team as a Subject Matter Expert specializing in Oracle databases. This role focuses on ensuring the robust health and performance of our Oracle environments.
We are seeking an individual with a deep understanding of Oracle database installation, administration, and troubleshooting. Your expertise will be crucial in maintaining system stability and optimizing database operations.
This is an opportunity to leverage your specialized knowledge in a dynamic support environment, contributing to the reliability of critical database systems.
Key responsibilities include the installation of Oracle software and database prerequisites, alongside comprehensive Oracle database basic administration and managing the latest features.
You will be responsible for maintaining instance parameters and system settings, migrating databases using various tools like SQL*Loader, Import/Export, and Data Pump.
Additional duties involve applying and testing security patches, managing user accounts, cloning databases using cold/hot backups and RMAN, and performing capacity planning for database growth. You will also manage automated file and storage, implement database security policies, and ensure database availability and resource management.
Ideal candidates will possess a strong understanding of Oracle database administration, including installation, parameter maintenance, and system settings.
Experience with database migration tools, security patching, user account management, and various backup and cloning techniques (cold, hot, RMAN) is essential.
A solid grasp of Oracle 10g/11g features such as Data Pump, ASM, and Flashback Recovery, coupled with performance tuning and monitoring skills using tools like AWR and TKPROF, is required. Familiarity with availability management, resource management, and task scheduling for databases is also expected.
HCLTech
IT Consulting