Ronald A. Guillemette
North Charleston, SC 29406
Contact Information
Phone cell 443-***-**** [voice mail]
Email Primary:acsztm@r.postjobfree.com
Summary
full-time Oracle DBA, versions 6-11gR2 since 1993; Unix and Windows database server platforms; primarily Enterprise Server, some RAC and Data Guard; perm and/or contractor/consultant role, production and/or project work (e.g., ERP upgrade), exposure to multiple industries and levels of government, OLTP and data warehouses (up to several terabytes), custom and ERP/COTS application databases,
Oracle Apps/EBS DBA, both physical and application DBA roles; versions 10.7, 11.0.x, 11i; typically Financials, some Manufacturing, HRMS modules, R12.2
prominent former employers: Oracle, IBM, CSC, SGHE, Coopers & Lybrand, Equifax; among end clients: Booz Allen and multiple federal agencies
ancillary responsibilities: some custom Oracle development, limited system (database server) administration, tech lead, training
former full-time MIS professor; several published articles and book chapters
certification: Oracle DBA 10G OCA; clearance: DoD; multiple public trust
Education
PhD in Management Information Systems, University of Houston, 1986
MBA, University of Houston, 1983
MA, Mathematics, University of Texas, Austin, 1977
BA, Mathematics & Philosophy, Our Lady of the Lake University, San Antonio, TX, 1975
Most Recent Experience
Engility, Oracle Apps DBA, 3/15-present, federal contractor in North Charleston, SC. Creation of Virtual Servers running RHEL 6.6. Cloned R12.2 one- and two-node test environments for 1.4TB Apps DB with customizations. Database reorganization project.
DBA Experience Summary
Date
Employer
Client
Location
Role
RDBMS
Platform
3/15-present
Engility
DoD
Charleston, SC
Oracle Apps DBA
11GR2
Linux
12/13-4/14
Novetta
DoD
Northern WV
DBA on Sys Admin team
10GR2 RAC
Linux
11/09-1/10; 7/10-10/10
Self
Livanta /
CMS
Annapolis Junction,
MD
Federal contractor on 2 contracts; production DBA
10GR2-11GR2
Oracle Linux
12/08-5/09
InnovaTech
USPTO
Alexandria, VA
Federal contractor for USPTO data warehouse
10GR2
HP/UX
02/08-7/08
SGHE
various
road warrior
Malvern, PA
Banner ODS database installation and training
10GR2
Unix;
Windows
9/07-11/07
Excell Data
Subcontract
Booz Allen Hamilton
McLean, VA
Test data warehouse DBS
10GR2
Solaris Unix
3/07-5/07
Grant Thornton
Veterans Benefits Admin.
DC
Contractor Oracle Warehouse DBA
10GR2
Solaris Unix
7/06-12/06
IBM AoD
various
Fairfax, VA
Oracle Apps DBA 11i
8i-10G
Aix Solaris HP/UX
Unix
10/05-5/06
NCI
NASA- GSFC
Greenbelt, MD
Contractor Oracle DBA
9iV2-10G
DataGuard
Solaris
Unix
5/05-9/05
CSC Consulting
GDLS
Sterling Heights, MI
Road warrior
Falls Church, VA
Oracle DBA Consultant
National Oracle Practice
Oracle Apps DBA 11i
9i
Unix
2/05-3/05
Clovis Group
Subcontract
Invitrogen/ Bioreliance
Frederick, MD
Oracle Apps DBA 11i
9iV2
Linux
11/04-1/05
CAS
Severn
Navair
Lexington Park, MD
Contractor Application DBA
9iAS
Windows
4/04-10/04
Optimos
National Archives
College Park, MD
Contractor Oracle DBA
Siebel Applications
8i-9i
Solarix Unix
11/03-3/04
Greenbrier Russel
subcontract
Fellowes
Itasca, IL
Oracle Apps DBA 11.0.3
Data warehouse DBA
9i
Windows
10/03-11/03
BizTech
subcontract
Brodart
Williamsport, PA
Oracle Apps DBA 11i
9iAS
9i
AIX Unix
Windows
7/02-11/02
Unisys
subcontract
Chicago Park District
Chicago, IL
Oracle Apps DBA 11.0.3 production DBA
Oracle Apps DBA 11i
upgrade project DBA
8-8i
Windows
7/02
Divine
subcontract
WMS Gaming
Waukegan, IL
Oracle Apps DBA
8i
HP/UX
Unix
7/01-10/01
AST
Waukesha County
Waukesha, WI
Oracle Apps DBA 11i Consultant Upgrade
8
Unix
4/01-6/01
SBI
various
Road warrior CA, UT
Oracle Apps DBA 11i
Contractor/Upgrade
8
Solaris
Unix
3/01-4/01
Self
Sweetener
Products
Vernon, CA
Oracle Apps DBA 11.0.3 Contractor
8
Windows
1/01-2/01
IT Convergence
Odwalla
Half Moon Bay, CA
Oracle Apps DBA 11i Contractor
8
HP/UX
Unix
12/00-12/00
Dazci
Various
Road warrior CA
Oracle Apps DBA 11.0.3
Contractor
8
Solaris
Unix
9/00-12/00
FutureNext
Consulting
Various
Road warrior CA
Oracle Apps DBA 10.7S C-11.0.x-11i Consultant
7,8
HP/UX
Solaris
7/00-8/00
Self
Hughes Space
El Segundo, CA
Oracle Apps DBA, 11.0.x
8
Solaris Unix
6/99-7/00
Advantest DBA
PERM
internal
Santa Clara, CA
Oracle Apps DBA 10.7 NCA
Clarify
7
Digital Unix, Solaris
Unix
Windows
5/99-5/99
Self
AGI/Impac
Melrose Park, IL
Oracle Apps DBA 11.0.x
8
Solarix
Unix
12/98-5/99
Database Technologies Corp.
various
Road warrior MD DC VA IL
Oracle Apps DBA Consultant 10.7, 11.0.x
7, 8
AIX,
Solaris,
HP/UX Unix
2/98-10/98
Oracle Consulting GEHS
various
Road warrior MN CA GA OK IL
Oracle Apps DBA Senior Principal Consultant 10.7 SC/NCA
7
Digital Unix, Windows,
Solarix,
HP/UX
11/97-1/98
Grant Thornton
Jernberg
Chicago, IL
Oracle Apps DBA Consultant 10.7SC
7
HP/UX
10/97-11/97
Self
Grainger
Lake Forest, IL
Oracle DBA/Apps DBA 10.7 contractor
7
Unix
4/97-10/97
Coopers & Lybrand
various
Arlington Heights, IL
Oracle Apps DBA Senior Consultant 10.7
7
Solaris,
Windows
2/97-4/97
Lockheed Martin
PERM
Chicago, IL
Local number portability project
7
HP/UX
9/96-12/96
Wilton Industries
PERM
Woodridge, IL
SAP Basis Administrator 2E
7
Solaris
8/96-8/96
Self
Master- Card
Creve Coeur, MO
Oracle OPS Test DBA
7
Unix
4/94-10/96
Market Knowledge
/ Equifax
PERM
Lombard, IL
Lead Oracle Production DBA
7
Solaris
5/93-10/93
ARC
US EPA
Chicago, IL
Oracle DBA Contractor RLIMS
6
Windows
Primary Role Summary
Senior Oracle DBA
full-time professional (1993-present). (Prior exposure since Oracle v2, 1982.). Enterprise Edition Versions 6 through 11GR2 (2014). Unix/Linux, Windows platforms. 10G OCA certification (July 2005). Senior production DBA at Equifax/Market Knowledge, Advantest America, Chicago Park District, National Archives and NASA-GSFC. Former senior principal, Oracle Consulting, IBM Applications on Demand, CSC Consulting (National Oracle Practice), and Coopers & Lybrand.
Versions: Enterprise Edition 6.x, 7.x, 8.0.x, 8.1.x (8i), 9i v2, 10G R2, 11G R1,R2
Optional Features: advanced replication (1998), Data Guard (physical/logical standby) (2006), partitioning (2003), parallel server (1996), RAC 10G R2 (2014).
Database Typology: OLTP/realtime; operational data store (ODS); data warehouse
Platform: Unix (Solaris 2.5-2.6, 7.0, 8.0, 9, 10; HP/UX 10.x-11.11; AIX 4.3.x, 5.1-5.2 (5L); Digital Unix/Compaq Tru64 4.0D), Linux (RHEL AS 2.1, 4.0, Oracle Linux), NT (NT 4.0, Win2000, Win2003)
Responsibilities/Projects
Production databases (operationmaintenance, hot/cold/RMAN backup/recovery, performance tuning, etc.) Test/QA/Development databases. Database cloning/refreshes, rehosting and database reorganizations, Oracle networking configuration.
Fresh installs, upgrades, patching, Critical Patch Updates,
Server setups and configurations (file system/RAID configuration/setup, raw devices, capacity planning)
Database builds; SQL*LOAD; data scrubbing; export/import, dare warehouse database table/index partition maintenance
Unix/Linux shell scripting.
Database upgrades of ERP software applications (including Manugistics upgrade (1999)).
Oracle product installation and configurations:Oracle Server Enterprise Edition (7.x, 8.0.x, 8i, 9i v. 1, 2, 10G R2, 11G R1, R2), Oracle Application Server (3.0.1.x, 9iAS v.1, 2, 10G, 10G R2), Oracle Warehouse Builder 10.2.0.2.8,Oracle Developer Server (1.6.x, 6I, 9I),Other Products (Discoverer 3.x, 4.x; EDMS; Designer); interoperability Patching; client/browser software installation/ configuration.
Other vendor product Installations: SunGard Higher Education/STC Banner/ODS/EDW, and other third-party products.
ERP Administrator
Oracle Applications/E-Business Suite (10.7-11i, 1997-2006). SAP R/3 (1996). Clarify (1999-2000). Siebel (2004). Manugistics (database upgrade, 1999). SunGard Higher Education/SCT Operational Data Store (2008).
Oracle Apps DBA (1997- 2006, 2015)
Versions: Oracle Applications/E-Business Suite (10.7-11i latest 11.5.10.2), R12.2
Products: Financials (GL, AR, AP, PO, FA), Manufacturing (OE/ONT/OM, INV, BOM, WIP, EDI, DPE), Human Resources (HR/PAY), Public Sector (Government Financials, PSB), Others (CRM, PA, ALR, ADI, GLDI, Workflow, Self-Service Web Apps)
Architecture: Client/server; NCA/multi-tier/web server
Platform (Uniform/Mixed): Unix (Sun Solaris, HP-UX, AIX, Digital Unix), NT
Responsibilities/Projects
Production/maintenance (operations, backup/recovery, performance tuning, one-off patches, megapatches, cloning/refreshes)
Apps system administration (concurrent managers, concurrent programs, user administration, printers)
Fresh install, architecture and configuration (10.7; 11.0.3; 11i), upgrades (10.7-11i, 11.0.x-11i, within-version (11.0.2-11.0.3))
Unix shell scripting (Korn, Bourne), NT command files
Concurrent program development, Report modifications (Y2K), Oracle Apps data migration (AP, AR, INV, PO)
Other ERP Software Administration
SunGard Higher Education Operational Data Store, versions 8/3.1.1 (2008)
Siebel 6.3 CRM, Siebel 7.5.3 e-Analytics (2004)
Clarify CFO98SR3, (1999-2000)
SAP R/3 v. 2.2E Basis Administration on Unix (1996)
Ancillary/Secondary Responsibilities
Oracle Application Development: Oracle Apps/ Unix scripting concurrent program (Advantest), data scrubbing and database development (MKI), as-needed modifications of reports, menus/forms, custom-built database alerts/processes/utilities, SQL Loader/Data Pump. Skills include SQL*PLUS, PL/SQL, Forms (3.0, 4.5, 9i), Reports (2.5, 9i), Pro*C, C/C++, Unix shell (as needed, since 1993)
Operating systems administrator:Database/Middle Tier Servers (Sun/DEC/Linux) at Advantest, National Archives, Livanta. Unix Administration (Sun Solaris 2.6, 8, Digital Unix 4,0D). Unix shell scripts Kron, Bourne, C, job scheduling cron and system and/or Oracle backups and restores. Kernel updates, Networker operation/patching, Veritas NetBackup (1999-2000, 2004) Oracle Enterprise Linux 5.5 installation, logical volume management, NT Administration (NT 4.0) at Advantest. User/group administration, application software installs, system backups task scheduler/at command scheduling. (1999-2000), user/email distribution list administration