Hobsons Choice IT Solutions Ltd

Summary of technical skills

16+ years ORACLE Database Administrator, Oracle 7, 8i, 9i, 10g, 11g
RAC, ASM, RMAN
Dataguard
Oracle Enterprise Manager / OEM Grid
SQL / PL/SQL
SQL Developer, TOAD
DELL (Quest) Shareplex / SPLEX
DELL (Quest) LightSpeed Engine for Oracle (LEO)
DELL (Quest) Foglight / Spotlight
UNIX (HP, AIX, SOLARIS, Linux), Competent shell scripting
Windows 7 / XP / NT / 2000 / Vista
Competent PC skills, (Microsoft Office)

Professional experience

Apr ’11 - current : AGEAS50 Ltd
Senior Oracle DBA
Oracle 10g / 11g, RAC, ASM, Grid on RHEL 5

At AGEAS50 Ltd (previously RIAS PLC / Castle Cover Ltd), I am the company's sole production support Oracle DBA, supporting legacy Oracle 10g systems, performing migrations to new Oracle 11g databases and providing day to day support and maintenance of the company's range of Oracle 11g databases.

Further to the day to day housekeeping, I have also implemented DATAGUARD DR service for the company's primary 11g Enterprise 4-node RAC cluster and a DELL Shareplex DR service for the company's secndary 11g Standard Edn, single node databse (5Tb)

Additional responsibilities include the build and support of a range of pre-production environments, including automated refreshes.

Apr ’09 - current : Hobson’s Choice IT Solutions Ltd
WEB DESIGNER / DEVELOPER (own projects)
Apache, php, MySQL, Linux SA, html, css

Continued improvement, enhancements and upgrades to my own suite of websites, including online communities, reference websites and online ecommerce solutions.

Aug ’08 – Apr ‘09 : Nationwide Building Society
ORACLE DBA – BAU & development support
Oracle 8i / 9i / 10g. Sun OS 5.9
OEM, TOAD

Sole DBA responsible for the ongoing maintenance, health-care, tuning and support of the Oracle 8i and 9i legacy production database systems, during the transition of the databases from the Portman Building Society to the Nationwide Building Society.

Development support for the migration teams, including backups, recoveries, database clones, script reviews, tuning and design review.

Provided database upgrade support from Oracle 8i / 9i to 10g

Nov ‘07 – Jul ‘08 : Hobson’s Choice IT Solutions Ltd
WEB DESIGNER / DEVELOPER (own projects)
php, Apache, MySQL, Linux SA, html

Ongoing development, improvement, enhancements and upgrades to my own suite of websites, including online communities, reference websites and online ecommerce solutions.

Nov ’06 – Nov ‘07 : Barclays International Bank, Poole, Dorset
ORACLE DBA (Production BAU support / new project rollout)
Core DBA support, Oracle 8i, 9i, 10g, IBM AIX 5.2
OEM, TOAD, Quest Foglight / Spotlight

Working within a team of DBAs, providing ongoing maintenance, tuning and support of the Oracle 8i and 9i production database systems.

Key tasks and responsibilities included database and server performance tuning, backup and recovery implementation and support and Oracle 10g upgrades.

New project rollout support included Oracle 10g builds, data loads and database migration tasks.


Jan '05 – Oct ‘06 : JPMorgan Chase, Bournemouth
ORACLE DBA (Full project life-cycle & BAU support)
DEV/UAT/SIT/PROD : Core DBA support, Oracle 8i / 9i / 10g
Dataguard, RAC
OEM, TOAD, Quest Foglight/Spotlight

Full project life-cycle Oracle DBA support, including (but not exclusively), 24x7 live production support, database migration management, new database builds, tuning, backup and recovery and database monitoring.


Aug ’04 – Jan ‘05 : Hobson’s Choice IT Solutions Ltd
WEB DESIGNER / DEVELOPER (own projects)
Dreamweaver PRO, Linux SysAdmin, Apache, MySQL, php, html

Jan '03 – Aug ‘04 : JPMorgan Chase / IBM, Bournemouth
ORACLE DBA (inc Oracle Financials)
DEV/UAT/SIT/PROD : Core DBA support plus rollout an support of 9iAS Release 2 n-architecture, providing 9iAS development support.

Aug ’02 – Dec '02 : Hobson’s Choice IT Solutions Ltd
WEB DESIGNER/DEVELOPER (own projects)
Web design and implementation
Frontpage 2000, raq4 systems admin, MySQL, php, html, java, perl.

Sep ‘00 – Jul '02 : Barclays International Bank, Poole, Dorset
ORACLE DBA
PROD/DEV, (60:40), database support, tuning, backup and recovery and upgrades. Oracle 7 / 8 IBM RS/6000, AIX 4.2/3 & NT/W2K
Shell scripting for DBA support tasks and hot backup process on NT

Mar ‘00 – Sep ‘00 : Scottish & Southern Energy, Havant, Hampshire
ORACLE DBA
Full project lifecycle support.
ORACLE 7 /8 HP9000 / HP-UX 10.20, IBM RS/6000 / AIX 4.2/3, COMPAQ DIGITAL, SUN/SOLARIS, DEC ALPHA / VMS.

Sept ’99 - Mar '00 : Matra Marconi Space UK, Portsmouth
SENIOR ORACLE DBA
DEV & PROD database support. SC sec. clearance Sept 1999.

Sep ‘98 – Sep ‘99 : London Electricity, Elephant & Castle, London
ORACLE DBA
DEV & PROD Database build, implementation & supportORACLE 7.3.x/8i, HP9000 / HP-UX 10.20 & IBM RS/6000 SP / AIX 4.2/3

June – Sept ‘98 : EDS (Defence) Ltd., Worthy Down, Winchester
Oracle DBA v7 / 8. SC sec. clearance June 1998.

1989 - 1998 : Liverpool Victoria Friendly Society, Bournemouth
Senior programmer / Oracle DBA
PL/1, CICS IMS DB/DC, Oracle 7, 8, 8i

1986 - 1989 : British Airways, Heathrow Airport, London
Trainee programmer, progressing to Senior Programmer, Systems Analyst, Business Analyst