Description

You will manage and maintain Oracle databases to ensure optimal performance and availability.

Monitor database health using Oracle Enterprise Manager and respond to incidents. Troubleshoot and resolve L2 level database issues, escalating to L3 when necessary. Perform root cause analysis for recurring issues and implement preventive measures. Execute and validate backups using RMAN and Data Pump. Analyse AWR/ASH reports and optimize SQL queries and database parameters.

Responsibilities

• Monitor database health and respond to incidents using Oracle Enterprise Manager.
• Troubleshoot L2 level database issues and escalate to L3 as needed.
• Perform root cause analysis for recurring issues and implement preventive measures.
• Execute and validate backups using RMAN and Data Pump.
• Analyse AWR/ASH reports to optimize SQL queries and database parameters.

Required Skills

• 7+ years of professional experience in database administration.
• Strong knowledge of Oracle Database architecture (11g, 12c, 19c).
• Proficiency in SQL, PL/SQL, and Unix/Linux shell scripting.
• Experience with RMAN, Data Pump, and Oracle Enterprise Manager.
• Familiarity with Grid Infrastructure RAC environments and ASM.
• Understanding of ITIL processes for incident, change, and problem management.
• Basic knowledge of automation tools including Shell, Python, and Ansible.

Key Skills

Education

Any Gradute