Earl D Shaffer

Principal Advanced Support Engineer at Oracle ACS

ab81qg@r.postjobfree.com

Summary

Specializing in

high performance database and application tuning

Teaching clients about the value of

- internal documentation including a production "run book"

- carefully implementing all Oracle Best Practices

- rehearsing failure scenarios to test formal, documented SOPs and checklists

Real-world hands-on Tuning experience with 11g Release 2 issues

Upgraded 9i, 10g, and 11gR1 DBs to 11gR2 using DBUA and exp/imp

Designed implementations of Disaster Recovery and RMAN backup/recovery

Defined and implemented Production Support SOPs

Developed custom tuning methodology for Siebel and PeopleSoft envs

Specialties

Core skills:

- Installations, upgrades, migrations, and DR

- DB + App Performance Tuning - AWR /ASH/ADDM

Presented "AWR/ADDM/ASH in 11g" NYOUG Summer conf 2011

Recent Oracle classes and seminars:

- 11g Advanced Streams, Oracle Education

- EM 12c, install/upgrade, Oracle Education

- EM 12c, use/admin, Oracle Education

- 11g RAC Admin, Oracle Education

- 11g R2 Best Practices, Tom Kite seminar

Experience

Principal Advanced Support Engineer at Oracle

May 2012 - Present (5 months)

ACS supports Oracle customers all over the USA

Handling critical on-site issues such as

- Performance Tuning

- RAC operational issues

- Exadata post-install customization and configuration

- MAA tests such as Data Guard setup, switch-over and fail-over tests

- Assisting customers with upgrades, patching, and Best Practices

Page1

Senior DBA and VP of Oracle Practice at OracleMan Consulting

2010 - May 2012 (2 years)

Client Projects

- Providing customized DBA best practices and SOP documents

- Mentoring clients about how to create a "run book" of production operations

- Contributed to the design of an HA solution for PeopleSoft 8.51 upgrade to 11g RAC env

- Oracle MAA review with RAC, RMAN and Data Guard (physical)

- Best Practices for monitoring Oracle 11g Release 2 RAC

- Best Practices ASM custom log monitoring

- Best Practices Data Guard custom log monitoring

- Best Practices - DB performance, environment setup, "right the first time"

- Oracle 11gR2 - install, testing, admin and monitoring

- Oracle non-RAC 9i to RAC 11gR2 migration planning

- Oracle 11gR2 RAC - post-install admin and monitoring

- Oracle 11g upgrade projects and DBA consulting

- Oracle RAC 11gR2 DB design, SAN / ASM on Linux

- Moving AIX-based databases to Red Hat Linux

1 recommendation available upon request

Senior DBA at The Hartford

2009 - 2010 (1 year)

Senior DBA

- Day-to-day DBA admin on 40+ databases

- Supporting custom applications and Siebel system

- Oracle application development support

- SQL Server 2005 - light day-to-day administration

Projects:

- Key member of team designing specifications to migrate Vitria/SOA to 11g RAC

- Set up the Grid Control-based DB monitoring and for tuning using SQL Tuning Advisor and Profiles

- Lead the enhancements of RMAN backup and catalog scripts

- Lead the research into SQL Server 2008 R2 new features

Managing Partner at OracleMan Consulting

2006 - 2009 (3 years)

Completed many 10g to 11g upgrades and migrations on various OSs

Completed many 9i to 11g upgrades and migrations on various OSs

Completed many 9i to 10g upgrades and migrations on various OSs

Completed many 8i to 10g upgrades and migrations on various OSs

Taught an on-site "11g new features" training for clients

Provided on-site and remote day-to-day Oracle DBA services

Specializing in installs, upgrades, migrations, and patching

Page2

Real-world production experience with 10gRAC and day-to-day ASM

Developed and implemented production support and "on call" SOPs

5 recommendations available upon request

Senior Oracle DBA/architect at GSI Commerce

2002 - 2006 (4 years)

Provided 24x7 Oracle DBA production support for 100+ DBs

Created 10g RAC cluster systems

Created 9i RAC cluster systems

Developed shell-script-based DB and host monitoring system

Wrote, documented and implemented on-call SOPs

Lead key 10g upgrades and new feature integration projects

7 recommendations available upon request

Managing Partner at OracleMan Consulting

2000 - 2002 (2 years)

Completed projects at many clients in and around PA, NJ, and DE

Industries such as insurance, pharmaceuticals and banking.

Provided on-site Oracle DBA consulting, day-to-day management

Supported Production systems using versions 8, 8i, and 9i

Implemented custom backup and recovery solutions

2 recommendations available upon request

Oracle DBA at Barron Collier Partnerships

1996 - 2000 (4 years)

Provided DEV, TEST, and PROD Oracle6 to 7.0 upgrades

Developed SOPs for on-call and general admin tasks

Provided day-to-day DBA tasks

Provided backup AIX system admin services including patching

Conversion of Oracle Financials 9.4 to MS SQL Server-based App

In-house systems supporting

- commercial real estate inventory and marketing apps

- specialty foods and distribution apps

Oracle DBA at Johnson & Johnson

1992 - 1996 (4 years)

Tampa-based subsidiary Critikon (medical devices and info systems)

DBA - Oracle v6 and 7.0 to 7.1

NetWare, Windows, and OS/2 based Oracle development

Development - Oracle Forms, SmallTalk/Oracle

Object-oriented analysis, design, and programming

1 recommendation available upon request

Page3

Project Leader at Eastman Kodak

1988 - 1992 (4 years)

Project Leader for the natural products research repository system

Key member of the Oracle systems development team

Upgraded v5.1 DB to Oracle 6.0, back when it was char-based

Taught internal classes on:

- Oracle Forms

- SQL ReportWriter

- Pro*C

2 recommendations available upon request

Analyst at GE

1985 - 1987 (2 years)

Work projects in the day, and completed my graduate work at night

Was awarded a MS in Computer Science - 2nd in my class

Knowledge Engineering system programing using KEE System

Wrote native LISP programs for AI systems and project work

PC-based Knowledge Engineering system evaluations for special projects

Researched AI topics such as blackboard architecture and goal-seeking

Satellite telemetry simulation using FORTRAN programs and specialized HW

Programmer/Analyst at Siemens AG

1983 - 1985 (2 years)

Back then we were SMS

Began work there just as the PC and LAN came into businesses

Taught C programming classes

Developed applications with the MDBS III database system

Moved the VMS group and worked on pharmacy applications

Projects

2010 - healthcare client project

Members:Earl D Shaffer

Upgrade PeopleSoft, move to RAC, add Data Guard

2010 Public Transportation Client project

Members:Earl D Shaffer

DB audit, 20,000 ft view report, 11gR2 upgrade project plan

Skills & Expertise

Oracle

Page4

Database Administration

Oracle DBA

SQL

Project Planning

Project Implementation

Software Project Management

MS Project

Oracle RAC

Oracle Data Guard

SQL Server

SQL Tuning

Database Management

Performance Tuning

Shell Scripting

Unix Shell Scripting

Solaris

AIX

Linux

Red Hat Linux

C

Change Management

Organizational Change

Technical Writing

Technology Transfer

Knowledge Management

Artificial Intelligence

Knowledge Engineering

HP-UX

Data Management

Patch Management

Installations

Scripting

AWR

RMAN

Operating Systems

Oracle Enterprise Manager

Databases

Ksh

RedHat

Oracle Administration

Database Design

High Availability

Performance Management

Oracle Streams

Courses

Page5

Senior DBA

The Hartford

Oracle 11g RAC instructor-led class

Managing Partner

OracleMan Consulting

Oracle 9i New Features seminar

Senior Oracle DBA/architect

GSI Commerce

Oracle10g New Features seminar

Oracle 10g RAC

Senior DBA and VP of Oracle Practice

OracleMan Consulting

Oracle 11g Release 2 New Features seminar

Education

West Chester University of Pennsylvania

MS, Computer Science

Activities and Societies: 2nd student at WCU to receive the

Master Of Science in Computer Science

1 recommendation available upon request

West Chester University of Pennsylvania

BS, Computer Science/Applied Mathematics

Activities and Societies: CS tutor

Honors and Awards

27 years of IT experience

Hands-on, day-to-day Oracle DBA for over 15 years

Presented technical papers at local, national, and international conferences

Author of the by-laws for local and regional Oracle User Groups

Awarded "Oracle Master", Oracle7, 1995, by Oracle Education

Page6

Interests

Guitar-based classic rock music, new technology, geeky Oracle stuff

Page7

Earl D Shaffer

Principal Advanced Support Engineer at Oracle ACS

ab81qg@r.postjobfree.com

19 people have recommended Earl D

"I have worked with Earl D Shaffer and I have noted that he is very proficient at writing scripts and he has

significant experience with Oracle technology."

Don Burleson, Student, The University of New Mexico - Robert O. Anderson School of Management, was

with another company when working with Earl D at OracleMan Consulting

""As a member of the technical team on one of my projects, Earl was my "go to" guy for technical issues

related to databases. Earl was a great asset to the project with his technical knowledge and experience. Earl

contributed well thought out comments and recommendations to the final project documentation.""

Chip Basquill, Project Manager, Barclays Bank, worked with Earl D at OracleMan Consulting

"Earl is an accomplished Oracle DBA who is adept at both the administration of Oracle databases, and also at

SQL-level and system-level tuning."

Christopher Johnson, Owner, Foundation Software Technology, Inc., worked with Earl D at OracleMan

Consulting

""Earl was placed at one of our Main Clients as a Senior Oracle DBA who performed major upgrades and

migrations to their Enterprise Oracle Environment. Earl gave more than a 100% to the project performing

long hours when needed. He was extremely knowledgeable with the Entire Oracle Upgrade and very detail

oriented. I would definitely work with Earl again for future projects with any of my clients.""

Scott Lieb, was Earl D's client

"I have know Earl for over 30 years. He is one of the brightest individuals I have met, especially when it

comes to Oracle. Having been an Oracle DBA in my past, I can assure anyone thinking about hiring Earl that

they are making the right choice! Very dedicated and hard working."

Robert Lucchesi, Sr. Project Manager/Engagement Dir., Cornerstone Management, was with another

company when working with Earl D at OracleMan Consulting

"Earl and I worked closely together at BarclayCard US as Senior Oracle Database Administrators. Earl has a

breadth and depth of knowledge about Oracle database systems that immediately benefited BarclayCard US.

The systems we worked on were of disparate and non-standard configurations, even between upper and lower

Page8

environments, and Earl was a driving force to synchronize the environments at the core of the database

functionality so development projects could work their way through the environments soundly, and function

correctly in each environment. I highly recommend Earl Shaffer as a Senior Oracle Database Administrator as

he has the skills and knowledge to manage databases for development and production operations."

David Hansen, Senior Database Administrator, Barclaycard, worked directly with Earl D at OracleMan

Consulting

"Earl was a senior member of the DBA group at GSI when I worked with him. Earl, being an Oracle Expert

was the go to guy for any/all oracle issues. He was also an author who created SOPs for GSI. He is a positive

role model for any DBA and brings in great work ethic. He is a great listener and a painstaking worker who

strives for excellence in whatever he does. I cherish a valuable experience working with him."

Parasuraman Sekar (Chandra), Oracle DBA, GSI Commerce, worked indirectly for Earl D at GSI

Commerce

"Earl was instrumental in helping me understand the structure of the GSI databases, and was a great resource

to bounce ideas off of when I was adding or modifying structures to add new features or improve

performance. He has a wealth of knowledge and is always willing to share it."

Ray Mcglew, Data Architect, GSI Commerce, worked directly with Earl D at GSI Commerce

"I can not say enough good things about Earl. I was new to GSI and Earl helped train me on the job. He was

very helpful in getting me up to speed with details around the data movement jobs, and offered his help when

I was on call and could not resolve an issue. I remember having to call him 3:00am to help me with an issue,

he was so nice and supportive. He has very good communication skills and takes pride in his work. He has

alot of knowlege of Oracle systems and would be a wonderful asset to any company that hires him."

Kristen Gautney, Oracle DBA/Developer, GSI Commerce, worked indirectly for Earl D at GSI

Commerce

"I worked with Earl at GSI for many years. He worked as a senior DBA while I was in the Linux system

administration group. Therefore we worked together in production system development and support. We

worked on many high-stress 'late night' production support issues. He worked very well with me as well as

the other SysAdmins in resolving these issues. I always had a good feeling when I knew he was 'on call'. I

would recommend him for any Oracle DBA position"

Jennifer Lynn, System Admin, GSI Commerce, worked with Earl D at GSI Commerce

"I worked with Earl during a complex infrastructure and database upgrade at GSI Commerce. He was a go-to

person for defining the upgrade we were planning. His meticulous attention to detail and insistence on "doing

it right" made him one of a small number of DBAs I could always rely on to help the project succeed. I

happily recommend him."

Jon Tulk, Consultant/Project Manager, GSI Commerce, worked with Earl D at GSI Commerce

Page9

"The core of our ecommerce business is data. Processing the data into meaningful and useful information that

supports, compliments and furthers the business is critical to success. Earl provided extensive, knowledgeable

and relevant support in maintaining and extending the information processing methods that were key to our

business. I can recommend Earl to any organization that wants dedicated, hard working and technically

current expertise with Oracle in a high volume data environment."

Joe Romello, VP Technology Solutions, GSI Commerce, managed Earl D at GSI Commerce

"Earl and I worked together when I was fairly new in Data Warehousing and I dependant on the DBA’s for

assistance in database maintenance and query tuning. He was always helpful, polite and professional. He

responded immediately to my questions and took the time to explain to the solutions. As a younger developer,

his patience and mentoring helped me grow professionally and I am truly grateful for his time. I highly

recommend Earl to any position he is pursing. He is extremely knowledgeable and an absolute pleasure to

work with."

Jodi Devine, Data Warehouse Engineer, GSI Commerce Inc, worked with Earl D at GSI Commerce

"Earl brings a new level of professionalism to providing Oracle DBA services, with a deep knowledge of

Oracle internals, proffessional networks that he leverages and a comprehensive toolbox of diagnostic and

tunig tools."

Robin Burris, was Earl D's client

"I have known Earl for many years as an Oracle develper/DBA. He is a true developer, dedicated to his craft,

and willing to put in the long hours to make a project succeed. Additionally, he can be an "out of the box"

thinker, providing innovative solutions to your problems. You can't go wrong using Earl's talents."

Warren Capps, President, Illuminations Inc., was with another company when working with Earl D at

OracleMan Consulting

"I very much enjoyed working with Earl as part of a software development team at Critikon, a Johnson &

Johnson company. Earl is hands down the best Oracle DBA I have ever had the pleasure of working with, and

I have worked with many over the years. Intelligent and detail-oriented, you can always depend on Earl to be

on top of his game. Earl is simply one of those rare individuals who can wrap a deep and wide technical skill

set with a pleasant and business savvy persona."

Michael Aube, Developer, Critikon, Inc., worked directly with Earl D at Johnson & Johnson

"Earl is a results oriented professional with excellent knowledge of database design and development

particularly in Oracle. Earl was instrumental in the development and delivery of an integrated set of systems

in early stage R&D for a major US pharmaceutical company. I highly recommend Earl for any role where he

can leverage his extensive knowledge of Oracle and other database technologies."

Jim Koch, Director, Integrated Discovery Systems, Sterling Winthrop, managed Earl D at Sterling

Winthrop

Page10

"Solid technical resource with outstanding problem solving and resolution skills. Excelled at developing

business focused solutions based on novel techniques and state of the practice technologies."

Chris Bouvier, Program Manager/Director Application Development, Eastman Kodak/Sterling Research

Group, managed Earl D at Sterling Research Group

"Earl Shaffer received both his B.S. Computer Science and M.S. Computer Science at West Chester

University in the 1980’s. I served as his advisor as well as his instructor for several courses. In addition to his

outstanding academic achievement (GPA=3.93 as a graduate student), Earl demonstrated great motivation

and initiative in his studies. Several of his courses (Journal Seminar, Thesis, Research Thesis) required

considerable independent work. He really excelled in this environment, pointing the way toward a very

successful career. I have been following Earl’s professional activities since graduation, and I am very proud

of his accomplishments. I am confident that he will continue to do an outstanding job with whatever he does

in the future. Dr. James D. Fabrey Chairperson, Computer Science Department Special Assistant to the Vice

President for Information Services West Chester University 25 University Avenue, Room 150

ab81qg@r.postjobfree.com 610-***-****"

James Fabrey, Chairperson, Computer Science, Special Assistant to the VP for Information

Services, West Chester University, taught Earl D at West Chester University of Pennsylvania

Expertise

Databases

Contact Earl D on LinkedIn

Page11

Contact this candidate