Sparrow Consulting, Inc.
www.sparrowconsulting.com
joew@sparrowconsulting.com
Phone:
410-489-7950 fax: 410-489-7951
Resume for Jay W. Nielsen
SUMMARY
· Experienced Oracle DBA
· Strong skills in SQL,
PL/SQL, and Oracle Developer Tools (Forms/Reports)
· Oracle professional
since 1989 ( DBA and Programmer )
· Senior instructor of
Oracle database design and programming
· Security Clearance: TS/SCI SSBI
030805 sponsored by DOD
· Started sole proprietor
OraSol LLC July 2004
· Oracle OCP Developer
since 2000 Progressing as OCP DBA for 10g
EDUCATION
BS, Computer Information Science,
AS, Information Systems Management,
Community College, USAF Apr 1990
EXPERIENCE
Jan 05 Present Contracted
to Sparrow Consulting Oracle
DBA
Oracle Database Administration responsibilities for a
PeopleSoft Application. Maintain the development,
staging, test, and production databases.
Create and maintain UNIX and SQL scripts for managing and observing database activities. Troubleshoot and fix data problems. Lead for tiger team in isolating and fixing
slow views. Found a query that was
taking over 7 hours to run and redesigned it so that it runs to completion
within 43 seconds. Helped redesign the
Configuration Management process to prevent slow views from being
introduced. Helped redesign the
Configuration Management process for speeding up the views already in the
production databases. We receive data
from other sources and are responsible for putting the data into
databases. The process was mostly a
manual process. Redesigned the process
for introducing the data into our databases.
The process is now automated with minimal manual intervention. Redesigned a PeopleSoft SQR taking 6-7 hours
to process, so that it now runs in less that one hour. Utilized Oracle Materialized Views as the
major enhancement of that SQR. Automated
the process for refreshing the training and test databases with the production
objects and data.
Nov 04 Jan 05 InSequence Inc Senior Database Developer
Performed Oracle 9i ETL
integration into a data warehouse system.
Isolated ETL script problems.
Redesigned database objects to handle data integration more
efficiently. Tuned the design of slow
working views.
Jul 03 Nov 04 iSYS LLC Principal Software Engineer
Performed Oracle PL/SQL
programming using Oracle 9i capabilities including various collection objects,
and also programed Oracle Reports with Developer 9i. Came into the project with no ramp up time
and very little instruction. Created 15
reports using PL/SQL ref cursors and word of mouth specifications. Tuned reports created by others and made the
queries faster. One report was taking
over 10 minutes to query the data, and tuning changes made it run
instantaneous. Performed Oracle Text
Search PL/SQL functions. Redesigned the
whole package for readability and tuning.
Maintained PL/SQL reports and packages.
Worked with testing team to solve many software problems. Spent many hours working the project design
document. Advised and assisted in the
design of the Virtual Private Database (VPD) effort on the project.
Jun 99 Jul 03 db-Training (Sysorex Inc) Senior Instructor
Taught an Oracle8i
Application Development Course for db-Training while concurrently working as a
consultant. Course curriculum included
128 hours of instructor-student contact time covering database design and
modeling, SQL, SQL*Plus, PL/SQL, Forms 6i and Reports 6i.
May 99 Jul 03 Sysorex Inc Senior
Systems Engineer
· Oct 99 Jul 03 Multiple responsibilities in a Department of
Defense budget database redesign. Worked
as development DBA and as the main point of contact for Oracle Reports design
and redesign. Many reports were already
created, but not fully functional, and lacking standardization. Created a standardized template for the
development team, saving hours of layout design difficulties that everyone was
experiencing. Some of the reports were
taking hours to run. Redesigned the
queries more efficiently so that the long running reports were only taking a
few minutes to process. Created a PL/SQL
package for all the reports to use, which greatly elimated duplicate coding,
and standardized the report setup. Helped many on the team in their PL/SQL,
Forms, and Reports design efforts. Was
the Development DBA for a task to make our database work in a Web
environment. Redesigned our form that
executed the reports, and set it up to utilize the more current
run_report_object Oracle builtin, and redesigned it to be more easily
maintainable. Assisted in the setup of
the Oracle Apache application server, and the reports server. Setup a mirror
database in our Web environment utilizing Materialized Views, and setup the
automation of updating the database by user request.
· May 99 Oct 99 Created seven new reports and revised
numerous existing reports using Reports 2.5 in an Oracle Applications
development effort for the US Chamber of Commerce. Designed and implemented an automated module
for data extraction. The module
extracted records from a space-delimited data file provided by the US Postal
Service containing address changes and undeliverable addresses, then matched
records in the subscriptions tables of the database. Addresses were automatically updated or
flagged as an invalid address. This
process required four PL/SQL procedures and functions, five SQL*Loader control
files, and three reports.
Mar 98 May 99 Trident
Data Systems Database Analyst
· Nov 98 May 99 Database team lead for migrating an Oracle
application to Windows NT. Responsible
for creating and modifying numerous database triggers and packages utilizing
PL/SQL. The packages and triggers
utilize DML, DDL, PL/SQL tables and record capabilities. Programmed the PL/SQL triggers and packages to
prevent mutating problems. Responsible
for creating and modifying tables, views, sequences, synonyms, indexes, primary
key and foreign key constraints.
Responsible for coordinating with the C-Programmers and their database
requirements.
· Mar 98 Nov
Feb 98 Mar 98 Robert Half International Senior Consultant
Redesigned five
customized reports using Reports 2.5 in two weeks, to meet specific client
requirements.
Aug 96 Jan 98 Oracle Corporation Senior Consultant
· Nov 97 Jan 98 Utilized Designer 2000 to develop Web
Applications.
· Oct 97 Nov 97 Created or redesigned a total of six forms
for the Defense Intelligence Agency printing plant, using Forms 4.5. Three forms, which previously existed, were
not functional. Three additional forms
were created, and all were standardized in appearance and functionality for
both X-term and Windows environments.
· Aug 97 Oct 97 Conducted preliminary study for transitioning
Forms 4.0 and Reports 2.0 to Developer 2000 v1.3. Identified which groups had forms and reports
and provided statistical information on how many forms and reports were
available and used by each of those groups.
Identified which forms and reports were created within Designer, those
generated using the CASE tool, and which were generated via the CASE tool and
subsequently modified. Following the
analysis phase, detailed documentation was developed to assist the client in
updating each category from Forms 4.0 to Forms 4.5, and each report from
Reports 2.0 to Reports 2.5.
· Oct 96 Aug 97 Database Engineer for five subsystems in a
very large database rearchitecture.
Responsible for coordinating database design, structure, size,
tablespace, etc. for each of the database subsystems. Created, updated, or deleted database
entities, tables, indexes, etc. using the Oracle CASE tool. Served as liaison to the database
administration team for implementation and maintenance of each database
structure, and for coordination with all
the other subsystems development teams.
· Aug 96 Oct 96 Performed Help Desk functions in support of
federal government agencies.
May 95 Aug 96 Booz·Allen
&
Team lead for the
maintenance of forms, reports, and menus in a federal human resources database,
as well as for the migration of a personnel database from RDBMS V6 to
Oracle7. Served as the database
administrator for the development system.
Responsibilities also included the development and maintenance of database documentation, task specifications,
and technical description of the entire human resource database.
Jun 75 May 95 US
Air Force Retired
Master Sergeant ( E-7 )
· Jul 92 May 95 Lead design engineer for several network
management Oracle database forms and reports.
Designed and maintained an Oracle database system that enabled customers
to track communication requirements, and integrated it with automated
electronic mail. First of its kind for
this client organization. Responsible
for standardizing, integrating and managing the efforts of electronic mail and
database administrators for multiple sites supporting thousands of users
globally. Also, served as the principal
point of contact for oversight and standardization of all network LAN/WAN site
operating instructions.
· Aug 89 Jul 92 Designed, developed, implemented, and
maintained Oracle databases, electronic mail systems, and performed system
administration for UNIX computer systems.
· Jun 75 Aug 89 Telecommunications Computer operator for USAF
and DOD worldwide message switching network.
Software,
Operating Systems, and Databases
Oracle
9i, 8i, 8, 7, RDBMS v6 & v5
Oracle
Forms 9i, 6i, 6, 5.0, 4.5, 4.0, 3.0, 2.3, 2.1
Oracle
Reports 9i, 6i, 6, 3.0, 2.5, 2.0, 1.1, 1.0
Designer
2000 1.3, Designer 5.1.8
SQL*Menu
5.0, SQL*Menu 4.2, Oracle*Mail Admin, SQL*Loader, PL/SQL, SQL
UNIX
(Sequent, Pyramid, NeXT, DEC, Sun OS, Solaris)
MS
Windows (3.11, 95, 98, NT, 2000, XP)
Oracle
Training
Oracle
10g Database Administration Fundamentals I & II
Oracle
9i Database Administration Fundamentals I & II
Oracle7
Database Administration I & II
Oracle
RDBMS v6 (Beginning and Advanced)
Designer
2000 Introduction
Developer
2000: Forms I&II, Reports, Oracle
Forms 4.0 for Beginners
Oracle
Forms 2.1, 2.3, 3.0, (Beginning and Advanced)
Oracle
ReportWriter 1.1
WebServer
Applications Introduction
Data
Warehousing Fundamentals
Oracle
Tuning
Relational
Database Design