SME - Oracle Exadata, Oracle DB (IN)
HCLTech
HCLTech
This role focuses on expert-level administration and support for Oracle Exadata and Oracle Database environments. The ideal candidate will possess extensive experience in managing complex Oracle technologies, ensuring optimal performance, and implementing robust solutions.
Key areas of responsibility include ensuring the smooth operation of Oracle RAC, ASM, Data Guard, and GoldenGate, alongside in-depth administration of Exadata Storage cells and compute nodes.
We are seeking a proactive individual with strong problem-solving skills and the ability to work effectively with global teams, contributing to the overall success of database operations.
Manage and administer Oracle Exadata environments, including Storage cells and compute nodes.
Oversee Exadata processes such as cellsrv, MS, and RS, utilizing utilities like cellci and dcli.
Handle startup and shutdown of Storage and compute nodes, along with Exadata component monitoring and alert resolution.
Execute Exadata image upgrades for database, cell, and Infiniband nodes, coordinating with hardware support for replacements and patching.
Install OEM agents and configure monitoring for Exadata database nodes.
Provide and implement performance tuning recommendations across all Exadata database machine components.
Generate reports like exacheck, sundiag, and OS Watcher to diagnose and resolve performance issues.
Manage resources using Exadata database features and handle mount point expansions.
Conduct proactive health checks of cell storage servers and switches, and manage day-to-day patching of Exadata cell nodes, responding to alerts.
Monitor the status of Physical disks using Cellcli commands and ensure efficient operation of cell nodes.
A minimum of 8 years of experience is required in database architecture design, administration, migration, integration design, and managing Oracle Data Guard, RAC, ASM, and GoldenGate.
Demonstrated experience in project implementation, transition, and transformation for Oracle Single Instance, Oracle RAC with ASM, and DR solutions is essential.
Familiarity with Oracle databases on AWS, Azure, or OCI is a significant advantage.
Proficiency in Oracle installation, configuration, and administration of ASM and Clusterware is necessary.
Experience with Very Large Database (VLDB) environments is crucial.
Strong SQL skills, including the ability to optimize complex queries for enhanced performance, are required.
Proficiency in Shell scripting is a must.
Extensive experience in database backup, restore, recovery, and Oracle DR build, configuration, and administration is needed.
Significant experience in installation, configuration, agent deployment, and setting up database monitoring alerts within Oracle OEM 12c/13c is expected.
Experience in creating installation scripts and procedures is beneficial.
Knowledge of Table partitioning, materialized views, and replication is required.
Extensive experience in analyzing and applying Oracle patches and performing database upgrades (e.g., 12c to 18c/19c) including ASM and RAC is critical.
Experience in database monitoring setup and integrating database alerts with ticketing tools, as well as database security enhancement, is required.
Excellent written and verbal communication skills are essential. The ability to prioritize, multitask, and collaborate effectively with onshore and offshore teams is desired.
A positive attitude, strong problem-solving skills, and self-initiative are mandatory qualities.
HCLTech
IT Consulting