Resume in Word Document format
23240 Twp 520 Cell: 780 913-9320
Canada T8B 1G3 E-mail: warren@regehr.com
Professional
Skills & Experience
2003
Lafarge Cement
Oracle Database Administrator
Server Tuning: Mar 2003
Inspected and made
recommendations for database tuning at the server level for
2002 – current (on going)
Technical Systems Analyst
Quality Assurance
Nov
2002 – Jan 2002
In a Quality Assurance role my
task has been to verify all documentation and update the information to current
levels as recommended by the Auditor General's report.
eCommerce Project
Nov 2002 – ongoing
Managing various eCommerce
applications being used by Alberta Revenue as they attempt to consolidate web
applications for Tobacco, LPG and Gasoline Exemptions, Hotel Tax and NHL
Players Tax. Duties included daily maintenance, scripting (Unix) to automate
all processes, troubleshooting and quality assurance implementations.
2000 - 2002
IBM Global Services, PeopleSoft Solution
Centre
Database Administrator and Web Server technical team
Data Warehousing project (Canadian Tire)
May 2002 – June 2002
Mainframe DB2 instance (ver.5
on OS/390) preparation for version upgrade.
Creation, deletion and tuning
of a remote databases.
Creation, deletion and
modification of base PeopleSoft tables for a data warehousing project.
Installation & Migration of a WebServer Project and Version Control
System (IBM)
November 2001 – May 2002
Acted as Oracle 8i DBA on NT system that
was migrated to a HP-UX Unix system.
Database tuning and optimising for 4
production and development instances.
Network configuration/troubleshooting (Net8
and TCP/IP).
Documentation and verification of
installation and environments.
Apache WebServer (1.3x) installation,
configuration and maintenance.
PVCS installation, upgrade and maintenance.
Various Software installation and upgrades
(NT and Unix)
System Upgrading & Maintenance (
September 2001 – November 2001
DB2 UDB maintenance (extent management,
alert logs and monitoring).
System upgrading for HP-UX, AIX Oracle
installations to new patch version 8.0 – 8.1.5.
New instance creation – 8i on AIX and HP-UX.
Third party vendor license verification and
renewal for BMC SQL*Backtrack for Oracle and Sybase database systems.
Installation of IBM national toolkit of
monitoring scripts.
PeopleSoft HRMS/Student
upgrade from version 7.0 to 7.62 (
January 2001 – June 2001
Migration, exports and imports
of Oracle-based vanilla PeopleSoft HRMS/Student database in parallel with a
highly customized existing version to a merged upgrade
Customization of PeopleSoft
Financials from version 6 to 7.5 (University of Alberta)
October 2000 – November 2000
Re-vamped cloning process used
to reproduce a production database for reporting database purposes.
Nightly batch stream process of PeopleSoft
applications (University of Alberta)
July 2000 – December 2000
Part of a 4-member DBA team responsible for
the maintenance, support and trouble-shooting of all problems that were
encountered in the database/client interface, network problems, backup/recovery
strategy, Unix shell scripting, database documentation and error-maintenance.
Continued documentation of process changes, revisions to existing hardware or
software set-up, error logs and corrective measures, instructional manuals.
2000
Database Administrator
Mar 2000 – June 2000
Was responsible for the nightly batch
stream process of Oracle-based PeopleSoft applications Part of a 4-member DBA
team responsible for the maintenance, support and trouble-shooting of all
problems that were encountered in the database/client interface, network
problems, backup/recovery strategy, Unix shell scripting, database
documentation and error-maintenance. Position was migrated to IBM Global who
became the outsource vendor for U of A ‘s Peoplesoft environment.
1995 to 1999
Lan Support, Tech Support and Instructor
September
1999 – December 1999
Software product testing as part of an
implementation considering the use of Oracle as the database of choice. Duties
included installation, database information loading (SQL*Loader), backup and
recovery scenario testing, PL/SQL script implementation and testing.
System Administrator / Lab Support
Sept 1995 – December 1999
Responsible for
connectivity (LAN) for multiple 24 station Windows/Macintosh computer labs.
Tech support for
all installed products (dBase IV, MSOffice, Aldus, Adobe…).
Instruction in
use of computers and programs to adult education courses ranging from.
introduction to computers to advanced database use including curriculum
material creation and implementation.
Education
Oracle Certified Professional
Database Administrator -
2000
IBM DB2 UDB certification - 2001
Bachelor of Education,
Courses
Performance Management
Communication Skills and Positive Attitude
Professional Vitality
Conquering Conflict Through Communication
Communication Tools
Oracle 8 Performance Tuning: Optimizing Sorts
and Minimizing Contention
Perl Basics