James P. McHugh ( acb2y6@r.postjobfree.com )

UK 016*-***-****

US 001-623-***-****

http://www.linkedin.com/profile/view?id=58233159&trk=tab_pro

***** *. **** ***** * Dellcot Lane

Glendale Worsley

Arizona Manchester

85304 M28 2PT

OBJECTIVE –

To be in a creative team where I can leverage maths, programming and mentoring skills to provide maximum R.O.I. I have 20 years of I.T. experience from Oracle 7-Beta, DB2 2.1, Sybase 10.3, SQL Server 6.5 on so many platforms with an assortment of middleware :- Web Servers + ERP App Servers – multiple languages. I started using Oracle and Sybase on UNIX back in 1993 – member of IBM Guide for DB2, International Sybase Users Group, Oracle Special interest groups. Metadata and SQL maintenance on DB2 and Oracle for consistent plan execution and manipulation.

SUMMARY -

• Troubleshot Oracle, Sybase, DB2 Upgrades etc from MVS to UNIX

• Large System Tuning e.g. Sun Solaris 50 cpu Oracle Data Warehouse

• Security Guideline Implementation ( IBM Standards )

• Multi-platform Replication, messaging,Assembler exits, Omni-Connect

• Multi-language - Cobol, Pro*C, Power-builder, dot Net, SAP, Fortan77

• Multi-E.R.P. Support ( SAP, Oracle Financials, JDA )

• Data Analysis, Systems programming, Disaster Recovery, Gateways

• Extensive utility usage :- bcp, sqlloader, dsn1copy, spufi, oem, svrany.exe ad infinitum. Smitty, glance, explain plan, dump analysis.

EXPERIENCE:

707 – Present

Unfortunately real-world family bereavement etc has impacted my ability to Job-Search and whilst always researching about new releases I am relishing the thought to do some creative work again. This was further hampered by the requirement to be back in the U.K. For 5 years to obtain Security Clearance. However I have kept my skillset up attending Oracle Web Seminars on new developments in Oracle and Java as well as SQL Server.

Contributor to many Blogsites e.g. http://it.toolbox.com/people/mchughetal/achievements and http://www.oracleracsig.org/pls/apex/f?p=105:100 and http://searchoracle.techtarget.com/feature/Oracle-database-administrators-assemble-their-2013-Oracle-wish-list .

Like most Oracle enthusiasts I have 11g2 on my laptop with a plethora of software e.g. Apache, EasyPHP to name a few. I have a home network with VNC, VMWare running e.g. Linux, dot.net, Java and a suite of Open Source tools.

~3/07 – ~7/07

Contract Oracle DBA to Richard Michael at Insight

Major Achievement – Personally trouble-shot a successful upgrade to 10G using a SAP-Oracle response file

Rebuilt Oracle standby database with log shipping

Worked in a SAP Basis team as an Oracle DBA on Redhat Linux and Tru64..

Applied Patches etc. Performed elementary Basis administration.

.

8/1/06 – 11/10/06

Contract Oracle DBA to PDS at APS

Major Achievement – Documented issues met whilst successfully implementing and upgrading Oracle with associated tools / patches

Sat and passed various Clearance related exams.

Upgraded instances to Oracle 10.2 from as far back as 8.1.7 using dbua, opatch etc Documented challenges met e.g. missing Solaris patches.

Rebuilt instances including refreshing materialized views with fine-grained security.

Installed OMS Intelligent agent and used Grid Control.

6/6/2005 - 4/24/06

Contract Oracle Database Engineer to SAI then CDI for IBM at American Express

Major Achievement – Implemented multi-threading logic to drastically reduce elapse times and implementation of Security Guidelines.

On-call support, Steady-State Work

Wrote some multi-platform infrastructure Korn scripts with PLSQL to be GNU compliant.

Used some maths skills to reduce the elapse time of a Korn script that ran an extra 23+ hours to take 30 minutes using multi-threading, made it self-scheduling .

Configuration of TSM backups with reporting ot Infomaster through APIs to raise tickets.

Adapted DB2 AIX API infrastructure Korn scripts to run against Oracle-TSM-Infomaster.

Sat in on new features meetings.

11/2002 - 2/2005: State of Arizona - Dept Health Services, Oracle DBA

Major Achievement –Troubleshot firewall issues and walked the Team through the technique.

Worked mostly with Oracle on Sun Solaris UNIX and Win2000 Servers hosting Oracle.

- Installed and configured Oracle instances and OEM; running various jobs with the OEM Job Scheduler. Performed regular DBA maintenance work, schema changes, environment refreshes, performance tuning, opening TARs and Troubleshooting,,, import-exports etc.

- Support for the conversion of the Solaris File system topology from Veritas QuickIO to QFS

using shared File systems between machines.

- Sat some dot Net classes which I really enjoyed, no project to use them on though also Oracle App Server class – really Apache Web Server – configuration..

9/2002 - 11/2002 : Contract Oracle DBA to Advance PCS

Major Achievement – Tuning performance scripts to run on multi-terabyte system.

Short-term 12 week contract for monitoring nightly Batch runs for their Enterprise Data Warehouse. On Sun Solaris with some 35 900MHz processors with Load Averages exceeding 30. Large tables 300 million plus.

9/2000 - 5/2002 : JDA Software, Scottsdale, AZ, Senior Oracle DBA

Major Achievement –Troubleshot implementation issues and Multi-language support.

. -Installed and monitored Oracle Databases v7.3.4, 8.0.5, 8.1.6 mostly on AIX 4.3.2, 4.3.3 but also on Windows NT 4.0 SP6, W2K. with Uniface

- Performed remote installs and tuning for clients in U.S, Japan, Chile and the U.K.

- Configured Pro*C Batch and Perl Batch programs.

10/1999 - 8/2000 : Valueamerica.com, Charlottesville, VA, Oracle DBA/SAP Basis Admin

Major Achievement – Tuning diverse environments – usage of RAC’s predecessor

- Monitoring SAP 4.5B in a clustered HP-UX setup on EMC with Oracle failover & load-balancing involving some SAP-Basis admin and UNIX scripting, SQL tuning, RMAN setup

- SQL Server:-Installing & initial monitoring for the Mustang Email Server with. Perl

05/98 - 08/99 : Service Corp International, Houston, TX, Senior Sybase Database Admin

Major Achievement – Administering Oracle, Sybase and SQL Server, cloning and upgrading Sybase, Oracle-Sybase-SQL Server database Installs tuning, Korn Scripts, PL-SQL for Admin

- DBA lead on html project on Oracle 8. on HPUX...

- DBA lead on the Lawson Sybase Payroll system involving a major upgrade

- DBArtisan, EMC and BMC tool support for, Oracle-Sybase-SQL Server database

- Installed Oracle Financials Application server, IIS etc on NT.

04/96 - 05/98 American General, Houston, TX, Consulting DB2-Sybase DBA

12/94 - 04/96 Hestair : client American General, Houston, TX. Contract DBA

Major Achievement – Multi-Platform Replication

Duties:

- Sybase Admin on 10.3 with AIX

- - Wrote prototype Powerbuilder programs to visually display Sybase/ UNIX stats

- AIX MDIs gateway integration s to the mainframe with SNA and IMSDC

- Data Modeling and Database Design for both DB2 and Sybase.

.

- Supported IMS-DC DB2/DLI applications using Boole and Babbage..

- Supported System Architect Data Modeling tool on NT, maintained Visual Basic programs to e.g. install S.A. on clients' machines from Lotus Notes.

- DBA support to MICROFOCUS COBOL and PC version of IMS/DC called Stingray.

- Wrote REXX programs.

08/94 - 11/94 Contract DB2 DBA to Deloitte and Touche for the State of Oklahoma –

K.I.D.S Project using Oracle/DB2 and PowerBuilder

Major Achievement – Working with Oracle Heterogeneous Gateway

- With the main Oracle DBA,Data Modelling and Database Design, screen walk-throughs.. Wrote PL-SQL triggers, stored procedures - - tuning SQL

10/93 - 07/94 Datronics, Dallas, TX, Contract DBA to AMEX, Phoenix, AZ

Major Achievement – Largest Mainframe Upgrades

Multi-mainframe international DB2 – IMS-DC support.

01/89 - 09/93 British Aerospace, Military Aircraft Division, DB2-DL1 DBA

Major Achievement – DB2 and DBRC implementation, worked design issues

Extensive Data analysis, DB2 and,DL-1 with CICS experience on MVS, some Assembler...

05/88 - 01/89 British Aerospace, Military Aircraft Division, Analyst/Programmer

Duties:

- Extensive programming experience with DL-1 and CICS on on MVS.

04/87 - 05/88 Electronic Rentals Management, Systems Programmer

Duties:

- Cobol programmer on ICL Mainframe

10/85 - 12/86 Carter,Chaloner & Kearns Trainee Chartered Accountant

Duties:

.

- Studied Law, Accounts, Economics & Quantative Techniques

EXTRA WORK UNDERTAKEN:

~1/97 – ~7/97

Contract DB2 DBA to Hestair at Chase Bank Houston

Major Achievement – Wrote a H2 level Assembler interface for the Mainframe to port to a VB-Crystal Reports DB2 setup on OS2-Windows NT using triggers for their Check free-Recon Image system

EDUCATION:

1985 University of Manchester, Manchester, England B.Sc. (Hons), Biochemistry

2006 March 3rd - Admitted as a Citizen of the United States of America

2004 Course 2124 Programming with C# - Interface - Phoenix AZ

2004 Course 2310 Developing ASP.NET Web Apps w/Visual Studio .NET ï Interface - Phoenix AZ

2004 Oracle 9i Database Management 2 - Greenbriar Russell - Phoenix AZ

2003 Oracle 9i Database Management 1 - Greenbriar Russell - Phoenix AZ

2003 Oracle 9i Applications Server Administration - Greenbriar Russell - Phoenix AZ

2001 Inventory Transfer Management - JDA Internal

2001 Inventory Management - JDA Internal

2001 Introduction to Java Programming - Internal Course AZ

2000 Introduction to Retailing - JDA Internal

2000 Oracle Openworld - San Francisco

2000 S.A.P., Philadelphia - BC315 Workload Analysis

2000 S.A.P., Boston - BC360 Oracle/Unix Core Fundamentals

2000 Oracle, Baltimore - Oracle 8i Backup & Recovery

1999 HP,Rockville Maryland - HP Serviceguard

1999 Oracle, Houston - Oracle 8 P&T

1999 EMC, Boston - EDM course

1998 Oracle, Houston - Oracle 8 for DBAs

1998 Lawson, Boston - Unix/DBA/App Server Admin

1998 SQL Server 7.0 - New Horizons Houston

1995 Sybase, Houston:- Sybase v11 performance & Tuning

1995 AIX for MVS Systems Programmers Houston

1993 SEQUEL/PLATINUM - DB2 Performance & Tuning

1992 Arthur Anderson - Client Server and DB2 v2.3 London

1992 SEQUEL/PLATINUM - CICS/DB2 Performance Tuning

1991 Logical Conclusions - Systems Analysis Blackpool

1991 Database Architects/CA - DB2 System Administration/Database Design Birmingham

1990 IBM - DB2 for DBAs l St John's Wood London

1990 IBM - Database Recovery and Control St John's Wood London

1989 IBM - DL/1 Logical Relationships St John's Wood London

1989 IBM - DL/1 Performance & Tuningl St John's Wood London

1988 Pansophic - TELON ( CICS Rapid Development Framework )

1988 British Aerospace (In-house) CICS, JCL, COBOL, DL/1 application programming 1987 ICL - VSCLP - SCL Programming - Beaumont London

1988 Data Training 8 weeks COBOL, Jackson Structured Programming, SCL (ICL/JCL ) Manchester

HOBBIES :- Reading Java and C journals, Age of Empires strategy games, Flying, Motorbikes, Football and going to the Bridgewater. .Now on Facebook.

Contact this candidate