Colin MacKellar - Oracle DBA

Member of the British Computer Society (MBCS) and Chartered Information Technology Professional  

IBM / Prometrics

IBM Certified Database Associate - DB2 10.1 Fundamentals

Examination Institute for Information Science

ITIL® v3 Foundation Certificate

Kingston University

MSc Information Systems (Systems Engineering)

Systems Analysis Examination Board

Certificate of Proficiency in SSADM

GCE `A` Level:

Mathematics, Physics and Economics

June 2016 to June 2020

VIX Technology Ltd - Oracle Database Administrator

Production, test and development support for Oracle 10g, 11g & 12c databases up to 4.7 Tb under Solaris. Database monitoring with Nagios and custom scripts. RMAN & Netbackup for backup and DB cloning. Incident and problem investigation and resolution. Oracle upgrades and patching. Database hardening. Documentation and SQL tuning. Flexible remote & on-site support.

March 2015 to June 2016

Alert IT Ltd - Oracle Database Administrator

Production, test and development support for Oracle 10g, 11g & 12c databases up to 1 Tb under Linux & Windows for AlertIT's multiple customers. Database monitoring, backup and DB cloning. Incident and problem investigation and resolution. Oracle upgrades and patching. Documentation and SQL tuning.

September 2014 to March 2015.

Coventry Building Society - Oracle Database Administrator

Production, test and development support for Oracle 11gR2 databases up to 1 Tb under Solaris 10 on Sun hardware. Dataguard standby databases. Database monitoring using Oracle Grid or Enterprise Manager (OEM) and custom scripts. RMAN & Commvault for backup and DB cloning. Incident and problem investigation and resolution. Documentation and SQL tuning. Oracle patching and upgrades using opatch. PCI project and database hardening.

October 2013 to March 2014

BT Cornwall - Oracle Database Administrator

Production, test and development support for Oracle 10g and 11gR2 databases up to 450 Gb under Red Hat Linux 4 and 5 on Dell hardware, including 19 production and 55 development and test databases. RAC & ASM for OLTP and Data Warehouse. Database monitoring using Oracle Grid or Enterprise Manager (OEM) and custom scripts. RMAN & Netbackup for backup and DB cloning. Incident and problem investigation and resolution. Documentation and SQL tuning.

February 2013 to May 2013

Admin Re contract for MacKellar Limited - Oracle Database Administrator

Test and development support for Oracle 10g & 11gR2 databases up to 40 Gb under HP-UX 11 on HP Superdome hardware.  Build databases and associated environments including dataguard and streams replication to support offshore system testing.  Build and integrate databases for Serena Dimension Configuration management and release Automation to support automated delivery of code and database environments for development, test and production. Generate and review documentation relating to the project and its handover to production.

February 2012 to December 2012

RDB Concepts contract for MacKellar Limited - Oracle Database Administrator

Production, test and development support for Oracle 8i, 9i (9.2.0) & 11gR2 databases up to 250 Gb under Solaris 10 and Red Hat/Centos/Oracle Linux on Sun and Dell hardware, including 30 production and 15 development and test databases.  RAC & ASM for OLTP and Data Warehouse.  Database monitoring using Oracle Grid or Enterprise Manager (OEM) and custom scripts.  RMAN & Netbackup for backup and DB cloning.  Flexible remote & on-site support.  Advice and guidance on business continuity and ITIL process improvement.  Staff mentoring and training.

October 2010 to July 2011 and October 2011 to January 2012

Premier Farnell contract for MacKellar Limited - Database Administrator

Production, test and development support for Oracle 8i (8.1.7), 9i (9.2.0) & 11gR2 databases up to 300 Gb under Solaris 9 and Red Hat/Centos Linux on Sun and Dell hardware, including 6 production and 30 development and test databases.  RAC & ASM for live operational data store.  Database monitoring using Oracle Enterprise Manager (OEM) and custom scripts.  RMAN & Netbackup for backup and DB cloning.  Quest Shareplex data replication.  Documentation convergence from wiki and Clearspace to Sharepoint for DBA and operational processes.  Flexible remote & on-site support.  Advice and guidance on business continuity and ITIL process improvement.

January 2009 to October 2010

MacKellar Limited Technical Consultancy

Multiple engagements for clients including Alert IT, Apana Business Psychology, Bellamy Opticians, CQC Solutions, Hambledon Consulting.  DBA for production, test and development databases from Oracle 8 to 11g on Solaris and Red Hat Linux, remote & on-site.  Remote DBA support for Oracle 9i (9.2.0) & 10g database production systems on Windows.  Advice and guidance on business continuity, process improvement using ITIL processes and web site integration.  Installation of CA Clarity on Windows and Unix platforms.  Development of PL/SQL routines for Clarity backend processing and database application tuning.

July 2005 to February 2006
and June 2006 to October 2008

Siemens Metering Services (Nottingham)
Metering Systems. ­ Database Administrator

Production, test and development support for Oracle 8i (to 8.1.7), 9i (9.2.0) & 10g databases up to 450 Gb in Siemens Metering under Solaris 8 & 10 on Sun and Fujitsu hardware, including 65 production and 160 development and test databases.  Database monitoring using Oracle Enterprise Manager (OEM).  Proof of concept systems under Linux on Dell hardware.  Day-to-day control of Oracle backups and restores using RMAN with Netbackup.  Schema updates adhering to formal change control methods, coordinated with in-house and third party teams.  Database creation and cloning from production to development, improved speed of test DB provision by 50% and reliability by 100%.  Capacity planning for production databases.  Fault investigation – independent and with 3^rd parties.  Review security alerts and apply fixes or patches and work-rounds as appropriate.  Enhancement and production of configuration and process documentation including introduction of a new wiki.  Provision of advice and guidance to users and developers.  Advice and guidance for junior DBAs.  Introduction and advocacy of wiki for operational support content.  Flexible and continuous, remote and on-site support to business operations.

June 2001 to Nov 2004

Perot Systems Europe for UBS Private Banking (London)
European Wealth Management project. ­ Database Administrator

Support for Oracle 8i (to 8.1.7) & 9i (9.2.0) databases up to 260 Gb in the UBS Private Banking Europe division using Veritas Clustering for high availability in three member clusters with underlying EMC & HDS SANs under Solaris 8 on Sun and Fujitsu hardware, including 40 production and 150 other databases achieving 99.9% availability.  Advice and guidance to staff on design and system operability and stability plus Data Warehouse support.  Setup and maintenance of RMAN, Korn and SQL scripts for Oracle and Informix backups, maintenance and diagnostics, including integration with NetCool system management and setup of clustered Quest Foglight. SQL & database performance tuning.  Fault investigation and resolution – independent and with 3rd parties, including Oracle Transparent Gateway (OTG) connections to DB400.  DBMS patches & upgrades.  Support for Sybase 12.5, SQL Server 2000 and one Informix 9.2 database.  Capacity planning for all DBMSs.  Flexible and continuous, remote and on-site support to banking operations.  Deputy webmaster of www.iua.org.uk

2000 to June 2001

Perot Systems Europe for UBS Private Banking (Zürich)
Extranet Project.  Database Consultant

Support for Oracle databases in the MyUbs extranet project using replication for high availability under Solaris and NT.  Setup and maintenance of Korn, Z shell and SQL scripts for Oracle backups, maintenance and diagnostics.  Data model refinement and delivery into production of the initial 400 Gb database system on Solaris/OpenLAN Unix using Oracle/Designer 2000.  Webmaster of www.iua.org.uk