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