Oracle Database Administrator (Staffing)

Responsibilities

• Database Operations & Support
• Act as Oracle DBA for CIM and related manufacturing systems.
• Ensure effective BAU support activities in line with internal customer needs and SLAs.
• Perform database monitoring, session management, lock analysis, long‑running query handling and hung session resolution.
• Manage L1 and L2 DBA tasks, including incident handling, root cause analysis and preventive actions.
• Perform backup and recovery using RMAN, including database cloning (e.g. duplicate database).
• Use Oracle utilities and features such as expdp/impdp, partitioning, advanced compression, LOB management and concurrent statistics.
• Conduct performance tuning using SQL Plan Management (SPM), hints and SQL Tuning Advisor.
• Analyse AWR/ASH/ADDM reports and implement tuning recommendations.
• Troubleshoot database issues such as TNS/network connectivity, tablespace/FRA utili...