EXPERIENCE

I have over 15 years experience as a computer consultant. My primary focuses have been systems management and the training of my clients' staff.

I specialize in the implementation, deployment, integration, and operation of cross-platform information systems. I establish reliable, secure network architecture. I am also adept at defining, developing, and delivering enterprise reporting systems. I maintain information systems through their whole life-cycle: I aid clients through the development stage, which focusses on strategic, tactical, and operational decision making; I remain involved throughout the implementation and operation stages; I manage risk by ensuring network security, including data backups; and I oversee the required decommission of older systems to ensure a smooth transition to new, more forward-looking set-ups.

Because I am well-versed in many platforms (Oracle, Linux, BSD, Solaris, Microsoft, Perl, Java, and many Open Source projects), other clients hire me to train their IT departments or their end-users on the finer points of their new or existing systems. Often this requires an initial consultative process to determine how I can best help their staff work more efficiently. Once the immediate needs of the organization and/or its employees have been determined, I often customize the course material to fit.

VERSATILITY

I have experience in a wide range of environments. I have contracted with both public and private organizations. I have worked with municipal and provincial governments, crown corporations, retail chains, construction companies, and high-tech firms. My private sector clients range in size from small consultancies to Fortune 500 companies. I have worked with technophobes as well as major technological powerhouses. I have also had the privilege of working in numerous locations across North America. I love learning, keeping current, and stretching my knowledge base.

PROBLEM SOLVING SKILLS

My problem solving and prioritization skills consistently outperform my clients' expectations. I can quickly determine the source of most any problem and can direct people –from end user to upper management– towards a speedy and fiscally responsible resolution. Often these issues present with time constraints, but I am quite comfortable under such pressure.

PEOPLE SKILLS

I pride myself on my interpersonal and collaborative skills. I have a great ability to build enduring, beneficial relationships with all my customers. It is my priority to listen to their needs and goals and remain connected to them to ensure that their systems are achieving the company's objectives while also respecting its budgets. When my clients face IT challenges, I am their first point of contact. I am personally approachable and fully capable of conversing with both technician and layperson alike.

LEADERSHIP SKILLS

I am an innovative, results-driven, hands-on leader. I am often asked to assume the role of group facilitator, and I am capable of quickly integrating the resources of various people in order to achieve a common goal within a fixed period of time. My extensive experience as a trainer has honed my presentation skills, as well as my ability to quickly read and meet the needs of diverse groups of people. I respond well on-the-spot and at the front of a group.

RECENT CONSULTING ASSIGNMENTS

COMPLETE CONSULTING HISTORY

Oracle Corporation: 1998 – 2010 (Intermittent Ongoing)

Contract Corporate Trainer

Delivery of Database Administration, SQL, PL/SQL, and Oracle Application Server seminars across North America.

Chintz and Company: 1997 – 2010 (As required support)

Contract Linux, Network, and Database Administration

Designed/implemented/maintained a multi-tier production network architecture

Extensive formal planning and documentation for all activities

Responsible for company-wide systems and network security

Maintain all LAN and WAN Cisco and HP ProCurve network devices

Directly handled all equipment negotiations and purchasing

Create Perl scripts to automate Point of Sale configuration and deployment.

Install Oracle 9i with 2 instances (production, dev ), Oracle patching

Project manager for ERP implementations including GERS BigTicket (Oracle-based), Compiere (Oracle-based), and Magstar (Non-Oracle based)

ODBC setup and testing for application layer

Designed system for configuration file management

Implemented an rsync backup system

Design/implement of network-wide resource monitoring system (nagios)

Reported directly to CTO

Canadian Wheat Board: January 2010 – March 2010

Oracle Applications (EBS) Consultant

Provided consulting services on Oracle EBS and Financials Statement Generator Implementation.

Alberta Infrastructure: July - August 2009

Business Intelligence Consultant

Provided consulting services regarding EUL design and report development.

Developed and delivered a custom Oracle Business Intelligence seminar.

Manitoba Hydro: November 2007 – June 2009

OpenBSD and Solaris Consultant

Advise Manitoba Hydro on secure implementation of OpenBSD servers for their power monitoring facilities. Developed and delivered custom OpenBSD and Solaris seminars focused on secure deployments of OpenBSD firewall/gateways.

Canadian Wheat Board: May 2008 – February 2009

Business Intelligence Consultant

Provided consulting services regarding EUL design and report development.

Developed and delivered (12 times) two custom Oracle Business Intelligence seminar.

BC Ministry of Attorney General: April 2008

Contract Corporate Trainer

Developed and delivered a custom Business Process Execution Language seminar.

IBM - USA: 2005 – 2008

Contract Corporate Trainer

Linux Kernel Internals, Perl, UNIX System Administration training in many locations in the United States.

Travel.bc.ca Ltd: 2006

Contract Linux System Administrator and MySQL Database Administrator

Installation and configuration of Asterisk PBX and Digium hardware on CentOS Linux.

Leier Construction: 2005 – 2008

Contract Linux System Administrator and MySQL Database Administrator

Responsibility for company-wide systems and network security

Network design and security reviews

Responsible for network wide security

Ongoing maintenance of the samba, web, print, sFTP, DNS and mail servers.

Design and implementation of a daily backup plan (including MySQL data)

Hardware maintenance

Polar Bear Corporation: 2005 – 2006

Contract Oracle Database and Oracle Application Server Administrator on Linux

Installation of Oracle 10g database.

Installation and configure 10gR2AS.

Install and configure Oracle Portal.

Update Portal schema from 10.1.2.0.2 to 10.2.4

Support and maintain Oracle 10g production instances hosting meta-data repositories.

Support and maintain Oracle 10g Application Servers production deployments.

Apply database and application server patches.

Troubleshoot problems with dbconsole and iasconsole managers, Apache, OC4J instances, Oracle networking, and database performance.

Develop and Deploy Java EAR and WAR files in OC4J instances.

Configured JDBC thin connection data sources

Perform SQL tuning.

Cashline: 2004 – 2008

Contract Linux System Administrator and MySQL/QMail Administrator

Responsibility for company-wide Microsoft and Linux servers and network security

Network design and security reviews

Responsible for Sonicwall configuration and network wide security

Ongoing maintenance of the samba, web, print, sFTP, DNS and SMTP/POP/IMAP servers.

Design and implementation of a daily backup plan (including MySQL data)

Hardware maintenance

Empress Painting: 2003 – 2009

Contract Linux System Administrator and MySQL/Postfix/Apache Administrator

Responsibility for company-wide systems and network security

Network design and security reviews

Responsible for network wide security

Ongoing maintenance of the samba, web, print, sFTP, DNS and mail servers.

Design and implementation of a daily backup plan (including MySQL data)

Hardware maintenance

University of Victoria: 2002 – 2004

Contract Oracle Trainer

Delivery of Oracle Database Administration, SQL, PL/SQL, web-based seminars.

Nexient Corporation: 2001 – 2007

Contract Oracle Database and Application Server Administrator on Solaris and Linux

Support and maintain Oracle 10 production databases.

Support and maintain production Oracle 10 Application Servers.

Installation, patching and maintenance on Oracle Application Server Infrastructure and Middle Tiers.

Production Support of Oracle Application Server: WebCache/J2EE, Portal and Business Intelligence middle tiers.

Installation of Oracle 8, 9i and 10g database.

Installation and configure 9iAS and 10R2AS.

Install and configure Oracle Portal.

Update Portal schema from 10.1.2.0.2 to 10.2.4

Apply database and application server patches.

Troubleshoot problems with dbconsole and iasconsole managers, Apache, OC4J instances, Oracle networking, and database performance.

Develop and Deploy Java EAR and WAR files in OC4J instances.

Configured JDBC thin connection data sources

Write Perl scripts to monitor and maintain the Oracle Application Server Infrastructure database.

Troubleshoot database problems.

Oracle Performance tuning.

SQL Statement Tuning.

Municipal Software Corporation: 2001

Contract Oracle Database Administrator and Solaris System Administrator

Sun server setup including installation and configuration of Solaris to support Oracle.

Solaris patching, Oracle patching.

ODBC setup and testing for application layer.

Install Oracle 9i with 2 instances (production, sandbox )

Royal Roads University: 2001 – 2003

Contract Oracle Database Administrator and Solaris System Administrator

Troubleshoot problems with web server, web listener, forms server, and concurrent managers, and database.

Create test web server, web listeners, form servers, concurrent managers, and databases from the production environment.

Create tablespaces, tables, and users for custom applications.

Maintain user security.

Maintain Oracle schemas and SGA region.

Write Perl scripts to monitor and maintain the Oracle database.

Write SQL scripts to monitor tablespace and extent growth.

The Lodge at Broadmead: 2001 – 2003

Contract Oracle Database Administrator

Install Oracle 9i and create 3 instances (production, backup and sandbox )

Install Oracle Designer and repository.

Support and maintain Oracle 9i databases including production instances hosting Oracle Designer repositories.

Create Repository template and 2 repository test instances.

Troubleshoot Oracle WebDB problems.

Install Oracle software. Assess database migration requirements.

Migrate database to new server hardware.

QA migrated database and make recommendations.

Cromedica: 2001

Contract Oracle Clinical and Oracle Database Administrator on Solaris

Maintenance of existing Oracle database.

Troubleshoot database problems.

Write Perl scripts to monitor and maintain the Oracle database.

Write SQL scripts to monitor tablespace and extent growth.

General Physics Corporation: 1998 – 2000

Contract Oracle Database Administrator on Solaris

Database upgrades from 8.0.6 to 8.1.7 on Solaris

Install of Oracle 8i databases.

Troubleshoot database problems.

Oracle Net8 set-up and troubleshooting.

Oracle performance tuning.

Create the application tablespaces, tables, and indexes.

Write shell scripts to monitor database growth and gather statistics.

Write Perl scripts to automate Oracle database creation and configuration.

Centre for Education Information Standards & Services (CEISS): 1998

Contract Oracle Developer

Oracle Forms and Reports maintenance for an in-house contract management system

Province of British Columbia (Ministry of Skills Training, Labour): 1995 – 1997

Junior Oracle Forms and Reports Developer Contractor

Oracle Forms and Reports development for an in-house contract management system

Province of British Columbia (Ministry of Attorney General): 1994 – 1995

Database Contractor

Database design and implementation (Macintosh-based SuperCard database product.)

University of Victoria: 1991 – 1994

Junior Solaris (SunOS 4.1) System Administration

User account management

Print server management

Application Support

Perl scripting

PROFESSIONAL DEVELOPMENT

Oracle Certified Professional ( Oracle DBA 8 through 10g )

Sun Certified System Administrator (2001)

Certified Associate in Project Management (Project Management Institute, PMI)

QUALIFICATIONS

Master in Computer Science (University of Victoria)

Thesis: An Implementation of Prioritized Queries using the Google SOAP Search API

Master in Public Administration (University of Victoria)

Bachelor of Music (University of Victoria)

Bachelor of Science (University of Alberta)

TECHNICAL SKILLS

Operating Systems

14 years Linux (Ubuntu, Redhat, Debian, Gentoo, SuSE)

10 years *BSD (Emphasis on OpenBSD)

10 years MacOS X (Desktop)

18 years Solaris

Desktop support of Windows XP/Vista/7

Networking

Complete understanding of TCP/IP, UDP, ICMP

Network troubleshooting

Server interface configuration (Including bridging, VPN, and IPv6)

Physical network maintenance and upgrades

Cisco switch and router maintenance

Familiar with Intel's PXE netboot protocol

BOOTP

DHCP

SNMP

IPv6

Security

Advanced knowledge of Unix security

Secure internet services

LAN/WAN security, VPN, pptpd

Firewalls (Sonicwall, SnapGear, Cyberguard, Checkpoint, PF, netfilter)

IPSEC

Encryption (PGP, GnuPG, SSL)

Cyrus SASL

SSH (SSH v1, v2 and OpenSSH)

Host-based security: OS hardening, disabling or encrypting unsafe network services

Security Policy Design and Implementation

Network/Host Security Auditing

Software

Apache HTTP/HTTPS servers (versions 1.3.x/2.0), nginx

DNS (BIND 4/8/9)

Vi, and ViM

NFS

NIS/YP

NTP

POP, IMAP, IMAPS

PPP (OpenBSD Kernel PPP)

SMTP (Postfix, QMail, Exim, Sendmail, procmail)

Samba

Source code control (CVS, Subversion, Git)

X Window System (configuring servers, desktops, application servers, XDM)

Database Administration

Oracle ( Database and Application Server maintenance, tuning, troubleshooting, backups)

MySQL (installation, maintenance, backups, tuning, replication)

PostgreSQL (installation, maintenance, backups, SSL, ODBC)

Programming/Scripting

Systems automation and maintenance tasks, but some

Perl5

Shell scripting (Korn, Bash, sh)

Ruby

PL/SQL stored procedures and database triggers

Limited C debugging, make

Hardware

All forms of x86 hardware (from laptops to quad Xeon CPU servers)

Sun SPARC hardware including sun4c/sun4u, Ultra 5/10/60, E450

Cisco routers/switches

HP Procurve Managed Switches

Co-location facility experience, large server installations, racking, power management