Summary

Overview

Work History

Education

Skills

Interests

Timeline

ROBERT WHITE

Summary

Mr. White has over twenty (20) years of experience working with, implementing, and upgrading Oracle RDBMS Enterprise Database, Oracle E-Business Suite, Oracle Enterprise Manager (Cloud Control) and other products including Portal, Developer and Designer Suites, Azure, hardware architecture configurations coupled with a variety of platforms and technologies. Using his wide variety of technical skills, over the past few years, Mr. White has acted in a Database Administrator (DBA) or Technical Lead on several projects. As a senior Oracle DBA, he performs all the expected database related tasks and acts as an advisor to others. As a technical lead, Mr. White has overseen teams of personnel focused on technical issues, including software development and project release schedules. In addition to hiring and training staff and delegating work assignments he has also collaborated with colleagues to identify and repair technical issues.

Overview

years of professional experience

Language

Work History

Database Administrator

25, Oceans Canada

Production and non-production Support
Oracle Enterprise Manager Cloud Control Upgrade Lead

senior DBA, Technical Support Specialist

12.2019 - 03.2025

Mr
White acts in a dual role, as a
His duties include all DBA related tasks for 19c, 12c, 11g database instances including upgrades, patching, rman backups and network/LAN infrastructure support
He also leads the Oracle Enterprise Manager Cloud Control upgrade project
Database Administrator: o 19c, 12x, 11x Installations, configurations and upgrading
O Oracle Enterprise Manager Cloud Control to monitor enterprise level targets including database instances, servers and middleware
O Daily database maintenance and teaks as required
O Administration of RedHat Linux servers
Lead Technical Analyst for Oracle Enterprise Manager Cloud Control Upgrade: o Upgrade Oracle EMCC repository from 11g the 12 o Upgrade Oracle EMCC system from 12c to 13c o All non-production environments built on Virtual Machine’s
Environment: IBM Power – AIX, Red Hat 6,7,8, SQL, Oracle Enterprise Manager Cloud Control 13c and 13c
Oracle Database Server 11, 12 single and multi-tenant databases, 18, 19
Project 24
Oracle Financials Cluster Group
Government Standards Development and Implementation Testing
Perforce Suite Support and Maintenance

DBA / Lead Technical Analyst, Senior E-Business Suite Programmer / Analyst

09.2011 - Current

Technical Support Specialist, Lead Technical Analyst

The Oracle

Financials Cluster Group (OFCG) is comprised of the following federal government agencies; EC
DFO, TC, INAC, CSC, NFB and Telefilm
The OFCG maintains and supports E-Business Suite versions 12.1.x and 11.5.10.2
Supported modules include Payables, Purchasing, and General Ledger, Fixed Assets
Receivables, iProcurement and custom modules including PWGSC Receiver General Interfaces
The technical framework is currently on a one- and two-tier architecture using Oracle RDBMS 10G and 11G on multiple IBM Power - Linux servers
Mr
White acts in a dual role, as a senior DBA, and Programmer / Analyst
His duties include all DBA related tasks for 12+ instances including upgrades, patching and network/LAN infrastructure support
He is also a programmer /analyst who writes and maintains Oracle Financials Cluster
Group patches and custom code including the Government of Canada Receiver General Interfaces (RGI)
He also maintains, configures, and supports Perforce TestTrack Pro, Perforce Surround Source Code
Management and Perforce Licence servers
Oracle E-Business Suite DBA /Technical Analyst: o Maintain and test financials standards for various government agencies
O 12x, 11x Installations and configurations, cloning and upgrading procedures
O Quality assurance, development of test plans, test execution, and results analysis o Oracle Enterprise Manager (OEM) to monitor system and server/CPU performance
O Government Receiver General Interfaces (FIS) maintenance o Daily database maintenance, system performance monitoring and tuning o “adautoconfig” and “adclone” methodologies used for instance mirroring
O Perforce Suite installation, configuration, and maintenance o Administration of RedHat Linux servers
Consultation regarding server configuration with IT Group o Server upgrade risk assessment analysis o Volumetric analysis and planning
Oracle E-Business Suite Programmer /Analyst: o Write, maintain, and troubleshoot custom code for all Oracle Financials Cluster Group custom applications, including Receiver General Interfaces o Modify GL, AP, AR, PO as required to support RGIs
O Create, customize, and troubleshoot Oracle forms and reports for Oracle EBS 12.x and 11i o Create, Test, and post all Oracle Financials Cluster Group RGI patches for EBS 12x and 11i (All patches are posted to Sitescape for client access)
Perforce Analyst and Technical Support: o Installation, configuration, maintenance, backups, and upgrades of Perforce Test Track Pro ticket tracking application o Installation, configuration, maintenance, backups, and upgrades of Perforce Surround SCM code versioning management system application
O Installation, configuration, maintenance, backups, and upgrades of Perforce License Server o Perforce user license maintenance
Environment: IBM Power - Red Hat ES5.4 Linux 64bit /32bit, Windows AD-utilities, SQL, Oracle Applications
EBS 12x, 11x, Self Service Framework utilizing Java, ASP, JSP, FIS – Receiver General Interfaces, Oracle Server 11, Perforce Suite of Products
Projects 23
Canadian National Laboratories (CNL)
Financial and Earned Value Reporting Project (MERLIN)

Agile Release Lead/Coordinator, Technical Lead

Canadian National Laboratories

07.2018 - 11.2019

Merlin is an enterprise-wide business reporting solution that uses robust technology and rigorous data governance to ensure the right information at the right time to the right people allowing CNL to make better decisions and instil trust and confidence in stakeholders
It is a reporting and analytics (Cognos) tool that accurately brings together data from different source systems (e.g., Cobra (financial), Oracle E-Business Suite, Oracle Primavera P6, EVMS) to create a reliable single source of business performance information for reporting and analysis purposes
Mr
White acted in several roles but acted primarily as the Release Management Lead for the project
His duties included all phases of the release management process, including the initial planning and design, developmental code management including code review, deployment to all environment levels including
Development, Training, and QA, Testing, and Production environments
Release Management Lead: o Manage and report defects to client while coordinating discussions between testing and development management teams
O Assist in providing project management guidance and issue/risk resolution
O Provided data collection from a wide range of sources; interacted and presented to IT and infrastructure support staff
O Assisted Project Management teams to ensure successful application releases while making certain best practices were adhered to
O Project Management: releases, scheduling
O Introduced Change and Release Management methodologies which integrated all disparate functions under one centrally managed area
O Operated at an advisory level, consistently interacting with IT to improve Release management processes
O Designed and managed the Release Management System that supported Release
Management Methodology and processes across all teams
O Coordinated Testing (Unit, System Integration, and User Acceptance) with Release
Management pre and postproduction deployments
O Completed and maintained hierarchy for Release process documentation library
Technical Lead: o Coordinate all changes with client and project team
O Coordinate all testing (Unit, System Integration and UAT) o Meet with clients to discuss requirements and expectations
O Task Management
Environment: Suite of physical and virtual hosts running Windows Server
Dell Boomi Data Integration
Cognos Analytics Business Intelligence, Microsoft SQL Server, Oracle E-Business Suite, Cobra Financials
Database, Oracle Primavera P6, other databases and source systems
Projects, Design Plan Package Project (DPP

Agile Release Lead/Coordinator, Technical Lead

Laboratories

04.2018 - 08.2018

Design Plan Package (DPP) is custom web application which was added as a major enhancement to an existing system, Engineering Change Control (ECC)
The primary purpose of the application is to provide users a web-based interface to request engineering assistance
Mr
White acted as the Release Management Lead but also participated in the development including data analysis
His duties included all phases of the release process including the Plan, Develop, Initial Deploy
Test, Release, Operational (deploy to Production)
Release Management Lead: o Manage and report deficiencies to client while coordinating solutions and discussions between testing and project development team
O Assist in providing project management guidance and issue/risk resolution
O Assisted Project Management teams to ensure successful application releases while making certain best practices were adhered to
O Introduced Change and Release Management methodologies which integrated all disparate functions under one centrally managed area
O Operated at an advisory level, consistently interacting with IT to improve Release management processes
O Designed and managed the Release Management System that supported Release
Management Methodology and processes across all teams
O Coordinated Testing (Unit, System Integration, and User Acceptance) with Release
Management pre and postproduction deployments
O Completed and maintained hierarchy for Release process documentation library
Technical Lead: o Manage development team
O Coordinate all changes with client and project team
O Coordinate all testing (Unit, System Integration and UAT) o Meet with clients to discuss requirements and expectations
O Task Management
Environment: Suite physical and virtual hosts running Windows Server
TOAD management toolset
Microsoft SQL Server database toolset (SSIS, SSMS, .net)
Several Oracle databases
Projects 21
Canadian National, (CNL)
Earned Value Management System Project (EVMS)

Agile Release Lead/Coordinator, Technical Lead

Microsoft

02.2018 - 05.2018

An Earned Value Management System (EVMS) was implemented as a tool which allows project managers to measure project performance across an enterprise
It is a used to find variances in projects based on the comparison of work planned and work performed
Earned Value Management is used on the cost and schedule control and can be very useful in project forecasting
Point-in-time baseline serves as a reference point for all other EVM related activities
The overall purpose of EVM is to provide quantitative data for project decision making
Mr
White acted primarily as the Release Management Lead but also as a data analyst
His duties included all phases of the release process including Plan, Develop, Initial Deploy, Test, Release, Operational (deploy to
Production)
Release Management Lead: o Manage and report defects to client while coordinating discussions between testing and project management teams
O Assist in providing project management guidance and issue/risk resolution
O Provided data collection from a wide range of sources; interacted and presented to executive and technical staff
O Assisted Project Management teams to ensure successful application releases while making certain best practices were adhered to
O Project Management: releases, scheduling with vendor interaction
O Introduced Change and Release Management methodologies which integrated all disparate functions under one centrally managed area
O Operated at an advisory level, consistently interacting with IT to improve Release management processes
O Designed and managed the Release Management System that supported Release
Management Methodology and processes across all teams
O Coordinated Testing (Unit, System Integration, and User Acceptance) with Release
Management pre and postproduction deployments
O Completed and maintained hierarchy for Release process documentation library
Technical Lead: o Lead development team o Coordinate all changes with client and project team
O Coordinate all testing (Unit, System Integration and UAT) o Meet with clients to discuss requirements and expectations
Environment: Suite of physical and virtual hosts running Windows Server
TOAD management toolset
SQL Server database toolset (SSIS, SSMS, .net)
Several Oracle databases as source systems
Project 20
Canadian National Laboratories
Environmental Data Management System (EDMS) Implementation Project

Senior Data Migration Analyst

Database Data Analyst

Microsoft

05.2016 - 02.2018

EQuIS for ArcGIS Implementation Configuration Specialist
Agile Release Lead, CNL is Canada’s premier nuclear science and technology organization
CNL is a world leader in developing peaceful and innovative applications from nuclear technology through its expertise in physics, metallurgy, chemistry, biology, and engineering
EDMS is an enterprise level data consolidation initiative
The result allows CNL to implement mapping applications that offer geospatial data on demand
The technical framework consists of a four-tier suite of Enterprise Windows and virtual servers hosting SQL Server
Enterprise, EQuIS Data Management and Geocortex with ArcGIS mapping
Mr
White acts in a dual role, as a data analyst /migration specialist and EQuIS Applications Specialist
His duties include data analysis across multiple formats including SQL Server, Oracle RDBMS, MS Access, Excel, Adobe PDF, and multiple image formats
All data is analysed and consolidated into a common format using a combination of SQL, VBA, and MS PowerShell
Agile Release Management Lead: o Coordinate release schedule for EarthSoft EQuIS, ArcGIS and Geocortex applications o Coordinate and perform EarthSoft EQuIS and Geocortex training sessions to facilitate the transition to newly created environment
Data analysis for EDMS in multiple formats including SQL Server, MS Access, Oracle Data analyst /migration specialist: o Consultation regarding server configuration for SQL Server 2012 o Consultation regarding server configuration for EQuIS Professional o Data analysis for EDMS in multiple formats including SQL Server, MS Access, Oracle
RDBMS, MS Excel, and external files
O Data Gathering from 39 data owners
O Data Cleansing and Transformation to consolidate data into 16 distinct formats
Geocortex Technical Specialist: o Oversee a team responsible for the creation and implantation of custom database objects to support workflows in Geocortex
EQuIS Enterprise Specialist: o Consultation regarding server configuration with IT Group o Install and configure EQuIS Professional Data Management toolset o Utilize EQuIS toolset including EQuIS Data Processor (EDP), Data Entry/Edit, Data Analysis and Data Querying o Develop and integrate EQuIS templates for data import and validation
O Train and Support clients in the use of EQuIS Professional and EQuIS Enterprise
Environment: Suite physical and virtual hosts running Windows Server
TOAD for SQL Server management toolset
Microsoft SQL Server database toolset
EQuIS Professional and Enterprise suite
Geocortex user interface with ArcGIS mapping layer using EQuIS Professional Data Management
Microsoft PowerShell task automation and configuration management framework
Visual Basic for Applications (VBA)
Project 19
ORACLE FINANCIALS SHARED SYSTEM PROJECT
Government Oracle Financials Shared System (OFSS) Implementation

Senior Applications DBA / Technical Analyst / Infrastructure Analyst

Problem Resolution & Source Code Management Administration
Perforce Suite Support and Maintenance

Technical Analyst

06.2009 - 04.2010

The Oracle Financials Shared System Project is a version 12 Implementation of Oracle Financials
This system is designed in accordance with five federal government agencies (EC, DFO, TC, INAC, and CSC) and includes Payables, Purchasing, General Ledger, Fixed Assets, Receivables, Asset Life Management, iProcurement, Projects and PWGSC Receiver General Interfaces
The technical framework is currently on a two-tier architecture using Oracle RDBMS 11G on an HP Linux 64bit server – using Red Hat Linux ES 5.4
The current implementation involves the conversion of 11.5.9 and 11.5.10 data into a pre-configured 12.1.2 environment
As a Senior Applications DBA, / Infrastructure Analyst and a Problem Resolution & Source
Code Management Administrator, some of Mr
White’s duties included:
Oracle E-Business Suite 12: o Defined, created, and maintained new database structures, primarily custom object schemas – e.g., xxdtc – for DRCTC and xxgac – for Government Acquisition Card o Performed installation of version 12x migrating from EBS v11i and technical configuration
O Providing technical support of EBS version 12x o Implement and test financials standards for various government agencies and interfaces
O Completed 12x Installations and configurations, cloning and upgrading procedures
O Oracle Enterprise Manager (OEM) to monitor system and server/CPU performance
O Performed Government Receiver General Interfaces (FIS) maintenance – modified/updated tables for RGI interfaces - SPS, SPS-IS, RPS, CFMRS, GBS and CRA o Developed and maintained SQL and PL/SQL scripting to perform data loads and conversions for all RGI tables as well as cluster delivered applications (GAC, DRCTC, STS) o Quality assurance, development of test plans, test execution, and results analysis o Developed shell scripts as part of general maintenance supporting Red Hat Linux – running system administration processes, batch jobs, etc
O Performed daily database maintenance, system performance monitoring and tuning
O Set up “adautoconfig” and “adclone” methodologies used for instance mirroring
O Performed evaluation of system performance, noted issues, and followed up to resolve these, used My Oracle Support (formerly Metalink) to research solutions, submit service requests and monitor progress
Documenting fixes as required
Technical Analyst: o Establish server configuration hierarchy with hosting agency
O Server upgrade risk assessment analysis
Infrastructure Working Group (Analyst): o Hardware analysis and recommendations o Customization’s porting and import methodology
O Data conversion strategy and implementation o Implement and enforce Oracle custom code standards
O Data warehouse feed strategies o Server upgrade risk assessment analysis
Perforce Analyst and Technical Support: o Installation, configuration, maintenance, backups, and upgrades of Perforce Test Track Pro ticket tracking application o Installation, configuration, maintenance, backups, and upgrades of Perforce Surround
Source Code Management (SSCM) application o Installation, configuration, maintenance, backups, and upgrades of Perforce License Server o Perforce user license maintenance
Environment: Red Hat Linux ES 5.4, AD-utilities, SQL, Oracle Applications 12.1.2, Self Service Framework utilizing Java, ASP, JSP, Oracle Server 11.2.0.1, Perforce Suite of Products
Project 18
ENVIRONMENT

Oracle Applications Troubleshooting Senior Consultant

DBA Lead Technical Analyst, Programmer Analyst

09.2010 - 08.2011

Environment Canada’s 11.5.10 Oracle Financials implementation (Merlin) includes Payables, Purchasing
General Ledger, Fixed Assets, and Receivables, Asset Life Management, iProcurement and PWGSC Receiver
General Interfaces
The technical framework is currently on a two-tier architecture, recently migrated from, TRU64 to RedHat Linux
The current implementation is focused on Oracle Enterprise GRID Control as well as the development of a migration strategy of Oracle E-Business Suite (EBS) from version 11.5.10 to
Release 12
Mr
White is contracted to provide application support and leadership and assistance to EC DBA staff and consultants during their various Oracle Financials upgrades and database/OS on-going support issues
All duties have thus far been performed on time and within budget to the satisfaction of the client
Database Administration: o Performed system tuning, monitoring, troubleshooting and general maintenance
O Installations, upgrading / patching
O Used Oracle OEM - GRID control administration – performed administration of various agents (collection, aggregation, repository) o Performed installation & technical configuration of Oracle EBS 11i in HP Tru64 and Linux environments o Created new database structures as required including custom object schemas – e.g., xxdtc – for DRCTC and xxgac – for Government Acquisition Card o Developed data conversion strategy to R12 using SQL and PL/SQL scripting to process tables and to verify and validate conversion results
O Developed and implemented security mechanisms (IT/Controls as directed by Ernst &
Young) to control user accounts and application access
O Develop and coordinate back-up, disaster recovery and virus protection procedures
O Performed UNIX shell scripting in HP Tru64 and Linux for system administration, running batch jobs
O Provided maintenance support and custom configuration for iAS 1.0.2.2.2s in support of web access administration and configuration – through editing of site and listener configuration files
O Completed configuration of shadow copying for databases
O Managed HP TRU64 to RedHat Linux migration – also performed installation over 3-month period of Oracle EBS 11i on RedHat Linux ES 5 but encountered program conflicts which required the Linux environment to be downgraded to ES4.5 o Maintained, debugged, and modified SQL and PL/SQL scripting as well as providing performance tuning
O Applications troubleshooting on ad-hoc basis
Performed evaluation of system performance, noted issues, and followed up to resolve these, used My Oracle Support (formerly Metalink) to research solutions, submit service requests and monitor progress
Documenting fixes as required
O Completed DB Installations, cloning, upgrading and patching procedures
O Daily performance of Database maintenance, system performance monitoring and tuning o Configured shell script “adautoconfig” and “adclone” methodologies used for instance mirroring
Programmer Analyst with Oracle Applications Financials:
Mr
White performed the following activities providing ongoing maintenance for all Government
Receiver General Interfaces (FIS) including working on related supporting modules GL, AP, AR, and
PO: o Modified and maintained physical data models using GL, AP, AR & PO as required to support various RGI interfaces and cluster applications
O Set up, registered, and maintained programs, system profiles and value set definitions in
Oracle EBS Application Object Library for financial applications – including all RGI interfaces supporting FIS (SPS, SPS-IS, RPS, CFMRS, GBS and CRA) as well as cluster solutions (GAC
DRCTC, CLCA) o Developed SQL and PL/SQL scripting to load data from external RGI systems into Oracle tables to support FIS tracking and reporting
O Analyzed and used open interface tables to support data loads and conversion (v11i to R12) as well as configuring data feeds for RGI interfaces and cluster applications
O Developing Oracle Forms and Reports using Developer 6i to support FIS requirements for financial reporting– troubleshoot and maintain custom Merlin reports
O Troubleshooting and maintaining Forms using Developer 6i – data entry/update Forms developed for users to access RGI tables
O Troubleshooting problems and maintaining applications during Oracle EBS 11.5.10 to R12 migration – tested RGI interfaces and cluster delivered solutions – modified code as required to develop fixes
O Performed maintenance and troubleshooting for Java servlets through Java Server Pages such as login issues identified by users; also coded customizations for JSP banners for the
R12 upgrade and for client notifications of maintenance events – updated AOL with value sets, program registration, etc
Used jDeveloper within Oracle Application Framework to perform all development, optimizing and testing activities
Lead Technical Analyst: o Consultation regarding new server architecture o Analyzed and recommended Server upgrade options
Environment: Red Hat Linux ES 4.5 running on IBM Servers – migrated from HP TRU64, Oracle Applications
EBS 11i, SQL, Self Service Framework utilizing Java, ASP, JSP, RDBMS 10G, Oracle Financials Cluster
Receiver General Interface Customizations (FIS-RGI)
Project 17
COGNOS
Oracle Financials 11.5.9 Upgrade + Time & Labour Projects

Senior Applications Database Administrator

THE PYTHIAN GROUP

08.2004 - 12.2004

Perforce Suite Support and Maintenance, Cognos 11i Oracle Financials implementation includes Payables, Purchasing, General Ledger, Fixed Assets, and Receivables
The technical framework is currently on a two-tier architecture using Oracle RDBMS 10G on a Sun Solaris server
As a Senior Applications Database Administrator, some of Mr
White’s duties included: o Developed and coordinated back-up, disaster recovery and virus protection procedures
O Performed UNIX shell scripting in Sun Solaris for server builds, daily system administration and batch jobs
O Provided SQL and PL/SQL scripting for queries and performance tuning
Oracle Financials 11.5.9 Upgrade: o Developed methodology to upgrade all instances to 11.5.9
O Quality assurance, development of test plans, test execution, results analysis, and documentation for implementation Oracle Financials 11.5.7 o Daily database maintenance, system performance monitoring and tuning o Rapid clone methodology utilized for instance mirroring
Technical Analyst for Oracle Time & Labour and Projects: o Consultation regarding technical requirements for new modules o Assisted in development of methodology to implement Oracle Time & Labour and Oracle
Projects, Sun Solaris, Oracle Applications 11.5.9 Self Service Framework utilizing Java, ASP, JSP AD- utilities, SQL, Oracle Server 8x, 9x
Project 16

Senior Applications DBA / Lead Technical Analyst

Financials Cloning and Support

12.2003 - 02.2004

The Pythian Group maintains a variety of different systems and versions of Oracle Applications for many different clients
As a Senior Applications DBA / Lead Technical Analyst providing problem solving and solutions for clients, some of Mr
White’s duties included:
11i Cloning and support
Daily database maintenance, system performance monitoring and tuning
Rapid clone” methodology used for instance mirroring
Environment: Linux 2.4.9 e.24 ES, Oracle Applications 11.5.7 Java, Dynamic HTML, AD-utilities, SQL, Oracle
Server 8x
Project 15

Senior Applications DBA / Technical Programmer Analyst

FEDERAL ORACLE FINANCIALS CLUSTER GROUP

04.2003 - 04.2010

Government Standards Development and Implementation Testing Portal Configuration and Maintenance, Oracle Financials Cluster Group (OFCG) is comprised of the following federal government agencies; EC
DFO, TC, INAC, CSC, NFB
The OFCG 11.5.8, 11.5.9, 11.5.10 Oracle Financials implementations included
Payables, Purchasing, General Ledger, Fixed Assets, Receivables, iProcurement and PWGSC Receiver
General Interfaces
The technical framework is currently on a one- and two-tier architecture using Oracle
RDBMS 10G on an HP Linux server
As a Senior Applications DBA / Technical Programmer Analyst, some of Mr
White’s duties included:
Oracle Applications Financials: o Built packages and deployed patches for RGI interfaces using Sitescape - RGI interfaces supporting FIS (SPS, SPS-IS, RPS, CFMRS, GBS and CRA) as well as cluster solutions (GAC
DRCTC, CLCA) o Performed all installations of Oracle Financials 11i and completed technical configuration of environment
O Generated databases as required for each version instance – maintained configuration control of databases, performed Daily database maintenance, system performance monitoring and tuning
O Maintained and tested financials standards for various government agencies o Supported and maintained 12x, 11x Installations, cloning and upgrading procedures
O Used Oracle Enterprise Manager (OEM) to monitor system and server/CPU performance and to administer agents
O Provided troubleshooting and maintenance for Workflow 2.6 because of upgrades to Oracle
Financials – verified and validated Workflow processing for sending and receiving events
O Performed Government Receiver General Interfaces (FIS) maintenance – tweaked and maintained physical data models supporting GL, AP, AR, PO and working with open interface tables to configure the RGI interfaces
O Troubleshooting RGI code to develop fixes including customizations – verified functionality of associated forms and reports through regression testing
O Configured and maintained AOL to ensure program registration, system profiles and value sets in Application Object Library – including all RGI interfaces supporting FIS (SPS, SPS-IS
RPS, CFMRS, GBS and CRA) as well as cluster solutions (GAC, DRCTC) o Developed SQL and PL/SQL scripts to provide ad hoc queries and maintain RGI tables – used commands in Forms to provide complex updating functions
O Performed Quality assurance, development of test plans, unit and integration test execution, and results analysis
O Developed UNIX shell scripts as required for system administration, file maintenance, running batch jobs
O Set up “adautoconfig” and “adclone” methodologies used for instance mirroring
O Performed Oracle Portal (9iAS – v1.0.2.2.2s) installation and configuration
O Developing and maintaining Oracle Forms and Reports using Developer 6i to support various FIS tracking and reporting requirements as well as Government Acquisition Card
DRCTC and cluster group tools (CGT) o Testing and troubleshooting problems in all RGI interfaces, cluster solutions and related
Forms and Reports – modified code as required to apply fixes
O Provided consultation regarding server configuration with IT Group
O Server upgrade risk assessment analysis
Perforce Suite of Products Implementation: o Installation, configuration, maintenance, backups, and upgrades of Perforce Test Track Pro ticket tracking application o Installation, configuration, maintenance, backups, and upgrades of Perforce Surround
Source Code Management (SSCM) application o Installation, configuration, maintenance, backups, and upgrades of Perforce License Server o Perforce user license maintenance
Environment: HP Tru64 UNIX, Red Hat ES Linux, WinNT, AD-utilities, SQL, Oracle Applications 12x, 11i, Self
Service Framework utilizing Java, ASP, JSP, Oracle Server 7x, 8x, 9x, Perforce Suite of Products
Project 14
COGNOS
Oracle Financials 11i Implementation (Upgrade from 11.5.5)

Lead Applications Database Administrator

CANADIAN UNION OF POSTAL WORKERS

08.2002 - 07.2003

Cognos 11i Oracle Financials implementation includes Payables, Purchasing, General Ledger, Fixed Assets, and Receivables
The technical framework is currently on a two-tier architecture using Oracle RDBMS 9i on a
Sun Solaris server
The project involved an upgrade of Oracle Financials from 11.5.5 to 11.5.8
As an Applications Database Administrator, some of Mr
White’s duties included:
Provided consultation regarding server configuration with SUN Microsystems
Designed and implemented a multi-tiered system for Oracle Financials 11.5.8 performing 11.5.8
Installations and patch applications and technical configuration
Developed SQL and PL/SQL scripting for data conversion between Oracle versions for GL, AR, AP
FA, and PO
Performed an upgrade to Workflow 2.6 for client, configuring Business Even System, set up mailers and notifications as required
Performed Quality assurance, development of test plans, test execution, results analysis, and documentation for implementation of Oracle Financials 11.5.8
Performed Daily database maintenance, system performance monitoring and tuning
Set up “autoconfig” (formerly “adclone”) methodology utilized for instance mirroring
Environment: Sun Solaris (UNIX), Oracle Applications 11.5.8 Java, Dynamic HTML, AD-utilities, SQL, Oracle
Server 8x, 9x
Project 13, Oracle Financials 10.7 to 11i Upgrade

Lead Applications Database Administrator

Canadian Union of Postal Workers

09.2000 - 11.2002

(CUPW) 11.5.3 Oracle Financials implementation includes Payables
General Ledger, and two custom modules (Grievances and Dues)
The technical framework was on a one tier architecture using Oracle RDBMS 8i on a Windows server moving to v9
The implementation involved the migration of 10.7 to 11i (11.5.1 then to 11.5.3)
As an Applications Database Administrator, Mr
White was responsible for the upgrade and implementation of Oracle Financials 10.7 to 11i; some of his duties included:
Establish, configure, operate, and manage software development environment for Oracle Financials using Oracle Developer 6i
Performed RDBMS v9 Upgrade and Patch installs, modules – GL, AP, AR, HRMS, Payroll and custom modules along with technical configuration
Quality assurance, development of test plans, test execution, results analysis, and documentation for migration of Oracle Financials 10.7 to v11i
Developed database structures for new modules – custom object schemas for Grievances and
Dues
Create and manage test, development, integration, and production servers
Manage cloning on test servers to ensure synchronization with production environment
Developed, tested, maintained SQL and PL/SQL scripting for financial module tables and custom modules – also provide conversion scripts for Oracle upgrade procedures
Also fine-tuned scripts to increase performance as required
Implementation of the first Oracle Payroll installation in Canada
Daily database maintenance, system performance monitoring and tuning
Environment: MS WinNT, SQL, Oracle Applications 10.7SC / 11i, Oracle Server 8x, v9
Project 12
DEPT

Applications Database Administrator, Programmer Analyst

OF FISHERIES & OCEANS

05.2000 - 09.2000

Department of Fisheries & Ocean’s Oracle Financials 11i (v11.5.7) implementation (Abacus) includes
Payables, Purchasing, General Ledger, Fixed Assets, iProcurement and PWGSC Receiver General Interfaces
The technical framework is currently on a two-tier architecture using Oracle RDBMS 10G on an HP Tru64 server
As an Applications Database Administrator, some of Mr
White’s duties included:
Develop and coordinate back-up, disaster recovery and virus protection procedures
Maintained and supported SQL queries and PL/SQL scripting for table updates - completed performance tuning
Database storage management, system performance monitoring and tuning
User management
Ad-hoc client support
Upgrade and Patch installs
Oracle Applications support, testing and results documentation
Performed daily database maintenance and instance refresh procedures – developed UNX shell scripts as required for system administration, file maintenance, printing, and batch jobs
Clone management for test, development, and integration environments

Programmer Analyst, MONTAGE

Working with open interface tables for GL, AP, AR, and PO to support data tables required for RGI interface applications
Developing, maintaining, and troubleshooting both Oracle Forms and Reports (Developer 6i) for RGI interfaces – many were customized for the Abacus environment to support FIS financial tracking and reporting requirements
Used SQL and PL/SQL in Forms and Reports as required to provide parameter-based retrieval of data fields
Investigated RGI and user functionality issues and proposed solutions to modify code and configuration – documenting solutions
Environment: TRU64 UNIX, Open VMS, Oracle Applications 10.7, 11i, SQL, PL/SQL, SQL
Navigator, Oracle
Forms & Reports, Oracle Server 7.3.4, MS FoxPro, MS Visual Basic
Project 11
DEPT
OF INDIAN & NORTHERN AFFAIRS, )
Oracle Financials MLS Implementation

Applications Database Administrator

04.2000 - 05.2000

MONTAGE

Dept.

Of Indian & Northern Affair’s 11.0.3 Oracle Financials implementation includes Payables
Purchasing, General Ledger, Fixed Assets and PWGSC Receiver General Interfaces
The technical framework is currently on a two-tier architecture using Oracle RDBMS 8i on an HP Tru64 server
The current implementation involves a custom French solution
As an Applications Database Administrator, Mr
White was responsible for an Oracle Applications 11.0 to0.3 upgrade and general database administration; some of his duties included:
Patch set implementations
Table space management
Establishment, operation, and management of development environment
User management
Back-up strategies, test plan development, execution, analysis, and documentation
Environnent: HP/UX, Oracle Applications 11.0.3, Oracle Server 8.0.5, SQL, PL/SQL, Designer
Project 10
DEPT
OF INDIAN & NORTHERN AFFAIRS, )
Oracle Financials 11.0.3 Implementation Development Environment

Applications Database Administrator

12.1999 - 04.2000

Some of Mr
White’s duties included:
Server set-up
Establishment, operation, and management of software development environment
Patch set implementations
Table space management
User management
Development of test plans, test execution, results documentation, acceptance testing
Back-up and export routines
Support
Environment: Sun Solaris, Oracle Applications 10.7SC / 11.0.3, Oracle Server 8.0.5, SQL, ADI, PL/SQL
Project 9

Oracle Programmer/Analyst

CANADIAN FOOD INSPECTION AGENCY, CFIA

05.1999 - 12.1999

Oracle Programmer /Analyst

Mr
White was responsible for the Analysis and Implementation of the conversion process from 20+ source data systems into a newly created Oracle RDBMS 7.3.4; some of his duties included:
Establishment and verification of business rules with the end users
Mapping data to the target RDBMS schemas
Validation and loading of the data
Follow-up, acceptance testing, results analysis, and documentation
An application was developed using Oracle Developer automate the conversion process
Environment: Various Systems migrated into Oracle Server 7.3.4, SQL, PL/SQL, Oracle Developer, and

Designer

Project 8
NAVCANADA – RATES AND REVENUES DIVISION
Project: Oracle Financials – Customer Interface Implementation

Oracle DBA, Programmer/Analyst

01.1999 - 05.1999

Oracle DBA, Programmer / Analyst

Some of Mr
White’s duties included:
The processes configured and called from the Oracle Financials environment: o External (ASCII file) data entry via - FTP Unix shell script o Creation of a temporary Oracle table - SQL
Plus o Loading the data into the temporary - SQL
Loader o Validation of the data using - PL/SQL
O Uploading all validated data into Oracle, and generation of status reports
Technical and User documentation was updated throughout the project: o Analysis and Design Document o Oracle Financials Setup Guide o Program Listings and Specifications Document o User Guide
Environment: HP/UX, Oracle Applications 10.7, Oracle Forms & Reports, PL/SQL, SQL, Oracle Server 7.3.4
Project

Oracle Database Administrator

MASI INC

09.1998 - 06.1999

For the Maintenance Contract Assignments project, some of Mr.

Database design and Programmer

03.1998 - 05.1998

Mr
White was jointly responsible for all phases of the Customer /
Inventory Tracking System project; some of his duties included:
Database design and creation – PowerBuilder/ Sybase GUI
Application development and report generation – PowerBuilder 5
Environment: Windows NT Server, Powersoft PowerBuilder5, Sybase Database
Project

DBA, Programmer/ Analyst

VIRTUAL VIDEO LTD

11.1997 - 03.1998

DBA / Programmer / Analyst

Mr
White was jointly responsible for all the application design phases of the Point of Sale – Transactional Application project; some of his duties included:
Existing Access database – ODBC
Application development – MS Visual Basic 4
Report generation – Crystal Reports and MS Word
Environment: Windows NT Server, Visual Basic 4, Access 8, Crystal Reports, ODBC to Access Database
Project

Database design/ Analyst/ Programmer

CANADIAN NATIONAL INSTITUTE FOR THE BLIND, CNIB

10.1997 - 12.1997

Database design / Analyst / Programmer

Mr
White was responsible for all the design and implementation phases of the Annual Walk-a-Thon tracking system; some of his duties included:
Database design (ERD) – ERWin
Application and Report Development – MS Access
Environment: Windows95, MS Access Application and Database, ERWin
Project 1

Oracle DBA, Programmer/Analyst

PRODUCT SOURCING INC

12.1994 - 10.1997

Mr
White was responsible for the design and build of the Inventory and Shipping System; some of his duties included:
External data entry from Excel
Loading and manipulation of the data into temporary tables - SQL
Loader
Validation of the data using - PL/SQL
Generation of summary reports
Environment: Windows NT Server, Oracle Forms & Reports, PL/SQL, SQL, Oracle Server 7x

Education

AIT Diploma -

Information Technology Institute (ITI)

01.1998

1 Diploma - Industrial Sociology

Nipissing University

01.1997

Basic Constable Level -

Police College

01.1994

Canadore College

01.1983

Skills

SUMMARY OF EXPERIENCE
Experienced Senior Oracle DBA
20 years' experience in installing, upgrading, and administering Oracle database server versions
7/8/9/10/11/12/18/19, including all related tools and applications (ie, SQL, PL/SQL, SQL
Loader
Import/Export, Data Pump, RMAN)
Experienced in the installation, upgrade, and administration of Oracle Enterprise Cloud Control
(EMCC)
Extensive technical knowledge and experience of implementing and upgrading Oracle E-Business
Suite version 107 SC/ Char, 1103, 11i, 121x, 122x
Data loading and data conversion
Implementation of full E-Business Suite (EBS) configuration, including business mapping, gap
Analysis, reporting, customizations, set ups, system and user implementation tests and production
Support
Project supervision and management experience
Functional knowledge of the Oracle
Application modules which assists when translating functional
Specifications into a technical design
Experience in Unix environments (Solaris, AIX, Linux, Open VMS) as well as Windows server
Experience in technical configuration and customization of Perforce products; Test Track Pro
Surround SCM and License Server
Experience in SQL Server Enterprise installation and configuration both physical and virtual
Experience in data migration, transformation and loading across multiple platforms and
Applications
EarthSoft EQuIS Enterprise Data Management implementation specialist, including administration
Training, and release management
Experience in the installation and configuration and administration of EarthSoft EQuIS Professional
Data Management toolset
Release lead in an ART continuous delivery environment
White’s duties included:
Table space management
User management
Role based security
Ad-Hoc monitoring of back-up and export routines, system performance tuning
Periodic perusal of database refresh outputs
Environment: Suite of 6 Oracle databases, running on 2 UNIX Servers, SQL, Oracle Server 734, Oracle
Application Server
Project 6
NAVCANADA - RATES AND REVENUES DIVISION
Project: Oracle Financials A/R – Consolidated Flight Billing System
Oracle DBA
Programmer/Analyst
August 1998 - January 1999
As an Oracle DBA, Programmer / Analyst, some of Mr White’s duties included:

The processes were configured and called from the Oracle Financials environment:
O External data entry from a FoxPro database - ASCII file FTP Unix shell script
O Creation of a temporary Oracle table - SQL
Plus
O Loading the data into the temporary table - SQL
Loader
O Validation of the data using - PL/SQL
O Error correction form - Oracle Developer Forms 45
O Uploading all validated data into Oracle, and generation of status reports
Project documentation:
O Analysis and Design Document
O Oracle Financials Setup Guide
O Program Listings and Specifications Document
O User Guide
Environment: HP/UX, Oracle Applications 107, Oracle Forms & Reports, PL/SQL, SQL, Oracle Server 734
Project 5
INFORMATION TECHNOLOGY INSTITUTE – CLIENT SUPPORT DIVISION
Technical Architect/ Developer
June 1998 - August 1998
As a Technical Architect/ Developer, Mr White was responsible the back-end design and development of two
Front-end forms for the Help Desk Tracking System; some of his duties included:
Database ERD generated – Oracle Designer
Application analysis and design – Oracle Forms
Report generation – Oracle Reports
Environment: Windows NT Server, Oracle Server 734, Oracle Tools: Designer, Developer/2000 Forms 45
Reports 20, SQL
Project 4
PROFESSIONAL DEVELOPMENT
Oracle Official Curriculum
O Oracle DBA
O Oracle Applications
O Oracle Developer Forms
O Oracle Developer Reports
O PL/SQL and Advanced PL/SQL, Server SQL, SQL
Other Relevant Computer Related Skills
O Network Architecture and Administration - MCSE
O Microsoft Visual Basic
O PowerBuilder
SKILLS
Environments
Unix
HP-UX
Sun-Solaris
TRU64
Linux
Open VMS
Windows
Application Software
Oracle Applications 12x, 11x, 10x
Oracle Database 11x, 10x, 9x, 8x, 7x
Oracle Self Service Framework (ASP, JSP)
Oracle Forms and Reports
Oracle Portal
Oracle Applications Custom Modules
Tools & Languages
Oracle Developer Suite
Oracle Designer
SQL, TOAD, SQL Navigator
Visual Basic
Java (ASP, JSP)
PowerBuilder

Interests

SECURITY Secret, File #: , 95-11-1865, Expiry August 24, 2020

Timeline

senior DBA, Technical Support Specialist

12.2019 - 03.2025

Agile Release Lead/Coordinator, Technical Lead

Canadian National Laboratories

07.2018 - 11.2019

Agile Release Lead/Coordinator, Technical Lead

Laboratories

04.2018 - 08.2018

Agile Release Lead/Coordinator, Technical Lead

Microsoft

02.2018 - 05.2018

Database Data Analyst

Microsoft

05.2016 - 02.2018

DBA / Lead Technical Analyst, Senior E-Business Suite Programmer / Analyst

09.2011 - Current

DBA Lead Technical Analyst, Programmer Analyst

09.2010 - 08.2011

Technical Analyst

06.2009 - 04.2010

Senior Applications Database Administrator

THE PYTHIAN GROUP

08.2004 - 12.2004

Senior Applications DBA / Lead Technical Analyst

Financials Cloning and Support

12.2003 - 02.2004

Senior Applications DBA / Technical Programmer Analyst

FEDERAL ORACLE FINANCIALS CLUSTER GROUP

04.2003 - 04.2010

Lead Applications Database Administrator

CANADIAN UNION OF POSTAL WORKERS

08.2002 - 07.2003

Lead Applications Database Administrator

Canadian Union of Postal Workers

09.2000 - 11.2002

Applications Database Administrator, Programmer Analyst

OF FISHERIES & OCEANS

05.2000 - 09.2000

Applications Database Administrator

04.2000 - 05.2000

Applications Database Administrator

12.1999 - 04.2000

Oracle Programmer/Analyst

CANADIAN FOOD INSPECTION AGENCY, CFIA

05.1999 - 12.1999

Oracle DBA, Programmer/Analyst

01.1999 - 05.1999

Oracle Database Administrator

MASI INC

09.1998 - 06.1999

Database design and Programmer

03.1998 - 05.1998

DBA, Programmer/ Analyst

VIRTUAL VIDEO LTD

11.1997 - 03.1998

Database design/ Analyst/ Programmer

CANADIAN NATIONAL INSTITUTE FOR THE BLIND, CNIB

10.1997 - 12.1997

Oracle DBA, Programmer/Analyst

PRODUCT SOURCING INC

12.1994 - 10.1997

Database Administrator

25, Oceans Canada

Technical Support Specialist, Lead Technical Analyst

The Oracle

Senior Data Migration Analyst

Senior Applications DBA / Technical Analyst / Infrastructure Analyst

Oracle Applications Troubleshooting Senior Consultant

Programmer Analyst, MONTAGE

MONTAGE

Dept.

Oracle Programmer /Analyst

Designer

Oracle DBA, Programmer / Analyst

DBA / Programmer / Analyst

Database design / Analyst / Programmer

AIT Diploma -

Information Technology Institute (ITI)

1 Diploma - Industrial Sociology

Nipissing University

Basic Constable Level -

Police College

Canadore College