Chris Willoughby

Consistently displays enthusiasm & diligence working hard to assimilate new skills

Previous managerial experience along with the mentoring of junior staff

Building Unix servers on VMWare.
Building zones on Unix machines to host oracle databases.
Building databases using several different versions of Oracle RDBMS
Successfully performed upgrades and patches on Oracle Databases from 8 to 19c
Successfully migrated all production and test/development databases from our Doncaster site to the DataCenter in Slough.
Successfully built new databases in Oracle 9i, 10g, 11g, 12c, 18c and 19c on Solaris 10 & 11 Unix operating systems
Successfully built new databases in Oracle 10g,11g, 12c, 18c and 19c on Oracle Enterprise Linux Unix operating systems.

Successfully patched databases for SAP and non-SAP on 11g, 12c, 18c and 19c

Successfully rebuilt databases in small endian from big endian

Successfully built new oracle RAC Servers on Redhat Linux and Solaris operating systems

Successfully migrated single instance databases into RAC databases.
Dataguarded Databases as part of D.R. Solution.
5 successful DR switchovers of all 13 databases from main site to DR site
Using Rman to backup and restore Oracle Databases.

Setting up Direct NFS and moving Database from local storage to NFS storage easily and efficiently
Responsible for the build and implementation of a large healthcare system

October 2016 to Present

Senior Oracle DBA

Spire Healthcare Group plc

Been involved in 48 projects so far with this company.

Working with 60 Oracle 19c Databases within a SAP environment

Created a 4 node and a 2 node 18c RAC systems on ASM on Solaris 11.

Implementing password complexity on every database.

Backing up and restoring databases using RMAN.

Refreshing test/dev databases from production backups using RMAN.

Sorting out block corruption.

Performing Oracle Database upgrades from 11g to 12c, 12c to 18c and 18c to 19c

Performing Oracle Database upgrades from 11.2.0.3 to 11.2.0.4

Patching  19c,18c, 12c and 11g SAP single instance and RAC databases and Non-SAP databases

Migrated single instance databases into RAC databases.

Moving all our Oracle databases from on-premise solaris systems into Azure Cloud on Linux O/S VM’s.

Dataguarding Azure Cloud databases to 2 standby’s using Dataguard Broker, Fast_start Failover with an observer.

Rebuilding databases from big endian to small endian 

Performing tuning of the Oracle Database to increase speed and efficiency.

Tuning sql scripts.

Cloning databases from one name to another including rebuilding structure as well.

Using export/import dump utilities to restore databases or rebuild new databases

Using Enterprise Manager 13c and Spotlight for Oracle to monitor databases.

ITIL process implementation.

Performing capacity planning for all databases.

Writing shell scripts to perform tasks.

September 2014 to September 2016

Oracle DBA

SKY

Was involved in 6 projects whilst working at this company.

Working in a team responsible for looking after over 2000+ development and production databases.

Creating 10g &11g databases for development and testing purposes

Creating/Deleting Oracle Users

Upgrading databases

Building Golden Gate extracts, pumps and replicats as well as building the database for the information to sit in

Fixing Golden Gate problems

Fixing Dataguard issues

Activating standby databases then flashing them back and putting them back into standby mode and restarting dataguard

Have a good understanding of RAC as we have live RAC systems, also have a 6 node RAC system.

Applying PSU patches to databases.

Using export/import dump utilities to restore databases or rebuild new databases

Using Enterprise Manager 12c to monitor databases.

Writing Unix shell scripts to perform tasks.

Reacting to tickets coming into the database team which might be requests, incidents (ranging from priority 1-4) or changes.

May 2011 to August 2014

Oracle DBA

Close Motor Finance

Was involved in 8 projects whilst working at this company

Looking after 20 production databases and 250+ development databases
Creating Oracle 10 & 11g Databases for development and testing purposes.
Using grid environment for the creation of ASM (Automated Storage Management) within the databases.
Creating Linux servers.
Using VMWare for the creation and cloning of Linux servers and oracle databases.
Backing up and restoring Databases using RMAN
Using Dataguard to real-time apply changes to the DR and Month End Databases.
Creating Direct NFS for ASM to sit in on SAN Server.

Moving Databases from local storage to NFS storage with little downtime as possible.
Creating/Deleting Oracle Users
Writing Unix shell scripts to perform tasks.

Migrated all production and test/development databases from our Doncaster site to the DataCenter in Slough.
Using import/export functions within the Oracle databases for bringing in certain schemas within the testing/development environments.
Have a good understanding of RAC as the live servers are built on a 2 node RAC system.
Created 2 node RAC databases on VMware.
Performed 5 DR switchovers, switching live databases in Slough to standbys and bringing up standbys in Docklands then reversing the process.
Flashed back databases with standbys attached in dataguard mode and brought them back into sync.
Tested migrating 10g databases up to 11g successfully.

Good understanding of Golden Gate, have built and administered several data feeds.

Mentoring junior member of Staff
Using Enterprise Manager 12c to install oracle grid/database software onto servers.
Using Enterprise Manager 12c to clone databases from one machine to another which includes changing the oracle sid as well.

Sep 2009 to May 2011

Oracle DBA/Developer

HC Slingsby Plc

Responsible for oracle 10g database with maginus software front end.

Responsible for oracle 8i database.

Responsible for Sql Servers on 2008 and 2000

Provide 1st line & helpdesk support & hardware & software support for over 100+ users Responsible for backups on oracle using RMAN and sql servers using maintenance plans

Creating tablespaces and monitoring them in Oracle.

Creating views, procedures, packages etc in Oracle.

Writing scripts in Unix shell, some incorporating oracle as well.

Creating users in Unix, Oracle and Maginus.

Altering Maginus templates.

Using Oracle Enterprise Manager and Oracle sql Developer to monitor system backend.

Producing adhoc reports using sql, pl/sql, or Maginus Reportwriter (VBA) and e-mailing results to users.

Creating cronjobs in Unix to perform out of hours tasks.

March 2009 to April 2009 (1 Month Contracting Role)

Sql Server Consultant

Sphinx CST

Built maintenance plan for sql server to backup machine and ship the logs out to another machine for disaster recovery.

Creating users and roles in sql server 2005 along with creating new users in Sage Line 500

Cleaning up sql server database of all temp tables left behind

Creating tables,indexes,views,stored procedures and triggers in sql server and letters in sql server to be triggered when new order is put on and also when despatch confirming orders.

Creating tables, stored procedures and triggers to capture information used for auditing purposes.

Altering dbforms invoices and statements to email in pdf format, despatch notes to ignore certain lines created in spool as well as altering them to have computa center logo and address on it when the customer is computa center

Pulling archive data from oracle and transferring it into sql server 2005.

Altering sage line 500 forms to display more than 10 chars in price field.

Creating scheduled jobs to perform several tasks out of hours.

Creating crystal reports used for financial reporting.

Wrote command shell and sql script to be able to resend ob10 invoices.

Documented instructions explaining how to perform DBA tasks and other procedures happening on the database.

Jul 2008 to March 2009

Oracle/UNIX DBA

TietoEnator

Responsible for over 100 production/development databases are up and running on a daily basis.

Creating database in 8i, 9i and 10g for development testing.

Creating/Altering Perl and Unix shell scripts to perform backups and restores on databases.

Provide 1st line & helpdesk support & hardware & software support for over 250+ users.

Performing PICT Testing on new software releases before being shipped out to customers.

Using DBA skills to monitor table and tablespace extents to ensure system stability along with using export and import facilities to create new companies and defragment system.

Performing Unix administration tasks on Solaris 10 servers to create new zones, keep machines up and running.

Creating new zones on Unix servers to hold testing databases.

Providing DBA support for offsite customer machines to keep them up and running.

Performing hot and cold backups on Oracle databases.

Writing PL/SQL and shell scripts to perform diagnostics on databases/servers.

Installing and configuring QAS software for use with address linking in Banking Software being built.

Using VMware to build images of desktops for use with installation testing and PICT testing.

Installing Oracle, Microsoft Office and Banking Software on Laptops/Desktops and configuring them to work.

Performing Data updates by using Oracle SQL Loader.

Creating new users in both oracle and Unix.

Mar 2001 to Jul 2008

ORACLE CONSULTANT

BT Lynx Ltd

Responsible for ensuring the database is up and running on a daily basis

Responsible for mentoring junior members of staff.

Appointed to work on a wide variety of major systems improvement programmes

Supports a TETRA/CS3 (SAGE line 500) system built on Oracle on top of UNIX operating system

Provide 1st line & helpdesk support & hardware & software support for 160+ users

Built Oracle 8.1.7 Databases on Windows 2000 & 2003 servers as well as Unix machines.

Installed and configured Oracle Transparent Gateway for Oracle to talk to Microsoft SQL Server databases.

Performing hot and cold backups, restoring on a standby Oracle machine to verify tapes

Successfully upgraded company’s system to Oracle 8.1.7 from 8.0.6, upgraded company’s system to Tetra version 4 from version 2 then upgraded company’s system to Sage Line 500 from tetra version 4 and upgraded Unix from 4.3.3 to 5.2

Transferred and configured sage line 500 from oracle 8i to sql server 2005

Using DBA skills to monitor table and tablespace extents to ensure system stability along with using export and import facilities to create new companies and defragment system.

Writing triggers,procedures,packages and views along with creating tables, indexes and tablespaces in oracle.

Improved database performance by restructuring and defragmenting system.

Using Toad to perform some necessary DBA tasks.

Using Oracle Enterprise Manager to monitor system backend.

Using Quest Spotlight for Oracle to monitor system performance and react when table locking appears.

Putting 2nd Oracle system into standby mode every month end and applying archive logs to it.

Installed and configured Java scripting to enable Oracle to email out of the back direct to users using SMTP utility.

Ability to rebuild sql server database on new system and transfer all users across.

Set up users in UNIX & TETRA, importing new products to database with sql loader

Cleansed system data and monitored tables to facilitate continued expansion. 

Upgraded ‘crash and burn’ machine and tested to ensure successful data migration

Utilised same documented procedures to upgrade standby and live machines

Administer system and maintain UNIX environment & live Oracle development

Monitors oracle alert logs checking for unforeseen errors & reacting accordingly

Built maintenance plan for sql server to backup machine and ship the logs out to another machine for disaster recovery.

Able to shrink databases in sql server.

Perform Backups and restores on Sql Server CRM system.

Created new databases in SQL Server.

Created tables,indexes,views,triggers and stored procedures in SQL Server.

Use DTS in SQL server to import and export Data and schedule overnight and email users (sometimes containing attachments).

Write stored procedures in sql server to perform various tasks

Create triggers to fire information from oracle to sql server databases.

Creates reports with Crystal Reports V8.5 or TETRA reportwriter in the database

Re-wrote major part of oracle form for the authorisation of non-stock purchases

Developed & amended form adding a further 4 screens to output various results

Completed part written form before testing thoroughly, passing and taking live

Produced adhoc reports using sql or pl/sql, e-mailing results to management

Created Credit control database including writing all of the oracle forms, creating tables/indexes, procedures,views,triggers and packages.

B2B Links – OB10 Exchange electronic invoicing and IBM Maritz Reports

Developing and amending definition forms in DBMail, DBFax and DBForms

Amending DBFax confirmation Unix shell scripts

Dec 1994 to Mar 2001

SYSTEMS ADMINISTRATOR

Leeds General Infirmary – Radiology Department

Responsible for the build and implementation of a large healthcare system

Developed system using SQL forms, reportwriter, pl/sql & SQL*PLUS batch routines

Planned, organised and implemented the system testing of new software

Provided 1st line & helpdesk support & hardware & software support for 100+ users

Acceptance testing, test script design, and leadership of technical/sales test team

Administered system and maintained UNIX environment & live Oracle development

Maintained/enhanced software using SQL* Forms/Reportwriter, pl/sql & shell scripts

Developed interfaces with other systems & scripts for ad-hoc management statistics

Wrote pl/sql script for creation of 4 character code for contracting charging purposes

Sep 1989 to Dec 1994

DATA ENTRY CLERK

Leeds General Infirmary – Chemical Pathology

Gained experience in database computer systems e.g. MAPIS, Telepath & dataease

Developed knowledge of word processor systems such as WordPerfect & Word 

Worked with & became skilled in spreadsheet systems such as Lotus 123 and Excel

Expanded knowledge and experience of database systems holding complex data

English 16+ C

Maths GCSE C

Human & Socal Biology GCSE C

Art O Level C

Art Diploma Lower Credit

RSA Typing Stage 1 Distinction