Merle C.
Deardorff
Cell: 214-457-2453 Home: 972-612-4046
Merle Deardorff MerleDear@netscape.net
PROFESSIONAL SUMMARY: A seasoned professional with over twenty
years technical experience, seven of which were focused in database concepts
including development, design, and implementation. Proven communication skills, with experience
serving as a liaison between the scientific and business community, and handling
customers in crucial technical situations.
Plus, demonstrated strong analytical skills in various roles including
risk analysis, the application of business rules, and identifying problems and
recommending solutions for the IT enterprise.
SKILLS HIGHLIGHT:
Oracle
Products:
RDBMS
Server EE 7.3-9.2, 9iAS Application Server, 9iAS Portal, Multi Threaded Server,
9i
Advanced Replication, Oracle Enterprise Manager, RMAN, Tuning Pack 9i,
Oracle
Names Server, Networking Assistant, Oracle Spatial to 9i, SQL*Plus, PL/SQL,
SQL*Loader,
Designer 2000, Transparent Gateway, Client ODBC
Operating Systems:
SUN Solaris to 8.0, IBM AIX to 4.3, Windows
NT/2000, HP-9000, UNIX/AIX/HP-UX
Management/Leadership
Skills:
5 years TQM, 3 years Lead Software
Engineer
Programming Languages:
PL*SQL, SQL, UNIX-kron scripting
Case Tools:
Designer
2000, ERWIN knowledge
Communications:
RealVNC, TelNet, FTP, TCP/IP, Novell
Date Base
Design:
§
Business Rules
Research, Interrogation
§
Requirements
Analysis
§
Logical Design
§
Physical
Implementation / De-normalization
Other Skills:
Technical:
§
Statistical
Analysis using MS EXCEL spreadsheet and DDE/ODBC database interface
§
MicroSoft OS 2000,
NT & XP, Office98-2003 Dialogue, Macro & VBS scripting
§
Microsoft ACCESS
Database, ODBC link to Oracle instance
§
Subject matter
expert in Propagation of Uncertainty and Risk evaluation
§
PeopleSoft Tools
I & II
§
ASSESS - Risk
Evaluation
Other:
§
Vocabulary:
Active & Reserve Navy, Nuclear Navy, Physical Security, Civil Engineering,
Chemical, Mathematics, Electrical, Medical & Botanical
EMPLOYMENT HISTORY:
ORACLE CORPORATION, 1998 –
2003
(Oracle Premier Support Team
“Advanced Product Services”)
The
Oracle Corporation is one of the largest software companies in the world, and the
Oracle Support Team “Advanced Product Services” contributes significant
revenues for the Oracle Corporation.
Over the past three years it has generated $4 Billion and is considered
an elite team. Oracle Support Services is
client specific, and is proactive, offering a higher degree of risk management
for its clients that include highly visible companies such as Sprint,
Ameritrade, Fidelity, eBay, IRS and Amazon on a 24 X 7 basis.
Senior Support Analyst, DBA (July, 1999 – May, 2003)
Primary Responsibilities:
·
Played a major
role in solving Severity One and Two (Production Database Down and Major
Business Impact) client service issues by determining the nature of the problem
and providing a solution
·
Developed a
rapport with clients and gained an in-depth familiarity with their specific needs
and environment
·
Provided technical
assessments regarding configuration and performance analysis to assist clients
in evaluating solutions
·
Replicated client
environment on in house test systems to provide work-around assistance
·
Helped customers
manage and maintain their Oracle environments, allowing for more proactive
service, and problem avoidance; Conducted migrations and backup strategies
·
Performed on site
engagements for tuning, installation, migrations and proactive analyses
Senior Consultant, DBA (November 1998 – July, 1999)
Primary Responsibilities: Performed
services at client sites as follows.
BHA Group Energy Document
tracking - future NCA
*
Consulted with IT
Department manager and Lead DBA to assess needs for a comprehensive backup system
*
Evaluated the
existing backup scripts for a cold full export
*
Installed,
modified and tested a hot backup script on Windows NT to satisfy the IT department’s
future requirements
*
Instructed Lead
DBA on the details of the hot backup scripts
*
Analyzed sizing
statistics for all tables and tablespaces
*
Recommended
initial and next extents plus percent increase
*
Instructed Lead
DBA on implementing the sizing changes, and in the use of Explain Plan in
preparation of tuning their application
Raytheon Aircraft Inventory
system
*
Installed Oracle
8.0.3 and 8.0.5 on Windows NT system
*
Developed and
implemented scripts for (Cold, Hot & Export) backup methods on Windows NT
hosts
*
Performed full database recovery on implemented backups
on the LOB system
SYSTEMS RESEARCH GROUP, 1997
– 1998
Systems Research
Group is an IT contractor concentrating primarily in the government sector. It
typically functions as a subcontractor, and in this case it acted as a
subcontractor of Lockheed Martin ITT for a US Navy HRMS project. The US Navy project was referred to as NSIPS
(Naval Integrated Personnel System), and was implemented on an Oracle 7.3.3.4
database.
Data
Administrator/Oracle DBA
Primary Responsibilities:
§
Performed as Data
& Database Administrator - ORACLE / PeopleSoft HRMS Application
§
Responsible for
over 350 Validation Tables, Data Research/Compilation, Database Table Creation,
and Data Load
§
Worked closely
with NAVY Functionals to define HRMS Business Rules and to verify Logical Codes
used by both Active and Reserve US Navy components as well as Officer and
Enlisted systems
§
Installed EDMS
conversion/interface tool on Windows NT
§
Linked Translate
Tables in EDMS and Loaded data into Translate Tables for EDMS
conversion/interface using SQL*Loader
§
Developed mapping
between EDMS meta database and NSIPS
§
Responsible for
Compliance issues between Department of Defense and NSIPS use of Logical Codes
§
Performed
Database and PeopleSoft Administration in support of NSIPS development and test
groups
§
Supported PeopleSoft
Table Builds and Table mods for development team
§
Completed Oracle
(ILT) course work in EDMS and EDMS installation
§
Completed PeopleSoft
(ILT) course work in Tools I & II
Rockyflats, Inc., (1991 –
1996)
Rocky Flats Environmental Technology Site is a Super Fund Site. From the period 1991 through 1996 it was
managed by several contractors.
Senior Member of Technical Staff
NDA Instrument Specialist
Primary Responsibilities:
§
Performed as Database
Administrator of NDA Standards Database and served as liaison between Safeguards
Measurements and Chemical Standards Laboratory
§
Developed the
procedures and data acquisition systems for the calibration relationship for
all the NDA (Non Destructive Assay) instrumentation
§
Created software
program for Holdup Measurements department
§
Created software
program for Time-Tracker (Microsoft EXCEL database application) for the purpose
of acquiring budgetary information on approximately 400 Safeguards employees
§
Led program
development for Plutonium Brushing Stabilization Program
§
Provided summary NDA
measurement control data reports to the Department of Energy
Education:
Currently working on Oracle Certified Professional (OCP) Oracle DBA 8i
– 9i
ORACLE 7 Masters Certificate, ORACLE
Education,
§
Database Administration
and Applications Database Administration
B.A., Chemistry,
Publications:
Institute of Nuclear Materials
Management (INMM), Vol. XXII 34th Annual Proceedings
(Speaker
and co-author) “AUTOMATED TEMPERATURE CORRECTION FOR BGO
DATA
ACQUISITION
SYSTEM USED FOR HOLDUP MEASUREMENTS”
