Joseph M. Wrobleski
Phone:
443-690-0680
WORK
EXPERIENCE
Sparrow Consulting, Inc Principal
Consultant 03/03
-Present
UMBC Part
Time Instructor 01/00
- 06/03
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 10g, 9i, 8i, 8.1.7, 8.0.5, 7.3.4, 7.2, 7.1, 7.0, 6, RMAN, RAC, Advanced Replication, Application Server 9i, Oracle Portal, Web DB, Internet Developer Suite 9i (iDS 9i), JDeveloper, Designer 2000, Oracle Enterprise Manager (OEM), SQL*Plus, Oracle SQL*Loader, Oracle Pro*C, PL/SQL, SQL-NET
Operating
Systems:
UNIX (Solaris, SUN OS, Linux, HPUX, 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++, Unix
Shell (Korn, Bourn, C), Java
Database
Administration:
Oracle Certified database
administrator. Experience with Oracle
installation, configuration and data modeling (physical and logical) on UNIX,
Windows 2000, Windows NT, and Windows 95.
Experience with backup and recovery planning and testing. Implemented backup and recovery plans using
both RMAN and OS utilities. 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.
Database
Design:
Experience with relational
database design.
Experience with star schema design. Experience with normalizing
and demoralizing databases for performance reasons.
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.
Other
Software/Tools:
PeopleSoft, Oracle Applications, Momentum,
FormSoft, Remedy, Kronos
PROJECT EXPERIENCE
Sparrow
Consulting, Inc., March 2003 – Present
LM Project, Oracle Database Administrator , April 2008 – Present
Assigned as the Lead DBA on an
Oracle O&M project for Lockheed Martin. Provide 24x7 support
for very large databases. Implemented a backup and recovery plan using EMC mirroring and
clones configured for point in time recovery. Write Unix shell
scripts to automate daily database maintenance tasks. Provide Oracle technical and SQL tuning
support to the project team. Working with Oracle 10.2.0.4.0, Solaris 10 containers, Veratas clustering, and EMC DMX arrays.
NGIT
Project, Oracle Database Administrator , Mar 2005 – April 2008
Assigned as the Lead DBA on an
Oracle development project for NGIT. Researched and configured Oracle Multi
Master Replication for the project. Implemented a backup and recovery plan using RMAN and Oracle
Exports. Write Unix
shell scripts to automate daily database maintenance tasks. Provide Oracle technical and SQL tuning
support to the project team. Working with Oracle 10.2.0.3.0, Solaris 2.8 and Web Logic.
Accenture
Project, PeopleSoft Database Administrator , Nov
2004 – Mar 2005
Assigned as a Senior Oracle DBA
on a PeopleSoft HR project for Accenture. Provide production DB support. Provide Database, Application Server and
Process Scheduler performance tuning support.
Create and troubleshoot Web Servers, Application Servers, and Process
Schedulers. Write Unix
shell scripts to automate daily database and application server maintenance
tasks. Provide Oracle and PeopleSoft technical
support to the project team. Provide SQL
tuning support to the project team. Working with Oracle 9.2.0.5, AIX 5l, and PeopleSoft HR 8.8 and PeopleTools 8.44.11.
NGIT
Project, PeopleSoft Database Administrator , Mar
2003 – Nov 2004
Assigned as the Lead Oracle DBA
on a PeopleSoft HR project for NGIT. Provide production DB support. Perform software migrations of both internal
and external PeopleSoft objects across databases. Copy and refresh PeopleSoft databases using
import/export and by cloning databases. Create
and troubleshoot Application Servers and Process Schedulers. Provide DB support for EZHR Forms
application. Write shell scripts to load
data and transfer data across networks. Implemented a backup and recovery plan using RMAN and Oracle
Exports. Migrate
databases to 9.2.0.5.0. Create
10.1.0.2.0 DB’s for testing. Write Unix shell scripts to automate daily database maintenance
tasks. Provide Oracle technical and SQL
tuning support to the project team. Working with Oracle 8.1.7.4, 9.2.0.5, 10.1.0.2.0 Solaris 2.7/2.8
and PeopleSoft 8.18.10.
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, Database Engineering Group Manager , Sep
1999 – Present
Assigned as Lead DBA on the USAID
Project (United States Agency for International Development). Responsible for the tasking
and supervision of the 6 member DBA team. Interface with the customer to report
progress and to plan future projects. Work with other matrix managers to plan
the amount of DBA support required for projects. Provide production support for
Oracle 9.2.0, and 8.1.7 databases. Migrate Oracle databases to versions 9.2.0 and 8.1.7. Work on the deployment of the AMS Momentum
Financial System. Assist in the
development of Web Applications using Web DB, Oracle Portal, and PL SQL Web
Developers Toolkit. Plan and implement
backup and recovery plans using RMAN.
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 9.2.0, 8.1.7, 8.0.5, OEM 9i, Application Server 9i, Portal 3.0, and
Web DB 2.1 on AIX 4.3 and Win 2000/NT 4.0.
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, July 1998 - June 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.
James
River Co., Data Warehousing Project, Dec 1997 - Feb 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.
Oracle
Education, Oct 1997 to Nov 1997
Teach Oracle Education Classes. Classes taught include Oracle 7.3 Database
Administration and Oracle 7.3 Backup and Recovery.
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
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 software development.
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
EDUCATION
University of
B.S. Computer Science, 1992
TRAINING
Oracle
Corporation:
Oracle 10g New Features for
Administrators
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
Applix
Ware
Solaris System Administration