|
Graham
Objective:
Oracle
Database Administrator
Summary:
Sixteen years experience in I.T. including ten years extensive
work as an Oracle DBA covering versions 7.1 to 9i in both
production and development environments.
Primarily worked for large organizations with 24x7
mission-critical systems, and also for a number of smaller
clients on individual projects. Worked successfully as part of
large and small teams, and have taken the lead role in
significant projects. I am resourceful and comfortably work to
tight deadlines in administration and troubleshooting
capacities. Versed in all aspects of the project life-cycle.
Oracle 8 Certified Professional (OCP) - currently
working on upgrading certification to 10g.
Skills:
-
Oracle 7, 8 and 9i; MySQL 4.0.15; Oracle Financials 10.5
-
HP-UX (9.04;10.20; 11); PTX/Dynix(2.1; 4.1.3);
Solaris(2.5.1); Linux (SUSE 9.0; Redhat 7.1); Windows (XP;
2000; NT4; 3.1); PICK; Novell 3.12; DOS
-
Oracle Failsafe; Cluster Administrator
-
Legato Networker; OpenVision Netbackup; HP Omniback;
Arcserve
-
SQL; SQL*Plus; PL/SQL; UNIX shell scripts (sed; awk; perl);
Databasic; SB+; RPL;Sycero/Clipper
-
Word; Excel; Open Office
Professional History:
2005 - Present TECHNICAL SUPPORT / CONSULTANT
[snip]
Repaired a failing software product and got it to a suitable
condition for selling.
·
Set-up and tested client API (interface with SMS Gateway)
·
Set-up the customer databases using MySQL
·
Amended problematic Perl CGI scripts to interact with customer
databases
·
Created additional CGI scripts for bulk-loading and data
maintenance
·
Produced documented procedures for application software
installation at customer sites
·
Monitored and maintained production databases
2005 – 2006 CONTRACT ORACLE DBA
[snip]
Sub-contracted by this company to provide cover for
their client during holidays
·
Monitored databases and backups using central repository
·
Made appropriate database amendments following server upgrades
·
Monitored performance of problem databases and produced report
of recommendations
·
On-site DBA support
2004 – 2005 CAREER BREAK
I took time-out to follow an ambition and travelled
solo around China (back-packing)
2003 CONTRACT ORACLE DBA
[snip]
Short projects to achieve specific goals to tight time-scales
·
Recovered non-functional database and produced health-check
reports
·
Implemented agreed changes to improve performance, resilience
and security
1998 – 2003 CONTRACT ORACLE DBA
[snip]
The original brief was to fix system performance problems that
were occurring on a regular basis, particularly around the
month-end reporting period. My success in this area led to
ongoing contract extensions to continue the work and perform
other additional duties. I was also sent as a trouble-shooter
and adviser to the companies DBA team in Chicago.
·
Liaised with in-house and third-party developers to advise best
Oracle practices
·
Evaluated licensing requirements and consulted with Oracle
·
Set-up and administered Oracle8i and Oracle9i databases on Win2K
clustered servers
·
Set-up backups (created RMAN scripts and catalogs), integrated
with HP Omniback
·
Conducted fail-over testing (Oracle Failsafe), plus recovery
testing for resilience
·
Trained/mentored a permanent DBA
1996 – 1998 SENIOR ORACLE DBA
[snip]
Worked in a team of twelve DBA's. Responsibilities were
primarily for the establishment of databases within the Network
Services division, plus support for the prepay mobile service.
The production databases were 24x7 and highly available. They
ranged in size from 4GB to 600GB. Applications were a mixture
of 3rd party and in-house developed client/server systems.
·
Designed and implemented new company database backup and
recovery strategy
·
Administered development, test and production database instances
·
24 hour support of production instances (one week in three
call-out rota)
·
Created scripts for monitoring
·
Administered Asynchronous Replicated environment
·
Capacity Planning
·
Documented procedures
·
Liaised with project teams, development teams and UNIX Support
1994 – 1996 ORACLE DBA
[snip]
I volunteered to take on the new role of Oracle Database
Administrator when the company replaced it's existing financial
systems with Oracle Financials. Initially, this was a part-time
role in parallel with my other duties, but soon grew to be a
full-time role in its own right.
·
Set-up of development, test and live databases (7.1.3 to 7.1.6
including upgrades)
·
Comprehensive administration duties including system
availability and resilience
·
Installed Oracle Financials 10.4 in U.K., Ireland, France and
Spain including localization's
·
Applied patches to RDBMS and Financials software
·
UNIX system administration duties including aiding with
migration from HP-UX 9.04 to 10.02
·
General support duties for PC's; Networking; Applications; etc.
1991 – 1994 ANALYST /
PROGRAMMER [snip]
·
Created Bank Standing Order application with interface to
general accounting system
·
Created Travel and Expenses Control system to track employees
expenses and advances for all UK sites. Included creating BACS
records plus accounting records with system interfaces
·
Created European Production Reporting system. This was a PC
application that I had to install at 13 sites throughout
Europe. The information was gathered into an EIS system for the
Company Directors.
Other Experience:
Before changing to a career in Computing I worked as a Financial
Accountant, being a part-qualified Certified Accountant, and a
qualified Member of the Association of Accounting Technicians (MAAT).
Foreign Languages:
Chinese (Mandarin) – conversational French –
working knowledge |
