Professional Highlights:
• Installation, configuration and upgrading of Oracle server software and
related products
• Design and implement physical and logical layout of the database
• Performance Tuning of Database and Applications
• Implement data security
• Implement and maintain database security (create and manage users, roles
assign privileges)
• Implement backup and recovery procedures
• Capacity planning
• Install, clone, patch and configure Oracle Applications 11.5.9 & 12.0.4
• Shell and command scripting for automation of DBA tasks
• Set up and maintain documentation and standards
• Interface with Oracle Corporation for technical support to resolve issues
• Perform technical trouble shooting and provide support to development teams
• Solid understanding of multi-vendor platform environments
• Solid understanding of Oracle Technologies
Professional Experience
Jul. 00 – present
Epcor
Database Administrator
Upgrading Production & Test Oracle Applications environments from 10.7
to 12.0.4.
Cloning, patching, and tuning Oracle Databases from Oracle 7.3.4
through to Oracle 10g.
Upgraded Databases to Oracle 10.2.0.4.
Managing Production, Test, Acceptance and Development Oracle
databases.
Performing database tuning, recovery, troubleshooting and
optimization.
Providing support for Developers.
Environment: HPUX 11i, Oracle 7.3.4 through Oracle 10.2.0.4, Oracle
Applications 11.5.10, Oracle Replication, Oracle Tools suite
Aug. 98 – Jun. 00
Telus Geomatics
Database Consultant
Upgrading Production & Test environments to Oracle 8.0.5.
Upgraded Development environment to Oracle 8.1.5.
Managing Production, Test and Development Oracle databases.
Performing database tuning, recovery, troubleshooting and
optimization.
Implemented Oracle 8 Spatial Cartridge (relational & objects model).
Loading data for Oracle Spatial Data Warehouse.
Providing support for GeoMedia Developers.
Environment: Integraph IS9000, Windows NT 4.0, Oracle 7.3.4 through Oracle
8.1.5, Oracle Spatial Data Cartridge, PL/SQL
May 98 – Aug. 98
Calgary Board of Education
Database Consultant
Strategic planning for upgrade to Oracle Financials 10.7 NCA.
Managing Production and Test Oracle Financials databases.
Performing database tuning, troubleshooting and optimization.
Providing knowledge transfer of DBA skills.
Environment: Dec Alpha 2100, Open VMS 6.2, Open VMS 7.1, Windows 95, Oracle
7.x, Oracle Financials 10.5, Oracle Forms 3.0, PL/SQL
Feb. 98 GeoPower Technologies Inc.
Database Consultant
Installed databases and provided trouble shooting support for GeoPower
clients.
Provided consulting services.
Environment: Sun UltraSparc 170, Solaris, Unix, Windows NT, Windows 95, Oracle
7.x, Oracle Forms 3.0, PL/SQL, Vi.
June 95 – May 98
City of Edmonton
Planning & Development
Technical Architect/Database Administrator
Completed Proof of Concept of SilverStream Designer.
Managed Production, Test, and Development environments for Oracle 7.x
and Oracle 8.x distributed database applications.
Performed database tuning, implemented security with roles, grants,
privileges.
Created PL/SQL stored procedures, packages and triggers.
Created Unix shell scripts to automate database monitoring and nightly
exports.
Installed and Upgraded Oracle Software.
Environment: Sun Sparc 4000, Sun Sparc 1000, Sun Sparc 20, Sun Sparc 10, Sun
Os, Solaris, Unix, Windows NT, Windows 95, Windows 3.x, Oracle 7.x, Oracle 8.x,
PL/SQL, PowerBuilder, Vi, AWK.
May 94 – Jun. 95
Shukle Computer Consulting
Information Systems Consultant
Developed PB 4.0 application for City of Edmonton.
Upgraded PB 2.0 application to PB 4.0.
Provided support for Web based applications, ECSMail, and Netscape
2.0.
Environment: Sun Sparc 4000, Sun Sparc 1000, Sun Sparc 20, Sun Sparc 10, Sun
Os, Solaris, Unix, Windows NT, Windows 95, Windows 3.x, Oracle 7.x, PL/SQL,
PowerBuilder, Vi, AWK.
Nov. 93 – May 94
City of Edmonton
Planning & Development
Programmer/Analyst
Provided software development, documentation, maintenance and support
of existing PowerHouse VAX/VMS System.
Provided PC support, software installation and network maintenance.
Environment: Digital 3400, Vax/VMS, Basic, PowerHouse, EDT, EVE
Mar. 90 – Nov. 93
Royal Alexandra Hospitals
Programmer/Analyst
Design and developed VAX BASIC Nursing Lab Order Entry system.
Developed interface between admitting system and purchased LabVision
software.
Provided maintenance and backup of LabVision database.
Provided liaison between LabVision vendor and software user group.
Environment: Vax Cluster, Vax/VMS, Basic, M Technology, EDT
Apr. 89 – Feb. 90 Sierra
Systems Consultants Ltd.
Computer Consultant
Developed province wide PowerHouse Student Level Data Collection system
for Ministry of Education.
Provided microcomputer support for Ministries of Finance and Regional
Development.
Environment: Vax Cluster, Vax/VMS, Basic, PowerHouse, Datatrieve, EVE, EDT
Oct. 88 – Mar. 89
Alberta Dept. Of Health
SYSTEMS ANALYST
Developed DBASE IV Aids Information Library System.
Maintained Environmental Health Information System.
Environment: IBM 30xx, IBM PC compatible, MSDOS, Clipper, Dbase IV
EDUCATION
1986 - 1988 N.A.I.T.
Edmonton, Alberta
Computer Systems Diploma.
1983 - 1985 UNIVERSITY OF ALBERTA
Edmonton, Alberta
B.A. with major in Economics and minor in Sociology.
1981 - 1983 CAMROSE LUTHERAN COLLEGE
Completed two years of Business Administration program, transferable to U. of A.
degree.
ADDITIONAL TRAINING
Maintaining Sql Server 2008 (2009)
Implementing Sql Server 2005 (2009)
Oracle 8 Spatial – Oracle Canada (2003)
Oracle 8 Advanced Replication – Oracle Canada (2000)
RedBrick DataWarehouse Administration – RedBrick Software Training
(1998)
Introduction to Java Programming - Sun Educational Services (1998)
Oracle Performance and Tuning Workshop - Oracle Canada (1997)
Advanced DataWindow Design - Computronix (1995)
Introduction to PowerBuilder – Computronix (1994)
Introduction to Oracle - N.A.I.T. MicroComputer Centre (1993)
|
