ANI Oliver C. B.Eng. Elect/Elect Eng (OCA, OCP, CWNA – In View) Oracle DBA and Oracle Application DBA, with over 5 years experience in installation of oracle e-business suite 11i - 11.5.10.2, 11.5.10, 11.5.9, 11.5.8. (Oracle application DBA, Application Object Library (AOL), System administration, Workflow and Oracle Discoverer).

Specialities: -

Database installations, monitoring, capacity planning, performance and tuning, backup and recovery, user data security, writing SQL codes, Disaster Recovery, cloning and patches, Oracle Application, DBA.

Responsibilities: -

• Provide technical and functional support

• Configured, implemented, installed and administer 10GR2 RAC on 2-nodes on HP Itanium Clusters (CFS)

• Performing regular maintenance, performance tuning, backup and recovery, Disaster Recovery on two nodes RAC environment

• Shell Programming/Unix Scripting

• Oracle workflow implementations

• Implementation of Business Continuity Architecture (Data Guard) for Oracle Applications (11.5.10.2)

• Grid Control and Oracle Enterprise Manager

• Portal 10g and Discoverer 10g

• Universal Content Management and Oracle Beehive

Accomplishments: -

• Install and Maintain over Five Oracle databases 10gR2 and eBusiness Suite Applications Release 10.5.10.2 on HP-UX

• Disaster Recovery Implementation ( Maximum Availability Architecture – MAA)

• Maintain and administer several oracle databases ( Production 2-nodes RAC, Test 2-nodes RAC, UAT, Application server 10g etc)

• Performed several database upgrades from Oracle 9i database to Oracle 10gR2. (10.2.0.4)

• Upgrade Oracle Applications eBusiness Suite from 11.5.10.2 to Release 12

• Provided technical support to functional consultants and developers on bug fixes and deployment of solution from development through UAT to Production.

• Proactively measure performance of systems and fine-tune to ensure optimization of performance by extracting traces on long running queries and running oracle utilities (such as tkprof, ADDM, AWR etc) to explain execution paths.

• Performed several clones from RAC to RAC and RAC to single nodes.

• Using Shell programming and Unix Scripting to automate some DBA and Application processes

• Planned and performed weekend maintenance for hardware and software.

• Provided standby service by mobile phones, blackberry to support the users off office hours and weekends