Must have skills:

Oracle Database Architecture

Oracle dataguard

Database patching

Oracle backup and recovery

L2 deliverables:

· Incident monitoring.

· DR sync issue 2nd level resolution.

· Backup and restoration in supported assets- scheduled or Adhoc.

· Performing export and import activities - scheduled or Adhoc.

· Handling issues related to performance.

· Database security patch application.

· Database housekeeping activity (purging, index rebuilding, reorganization, gathering statistics).

· Log calls with vendor for product bugs.

· Provide timely escalation of complex problems to a technical support resource and/or to the appropriate level

of senior staff

· Perform DR, backup restoration drill.

· Cloning database for supported assets.

· Database job creation and configuration.

· DB - Instance Hung/Terminated unexpectedly

· DB - Crash

· DR reconfiguration for existing setup.

· DB - Flashback configuration and restoration

· Performance - ORA errors - resolve or escalate to L3 or vendor appropriately.

· ASM monitoring and space addition.

· Starting and stopping database, ASM, RAC services.

· Necessary support for restoration or drill

· Preparation of MIR for Major Incidents

· RAC Installations - grid & oracle home installation

· Hardening of the database along with documentation

· Review of daily/weekly/monthly checklist

· Repeat Incident / Alert Analysis

· Reinstallations raise due to incidents

· Incident / Request Fulfillment / Change management

· DF installation.

· Database integration.

· Daily reports review.

· Troubleshooting.

· Application profiling.

· Patch management.

· Failover testing.

· Periodic HA review and testing.

· Closure of audit requirement.

· Vendor co-ordination.

· Compliance as per policy.

· System book creation and periodic review.