SME - Oracle Exadata, Oracle DB (IN)
HCLTech
HCLTech
Seeking a highly skilled Oracle DBA L3 with extensive experience in Oracle Exadata and Oracle Database administration. This role demands a proactive approach to resolving issues, mitigating risks, and driving projects to successful completion. Excellent communication and documentation abilities are essential for effectively collaborating and presenting findings.
Candidates should possess a strong analytical and problem-solving mindset, with a proven track record of working with production systems. Familiarity with Solaris, Linux, and Veritas Cluster is expected, alongside a good understanding of scripting. The ability to identify and implement automation opportunities for service improvement is key.
This position involves participation in a 24x7 environment, including rotational shifts and on-call duties, requiring adaptability and a commitment to continuous service improvement. The role is designed for an experienced professional ready to take ownership of critical incidents and drive effective communication during high-severity events.
Administer and maintain Oracle 18c/19c databases, ensuring high availability and performance. Implement and manage database migrations, installations, upgrades, and patching cycles. Conduct in-depth performance analysis and tuning using tools like AWR and ADDM. Plan and execute backup and recovery strategies utilizing RMAN. Configure and manage Oracle Data Guard and RAC environments, including troubleshooting complex issues.
Drive critical incident management, performing root cause analysis for both proactive and reactive tickets. Identify and implement automation initiatives to enhance service efficiency. Monitor overall system functioning and pinpoint areas for improvement. Actively participate in service improvement plans and contribute to the development of short and long-term strategic plans for database operations.
Provide support for on-call duties as required and ensure effective communication over calls during critical situations. Manage storage, kernel parameters, and initialization parameters. Implement and administer database blackouts and utilize flashback features for recovery. Ensure effective management of alerts and notifications. Manage cross-platform transportable tablespaces and contribute to data warehousing knowledge.
Minimum of 7 years of relevant experience in Oracle 18c/19c database administration. Must possess strong analytical and problem-solving skills, with extensive experience on production systems. Expertise in database migration, installation, upgrades, and patching is mandatory.
Proficiency in performance analysis and tuning, including the use of AWR and ADDM. Experience with RMAN for backup and recovery strategies is essential. In-depth knowledge of Oracle Data Guard and RAC, including implementation, configuration, administration, and troubleshooting, is required. Familiarity with Solaris, Linux, and Veritas Cluster is necessary.
Good scripting knowledge and experience with utilities like Data Pump, Export/Import are expected. Understanding of storage management techniques and Oracle kernel parameter tuning is important. Experience with Oracle Exadata, GoldenGate, or OEM is a significant advantage. Certification in Oracle database administration (18c/19c) is preferred. Willingness to work in a 24x7 rotational shift environment and participate in on-call rotations.
HCLTech
IT Consulting