Oracle Management

Curriculum Vitae

Name Douglas Ian Burns Date of Birth 31/12/65

Address

Role Sought Oracle Consultant/DBA/Developer

st

Next Availability 1 March 2012

Telephone

Email *********@*****.*** Home Page http://oracledoug.com

Profile

? Experienced and passionate Oracle expert with over 20 years experience as a Development

and Production

DBA, Trainer and PL/SQL Developer with particular knowledge and interest in solving

complex performance

issues using his extensive knowledge of the full range of analysis tools.

? Skilled mentor and educator who enjoys sharing knowledge and collaborating with other

team members and

a mature and effective contributor to meetings and decision-making processes at all

levels. Enjoys using his

detailed knowledge of Oracle to ensure that development teams make the most effective use

of Oracle.

? Has developed and delivered Oracle courses for a number of training vendors including 6

years as a

freelance instructor for Learning Tree International and recently developed a two-day

Oracle 10g

Performance Analysis course for the Oracle EMEA Celebrity Seminar series and delivered

the course in

Oracle education centers in several European locations..

? Active member of the Oracle community who has written and presented papers at

conferences in Europe

and the US including Oracle Openworld, Hotsos Symposium and UKOUG. Presentations in the

past year

cover Statistics on Partitioned Objects, SQL Plan Management and Real-Time SQL

Monitoring.

? One of 33 world-wide Oracle ACE Directors in the Database Management & Performance

category. ACE

Directors are Key Opinion Leaders invited to attend Oracle Openworld by Oracle

Corporation including a

two-day technical briefing at Oracle HQ immediately prior to the conference.

http://tinyurl.com/63udxzp

? One of 80 members of the Oak Table Network an informal invitation-only group of some

of the world s

leading Oracle experts. http://oaktable.net

Career Resume

As a contractor since 1993, most positions have been Oracle DBA roles which have

consisted of standard DBA

activities, such as software installation; backup and recovery planning and

implementation; database sizing; user

account management; performance monitoring; schema management for development projects

etc. The specific

duties listed below are selective and often exclude some of these activities.

06/09PresentOracle Specialist UBS

Environment Oracle versions 10gR2 and 11gR2, Exadata V2, several multi-terabyte data

warehouse

systems, PL/SQL, OEM Grid Control

? Working in the Financial Control IT organization within this Tier 1 Investment Bank and

Wealth Management

organisation, I was involved in the ongoing development, support and trouble-shooting of

a handful of critical

multi-terabyte data warehouse and reporting systems.

? Key member of the Database Performance Team with responsibility for identifying,

analyzing and resolving

performance issues in critical Production systems and reviewing and helping others

develop efficient SQL at

all stages of the development life-cycle.

? Key member of Exadata V2 implementation team that conducted the initial proof-of-

concept exercise and

then implemented one of the first true Production implementations of two half-racks

supporting Finance

Balance Interface and Meridian/Neutral Data-store applications.

? Personally responsible for developing, managing and executing the implementation plan

to migrate FBI

from the existing Intel/Fusion IO platform to Exadata.

? Solved several show-stopping performance issues to ensure that we were able to migrate

to Exadata

within very tight timescales.

? Worked closely with senior Oracle Corporation staff in addressing ongoing issues

encountered as a

result of running complex high-throughput applications on a relatively immature platform.

? Member of team that upgraded Multi-terabyte General Global Ledger to Oracle 11.2,

identifying and

resolving a number of performance problems with changing SQL Execution Plans and

delivering a phased

introduction of new optimiser features and elimination of legacy parameter settings.

? Oracle Developer/DBA for Operational Cash Ladder project developing a forward-looking

liquidity solution for

use by Front-Office traders and internal Treasury department which entailed all

Development DBA activities

including initial schema design, partition and statistics management utilities developed

in PL/SQL, guiding

Java developers in the most efficient use of Oracle and assisting with any Oracle issues

encountered. This

project used Agile/Scrum methodologies extensively.

.

04/0706/09Oracle DBA Standard Life

Environment Oracle versions 8.1 10.2, AIX, Tivoli Storage Manager, Audit Vault 10.2.3,

Grid Control

10.2.0.4, Ab Initio, Quest Foglight

? Standard Life is a leading provider of investment, banking, life assurance and pensions

products. 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.

? Joint Technical Lead on Oracle Grid Control and Audit Vault implementation project.

? Lead role on Proof of Concept exercise to establish a suitable Oracle and hardware

configuration to load 2.7

billion rows into a new Data Warehouse within a limited batch window. This included

multiple performance

tests, system improvements and documenting recommendations.

? Owned and developed a detailed database creation process and related documentation to

improve the

quality of new Oracle system deployments.

? Refined a full production copy test environment refresh procedure for Investments

projects, reducing the

duration dramatically and improving reliability.

? Worked closely with Group Information Security on development of group-wide database

security standards.

01/0704/07Oracle DBA The Pythian Group

Environment Oracle versions 8.1 10.2, Solaris, Linux, AIX, RAC, ASM, Dataguard

? The Pythian Group (http://www.pythian.com) is North America s premier remote DBA

support services

organisation. I was a member of a team of three DBAs who supported a variety of customer

systems ranging

from Oracle 8.1 to 10.2, running on Linux, Solaris, AIX, Windows and OpenVMS.

? Helped implement a pair of 10.2 RAC/ASM/Grid Control clusters on Linux for performance

testing.

? Implemented standard monitoring scripts for a new client, making modifications

necessary for them to work

in a RAC environment.

09/05 12/06 Oracle DBA BSkyB (British Sky Broadcasting)

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

RMAN

? I worked across all areas of Sky s 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 Sky s dynamic working

environment.

? Helped to develop Sky s new Production Database Standards to include 10g new features.

? Tuned a number of significant batch jobs, reducing execution times from hours to

minutes.

? 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.

Contract Roles

04/0509/05Oracle DBA Scottish Water

10/0403/05Oracle DBA Sun Microsystems

04/0409/04Oracle DBA Kraft Foods Europe

01/0404/04Oracle DeveloperStandard Life

11/9707/04Instructor and Technical EditorLearning Tree International

04/0207/02Oracle Performance AnalystMars Inc

.

09/0111/01DBA Edinburgh University

04/0106/01Oracle ConsultantOrbital Software

04/0002/01DBA Deutsche Bank / Wood Mackenzie

01/0004/00DBA Scottish Equitable

08/9912/99Oracle ConsultantICL (Client - Romanian National Railways

)

03/99 - 06/99Senior DBA @Home Netherlands

04/98 - 01/99DBA / Technical Architect Vision Consulting

10/97 - 01/98Oracle DBA S.A.I.C

02/97 - 08/97Oracle DBA Syntegra

05/96 - 02/97Oracle DBA Barclays Stockbrokers

07/95 - 05/96Oracle DBA Barclays De Zoete Wedd

11/94 - 05/95Instructor Oracle UK

05/95 - 07/95Operations ManagerMFS Communications

06/94 - 05/95Oracle DBA MFS Communications

03/94 - 06/94Senior A/P Student Loans Company

01/94 - 03/94Oracle DBA London Borough of Hackney

01/93 - 12/93Oracle DBA / ConsultantSaudi Arabian Oil Company

Previous Permanent Roles

04/90 - 09/92Senior Analyst Programmer/DBA Lloyds Bowmaker

To reduce the length of this resume it only contains details of Oracle-related work.

Prior to working with Oracle, I

worked as a Z80 assembly language programmer (home computer games) and a Clipper/C

programmer (motor

finance). Details are available on request.

Education

Secondary School

Archbishop Holgate s Grammar School, Hull Road, YORK Y01 5HA (09/78 - 06/82)

7 GCE Ordinary Level Pass / 1 CSE Grade 1

Occupational Training

AIX System Administration, Unix Command Language and Shell Programming, Presentation

Skills Workshop, Oracle

8i PL/SQL Programming, Oracle8i DBA, Oracle 9i DBA, SQL Server 7 DBA

Occupational Qualifications

Chauncey Group Oracle DBA Certification Exam Pass 1997Oracle 9i Certified Professional DBA (OCP) Pass 2002

Contact this candidate