Oracle Certified Professional:
Joseph M. Wrobleski
joew@sparrowconsulting.com
Phone: 443-690-0680
Work experience
Sparrow Consulting, Inc.
Principal Consultant
03/03 - Present
University of MD, Baltimore County
Oracle Instructor
01/00 - Present
Computer Sciences Corp. (CSC)
Principal Computer Scientist
09/99 - 03/03
Oracle Corporation
Technical Manager
09/97 - 09/99
DASD Corporation
Principal Software Engineer
06/96 - 09/97
NASD
Lead Programmer/Analyst
06/95 - 06/96
Social Security Administration
Data Base Administrator
07/94 - 06/95
TRW
Software Engineer
02/88 - 07/94
Skills highlight
Oracle Products:
Oracle 9i, 8i, 8.1.7, 8.0.5, 7.3.4, 7.2, 7.1, 7.0, 6, RMAN,
Parallel Server, Advanced Replication, Application Server 9i, Portal,
Web DB, JDeveloper, Internet Developer Suite 9i, Designer 2000,
Oracle Enterprise Manager (OEM), SQL*Plus, Oracle SQL*Loader, Oracle Pro*C,
PL/SQL, SQL-NET
Operating Systems:
UNIX (HPUX, Solaris, SUN OS, TruCluster 64, AIX, Dynix, SCO), Win 2000, Win XP,
NT 4.0, Windows 95, Windows 3.11, MS-DOS
Hardware:
Sun, HP, IBM, Sequent, Dec, Intel PC's
Languages:
PL/SQL, C, C++, Java, Unix Shell (Korn, Bourn, C)
Management/Leadership Skills:
Project Management, Managed development teams, Project Lead on various
platforms and projects, Account Manager for several consulting accounts.
Database Administration:
Oracle Certified database administrator. Experience with Oracle installation,
configuration and data modeling (physical and logical) on UNIX, Windows
NT, and Windows 95. Experience with backup and recovery planning and testing.
Also experience with import and export of environments. Experience with
Parallel Server and Replication. Extensive experience with Oracle performance
tuning using TKPROF, Explain Plan, Enterprise Manager, and operating system
utilities. Project Management of DBA's and consultants. Developed schedules
for DBA specific tasks. Oracle database conversion and upgrade.
Life Cycle Expertise:
Pre-Sales, Post-Sales, Project Management, Requirements Gathering, Business
Analysis, Requirements Analysis, System Design, Data Modeling, Implementation,
Testing, Systems Support, Product Installation.
Methodologies:
Structured Analysis and Design, Structured Programming, Object Oriented
Analysis and Design, Booch
Instructor:
Conduct Oracle and Unix technical training. Courses taught include Relational
Data Modeling, Oracle Introduction, SQL-Plus, Oracle Application Performance
Tuning, Oracle Database Administration, Oracle Backup and Recovery, Intro
Unix, and Advanced Unix.
Specialty Skills:
Data Warehousing, Telemarketing Call Centers, Logical Data Base Design,
Application Development, Federal Government Applications, Automated Identification
Systems, General Business Systems, Work Flow Management
Other Software/Tools:
Momentum, People Soft, Remedy, Kronos, Texas Instruments IEF, Informix,
Applix Ware, XWindows-Motif
Communications/Networking:
TCP/IP, SPX/IPX, Internet, Windows NT Services and Ethernet
Project experience
Sparrow Consulting, Inc, Principal,
March 2003 – Present
Northrop Grumman IT,
March 2003 to Present
Oracle DBA for a PeopleSoft HR database. Implemented a backup and recovery plan
using RMAN. Migrate databases to to 8.1.7.3. Provide technical support and SQL
tuning guidance to the project team.
University of Maryland Baltimore County (UMBC),
January 2000 to Present
Part time instructor for the Division of Professional Education and Training.
Teach Oracle 9i DBA, Tuning, Backup and Recovery, and PL SQL courses.
CSC, Principal Computer Scientist,
September 1999 – March 2003
USAID Project, Oracle Database Support and Web
Development,
Dec 1999 – Mar 2003
Assigned as the Lead Database Administrator on the USAID Project (United
States Agency for International Development). Responsible for the tasking
and supervision of the 6 member DBA team. Provide production support
for Oracle 9.2.0 and 8.1.7 databases. Migrate databases from 7.3.3
to 8.1.7 and from 8.1.7 to 9.2.0. Work on the deployment of the AMS Momentum
Financial System. Provide Oracle replication support. Assist in the development
of Web Applications using Web DB, Oracle Portal, and PL SQL Web Developers Toolkit.
Provide data modeling support for both OLTP applications and Data Warehouse
applications. Provide Oracle technical guidance and tuning support to the project team.
Working with Oracle 7.3.3, 8.0.5, 8.1.7, 9.2.0, OEM 9i, Application Server 9i,
Web DB 2.1, and Portal 3.0 on AIX 4.3 and Win 2k/NT
MOISE Project, Oracle Database Support,
Sep 1999 – Dec 1999
CSC Mission Oriented Information System Engineering (MOISE) project for
the US Coast Guard. Provide architectural design and review support for
all ongoing Task Orders. Lead DBA for the development environment. Provide
data modeling support for both OLTP applications and Data Warehouse applications.
Provide Oracle technical guidance and tuning support to the project team.
Working with Oracle 7.3.4, 8.0.5, Web Application Server 3.0.2, and Application
Server 4.0.7 on HPUX 10.2 and 11.0.
Oracle Corporation, Technical Manager,
September 1997 – September 1999
Department of Justice, Office of Justice Programs,
June 1999 to Sep 1999
Project manager and Technical Lead for the Grant Management System (GMS).
GMS is a Web application developed using PL/SQL, Oracle 8.1.5, and Application
Server 4.0.7. Led a team of 4 developers in requirements definition, design,
implementation, testing and deployment.
Computer Sciences Corp. (CSC), Oracle Database
Support, April 1999 to June 1999
Lead Oracle Consultant on the INS STARS Enforcement project for
the U.S. Immigration and Naturalization Service. Provide data modeling
support for the EID database. Provide Oracle technical guidance and tuning
support to the INS. Manage all onsite Oracle Consultants. Working with
Designer 2000 Rel 1.3 and Oracle 7.3 Parallel Server on Dec Alpha hardware.
Computer Sciences Corp. (CSC), Oracle Database
Support, July 1998 - April 1999
Lead
Oracle Consultant on the CSC Mission Oriented Information System Engineering
(MOISE) project for the US Coast Guard. Provide architectural design and
review support for all ongoing Task Orders. Lead DBA for the development
environment. Provide data modeling support for both OLTP applications
and Data Warehouse applications. Provide Oracle technical guidance and
tuning support to the project team. Manage all onsite Oracle Consultants.
Working with Oracle 7.3.4, 8.0.5, Web Application Server 3.0.2, and Application
Server 4.0.7 on HPUX 10.2 and 11.0.
Electronic Payment Systems (EPS), Oracle Database
Administration and Tuning,
March 1998 - July 1998
Lead Oracle consultant
on a project to migrate production databases from NCR hardware to Sun
hardware. Migrated databases included People Soft, Remedy, and a custom
billing application. Provide database administration and tuning support
to EPS personnel. Installed and configured Oracle 8.0.4 for acceptance
testing in preparation for migration to Oracle 8. Installed and configured
Enterprise Manager 1.5 with Performance Pack and Tuning Pack. Installed
and Configured Intelligent Agents and Data Gatherer on Sun Solaris 2.6.
Trained EPS personnel in the use of Enterprise Manager.
Symbol Technologies, Oracle Database Tuning,
March 1998
Installed Enterprise Manager 1.4 with Performance Pack. Installed and
configured Intelligent Agents on HPUX 10.2. Trained Symbol personnel in
the use of Performance Pack. Installed and configured Oracle 8 on an HPUX
platform.
Hughes Network Systems, Oracle Database Tuning,
February 1998
Tuned Oracle 7.3 Databases. Trained Hughes Personnel in Oracle Architecture.
Trained Hughes personnel in application tuning using TKPROF and Explain
Plan. Assisted in planning backup and recovery strategy.
Heritage Inks, Oracle Financials Database Maintenance,
February 1998
Database Maintenance for a large Oracle Financials implementation. Export
and Import the database to eliminate fragmentation. Plan and implement
a backup and recovery strategy. Wrote Unix Shell scripts to automate database
backups. Tune the database.
Symbol Technologies, Oracle Database Tuning,
February 1998
Database tuning for a large PeopleSoft and Kronos implementation. Installed
Enterprise Manager. Trained Symbol personnel to use Enterprise Manager.
US Steel Corp., Oracle Database Administration,
January 1998
Database Administration for over 30 Oracle Databases. Installed Enterprise
Manager and set up repository. Trained US Steel personnel to use Enterprise
Manager. Hold training seminars for US Steel personnel on Oracle 7 Architecture.
James River Co., Data Warehousing Project,
December 1997 - January 1998
Database Administrator for large Data Warehousing project. Tuned system
using TKPROF, Explain Plan, scripts to monitor the SGA and UNIX (sar,
vmstat, iostat) utilities. Plan backup and recovery strategy. Write UNIX
shell scripts to automate data loads. Wrote PL/SQL scripts to load data.
Planned physical design of the database. Recommended system configuration
to James River Management.
Department of Justice, Oracle Database Disaster
Recovery,
November 1997
Performed disaster recovery of Oracle 7.3 Database. Planned backup and
recovery strategy for system.
Oracle Education,
November 1997
Teach Oracle Education Classes. Classes taught include Oracle 7.3 Database
Administration and Oracle 7.3 Backup and Recovery.
Ciba Specialty Chemicals, Database Performance
Tuning,
October 1997
Tuned a large Oracle 7.3 Peoplesoft Database. Installed Oracle Enterprise
Manager and set up repository. Trained Ciba personnel to use Enterprise
Manager and to monitor database performance using Enterprise Manager Performance
Pack.
Lockheed Martin Corp., Database Performance Tuning
and Database Administration on Oracle Consulting Project,
September 1997 - October 1997
Tuned large Oracle 7.1 database running on AIX. Developed monitoring scripts
using Korn shell scripts and SQL*Plus scripts. Trained Lockheed Martin
personnel on monitoring the database and using the supplied scripts. Explained
the Oracle 7 architecture to Lockheed Martin personnel.
DASD Corporation,
June 1996 - September 1997
Project Management, Account Management
Managed the Oracle business for DASD Corporation. Acted as account manager
and technical lead for all Oracle projects. Lead DBA, National Republican
Senatorial Committee Data Base Administrator and Unix System Administrator
for the NRSC Telemarketing Center. Conducted database tuning, application
tuning, data loads, and backup and recovery. Provided Oracle technical
support to the centers management. Wrote scripts to generate system reports
and to automate system maintenance tasks. Provided 24 by 7 database support.
Supervised all onsite DASD consultants.
Oracle Technical Training, Miaco Corporation
Conducted Oracle and Unix technical training. Courses taught include Relational
Data Modeling, Oracle Introduction, SQL-Plus, Oracle Application Performance
Tuning, Oracle DataBase Administration, Intro Unix, and Advanced Unix.
Oracle Web Server, SUN Micro Systems
Performed work on an Intranet forecast tool used by sales force. Application
was written in PL/SQL using the developers tool kit provided with the
Web Server. Application allowed sales force to enter and modify forecasts
through a WEB Browser into an Oracle Database. Application also allowed
managers and financial analysts to generate reports based on sales projections
through the WEB Browser.
National Association of Securities Dealers (NASD),
June 1995 - June 1996
Product Development of Application to Track Backing Away Complaints.
Participated in full life-cycle development of an application to track
backing away complaints. Acted as Lead Programmer on the project. Front
end development was done in Applix Ware with an Oracle database on the
back end. PRO*C programs were also developed for execution through the
UNIX cron utility.
Product Development of Customer Complaints Tracking System
Lead programmer in the development of PRO*C programs to conduct daily
data loads into the customer complaint system. Developed UNIX Shell scripts
to control all data transfers between machines and all processing. Shell
scripts controlled all batch processing including error handling.
Social Security Administration (SSA),
July 1994 - June 1995
Data Base Administrator
Primary responsibilities were Oracle DataBase Administration. Secondary
responsibilities were UNIX system administration. Installed Oracle software.
Created and tuned database instances. Provided network support. Provided
Oracle support to developers.
TRW,
February 1988 - June 1994
Automated Identification System Product Development,
January 1993 - June 1994
Employed as a software engineer. Worked on relation data models to store
demographic data. Wrote PRO*C programs to access the database. Acted as
the development environment database administrator. Wrote workflow managers
in C that were capable of full recovery in the event of a system crash.
Worked on all aspects of the software life cycle.
Anti Submarine Warfare (ASW) Projects,
February 1988 - December 1992
Employed as a software engineer on ASW projects. Applications were written
in C and ran in both UNIX and DOS environments. Worked with full life
cycle development.
Clearance
TS
Education
University of Maryland Baltimore County
B.S. Computer Science, 1992
Certification
Oracle Certified Professional Program (OCP)
Certified Oracle 9i Database Administrator
Certified Oracle 8i Database Administrator
Certified Oracle 8 Database Administrator
Certified Oracle 7.3 Database Administrator
Training
Oracle Corporation:
Oracle 9i New Features for Administrators
Oracle 8i Java Database Administration
Oracle 8i New Features for Administrators
Oracle 8 New Features for Administrators
Oracle 8 Terabyte Database Workshop
Oracle 7 Symmetric Replication
Oracle 7 Distributed Database Administration
Oracle 7 Database Administration
Database Design for Oracle Warehouses
Designer 2000 Rel. 2.1 First Class
Designer 2000 Rel. 2.1 Generate Web Applications
Developer 2000 Rel. 2 Forms 1
Data Warehousing Fundamentals
Java Programming
Other Training:
Custom NT
Texas Instruments IEF Fast Track
Applix Ware
Solaris System Administration
