Joseph M. Wrobleski
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
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
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
Sun, HP, IBM, Sequent, Dec, Intel PC's
PL/SQL, C, C++, Unix Shell (Korn, Bourn, C), Java
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.
Experience with relational database design. Experience with star schema design. Experience with normalizing and demoralizing databases for performance reasons.
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.
PeopleSoft, Oracle Applications, Momentum, FormSoft, Remedy, Kronos
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 18.104.22.168, 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 22.214.171.124.0. Create 10.1.0.2.0 DBs 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 126.96.36.199, 188.8.131.52, 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.
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
B.S. Computer Science, 1992
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
Solaris System Administration