|
Personal
Details
Availability
Date of Birth:
Qualifications
1999/2002 Oracle Certified Professional DBA (v7.3, 8.0,
8i)
1989-1991 Bachelor of Commerce And Administration,
Victoria University of Wellington
Personal
Profile
I am a Senior Oracle Consultant with over 10 years
experience in both business focused and hands on IT roles. I am
skilled in all facets of Oracle analysis, design and development
but particularly with regards to multi-tier, 24x7 e-commerce
platforms. I have experience working with major blue chip
corporations, banks & leading edge startup companies and I have
worked in the UK, the USA and New Zealand. I believe my
strengths lie in my ability to combine excellent client facing
skills with a customer focused attitude, business awareness and
a solid technical background.
Achievements
§
Seconded to Oracle Corporation HQ to work in
product management & development for the Oracle Developer Suite.
§
Successfully designed & built an XML messaging,
catalogue shopping tool that directly led to the company’s first
client sale.
§
Successfully mentoring a development team with no
knowledge of Oracle and little knowledge of structured and
formal development lifecycles. Result – efficient Oracle code
and a development team working together!
Technical
Summary
§
Oracle Database Administration and Development (7
years) -
o
Versions 7.3 (3 years), v8 (4 years), v8i (4
years), v9i (2 years)
§
Logical and physical database design and
architecture (7 years)
§
SQL and PL/SQL development (7 years)
§
Oracle Application Server v2 – v9iAS & 10g (5
years)
§
Oracle Designer v1.3 to v6i (5 years)
§
Oracle Enterprise Manager (6 years)
§
Oracle 9iRAC (1year), Oracle RMAN (2 years)
§
Oracle Developer – Forms (3 years), Oracle
Developer – Reports 4.5 to 6i (3 years), Oracle Discoverer (3
years)
§
Oracle JDeveloper and Java (3 years), J2EE (2
year), OC4J (1 year)
§
JSP, Servlets, Struts, Tomcat (6 months)
§
BEA Weblogic v5 and 6. (1 year)
§
Oracle Internet File System (iFS) (6 months)
§
Oracle Spatial (6 months), Oracle Advanced Queuing
(1 year)
§
HTML (3 years), XML (2 years)
§
Unix Administration and Shell script development
(6 years)
§
OS - WinNT (6 yrs), Win2000 (2 yrs), Solaris v2.5
– 2.8 (6 yrs), AIX v4.3 on RS6000 (1 yr), HPUX (1 yr)
§
CVS, PVCS, Clearcase, Microsoft SourceSafe (5
years)
§
OO, UML (2 years)
§
Veritas (Volume Manager/Cluster Server/NetBackup)
(1½ years)
Experience
Mar 2004– Present
[snip] London, UK
§
Oracle 9i,
Oracle 9iAS Release 2, Oracle 9iRAC, Oracle RMAN, DataGuard,
Solaris 2.8, Oracle Enterprise Manager (OEM), OC4J, Veritas
Cluster Services
I
rejoined Rabobank to troubleshoot and performance tune an OLTP
Retail Banking Application that was in a critically poor
performing state. I also undertook standard production DBA
work.
Oct 2003 – Feb 2004
Various
UK
§
Oracle 9iAS
Release 2 and 10g, Oracle Forms & Reports Server, OC4J, Solaris
2.8, Windows 2000, Oracle Discoverer Server, Oracle Internet
Directory, Oracle Single Sign On
Sep – Dec 2003(3 months-1 renewal)
[snip]
London, UK
§
Oracle 9i,
Oracle 9iAS Release 2, Oracle 9iRAC, Oracle RMAN, Solaris 2.8,
Oracle Enterprise Manager (OEM), OC4J, Veritas Cluster Services
I
joined Rabobank on a short term engagement to provide expertise
in 9iAS, 9iRAC and RMAN for a critical period of development,
operational acceptance testing and go-live for an OTLP Retail
Banking application
Mar-June 2003(4 months-2 renewals)
M[snip] London, UK
§
Oracle 9i,
Oracle 9iAS Release 2, Oracle 9iRAC, JAVA, JDBC, Solaris 2.8,
Oracle Enterprise Manager (OEM), Oracle Forms and Reports
Server, OC4J, Veritas Cluster Services
I was
called into M & G on behalf on Sun Professional Services to
design and architect an Oracle Forms and Reports migration
project to Oracle9iAS Release 2. –
Sep 2002- Jan 2003(5
months)
[snip] London, UK
§
Oracle 8i,
Oracle 9i, Oracle 9iAS, SQL, PLSQL, JAVA, Windows2000, Solaris
2.8, Oracle Enterprise Manager (OEM), Oracle Reports, CVS, J2EE
Mar 2002- July 2002 (4 months –
1 renewal) I[snip] London, UK
Image.net is an internet
digital asset management (DAM) system company. They were
building an internet based DAM system on Oracle 9i, 9iAS, 9iFS,
XML and Apache Struts (A J2EE based framework). I was working
with Acora IT - a technology consultancy that provided the
initial analysis, platform evaluation and recommendation to
senior management -
o
I provided the
only Oracle expertise in the form of architecture & design,
staff training & mentoring.
o
Installed,
configured and tuned Oracle 9i and 9iAS (Release 1,using 9iFS
and OC4J mainly).
o
Designed and
documented the development lifecycle, the source control
environment & the Oracle installation (both development and
production).
o
Managed the
Oracle Production environment – 3 Veritas clustered Solaris
servers running clustered OC4J containers inside 9iAS and Oracle
9i, managed with OEM & OMS.
o
Oracle DBA –
designed, tuned, managed and backed-up using Veritas NetBackup,
RMAN & OEM.
o
Developed using
the Oracle Internet File System (9iFS), SQL, PLSQL, Java (JSP
and Servlets), Tomcat, 9iAS (OC4J) and XML.
Nov 2000 - Feb 2002 (15 Months
– 2 renewals)
[snip]
Ltd
London, UK
2020Me is an Internet
technology company that has developed a virtual personal
assistant/concierge/shopping e-commerce site. They hold a number
of patents for their technology. I was a lead Oracle Consultant
looking after the Oracle Infrastructure mainly as a Development
and Production DBA but I was also charged with evaluating new
and advanced Oracle based technology -
o
Oracle
Development DBA and Production DBA (Install, configuration,
tuning, management, backup/recovery, design, documentation and
migration 8i - 9i)
o
Logical and
physical data design using Oracle Designer 6i
o
Extensively
involved in development using Java, PLSQL, SQL, XML Messaging,
Advanced Queuing
o
Team-led,
designed and built a major part of the “catalogue shop” a
hub-based XML catalogue exchange using JDK 1.2, Java Stored
Procedures, SQL, PLSQL, Advanced Queuing, Oracle Text
o
Team-led project
to evaluate location based services using Oracle Spatial and
9iAS
o
New technology
evaluation i.e. replace Weblogic with Oracle9iAS, location based
services, AQ
o
Presales work and
onsite and offsite customer support.
o
Unix/Solaris
Administrator (until a fulltime administrator was hired)
April 2000 - Oct 2000 (6
months)
[snip] London, UK
MobileAge were developing an
Application Service Provider framework for secure mobile
applications. I was providing the Oracle expertise in terms of
platform selection and management -
o
Evaluated,
recommended and built the Oracle platform, storage structures
and data interfaces.
o
Oracle
Development and Production DBA (Install, configuration, tuning,
management, backup/recovery, design and documentation)
o
Logical and
physical data design using Oracle Designer and Visio.
o
Unix/Solaris
Administrator
o
Systems
development. I built an internal systems management and
monitoring website using unix shell scripts, java and HTML as
well as parts of their first mobile SMS application using JDK
1.1.6, SQL and PLSQL.
Mar 1999 – Mar 2000 (12 months
– 1 renewal)
[snip]
London and San Francisco
The project was a “push”
messaging and knowledge management application for distributing
strategic information. I was the Analyst in charge of business
requirements and technology evaluation -
o
Business
requirements analysis, market analysis, technology evaluation
and feasibility studies.
o
Prototype
development PERL, Oracle 8.0.5, MacroMedia Director, Backweb.
o
Logical and
physical data design using Oracle Designer.
o
Oracle
Development DBA
1996 – 1999 (3 ½
years)
Oracle Corporation New Zealand and
USA
I was a Senior Presales
Consultant responsible for Advanced Technology. I developed
expertise in database administration, data analysis, database
design and development, Application Servers and multi-tier
architectures. I regularly took responsibility for a number of
presales opportunities which involved leading teams of
developers and consultants (as well as sole charge projects) on
sales, support and consulting engagements. I gave regular
presentations to clients at both Senior Management and IT
department level and at industry events (most notably Oracle
OpenWorld in Australia) and I was also recognized for my
abilities and seconded to Oracle HQ in California for 4 months
to work on version 6 of the Oracle Internet Developer Suite.
Some examples of the projects I
worked on include:
-
Team led a project to build a Java/CORBA Application
Server based prototype for Telecom NZ using Oracle’s Java IDE (JDeveloper)
and the Oracle Application Server.
-
Team led the project and designed the architecture for an
extranet for the NZ wholesale electricity market in conjunction
with Ernst and Young and Compaq/Digital.
-
Designed and built an operational datamart prototype for
AMP using Oracle’s Datamart Suite which includes Oracle
Warehouse Builder, Oracle Reports and Oracle Discoverer.
-
Team member on a prototype project to provide online land
title information for Land Information New Zealand using the
Oracle Spatial Data Option in conjunction with MapInfo.
1993 – 1996 (3
years)
Colgate Palmolive
New Zealand
Financial and management
accounting and statutory reporting. Systems analysis,
development and support. |