DATABASE ADMINISTRATOR
Database administrator (DBA) with over 20 years experience with variety of
database management systems (DBMS). Delivered project development through
production support for IBM DB2 v8 on z/OS, Oracle 9i, 10g and Sybase 12.5 on Sun
Solaris/ Unix 9, SQL Server 2005 on NT.
Areas of expertise include:
Technical Leadership
Project Management
Problem Solving
Decision Maker
Policy and Procedures
Mentoring
Physical Database Design
Client Focus
Collaborating
TECHNICAL SKILLS
Hardware: IBM System z990, IBM System z10, Sun Solaris-Unix, HP-Unix
Databases and Software:
DB2 BMC Alter for DB2, BMC Catalog Manager for DB2, BMC Change Manager for DB2,
BMC Check Plus for DB2, BMC Copy Plus for DB2, BMC Dasd Manager Plus for DB2, BMC
LoadPlus for DB2, BMC Reorg Plus for DB2, BMC Unload Plus for DB2, CA Endevor, CA
Librarian, DB! Explain
Oracle BMC SQL-BackTrackฎ for Oracle, Oracle Enterprise Manager Grid Control,
Oracle Migration Workbench
SQL Server SQL Server Enterprise Manager
Sybase BMC SQL-BackTrack for Sybase, Sybase Central
Other BMC Control-M, BMC PATROL, BMC SQL-Programmer Expert CA ERWin Data
Modeling, HP ServiceCenter, IBM InfoSphere Metadata Workbench, IBM InfoSphere
DataStage, IBM Tivoli software, Serena PVCS Version Manager, Serena TeamTrack
Tools Microsoft Office 2003, Microsoft Project, Microsoft Visio
PROFESSIONAL EXPERIENCE
The Vanguard Group, Malvern, PA
Database Administrator 1997 2007
Vanguard is one of the world's largest investment management companies and the
world's highest-value provider of investment products and services. Approximately
$1.24 trillion in U.S. mutual funds (as of 8/31/2009).
Key projects:
Played a key role in the Sybase to Oracle migration efforts, wrote how-to
document Sybase to Oracle Migration Guidelines used by DBAs and Developers,
convinced Oracle to present a seminar.
Project Manager for the evaluation and implementation of SQL Backtrack for
Oracle. Coordinated the efforts of several Oracle DBAs as they assessed if
product warranted for implementation.
Principal DBA resource in use and evaluation of ETL tools. Contributed Subject
Matter Expertise and project support to MetaStage and DataStage strategy efforts,
administered support to projects using these tools.
Mirrored databases for heterogeneous platforms from DB2 z/OS to Oracle,
resolved all technical issues, datatype mismatches, and generated physical model
and database.
Demonstrated mentoring skill in cross-training effort on a project requiring
DB2 and Oracle databases.
Assessed the capabilities and usefulness of several third party products
making recommendation for purchase. Worked with vendor installation and
training.
Supported all PeopleSoft environments including 60+ instances for
HR/TL/LMS/WFA/QML/STAT. Evaluated storage use and developed a project plan for a
PeopleSoft storage management clean-up.
Designed physical database models for several database management systems
including DB2, Oracle, and Sybase. Conducted physical database design reviews and
application code reviews.
Provided project support for Microsoft SQL Server databases, including
evaluation and implementation.
SmithKline Beecham Clinical Laboratories, Collegeville, PA
Lead DB2/Sybase Database Analyst 1990 1996
SmithKline Beecham Clinical Laboratories (SBCL) a national testing and service
network consists of regional laboratories, specialty testing operations and its
Genetics Testing Center, as well as a number of rapid-turnaround or "STAT"
laboratories, and patient service centers. SBCL had 1998 revenues of $1.6
billion.
Key projects
Developed, documented and presented a proposal for DB2 Security Policies and
Procedures across all DB2 application environments creating roles and
responsibilities for database access by functional areas.
Key leadership role quickly developed technical skills in Sybase and HP-Unix,
set policies and directions as a member of the re-engineering Test Services
Delivery process team for the new Automated Laboratory.
Collaborated with IT resources from the Laboratory and Business systems in a
Breakthrough Project Team to evaluate SQL Efficiencies. Presented and published
DB2 SQL DO's and DON'Ts Technical Manual and DB2 SQL DO's and DON'Ts Reference
Card.
Evaluated, recommended, and acquired several DB2 administrative and monitoring
third party tools, organized vendor training for all sector DBAs at SmithKline
Beeham. Coordinated the roll-out of DB! Explain product.
Led Database Physical Design and SQL Coding reviews to ensure efficient data
access with application development teams. Created DB2 and Sybase physical design
models using modeling software.
EDUCATION
Drexel University, Philadelphia, PA
Bachelor of Science Anticipated completion June 2011
Delaware County Community College, Media, PA
Associates Applied Science, Major in Data Processing GPA 3.75/4.0
TECHNICAL TRAINING
DB2 DB2: UDB for z/OS and OS/390 Data Sharing Performance and Tuning, DB2: UDB
for OS/390 Database Administration, DB2: Advanced SQL Workshop, DB2 OS 390 Stored
Procedures, IBM DB2 Enhancement Seminar, DB2 Performance and Tuning, DB2 Advanced
SQL Tuning Techniques, DB2 Database Administration Workshop, DB2 Concepts and
Facilities, DB2 Application Design Workshop
Oracle Oracle9i: Database Performance Tuning, Oracle Database 10g: New Features
for Administration, Oracle9i: New Features for Administration, Oracle: Enterprise
DBA Part 1B Backup & Recovery, Oracle: Enterprise DBA Part 1A Architecture &
Administration
SQL Server SQL Server 2005 New Features Boot Camp
Sybase Advanced Sybase SQL Server Administration, Sybase: System 11 Perf &
Tuning, Advanced Transact SQL, Advanced Transact SQL/SQL Server Performance,
Sybase SQL Server Administration, Introduction to Sybase
Other Unix Hands-on Workshop, Data Warehousing Conference, Implementing
Client/Server Systems, Ascential: MetaStage Essentials (MS220), DataStage
Essentials for Server, Project Management Managing IT Projects, Peregrine Service
Center Change, ERwin: AllFusion ERwin Data Modeler Introduction (ER110)
|
