Charles - DBA ORACLE

10/09 – Present Oracle DBA TOTAL RM UK “C”

Environment Oracle versions 8.1 – 10.2, AIX, Tivoli Storage Manager, Audit Vault 10.2.3, Ab Initio, Quest Foglight

• TOTAL is the UK's fourth largest oil company, employing around 7000 people at offices and service stations across England and Wales. I was a member of the Production DBA team who supported a variety of business systems ranging from Oracle 8.1 to 10.2, running on AIX.
• Using a combination of Statspack and wait event tracing against overnight batch processes to identify performance problems.
• Creation of Project QA and development environments, using both cloning and edited DDL scripts to generate smaller versions of the production environment.
• Evaluation of faults in existing physical design and documentation of proposals to improve the system.
• Development of PL/SQL, SQL and Shell scripts for schema comparison across multiple development and testing environments.
• Refined a full production copy test environment refresh procedure, reducing the duration dramatically and improving reliability.
• Worked closely with Group Information Security on development of group-wide database security standards.


06/07 – 09/09 Oracle DBA LHS Group (Part of the Ericsson Group) – Germany “P”

Environment Oracle versions 8.1 – 10.2, Solaris, Veritas Quick I/O, Netbackup, RMAN

• I worked across all areas of the company business systems, including the Data Warehouse and the new CRM project, as part of a large team of DBAs supporting several hundred production, development and test databases. This included on-call production support and shift work to support LHS Group dynamic working environment.

• Helped to develop LHS Group new Production Database Standards to include 10g new features.
• Implemented procedures to manage historic optimiser statistics to help diagnose problems with changing execution plans.
• Tuned a number of significant batch jobs, reducing execution times from hours to minutes.
• Primary DBA support contact for new Scheduling and Bookings Enhancements project using Click Software Service Optimisation Suite. This included all test, development and production implementation activity.
• Significant server consolidation activity in co-operation with the Unix Sys Admin team
• Training and coaching of existing permanent DBAs moving from Adabas to Oracle support roles.

02/05 – 06/07 Oracle DBA IBM Frankfurt – Germany “P”

Environment Oracle versions 8.0 – 9.2, Solaris, PeopleSoft, LIMS, Netbackup, Rman, OEM

• I worked in the IT development technical team, supporting 70-80 development and test databases used by the development teams to implement a variety of off-the-shelf applications, particularly Peoplesoft Financials modules and LIMS. This included project work relating to new releases and ongoing support work, including environment refreshes, fault resolution and general Oracle consulting.

• Significant DBA support for upgrade of Peoplesoft to version 8.45
• Migration of DB2 to Oracle
• Production of overall system review document including recommendations to improve existing system architecture and support model
• Filesystem reconfiguration and database file moves to implement OFA-compliant configuration
• Planning for upgrade of Sun E10K development and test server to E25K
• Development of a procedure to refresh the database from mainframe extract files (Pro*C)
• Primary Unix Administrator and Oracle DBA