|
OBJECTIVE
|
To
focus and provide solid design and excellent quality as a Senior Database
Administrator working with Oracle, MySQL, and SQL Server database
technologies and the Java and PL/SQL programming languages.
|
|
|
|
|
|
EXPERIENCE
|
The DBA Zone, Inc., Pittsburgh PA
|
|
|
Senior Database
Administrator
|
August 2004 –
Present
|
|
|
|
|
|
- Designed and
implemented various high availability solutions for a diverse group of
clients running Oracle9i,
Oracle10g, and Oracle11g using Data Guard, RMAN, Oracle
Real Application Clusters (RAC), Streams, Oracle Flashback, and
LogMiner. Provided JDBC programming support to implement Transparent
Application Failover (TAF), Fast Application Notification (FAN), Load
Balancing Advisory (LBA), and a custom application to monitor LBA FAN
events.
- Technical
lead for a large number of tuning projects. Performed application, SQL,
and database instance tuning using a wide range of technologies
including ADDM, AWR, Statspack, extended SQL trace (event 10046 trace
files), CBO analysis (event 10053 trace files), Confio, OEM Performance
Manager, and custom scripts.
- Created an automated,
enterprise wide monitoring infrastructure using several key technologies
including UNIX shell scripts, PowerShell, Java, and SQL. This allowed
our operational DBA team to efficiently gather database metadata,
exceptions, and performance statistics for remote clients running Oracle,
MySQL, and SQL Server using a consolidated Intranet approach.
- Developed,
designed, and implemented the company’s internal DBA Portal using
Oracle10g Application Server.
- Established
and wrote the company’s standards and best practices document for all
Oracle database environments based on Oracle's Optimal Flexible
Architecture (OFA). This document outlined all standards for the DBA
Operations Group including installing/upgrading Oracle, creating
databases, DBA tools, administration and monitoring, naming standards,
coding standards for Java and PL/SQL, policies, practices and
procedures.
|
|
|
|
|
|
Management Science
Associates,
Pittsburgh PA
|
|
|
Senior Database
Administrator
|
March 2004 –
August 2004
|
|
|
|
|
|
|
- Led all major
tuning efforts using Statspack, SQL tuning, and the wait events
interface that resulted in significant improvements in response times
for both application and data migration modules.
- Provided DBA
and programming support for all internal and client based Oracle
implementations.
- Developed and
integrated several web-based modules in Perl and Java for analyzing data
integrity and tuning metrics for the divisions’ flagship product.
- Provided
mentoring and knowledge transfer to DBAs and developers on Oracle
architecture, Oracle9i new features, tuning methodologies,
database replication, RMAN backups, Oracle9i RAC, Oracle’s JVM,
PL/SQL, and the BEA WebLogic Platform.
|
|
|
|
|
|
|
CoManage
Corporation,
Wexford PA
|
|
|
Senior Database
Administrator
|
May 2002 – January
2004
|
|
|
|
|
|
|
- Performed
analysis of current optimization model and provided recommendations to
move to Oracle's cost-based optimization. Led the stress test initiative
to evaluate the success of this approach.
- Established
and wrote the Performance Tuning guidelines for the Engineering
Department to enhance the quality of the product for all current and
future code development. This document includes hints for SQL, PL/SQL
and JDBC performance tuning, application tuning methodologies,
determining instance and I/O efficiency, and using tools like Statspack,
Precise/Indepth and TKPROF.
- Designed and
implemented a web based solution in Perl and DBI:DBD
for capturing and reporting metrics from Statspack, Database Resource
Manager, Shared Server Architecture (formerly known as Mutli-Threaded
Server), latching and wait event statistics and the efficiency of the
Shared Pool.
- Developed and
designed Java packages and PL/SQL packages to be included in the
TrueSource product that provides automated database maintenance,
backups, and tuning support.
|
|
|
|
|
|
|
Marconi
Communications (formerly FORE Systems), Warrendale PA
|
|
|
Senior Database
Administrator
|
May 1998 – May
2002
|
|
|
|
|
|
|
- Designed and
implemented Web*DBA, a web based DBA tool that provides solutions to
enterprise database management from a common interface. Some of the
current modules include Tablespace Monitor, Change Management, Security
Manager, Session Manager, Lock Manager, Utlstat and File IO.
- Led the
application design team in developing a custom ETL application using
built-in Oracle technology (Oracle Replication, Materialized Views, Snapshot's,
and PL/SQL) as well as designing the Star Schema used to support the
company's Enterprise Business Intelligence system.
- Established
standards for all Oracle database environments based on Oracle's Optimal
Flexible Architecture (OFA). This initiative involved redesigning all
new and legacy environments to adhere to these newly established
standards.
- Established
and wrote the Database Administrators Procedures document for the IT
department. This document outlines all standards for the DBA Group including
installing/upgrading Oracle, creating databases, DBA tools,
administration and monitoring, naming standards, coding standards for
Java and PL/SQL, policies, practices and procedures.
- Redesigned a
thorough backup and recovery strategy for all major production systems.
This initiative involved the design and development of several UNIX
shell scripts used for both physical and logical backups. Also included
in this effort was the development and testing of various recovery
strategies that included media failure, user failure, and block
corruption.
- Successfully
maintained peak performance of all primary databases by providing
advanced tuning methods, customized scripts, Oracle Enterprise Manager
and Precise/SQL.
|
|
|
|
|
|
|
Computer People, Pittsburgh PA
|
|
|
Programming / DBA
Consultant
|
September 1997 –
May 1998
|
|
|
|
|
|
|
- Provided
programming and DBA support for migrating corporate wide applications
from the IBM Mainframe to a client/server environment using Oracle 7,
Pro*C and OpenVMS.
- Designed,
coded and converted various Pro*C programs from COBOL for use in the
current Analysis Data Warehouse.
- Successfully
designed and developed a backup/recovery strategy and procedures for
several Oracle 7 databases.
- Enhanced the
performance of the company's Oracle environment by providing advanced
performance tuning and coding standards.
|
|
|
|
|
|
|
Lawrence Livermore National
Laboratories,
Livermore, CA
|
|
|
Computer Scientist
/ Math Programmer
|
July 1994 –
September 1997
|
|
|
|
|
|
|
- Optimized,
automated and redesigned a cost accounting system from Oracle Forms
3.0/Korn Shell to the Web using C, Perl 5, Oraperl, and PL/SQL.
- Performed
needed DBA tasks to redesign and tune several Oracle instances hosted on
VMS.
- Managed a
group of developers responsible for researching and recommending
solutions for the department's current and future Oracle Web
infrastructure.
- Selected as
task leader and programmer for converting extension scripts and C
programs for the Oracle Financials from VAX/VMS to HP UNIX.
- Implemented a
secure infrastructure for developing transaction based financial
applications in PL/SQL and Oraperl for use within the company's newly
created web based infrastructure.
|
|
|
|
|
|
EDUCATION
|
Bachelor of
Science
California State University, Stanislaus
Major:
Computer Science
|
May 1994
|
|
|
|
|
|
PUBLICATIONS
|
Conducting the
Java Job Interview
Rampant
TechPress, Author
|
April 2004
|
|
|
|
|
|
|
Conducting the
J2EE Job Interview
Rampant
TechPress, Author
|
April 2004
|
|
|
|
|
|
|
Oracle PL/SQL for
DBAs
O’Reilly,
Technical Editor
|
October 2005
|
|
|
|
|
|
|
Oracle Privacy
Security Auditing
Rampant
TechPress, Technical Editor
|
September 2003
|
|
|
|
|
|
|
www.idevelopment.info
Owner,
Site Author
|
January 1998 -
Present
|
|
|
|
|
|
|
Oracle Technology
Network
Guest
Contributor
|
June 2004 -
Present
|
|
|
|
|
|
|
The Pipelines
Newsletter
Guest
Contributor
|
September 2003 -
Present
|
|
|
|
|
|
|
SearchOracle.com
Guest
Contributor
|
June 2004 -
Present
|
|
|
|
|
|
CERTIFICATIONS
|
Oracle Database
Administration 10g
Oracle
Corporation
|
December 2009
|
|
|
|
|
|
|
Oracle Database
Administration 9i
Oracle
Corporation
|
March 2006
|
|
|
|
|
|
|
Oracle Database
Administration 8i
Oracle
Corporation
|
January 2003
|
|
|
|
|
|
|
Oracle Database
Administration 8
Oracle
Corporation
|
February 2002
|
|
|
|
|
|
|
Oracle Database
Administration 7.3
Oracle
Corporation
|
December 1999
|
|
|
|
|
|
|
Java Development
Learning
Tree International
|
October 2001
|
|
|
|
|
|
SKILLS
|
Languages:
|
Ada
|
C/C++
|
C#
|
DBI:DBD
|
|
HTML
|
Java
|
JavaCC
|
Javascript
|
|
JDBC
|
JScript
|
Oracle
JVM
|
Oracle
XMLDB
|
|
Perl
|
PHP
|
PL/SQL
|
Pro*C
|
|
PowerShell
|
sed/awk
|
SQL*Loader
|
SQLJ
|
|
T-SQL
|
Tcl
/ Tk
|
Troff
|
UNIX
Shells
|
|
Visual
Basic
|
XSL
|
XML
|
|
|
|
|
|
|
|
|
|
Databases:
|
Oracle
RDBMS (6.x – 11g R2)
|
SQL
Server (2000 – 2008 R2)
|
|
MySQL
(3.23 – 5.x)
|
|
|
|
|
|
|
|
Application Server
Environments:
|
Oracle
9i AS, 10g AS
|
OC4J,
ADF, BC4J
|
|
Oracle
WebLogic Suite
|
Sun's
J2EE SDK
|
|
|
|
|
|
|
LDAP:
|
Oracle
Internet Directory
|
Netscape
Directory Server
|
|
Oracle
LDAP SDK - (PL/SQL and Java)
|
Netscape
LDAP SDK - (Java)
|
|
|
|
|
|
|
Development
Environments:
|
JDeveloper
|
Visual Studio
|
|
Designer/Developer 2000
|
Oracle Application Express
|
|
IntelliJ IDEA
|
Discoverer 4i
|
|
Visual FoxPro
|
UltraEdit
|
|
|
|
|
|
|
Operating Systems:
|
UNIX
- (SunOS, Solaris, HP-UX, Linux)
|
OpenVMS
|
|
Windows
NT/2000/XP/2003/2008/2008R2
|
|
|
|
|
|
|
Software
Configuration Management:
|
Apache
Subversion
CVS
- (Solaris, WinCVS)
Continuus
Oracle
Software Configuration Manager (formerly
Oracle Repository)
|
|
|
|
|
|
Volume Management:
|
Oracle
ASM Dynamic Volume Manager (ADVM)
Oracle
Automatic Storage Management (ASM)
Solstice
DiskSuite / Volume Manager
Linux
Multipath
|
|
RAID on Linux - (md, raidtools, mdadm)
|
|
Sun
StorEdge RAID Manager
|
|
Logical
Volume Manager
|
|
|
|
|
|
Backup Management:
|
|
|
REFERENCES
|
References
are available on request.
|
|
|
|
|
|