Curriculum Vitae 

Key Skills and Experience 

·         Experienced Oracle 8i and 9i DBA for large Oracle systems and new installations

·         Oracle Application Server used to produce dynamic HTML/Javascript

·         Design and build of an XML interface using Java in the Oracle 9i Java VM

·         Designer 2000 modelling and generation of Oracle applications

·         System design to PRINCE 2 and ISO 9000 standards

·         Experienced Oracle development team leader

·         HPUX, AIX Unix, VMS, IBM 3090(VM & MVS) & OS/2, NT 4.0, Win2000, Linux

·         Developer 2000 including Forms 5.0, Reports 3.0 and PL/SQL packages

·         Developed Oracle interfaces to Java and Visual Basic (JDBC and ODBC)

·         Develop and maintain PostgreSQL and MySQL driven web sites that use Perl via a DBD/DBI interface on Sun Cobalt Raq servers 

Qualifications & Training 

·         Six "O" levels - King John School, Essex

·         Higher National Diploma, Mechanical Engineering, Bristol Polytechnic

·         OU masters degree (1st & 2nd year) computer architecture and operating systems

·         Several Oracle short courses on SQL*Forms, PL/SQL and Oracle CASE tools

·         Management training at British Aerospace 

Employment History 

Aug. 2002 to date         MySQL Web design ~ [snip]

 ·         Design, develop, host and support over 20 commercial web sites on two Sun Cobalt Raq Servers for a variety of local and national companies.  These include MySQL database driven sites using Perl and DBD/DBI methods.  My infrastructure includes a Linux Mandrake server as a backup machine for the two Raq servers which are located in London Docklands ‘Telecity’.  The machines currently serve over a Terabyte of data per year.

April 2002 – Aug. 2002           Oracle Development DBA ~ [snip]

·         Oracle 9i (Windows 2000) design and development DBA for a new version of Omiga plus that includes data synchronisation to IFA's laptops.  Using a Visual Basic front end and PL/SQL stored packages, the product provides point-of-sale information to IFA's laptops.

·         Develop reliable methods of copying XML data stored in LOB's between Oracle instances.

·         Translate "Select" (data modelling tool) logical models into physical data models that are Oracle compatible. 

Sept. 2001 – Jan. 2002            Oracle Development Specialist ~ British Telecom. plc 

·         Design and development of a personnel hierarchy directory using PL/SQL packages on Oracle 8i and the Apache Web server.

·         Design and development of an XML generic asset management system using Oracle 9i and Java stored procedures with Jakarta Tomcat add-in modules. 

Feb. 1999 – June 2001               Design / Development DBA ~ Newcourt Finance Ltd 

Design and development of a credit scoring engine accessible via two different applications:

a) Oracle Application Server using PL/SQL and Java packages and b) a VAX based legacy system via Java and Oracle Pipes.  The legacy system interface is achieved using CORBA compliant ORB’s that allow Java access to data in both directions.  An XML interface was designed and built using the Oracle Java VM to parse incoming XML data.  Working to extremely tight timescales, the European Credit Service was successfully implemented in multilingual versions.

·         Target platforms: Oracle 8.1.6 (Oracle 8i) on Windows NT and HP Unix

·         Designed using Erwin software tool for entity – relationship modelling 

Sept. 1997 – Jan. 1999               Design / Development Analyst ~ British Telecom. plc 

Design and development of a new financial Intranet solution using Oracle Web Server and PL/SQL packages to produce dynamic HTML pages which include Java Script functions.  The Database server is a 10 processor DEC Alpha machine running DEC Unix.  My role was to model the current accounting system using Designer 2000 and produce modular PL/SQL code and Java Script that performs well against a large (Terabytes) Data Warehouse.  Develop Perl scripts to manipulate input files via web interface.

·         Use Designer 2000 to model the table structures and modules required

·         Manage a Designer 2000 repository on a Windows NT Server using Enterprise Manager

·         Write PL/SQL packaged procedures and functions that produce dynamic HTML

·         Write Java Script procedures to validate user input and improve the Web user interface 

Jan. 1996 – Aug. 1997                   Systems Architect /DBA ~ Subscription Services Ltd

DBA and development team leader for a high availability 300+ user Oracle 7.2.2 telesales system running on an HP Unix machine.  My role was to transform business analysts application requirements into practical physical designs that perform well on the infrastructure available at this ISO 9000 approved site.

·         Customer facing support of business analysts at design reviews

·         Design and maintain tablespaces, users and data structures

·         Design, implement and test automated backup routines and install Unix UPS system

·         Set up Visual Basic applications accessing Oracle via ODBC and Oracle Objects

·         Write PL/SQL server side packaged procedures and functions called from VB applications

·         Give performance tuning advice to application developers to optimise SQL code

·         Use Designer 2000 to model then generate a Forms 4.5 project budget database

·         Set up an INTRANET Web server to access dynamic HTML pages from Oracle 7.3

·         Use replication snapshots to set-up a distributed database across a TCP/IP network employing SQL*Net links to Oracle 7.3 on a Windows NT server used as a data archive 

Sept. 1995 – Jan. 1996              Application Design/Build ~ National Power, Swindon

 Design of Gas spot market dealing database using Oracle 7.2 on a Unix AIX platform.

Oracle Menu 5.0/Forms 3.0 application accessed via Windows TCP/IP Telnet sessions. 

·         Bulk data handling routines using SQL*Loader and packaged functions / procedures

·         DBA and performance tuning tasks undertaken during application acceptance 

April 1995 – Jan. 1996                             Oracle DBA/Designer ~ NPI Pensions, Cardiff 

DBA and design of Oracle 7.0.16 client/server OS/2 database used to store telesales data for a new pension scheme.  Win OS/2 clients accessed via SQL*Net.  Tasks included: 

·         Design and implementation of database backup and disaster recovery strategies

·         Liaison between users and system administrators to optimise the configuration

·         Developed output reports using Oracle Reports 2.0 and Oracle Data Browser

·         Prepare and deliver training sessions to users and a trainee DBA

·         Design and implementation of interface from Oracle to Sedgwick Noble Lowndes for payment of pensions via the "BACS" system 

Aug. 1994 to March 1995                        Project Leader ~ SoundCheck Music, Taunton 

Designed and built an EPOS Electronic Point of Sale/stock control system for a music retailer. 

·         Designed using GUPTA SQLWindows and SQLBase. Look-up catalogue data in dBase 

Jan. 1993 to July 1994                            Lead Analyst ~ Property Services Agency(PSA) 

Systems analyst to Unicorn Consultancy Services Ltd., formerly Property Services Agency.

Database used to control budgets on multi-million pound commercial building projects. 

·         Oracle CASE methodology used to design this VAX VMS based system

·         Data analysis, design and build of an Oracle 6.0/Forms 3.0/SQL*Report(RPT) app. 

Dec. 1990 to Jan. 1993                                        Director ~ TecNet Software Services Ltd

Design and development of an engineering database for the European Space Agency 

·         Built up and lead the four man design team

·         Data structure and applications designed using Oracle CASE methodology

·         “Porting” of Forms to IBM 3090 mainframe environments running both MVS and VM

·         Design and integration of Microsoft 'C' based data collection and graphical display tools

Oct. 1988 to Dec. 1990                   System Analyst ~ European Space Agency, Holland

Systems analyst on the Columbus space programme Engineering Data Base (EDB).  Rapid application development techniques were used to design this Oracle 5.0, Forms 2.3 system. 

·         Design / build of system used to calculate spacecraft mass properties

·         Manage the workload of junior programmers who assisted in these tasks

·         Together with two other consultants, I prepared and presented to an audience of 25 trainees, a one week tutorial course on spacecraft systems and software assurance 

Sept. 1982 to Sept. 1988               PA Manager ~ British Aerospace Ltd, Filton, Bristol

Product Assurance Manager for the Space Platform Element of the Columbus programme. 

·         Project responsibility for hardware and software quality, safety and reliability

·         Introduced computer aided methods for control of non-conformance’s

·         Designed & built database applications using Rbase for control of spacecraft hazards

·         Deputy Product Assurance Manager for the deep space probe “Giotto”

·         Performed test surveillance, key point inspections for numerous items of flight hardware 

Sept. 1980 to Sept. 1982               Test Engineer ~ Martin Marietta, New Orleans, USA 

Test Engineer on the Space Shuttle External Tank project, prior to first flight. 

·         Commissioning of a microprocessor based test control system utilising a 6502 processor

·         Perform qualification testing of the Shuttle external tank to NASA procedures 

1973-1980                             Test Engineer ~ Rolls-Royce Ltd., Aircraft Engines, Bristol

 Structural Test Engineer performing static and cyclic testing of jet engine components.

·         Design, draw and arrange manufacture of test fixtures

·        Completed a Rolls-Royce apprenticeship that included 3 years block release to gain HND