Oracle Database Administrator

Must have skills:

Oracle Database Architecture

Oracle dataguard

Database patching

Oracle backup and recovery

· Create, Update and maintain Knowledge base.

· Check and implement best practices.

· Cloning database for supported assets.

· Planning and updating Backup and restoration policies for exiting assets.

· Capacity planning related to database.

· RAC related issue resolution.

· DB – Crash / Rebuild due to Incident

· DB - Instance Hung/Terminated unexpectedly

· DR reconfiguration for existing setup.

· Database security patch application.

· Database impact analysis in case of major activities.

· DB - Flashback configuration and restoration

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

· Providing root cause analysis.

· Starting and stopping database, ASM, RAC services.

· Perform DR, backup restoration drill.

· Preparation of RCA for Major Incidents

· Repeat Incident / Alert Analysis

· Performance tuning suggest by OEM

· Updation and maintenance of Availability, Capacity management

· Risk Analysis and providing the mitigation planning

· Continual Service Improvement Planning and executions

· Planning and execution of DR Drills based on availability of DR setup and recovery procedures

· Preparing, maintaining and updation of SOP and KBase

· Maintaining and updation of Infra AS IS / Infra Documents

· Incident / Problem / Change management

· Reinstallation and configuration of server raised due to Incident

· Applying new policy.

· Configuring new policy.

· Analysis of blocked rules.

· Blocking IP’s.

· Create custom policy.

· Firmware upgrade.

· Version upgrade for DAM Oracle.

· DR build and drill as per schedule.

· Capacity planning.

· Incident/Problem management.

· Change management and execution.

· RCA submission.

· Adherence to ISMS policy.