Lytham St Anne's, England, United Kingdom
Welcome, Bienvenida, Bienvenue, Willkommen, Czesc, Shalom, Namaste, Vanakkam, As-salamu alaykum, Moshi Moshi, Huan Ling, Nin Hao, Sawasdee, Privet, Ngiyakwemukela ★ DBA ★ Programmer ★ Data Modeller IBM Mainframe, UNIX DBA on Oracle, Sybase, DB2 and SQL Server. Design and UI experience. Worked with Quality and Security Guidelines e.g. HIPAA, ISO9000 : Mainframe to Open Systems.. Extensive Commercial experience from being a trainee Chartered Accountant with some of the largest U.K. Retail Clients developing Open System, Internet and Mainframe cross platform solutions. [email protected] [email protected] Interesting achievements ... Had Military and Nuclear Clearance .. rewrote code for IBM to run 50x faster .. fortunate to have experience in multiple RDBMS and HDBMS from Change Accumulation (IMS), Consistency Tokens (DB2), Bulk Collect, raw devices and Sticky bits (Oracle), Logical Devices ( Sybase ), svrany.exe ( SQL Server). Specialties: Thinking out of the Box. Adding quality standards to a project. Researching Magazines/Code eg Doctor Dobbs/Tom Kyte/Java Journals for reuseable mathematical techniques which are platform independent. Always wanted to consolidate my tuning experiences into a software package rather than using disparate software packages that clients opt for eg Toad, OEM, AWR, Glance etc Thus I am a Drupal/ PHP advocate with OCI. Love blogging... especially Tom Kyte's articles e.g. http://it.toolbox.com/people/mchughetal/achievements and http://www.oracleracsig.org/pls/apex/f?p=105:100 http://searchoracle.techtarget.com/feature/Oracle-database-administrators-assemble-their-2013-Oracle-wish-list Having both a scientific background and commercial background gives an edge on Problem Solving and provides synergistic solutions. I have an eagerness to learn.
• Linux/SAP/Oracle troubleshooting with SAP Solution Manager ... Insight • SAP Basis Admin .. ValueAmerica • Oracle OPS, UNIX Clustering and Failover, ValueAmerica • Oracle Upgrades and Config ... JDA, Insight, APS • Oracle streams and TSM... AMEX • Oracle 7-Beta .. Deloitte and Touche • SYBASE, UNIX, ... Valic, SCI • SYBASE, Oracle, Lawson, UNIX, EMC SAN and Multiplexing ... SCI • Oracle Forms and Reports, Discoverer, UNIX, ... AZ DHS • C#, ASP.net, ... AZ DHS • Pro*C and Uniface configuration ... JDA • Basic Java ... JDA • Java, makefile and UNIX Package configuration ... Insight • ASP Web Clustering and Failover, .. ValueAmerica • Powerbuilder, Visual Basic, REXX, ... Valic • Cobol ... Data Training • Fortan 77 ... CDC Cyber.. Manchester University • H2 Assembler, Cobol .. Valic, Chase • IMS/DC, Boole/Babbage, REXX ... Valic • IMS/DC, more BMC, Massive DB2 Subsystems ... AMEX • CICS, JCL, Assembler, DL/1, DB2, Datavantage, Easytrieve, SAS, BMC, Omegamon ....BAe/IBM • VSCLP ... ICL
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
Whilst at BAe :- Team Leadership Skills Presentations Skills Negotiation Skills Technical Writing Skills Holding Effective Meetings Whilst at VALIC :- Modelnetic Management Models
★ DBA ★ Programmer ★ Data Modeller Technologies : - Database systems :- Oracle,, Sybase, DB2, SQL Server and DL/1 aka IMS etc - UNIX Operating Systems :- AIX, HP-UX, Linux, Tru64. Sun Solaris etc - Mainframe Operating Systems :- IBM OS390, MVS/ESA, MVS/XA and ICL 3960,2966 - Programming Languages :- C#, Java, Cobol, Fortan, Assembler, REXX, JCL, SCL etc - ERPs :- SAP, Oracle Financials, Lawson, JDA - Mainframe Transaction Systems :- CICS, IMS/DC - Other :- EMC Storage Management, Scripting.Troubleshooting, Upgrades,,VMWare. .
Successfully troubleshot their SAP Oracle upgrade using a response file, applied security patches, monitored their Oracle/SAP/Standy database setup. Had an interesting time when they had a total power-outage with v$recover_file. It all worked. Rebuilt their standby database. Used Oracle tuning techniques to turbo-charge their SAP experience. Metalink rules ... The rate-limiting step in most applications is how they access their data.