|
Dan Hooper 610-216-3124 (cell phone) |
|
|
|
WORK
HISTORY |
|
10/07
to Present Role: Oracle Applications
11i DBA |
|
Company: Non-Profit
Education and Workforce Development company in Iowa City, IA |
|
|
|
Oracle
Apps 11i DBA supporting 11.5.10 CU2 running on RedHat
Enterprise Linux (RHEL) 4. The implementation includes Financials, HR, Order
Management, iStore, Warehouse Management (WMS),
etc. The application is running with a 4 node RAC cluster of Oracle 10.2.0.3
on IBM p-series servers (64-bit). Also in production the system has 6
external facing application servers running iStore
and 4 internal application servers running Forms, Discoverer, Concurrent
Manager, MSC, etc. My
primary role is to support the clients Production, Test, Stress Test and
Development environments. Also, I am leading the implementation of Parallel
Concurrent Processing (PCP) and creating a Stress Test environment. Various
tools are used to support these environments, including OEM/Grid Control,
Load Runner, SQLDeveloper, and Subversion. |
|
8/07
to 10/07 Role: Oracle Applications
11i DBA |
|
Company: Wilson
Greatbatch in Clarence, NY |
|
|
|
Lead
Oracle Apps 11i DBA supporting 11.5.10 CU2 running on HP/UX. Implementing Oracle
Demantra 7.1.1 and Enterprise Planning and Budgeting (EPB) version ZPB.B. |
|
|
|
9/05
to 8/07 Role: Oracle
Applications 11i DBA and RedHat Enterprise Linux Administrator |
|
Company: The
Pampered Chef Addison IL |
|
|
|
Lead
Oracle Apps 11i DBA performing a full implement and supporting 11.5.10 CU2 running
on RedHat Enterprise Linux (RHEL) 4, which is running on HP ProLiant DL580 G3
servers. I upgraded all of the 9i databases to 10g R2, which is the latest
supported version for 11i apps. The implementation includes Financials, CRM, InterAction Center, Advanced Supply Chain (ASCP), Demantra
7.1, Warehouse Management (WMS), and Order Management. I also implemented
multi-language (French, Spanish, German) on pre-existing Development, Test,
and Production systems. |
|
|
|
I
developed the TA120 (Platform and Network Architecture) document with
recommendations for RHEL AS 4 on HP ProLiant using storage on an HP EVA8000
SAN. My recommendations included the implementation of NetBackup
with RMAN, RAC, Shared appl_top, DataGuard, and improvements in the data center and DR
site. |
|
|
|
As
the Linux Administrator, I installed Linux AS 4 on the new servers and
configured sendmail for use with |
|
|
|
In
the first phase of the project, I implemented Oracle Email Server 5.2.2 using
a 9i database on Linux (AS RHEL 3). I
installed, configured, and implemented Oracle Enterprise Manager 10.2 to
manage the production, test, and development environments. Implemented RMAN
with a repository to perform hot backups (full and incremental) for all
environments. Configured
RapidClone and created a detailed cloning document.
Performed numerous clones from production. Additionally,
I installed and configured OCFS2 filesystems to be
used by all Linux nodes. Also, installed and implemented ASM to be used by all
Oracle instances. Implemented RAC for the Production and Test environment. Installed,
configured, and implemented the iSupplier portal.
This included installing and configuring Apache on a Reverse Proxy Server.
Also, I cloned and configured the 11i Apps web tier which is accessed by the
External suppliers. Started
implementation of Advanced Supply Chain (ASCP) and Demantra demand planning. Created
development environment for Demantra 7.1.1 with a 10gR2 database and Tomcat 5
running on Linux RHEL4. Other desktop tools for Demantra are installed on
Window XP. |
|
|
|
3/05
to 9/05 Role: Oracle
Applications 11i DBA on RedHat Enterprise Linux 3 |
|
Company: City
of |
|
|
|
Lead
Oracle Apps 11i DBA performing full implementation and supporting 11.5.9
running on RedHat Enterprise Linux 3, which is running on IBM xSeries 445 and 346 high-performance servers. I performed
fresh installs on the servers, as well as, a migration of a customized 11.5.9
environment from Solaris 8 to RedHat Enterprise Linux 3 (RHEL 3). The
environment, which was in CRP, was hosted at Oracle’s eStudio
on Soloris. My first major task was to migrate the environment in-house to the client’s Linux
servers. The environment is a two tier (db/cm and app/web) set-up. |
|
|
|
Once
the environment was migrated to Linux, I RAC’ed the
database (9.2.0.5) to a two-node cluster and implemented PCP. I then
load-balanced the apps tier to two nodes and converted it to a shared
APPL_TOP. |
|
|
|
I
am creating extensive documentation for the client, so that they can support
the environments. I am also mentoring 3 DBAs on supporting the application. |
|
|
|
I
have also installed and implemented Oracle 10g databases for internally
developed applications. I have documented and performed Data Pump (expdb, impdb) tasks to move
large amounts of data from one instance to another. I have also used it to
load newly created Big File Tablespaces. |
|
|
|
Installed
OracleAS 10g (9204) to integrate OID and SSO for use with Oracle Apps 11i. My
client was one of the few government agencies that was
on the Early Adoption Program for this configuration. |
|
|
|
I
upgraded the Apps from 11.5.9 to 11.5.10 in a test environment. |
|
|
|
8/04
to 3/05 Role: Oracle
Applications 11i DBA & Oracle Application Server 10g Administrator |
|
Company: Sungard Recovery Services, |
|
|
|
I
was a member of a 3-member Oracle Applications 11i DBA team. My role was as a
Senior Apps 11i DBA supporting production, test, and development
environments. In addition to my 11i DBA role, I was the administrator of the
company’s intranet site, which is using Oracle Application Server 10g (9.0.4)
with Oracle Portal, Webcache, etc. I administered
the Oracle Internet Directory, which is automatically synchronized with the
Microsoft Active Directory. |
|
|
|
My
first accomplishment was to install and configure a Test and Production
environment for Oracle Portal. I migrated the development environment to the
new Test and then eventually to the new Production environment. Each
environment runs on two SunFire V240 servers
running Solaris 8. |
|
|
|
The
Oracle 11i Apps production is running version 11.5.9 in a 2-tier environment.
The Web tier is load-balanced across two Sunfire
280 servers. The database and concurrent manager server is running on a SunFire v880. All are running Solaris 8. The Application
modules running are HR, the Financial Suite, Sales Online, Marketing Online,
and iProcurement. Applied
numerous patches and create clones (RapidClone)
during off-hours and weekends. |
|
|
|
I
completed the 11.5.9 to 11.5.10 upgrade on a test instance, which is running
HR and Financials. |
|
|
|
9/03
to 8/04 Role:
Oracle Applications 11i DBA |
|
Company:
The Hibbert Group, |
|
|
|
Lead
Oracle DBA performing full implement of Oracle Apps 11i (11.5.9) on Sun Fire
6800 Server running Solaris 9. Production and testing environments are a two-tier architecture with 9.2.0.3 (9i) Oracle database
running in RAC using Veritas Advanced Clustering
3.4 for 9i. The application servers are running all 11i components
(concurrent manager, forms, Discoverer, etc.) except the database. |
|
|
|
It
is a phased implementation. Marketing Online has been implemented into
production. Inventory, Order Management, iPayments, Mobile Warehouse Application/Mobile Supply
chain, AP, AR, GL and FA have recently been implemented into
production. Implemented barcode fonts to be used by various printers.
Implemented the use of Zebra printers. Installed and manage MWA dispatcher
and servers for use with Symbol RF devices. |
|
|
|
I
installed 11i (11.5.9) on all environments. I RACed
the production and test 9i databases, which included manual modifications of
the Apps 11i environment and performing RAC configuration using srvconfig, srvctl, and gsdctl. I have performed a number of clones for testing
and development. |
|
|
|
I
have also performed a number of SYSADMIN functions including creating
printers, flexfields, users, and responsibilities.
Also, I reviewed and implemented changes to the BR100s for test and
production. I reviewed and implemented custom code as defined by the MD120s. |
|
|
|
I
have created RMAN (Veritas Netbackup) scripts and
implemented them into all environments. I have installed and implemented OEM
on Solaris server. |
|
|
|
I
implemented StatsPack on test and production
environments. Setup of regularly scheduled snap shots. Perform analysis on
results. Also, developed and implemented maintenance scripts (Korne shell, SQL and PL/SQL). |
|
|
|
Installed
OracleAS 10g in development environment for use by Discoverer 9.0.4 (10g).
Supporting Discoverer 10g development effort. |
|
|
|
Created
testing environment for implementation of Load balancing components of the
11i tech stack. |
|
|
|
Developed
and tested Recovery procedures. The procedures detailed recovery’s of 11
Oracle Databases on HP/UX. The Oracle versions were 8i and 9i with sizes
ranging from 100 Gig to over a terabyte. Also, developed recovery procedures
for SAP application. Successfully performed DR exercise for these Oracle
databases and applications at the Sungard facility
in |
|
|
|
6/02
to 9/03 Role:
Oracle Applications 11i DBA |
|
Company:
Subaru of |
|
|
|
Performed
initial install of Oracle Apps 11.5.5 (11i) on Sun Fire 6800 Servers. Shortly
after the install, I upgraded the development instance and Model office
instance to 11.5.8 (11i). I also installed 11.5.8 using Rapidwiz
for the Test instances. The database for all instances were upgraded from
8.1.7.2 (8i) to 8.1.7.4 (8i) and finally to 9.0.3 (9i). All environments are
running with 9i databases. |
|
|
|
Performed
many clones of 11i environments using Autoconfig
and RMAN with Legato. Cloned 11.5.8 environments using Rapid Clone. |
|
|
|
Mentoring
and knowledge transfer to junior 11i DBA. Install Oracle Tutor. Develop,
test, and document procedures for cloning (using AutoConfig), RMAN backups,
patching, upgrading to 9i, upgrading to 11i, and Tutor. Configure and support
9iAS (Apache) environment. Install and configure Data Guard for 9i release 2
instances. Developing and implementing monitoring scripts (SQL, Korn shell) for the database. |
|
|
|
Installed
and implemented Oracle Enterprise Manager (OEM) to manage and monitor all
Oracle instances including the ERP instances. Upgraded Oracle Application
Manager (OAM). Implemented Workflow 2.6. |
|
|
|
Installed,
implemented and supported 9iAS release 2 environments. Installed and
administered Discoverer 9 (5.1) in 9iAS release 2 environments. Also
installed Discoverer 4i in 9iAS release 1 environment, but because of key
features in Discoverer 9, the client will not be using the 9iAS release 1
environment. |
|
|
|
Client
is currently running Financials (AP, AR, GL, FA), Discrete Manufacturing
(BOM, WIP, |
|
|
|
1/02
to 6/02 Role:
Oracle Applications 11i DBA |
|
Company:
GE, |
|
|
|
Providing
Oracle Apps 11i DBA support to an international manufacturing company. Currently at version 11.5.4 on HP/UX 11.0 N
and L class servers using an Oracle 8.1.7 64-bit database. Implementation
includes HR (Payroll), Manufacturing, CRM, Financials, and iStore. Perform numerous cloning of 2-tier production to
2-tier test environments. Working on upgrade to 11.5.6 and possibly 11.5.7. |
|
|
|
Upgraded
RDBMS 8.1.7 32 bit to 8.1.7 64-bit. I researched and implemented Case 11i
into Designer/Repository 6i for 11.5.6. |
|
Troubleshooting
performance issues with Discoverer 4i on HP/UX platform. Upgraded to
Discoverer 4.1.37. Worked with UNIX admin to apply OS patches and modify
kernel parameters for Discoverer. Working with network administrator on
Discoverer and 11i performance issues. Performed tuning of Workflow 2.6.
Administered Discoverer 4i servers and Noetix
views. |
|
|
|
Supported
European conversion of 3 sites to Apps 11i. Additional European locations
will be integrated into Apps 11i in the coming months. Because of the
additional users, I implemented MTS and Forms Metric Server. The Metric
Server now balances the load between two HP/UX Apps servers. |
|
|
|
Configure
and support 9iAS (Apache) environment. |
|
|
|
11/00
to 12/01 Role:
Oracle Applications 11i DBA |
|
Company:
Agility Communications, |
|
|
|
Installed,
implemented, and maintained Oracle 11i (11.5.2). Implementation includes
Financial, Manufacturing, and HR modules. |
|
Administered
Development, Test, and production environments on HP/UX 11.0 N and L class
servers. Production is a two-tier environment. Administer security (create
users and responsibilities), administer the 8.1.6 instance, provide end-user
support, apply and document patches. Backups administered by Omniback. Perform cloning of Test environment to
development environment. Cloned two-tier production environment to a single
tier Test environment for regression testing of patches. Installed a number
of Family packs to test and production (Order Management, Discrete
Manufacturing, Procurement, Receivables, etc.). |
|
|
|
Upgrade
11i from 11.5.2 to 11.5.3. Administer Vertex tax rate and geocodes.
Installed and configured Financial Analyzer and Oracle Express server. |
|
|
|
Installed
and administer Discoverer 3i on HP/UX platform. Create EUL and administer
security and user access. Upgrade to Discoverer 4i. Troubleshooting
performance issues related to HP/UX and Discoverer. Implemented Oracle Business Intelligence
views in Discoverer 4i. |
|
|
|
Extensive
use of AD administration tools (adpatch, adctrl, adident, etc.).
Administer Forms server 6.0.8.8. Upgrade to Forms 6.0.8.12. Administer the
Apache 1.3.9 server for ERP and Discoverer. Administer Report 6.0.8.8 server
for ERP. |
|
|
|
Install
Oracle Shop Floor Manager (OSFM). Provide administration support to Oracle
Consulting during implementation of OSFM. |
|
|
|
Installed
and maintained Oracle 8.1.7 for in-house developed applications. Implemented
MTS and Oracle JVM. Installed Oracle 9i on a development environment for new
development of the application. Configure and support 9iAS (Apache)
environment. |
|
|
|
Created
support documentation for implementation and administration of the
application, database monitoring, Discoverer, sysadmin
tasks, etc. Developed and implemented monitoring scripts for the application
and database. |
|
|
|
9/00
to 01/01 Role:
Oracle 8i DBA for Java Application Development Group |
|
Company:
Lucent, |
|
|
|
Tuning
production databases at customer site for Lucent. Provide support to
development and implementation groups for all applications that access Oracle
databases. The application is written in Java. The environment is Solaris 2.7
and NT. |
|
|
|
|
|
7/00
to 9/00 Role:
Oracle DBA for Data Warehouse Engineering Group |
|
Company:
Bristol-Meyers Squibb, |
|
|
|
Member
of Oracle DBA team, which supports a pharmaceutical Data warehouse
environment that contains 12 Terabytes of data. Administer Oracle 7 and 8
databases on HP/UX 10.20 and 11 K, N, and V class servers. Perform
installation and upgrades of Oracle server. Support data warehouse
development team and Sales/Marketing users. |
|
|
|
3/00
to 6/00 Role:
Manager DBA Group and Oracle 8i DBA for Web applications |
|
Company:
Destiny WebSolutions, Inc., |
|
|
|
Developed
and managed a DBA group of 3 DBAs. Hired 2 DBAs. Managed groups
workload. |
|
|
|
Also,
I was the Oracle DBA for various Internet applications for Financial Services
clients using Oracle 8.1.x (Oracle8i).
Install RDBMS software, administer development and QA instances.
Developed PL/SQL packages returning cursor variables for Java front-end.
Loading data using SQL Loader. Instances reside on Solaris 2.6 and AIX 4.3
servers. Applications use WebLogic or WebSphere.
Configure, implement and administer Jserver for
deploying Enterprise Java Beans (EJB). |
|
|
|
Provide
database support of production instances for clients. Configure and monitor
RMAN backups. Monitor database performance (I/O, space, etc.). Developed and administered very large
partitioned tables. Developed SQL Loader scripts for these tables. |
|
|
|
Maintain,
modify, and develop new data models using Erwin. |
|
|
|
2/99
to 2/00 Role:
Manager DBA Group and PeopleSoft DBA |
|
Company:
Fleet Credit Card Services, |
|
|
|
Built
and managed the Corporate IT database administration group reporting to the
VP of Systems. The group consisted of 10 Oracle DBAs. Performed employee
yearly evaluations and salary review. Also, managed budget of $5 Million.
Develop and implement policies, procedures, and tools for administration of
all Oracle databases in the corporation. Coordinate and manage the migration
of Oracle 7.3.4 to Oracle 8.0.5 and 8.1.5. |
|
|
|
Directly
involved in the database design for all applications being implemented in the
corporation. This includes DataMart and |
|
Data
Warehouse project, migration of PEGA systems from VMS to HP-UX, and various
Internet initiatives (Destiny/Lycos). |
|
|
|
Also,
I continued to support the PeopleSoft production, test, and development
environments as a lead DBA. |
|
|
|
2/98
to 2/99 Role:
PeopleSoft DBA |
|
Company:
Fleet Credit Card Services, |
|
|
|
Configured
and recommended for purchase the hardware and software necessary to support a
PeopleSoft GL, AP, and AM system on HP UNIX with
Oracle backend. Installed, implemented, and administered two-tier and
three-tier PeopleSoft Financials 7.0 and 7.5. Installed, configured, and
administered the Oracle database, process scheduler, application server,
tuxedo, and jolt. |
|
|
|
Administered
PeopleSoft HR 5.11 and GL/AP/AM 5.11 on HP UNIX using Oracle 7.3. |
|
|
|
|
|
6/97
to 2/98 Role:
Lead ORACLE DBA |
|
Company:
Advanta Credit Card, |
|
|
|
Lead
ORACLE DBA responsible for 40 plus instances at an |
|
|
|
3/97
to 6/97 Role:
ORACLE DBA/ HP-UX 10.x SYSTEMS ADMINISTRATOR |
|
Company:
Hewlett Packard Professional Services, |
|
|
|
Support HP PSO clients as an Oracle DBA and HP-UX 10.x Systems Administrator. My duties include installing and configuring Oracle 7.x, HP-UX 10.x, Service Guard, IT/O; troubleshooting Oracle performance problems; assisting and developing logical data models; creating and implementing a variety of Oracle database objects; design and create logical volume groups, logical volumes and file systems for Oracle data files, indexes, etc. I help developers tune their Oracle applications. I also develop Pro*C, PL/SQL, and Perl programs, as well as shell scripts. I used a variety of Oracle tools and utilities which include SQL*Loader, Import, Export, SQL*Plus, SQL*Forms, Reports 2.5, SQL trace/TKPROF, etc. The clients run their applications on HP 9000 K-class or T-class machines in a High Availability environment. |
|
|
|
7/96
to 2/97 Role:
Oracle DBA and Developer |
|
Company:
MERCK & CO., |
|
|
|
Tune
and create very complex SQL queries and views that access a very large ORACLE
7.1.6 database for a financial decision support system (DSS). Creating and
tuning PL/SQL 2.1 packages, stored procedures, and functions to be used by
application developers creating Data Windows in PowerBuilder 4.0. Tuning
using Explain Plan and TKPROF. Develop and maintain database triggers and
constraints. Added data integrity to a
group of tables with foreign keys and delete cascade. Develop and tune
existing Pro*C programs and stored procedures for the batch process which is
running on an HP 9000 K-class machine (HP-UX 10.10). Develop Data Windows
using PowerBuilder 4.0. Maintain
logical and physical data model using ERWIN. Installed and maintained Perl
5.003, DBI 0.74, and DBD-ORACLE (ORAPERL) .44 on HP 9000. Coded modules using
Perl 5 and Oraperl. |
|
|
|
12/95
to 7/96 Role:
Oracle DBA and Developer |
|
Company:
AT&T, |
|
|
|
Oracle
DBA and developer of Client/Server application for the Billing Collections
and Risk Management System. Developed logical and physical model. Wrote DDL
to create tables, views, indexes, and constraints. Implemented data integrity
with foreign keys. Developed Pro*C, PL/SQL 2.2, SQL*Loader, PERL 4, and ORAPERL
programs, packages, stored procedures, and functions that loaded, accessed,
and manipulated data on an ORACLE 7.2 database for the batch process that
runs on an NCR 3000 UNIX machine. In the system test phase I tuned the
on-line and batch portions of the application using Explain Plan and TKPROF.
In addition, I created Visual Basic 4.0 Enterprise Edition forms for Windows
95 Clients and reports using |
|
Crystal
Report 4.5. |
|
|
|
6/95
to 12/95 Role:
Oracle DBA and Lotus Notes Developer |
|
Company:
AT&T, |
|
|
|
Oracle
DBA and developer of LOTUS NOTES 3.2 system for Long Distance Marketing
Group. This system automated the workflow for the creation and maintenance of
marketing messages and billing inserts. My main function was to develop the
process that accessed and updated ORACLE 7 tables. This process was written
in C. The LOTUS NOTES Server runs on a Windows NT Server. The analysis was
done using an Object Oriented Methodology. |
|
|
|
Attended
all available Oracle DBA training classes administered by Oracle Corporation.
Also, attended Lotus Notes administration courses. |
|
|
|
1/95
to 5/95 Role:
Pro*C Developer |
|
Company:
AT&T, |
|
|
|
Project
Leader and developer of UNIX/C portion of a Residence Billing System (IDB
TEXT) and a Financial Reporting System |
|
(RIPS).
Applications were developed using ORACLE FORMS 3.0 on an NCR 3000 with data
stored on an ORACLE 6 database. Batch processes were written in C and PRO*C. |
|
|
|
|
|
5/88
to 12/94 Role: DB2
Developer |
|
Company:
AT&T, |
|
|
|
Developed
and maintained a Financial reporting system with it’s
data stored on DB2 tables on an IBM Mainframe system. The application was
developed using COBOL II. |
|
|
|
6/83
to 5/88 Role:
Mainframe Developer (BAL, COBOL, PL/1) |
|
Company:
Various |
|
|
|
Contracted
by a number of companies to develop and maintain billing, financial, and
marketing systems on MVS platforms using BAL, COBOL, and PL/1. Provided PC
training and end-user support. American General (Houston, TX), Alexander
Hamilton Life (Farmington Hills, MI), R.L. Polk (Taylor, MI), Detroit Ball
Bearing (Detroit, MI), AT&T (Piscataway, NJ; Kansas City, KS; Silver
Spring, MD; Fairhaven, MA; Mesa, AZ). |
|
|
|
|
|
6/81
to 6/83 Role:
PL/1 and BAL Developer
|
|
Company:
New York Life Insurance Co., |
|
|
|
Developed
and Maintained a Group Billing System written in BAL and PL/1 on MVS
mainframe. |
|
|
|
|
|
EDUCATION: |
|
|
|
1993
to 1995 – Attended |
|
1995
– Oracle7 DBA and developer courses administered by Oracle Corporation |
|
1997
– HP/UX Unix administration courses (LVM, Admin, MC/Service Guard)
administered by HP |
|
1998
– PeopleSoft 7.5 implementation and administration courses administered by
PeopleSoft Corporation |
|
2002
– Completed 4 out of 5 Oracle DBA OCP certification exams. Scheduled to
complete final exam. |
|
|