Minimum of 5+ years in supporting Oracle databases in Exadata machine and ODA(Oracle Database Appliance) environments.
Minimum of 5+ years experience in troubleshooting and supporting databases in Oracle Linux, Oracle RAC, and Oracle ASM configuration
Good understanding of ODA architecture and patching experience.
Good understanding of Oracle Exadata architecture and internal framework ; Must have worked on X3/X4/X5/X6/X7/X8 Exadata machines ( at least 2 models), Oracle 19c grid, Oracle 12.2/18/19c RAC databases, 13c cloud control.
Monitor Oracle DATABASE, Check alerts and take care of DATABASE issues (issue resolution) in Exadata
Have experience in Exadata and database monitoring using Oracle Enterprise Manager(OEM) - Agent installation, DATABASE discovery, Database alert configuration.
Setup various default and customized metrics in cloud control for Exadata
Should have good System admin, networking and storage knowledge.
Should be able to work with Oracle on all hardware issues and facilitate fixing the same.
Performance tuning as needed to ensure DATABASE is up and running healthy
Experience in Oracle RMAN backup automation using shell script, backup monitoring, backup tuning, and different types of RMAN Database recovery procedures
Database problem troubleshooting tasks ( using AWR report, ASH report, ADDM report, Various Oracle Advisory framework)
Experience in Oracle database Disaster Recovery(DR) setup and management using Oracle Data Guard and Oracle Golden Gate.
Well versed with different Oracle database migration methodologies including data pump export/import and cross platform migration etc.
Critical Database Migration on Production systems using DR setup/Pre-cutover/Cutover and EXPDP-IMPDP ; Database migration from ODA(Oracle database appliance) to Exadata and vice-versa.
Experience in database home installation, Database upgrade, patching, and regular maintenance of databases in Exadata
Experience in Exadata patching procedures like QFSDP
Provide on call rotation DATABASEA support, identifying and resolving DATABASE issues, problem troubleshooting, root cause analysis, opening ticket with oracle
Experience in various database refresh procedures - Database cloning and Data pump export/import
Good understating on database change management procedure including drafting change request, technical review, approval, and change implementation in change maintenance window
Additional Requirements:
Should be flexible to work in 24X7 shift operations
Capable of handling escalation independently
Oracle certified administrator - preferable.
Industry certification in at least one of the cloud technologies ( optional ).
ITIL processes - Incident Management, Change Management Problem Management.