SKILLS SUMMARY

Management

**+ years Managed teams of up from 2 to 30 staff at levels from team leader to Project Management.

Environment

4+years Managed environments on a variety of Unix and windows hardware.

Systems Design

25+ years Relational Database Design/Database Architect, OLRT Banking Systems, Personnel, Payroll, Pensions, Manpower Planning, Nominal, Sales and Purchase Ledgers, Stock Control, Stock Accounting, Fleet Management, Network Design (Point to Point and Multi-drop), Data Transmission, Portfolio Management

Database Design 13+ years Logical and Physical Database Design using Erwin, Excelerator, Oracle CASE, Designer. Database design for Oracle, Ingres, RDB and CA-DB

Oracle

Versions 3 to 10G

20+ years Database administration, performance tuning and database sizing, Design of Oracle Express Data Warehouse system. Training of Technical Staff and Users. Software installation under Open VMS, UNIX Windows NT and 2000. Experience of versions 3 through to 10G including Parallel Query/Server on systems above. Tools used include SQL*PLUS, Export, Import, Enterprise Manager, DataPump, OEM

CA-DB

3+ years Database Administration, Performance and Tuning. Logical and Physical Database Design with CASE tools. Training of Technical Staff and Users. Product Assurance and Technical Support (Pre and Post Sales). Consultancy and Seminars. Programming (CA-Generator).

Ingres

2 years Database Administration, Performance and Tuning. Logical and Physical Database Design. Software installation under VMS and UNIX. Technical Support (Pre and Post Sales)

Other Tools Siebel – 18 months, ATG – 18 months, Crossworlds– 18 months, Clearcase – 6 months, Sourcesafe – 6 months

Case

10 years Case design using Erwin, Excelerator, System Designor, Oracle Case, Oracle Designer and Developer and Sybase Power Designer

RDB

6 months Database Administration, Performance and Tuning. Logical and Physical Database Design. Programming using CA-Generator

CA-Generator

3+ years Training of Technical Staff and Users. Product Assurance and Technical Support (Pre and Post Sales). Consultancy and Seminars.

Systems Management

6 years DEC VAX, ALPHA, IBM RS6000, ICL System 4, ICL

Operating Systems DRS6000, ICL System 4 - 4 years. VMS - 12 years. UNIX (HP-UX, Sun Solaris, Ultrix, IBM AIX and Sequent) 10 years, Windows various flavours 15 years

Hardware DEC - VAX, ALPHA, PDP/11. IBM - 360/370 series, RS6000. ICL - System 4, DRS6000, DRS3000, HP Unix, Sun Solaris

CAREER SUMMARY

Independent Consultant Consultant May 1996 to Present

Consultant / DBA for clients using Oracle.

• Jaguar Land Rover - Oracle DBA on migration of systems from Ford – Feb 2010 to July 2010

• Itrain – Consultant/Trainer for Oracle and Siebel - Oct 2009 to Jan 2010

• Career break – Took some time off to spend with grandchildren. - Oct 2008 to Oct 2009

• Strathclyde Fire and Rescue – Design DBA on Cedar Financials system using Windows 2003 Oracle 10g system using RAC. ERWin used for design of both systems. Business Objects used for reporting for Warehouse and Financials. - July2008 to Sept 2008

• Premier Farnell – Development and Production DBA on Sun Solaris/Linux using Oracle 9i and 10g. Cloning databases from UK to USA. OEM, SQL Developer - Mar 2008 to Apr 2008

• Cambridge University Press – Production DBA on Sun Solaris using Oracle 10g systems with Oracle Enterprise Manager (OEM), RMAN, Grid, Real Application Clusters (RAC), DataPump, SQL Developer. Day to day system maintenance and rebuilding RMAN and Dataguard copies - Dec2007 to Feb2008

• Department of Works and Pensions – Designer/Architect on payments project for DWP/Siemens using ERWin. Conversion to ERWin from Rational Rose and then to Oracle Designer for Logical Data Model. The system used Oracle 10.2 and Applications 12.0 on E25K running Solaris 10/11. Producing logical design for payments system interfacing to Oracle Accounts Payable. OEM used for monitoring. - Jan 2007 to Sept 2007

• Play.com – Production DBA on Oracle 10.1 and 10.2 systems on Linux and AIX using OEM, RAC, Sourcesafe, SQL Developer and RMAN. Day to day system maintenance, performance tuning and table and index resizing. - Oct 2006 to Dec 2006

• National Australia Group – Design/Development DBA – Designing and building Data Warehouse Databases on Oracle 9i using OEM, RAC on Sun Solaris, Erwin, SQL Developer, Toad, Sourcesafe and ClearCase. Extracting and cleansing data from live banking systems for use in the warehouse. Day to day system maintenance. - June 2006 to Sept 2006

• Northgate IS - Environment Manager/Development Oracle DBA - Responsible for all Unix/Oracle environments on 10 AIX 5L machines running Oracle 9.2 with OEM, Cordaptix, Tuxedo and Weblogic. System Manager and DBA reporting to me. June 2005 to Feb 2006

• Homeserve – Production Oracle DBA providing cover for holidays – DBA/systems administrator on warranty/insurance systems Oracle 10G running under SUSE Linux. OEM, RAC. – May to June 2005

• Argos PLC – Consultant. Technical support on PKMS warehouse project using Oracle 9I on AIX. Feb 2005 to May 2005

• Mobile Cohesion – Development Oracle DBA. Migration of database from Ingres, design and build using Oracle 10g with RAC on Solaris 9 – Jan 2005

• Netonomy – Development Oracle DBA. Tuning Data Warehouse application and providing skills transfer to existing staff. Updating Oracle. – Dec 2004

• ATOS Origin – Senior Production support DBA on Sun Solaris, HP-UX, AIX, Red Hat Linux, NT, and VMS for Oracle versions 7.3.2 through to 10g. OEM and RAC – May 2004 to Oct 2004

• Rescon Ltd (Irish Department of Justice) – Senior Production DBA/Environment Manager. Oracle DBA/Unix Administrator for prisoner management on IBM RS6000 running AIX 4.3.3, AIX 5L and Windows 2000 for Irish Prison Service. System management using SMIT. Installation and upgrade of Oracle versions from 8.0.5 through to 9.2 on over 30 databases. Upgrading 10 databases from 8.1.7.4 to 9.2. Database control using OEM. Tools used include Erwin, Discoverer and third party software supplied by Anubex, Fujitsu, IMS and Softworks, Business Objects. May 2003 to Mar 2004

• TreeFrog Software – Consultant. Tuning Waste and Loss Oracle Windows NT database. Upgrading to 8.1.7.2. Training client staff in basic SQL. – Feb 2003

• BAE Systems – Consultant. Designed and set up backup and recovery strategy for 2 Security cleared Oracle Parallel Server systems, one on Sun Solaris and one on Windows 2000. – Jan 2003

• Unisys (at Norwich Union now Aviva) - Senior Development and Production DBA/Architect - Duties include: - Database administration on Oracle 8.0.6 and 8.1.6 on development and production systems using Parallel Server, Crossworlds, ATG and Siebel on Sun E10Ks using Solaris 2.6 for a web based Wealth Management system, maintenance of Logical and Physical data model using Erwin, set-up and maintenance of Oracle databases including warehouse, performance tuning, sizing. Data loading into Siebel database. Tools used include Toad, Foglight - Mar 2001 to Sept 2002

• Rubus (was Nvision) – Development DBA/Architect on Oracle on Oracle 8.0.5 and 8.1.6 web based databases on Sun Solaris 2.6 and Windows NT. Responsible for software installation, maintenance of Physical data model using Sybase Power Designer, maintenance of all personnel Oracle databases using Parallel Query/Server and establishment of hot standby. – July 2000 to Jan 2001

• Royal London Insurance – Production DBA/Environment Manager on Oracle 8.1.5 insurance and personnel decision support databases under Sequent Dynix and Microsoft NT. Responsible for all aspects of support and training of RLI staff on Oracle. Liaison with suppliers and Royal London staff. – Nov 1999 to May 2000

• Unisys (Insurance Practice) – Development DBA on Oracle 8.1.5 running under Sequent Dynix. Responsible for performance tuning and benchmarking. Capacity planning on Sequent Dynix. Database sizes vary from 3 Gigabytes to 50 Gigabytes and used Parallel Query/Server and Partitioning of large tables and indexes. Knowledge transfer. – April 1999 to Oct 1999

• SmithKline Beecham – Production DBA for over 40 Oracle databases under VMS, Open VMS and flavours of UNIX. The databases include development and production with replication and 7 x 24 hour operation. Databases in the UK and US. – Nov 1998 to April 1999

• NCR EMEA – Production DBA for Oracle 7.3.3 databases on NCR UNIX equipment. Responsible for the maintenance and support of databases for use within NCR EMEA Customer Care Link System and Oracle Payroll/Human Resources databases. Support for other databases including Oracle financials and payroll provided on an ad-hoc basis. – May 1998 to Nov 1998

• CSK Software – Development DBA for Oracle 7.3.3 databases on SUN Solaris systems. Responsible for the setup of Pacemaker financial system, maintenance of development systems and support for extended trials on customer site. Maintenance of data model and database documentation using System Designor. – Feb 1998 to May 1998

• Marks and Spencer – Production DBA for IBM RS6000 system under AIX and Windows NT. Responsible for the day-to-day running of an operational system handling Contract management. Capacity planning. Rationalisation of hardware from 1 pair to 2 pairs of RS6000s using HACMP. Responsibilities include the day-to-day running of 6-linked production databases with Gateways to DB2, a training database and 6 testing databases. – May 1996 to Jan 1998

Vista Ltd Database Development Manager May 1995 to May 1996

Responsible for the design of an Oracle Database with which Vista could migrate their current 4GL based systems onto Oracle. Using Oracle Designer/2000 built a logical and physical database using Oracle V7 on DEC Alpha under Open VMS which could be used for migration. Produced pilot applications using Developer/2000 to evaluate whether to use Oracle tools rather than Vista 4GL. Established a demonstration database with applications using Personal Oracle 7, which could be used both in the UK and in USA by non-Oracle staff. Liaison with suppliers and customers. Designed an Oracle Express data warehousing demonstration system and a similar system using Developer/2000

Productcopy Ltd Consultant March 1992 to May 1995

Consultant / Database Administrator on projects for clients using Oracle including: -

• SCT - Senior DBA implementing billing system for British Gas Service using Oracle V7 on Sun Solaris under UNIX and Amdahl Mainframe using MVS. – 14 months

* Union Railways - Team Leader, Database Designer, Database Administrator, Environment Manager on DEC VAX under Open VMS on GIS system for the Channel Tunnel Rail Link using Oracle V7 with Oracle Case (Designer, Generator and Dictionary). – 6 months

* Cable Data - Database Administrator on IBM RS6000 under AIX using Oracle V6. - 8months

* British Rail - Database Administrator on IBM RS6000, HP-UX and on Novel Network using Oracle V6 and V7. Cover for extended sick leave. – 1 month

* Rudolf Wolff - Database Administrator on DEC VAX and DEC Alpha using Oracle V6 and V7. – 6 months

CSC Ltd DBA/Project Leader Jan 1991 to March 1992

Consultant / Database Administrator on projects for clients using Oracle including: -

* Cellnet – Project Leader. Responsible for staff recruitment, quality control, project planning and controlling up to 30 staff as Project Leader on Telephone Billing re-engineering project on DEC VAX under VMS using Oracle V7. Produced all system documentation using Word for Windows and WordPerfect. – 9 months

* Criminal Injuries Compensation Board – Database Designer/Administrator on ICL DRS6000 under UNIX using Oracle V6 with CASE. Documentation using Word for Windows. – 6 months

Flinthold Ltd Consultant Nov 1989 to Jan 1990

Consultant / Database Administrator on projects for clients using Oracle including: -

* Peterborough Software - Database Administration, Technical Support, Performance Tuning and Benchmarking for Payroll/Personnel Systems using Ingres on a variety of platforms (IBM RS6000, ICL DRS6000, DEC VAX, DEC ULTRIX). Capacity Planning for customers to enable the correct hardware to be purchased – 12 months

* Wincanton Management Services - Design and development of a Vehicle Administration system using CA-DB and CA GENERATOR producing COBOL and BASIC on DEC VAX under VMS. – 6 months

Cullinet Software (later CA) Product Specialist July 87 to Nov 89

United Kingdom Product Specialist on CA-DB and CA-Generator on DEC VAX platform. Responsibilities included Pre and Post-Sales Support, Database Design and Administration, Training, Consultancy, Seminars, Exhibitions and Quality Assurance of RDB and Oracle versions of CA-Generator.

Flinthold Ltd Aug 84 to July 87

Database Consultancy for a number of clients including:

* CAP Gemini Sogeti - Portfolio Management system for Midland Bank using Oracle with structured design (Gane and Sarson with Excelerator). Responsibilities included Database Logical and Physical Design, Database Administration, Training, Systems Management and Programming (SQL, SQL*FORMS, PRO*COBOL ODS, ODL). - 2 years

* Oracle UK at Property Services Agency - Responsibilities included Database Administration, System Management and Consultancy for Property Services Agency for Oracle products (SQL, SQL*FORMS, PRO*COBOL and RPT/RPF) - DEC VAX using VMS. - 6 months

* Morgan Guaranty - Database Administration on Ingres Banking system -DEC VAX using VMS. - 6 months

Trustee Savings Bank Principal Analyst Aug 72 to Jul 84

Initially employed as a systems analyst on the OLRT banking systems but transferred to TSB Central Board as a consultant working with organizations providing services to the group and with all segments of the group. The main areas of involvement were design and development of banking and administration systems including:

* OLRT Banking - Design, development and testing of enhancements on ICL System 4 hardware.

* Communications - Hardware evaluation and testing. Network Design for ICL System 4 and Burroughs systems, Project leader for design and development of DEC PDP/11 data transmission system for use in BACS Clearing.

* Personnel/Payroll - Rationalization of TSB payrolls into single IBM UNIPAY system. Implementation of pensions administration system on ICL 1900 then IBM hardware with automated links to payroll. Designed and developed Manpower Planning system on Comshare timesharing system using Questor. Team Leader/Database Administrator for software evaluation, design and development of TSB Group Personnel System using Oracle on DEC VAX.

ARC Systems Analyst/Programmer Nov 69 to July 72

Systems design and programming on various clients systems including:

* Programming for payroll/salaries systems using COBOL and Usercode on ICL System 4.

* Design and programming of Stock Control system using COBOL on ICL System 4.

* Decimalisation of Tesco payroll using COBOL and Easycoder on Honeywell 200 series.

* Systems testing of TSB OLRT Banking System.

Philips Electrologica Systems Supervisor Mar 69 to Nov 69

Responsible for systems and programming for P350 VRCs for Northwest England and North Wales.

Staveley Industries Senior Programmer Sept 68 to Mar 69

Senior Programmer for Stock Accounting and Order Processing systems in Assembler and RPG for IBM 360/40 hardware.

Great Universal Stores Leading Programmer June 66 to Sept 68

Trainee Programmer through to Programming Team Leader for systems including:

* Payroll - Programming and Maintenance of system using Assembler on IBM 360/30.

* Stock Forecasting - Programming and maintenance of system using Usercode on ICL System 4.

* Stock Control/Stock Accounting/Customer Accounting - Programming Team Leader on system using Usercode and COBOL on ICL System 4 then reprogramming using Easycoder and COBOL for Honeywell 200 series.

PERSONAL

ADDRESS 269 Park Avenue, Bushey, Hertfordshire, WD23 2DR

TELEPHONE 019**-****** Mobile 077**-******

EMAIL ADDRESS httxrd@r.postjobfree.com

STATUS Married with 2 sons (32 and359)

EDUCATION Manchester Grammar School

O Level - Maths, Pure Maths and English

A Level - Maths, University Test in English

HOBBIES Bridge, Chess, Football, Driving, Mah Jong and similar games.

Contact this candidate