|University of Calgary||October 2004 - January 2006||Senior Peoplesoft DBA and Administrator|
Senior Database Analyst and Administrator for the university’s Administrative Systems Renewal project implementing Peoplesoft Financial, Material Management, Human Resources, and Student Administration. Steered the databases from Peoplesoft install through go-live of the Financials implementation phase, including a successful switch to the standby database when a microcode bug caused block corruptions.
Provide overall leadership and technical support
for all core system (PeopleSoft – Financial, Materials
Management, Human Resources and Student Administration) database services
Ensure that external and internal regulations and policies governing data management are met including regulations concerning security, auditability and privacy.
Supervise, mentor and train other database staff.
Plan and coordinate database security measures and access controls.
Monitor the production database, application server, and web server and tune long running queries and processes.
Immediately, and single handedly, managed the implementation of Oracle databases for development, test and production of Peoplesoft Finance/Supply Chain Management, HR, and Student Administration. Continued to maintain multiple databases for each system including on-demand duplications and refreshes. 3 different and separate development groups meant managing 20 to 30 databases and associated middle tiers.
Proactively investigate performance characteristics of the expected production databases using open source tools (the Grinder).
Invent and implement a solution to prevent sql generated by psquery to consume too many database resources.
|Petro-Canada, Calgary||April 1990 - June 1996||Application Specialist|
In interaction with the users evaluate, develop and implement integrated client/server solutions to assist in meeting the clients’ business goals and objectives.
Advise and assist developers and management on issues regarding development tools, databases, communications, client/server architecture.
Contributed and participated as a core project team member in the successful delivery of a distributed General Ledger system (Peoplesoft GL with Oracle on AIX) in time and under budget. This system has improved the timeliness of financial reporting while giving online access to the underlying data. My main deliverables were: technical advisor to project leader and management - benchmarking and stress testing - architect the placement and integration of application, communication and database components - implement business rules using database triggers and stored procedures - performance tuning
Established the dynamic workstation configuration that became the basis for the standard workstation configuration in the corporate division.
Developed a Windows application to verify/create the necessary environment before starting other applications, resulting in simplified installs and fewer support calls.
Early adopter of object-oriented methodology. Evaluated development tools and recommended Powerbuilder for client/server development in 1992. Chaired the project that defined and established standards for Powerbuilder development.
Designed and implemented rules and procedures for source code control for the corporate division. Received favorable review for speed of implementation.
|Petro-Canada, Calgary||October 1985 - April 1990||Database Specialist|
Responsible for installation and maintenance of IMS DB/DC, DB2, SQL/DS, and related products. Formulated strategies and procedures related to databases and transaction monitors.
Led the project to review an acquired IMS-based software package. Identified and implemented changes which - without program modifications - resulted in substantial reduction of CPU consumption and improvements in on-line and batch performance.
Designed and programmed a DB2 call attach program interface that enabled a modular design of on-line applications.
Designed and implemented a user friendly menu front-end for IMS applications
|Canadian Utilities, Edmonton||September 1982 - October 1985||Systems Programmer|
Responsible for installation and maintenance of IMS DB/DC, CICS, DISOSS, ADABAS, NATURAL Developed crucial modifications to the original NATURAL/IMS interface to make it functional. Created an on-line ADABAS monitoring system under NATURAL.
|Sulzer Brothers, Switzerland||July 1979 - July 1982||Database Administrator|
Responsible for installation and maintenance of DL/1 in a CICS-DOS/VSE, later MVS, complex. Proposed and developed a CICS application which enabled operations to take applications on-line or off-line individually, without shutting down the system, increasing availability for unaffected applications.
|IBM Germany, Böblingen||June 1974 - July 1979||Systems Programmer|
In a team of two, designed and programmed the operating system kernel of a hardware test system for the 43xx series. We were both recognized with awards for our accomplishment.