CLICK HERE FOR A VERSION IN WORD FORMAT

Vivian (Jenny) Jacobson
Phone: (281) 395-5889
E-mail: jenny@cadre.dsl.pitt.edu
URL: http://home.thezone.net/~jdawson/html/jenny.htm

Summary

3 years experience creating and cloning databases; backup & recovery; creating & starting up SQL*NET listeners; creating database objects for SAP and datawarehouse, tuning data storage, writing shell scripts, creating SQL/SQL*PLUS reports; training new DBA. Possess Oracle DBA masters certificate.

Hardware

HP K200, K400, 9000; Sun Ultra SPARC II, PC [Pentium, 80486, ...], HP LaserJet, Playwrite and Plexnor CD-ROM recorder drive, scanner.

Software:

Languages: SQL, Bourne, Korn, and C shells, PERL, HTML, "C", PL/SQL.

Operating Systems: HP-UX, Sun Solaris 2.5, AIX, Windows 95, DecAlpha/NT 4, Pentium/NT4, Windows 3.1, Windows for Workgroups 3.11, DOS

Databases: Oracle 7.3.4, 7.3.3, Oracle 7.3.2, Oracle 7.2, Oracle 7.1.6, Oracle 6.x, Microsoft Access.

Tools:

Oracle: Oracle Applications (Manufacturing and Financials) 10.7 (Utilities: AutoPatch, AutoInstall), (modules: AP/AR/OE/PO/GL, Inventory, MRP, BOM), datawarehousing, distributed databases, data replication, SmartClient; SQL*PLUS; Server Manager; SQLDBA; Export/Import, orainst.
Internet/WWW savy.
UNIX: vi, crontab, compress, FTP, man pages, grep, awk, sed, cpio, tar, cp, rcp, find, telnet, ELM, PINE, mailx, RCS, lp, netstat, ping, top.
Other: ERwin ERX 3.5, SQL*Backtrack 2.3.0.6, 2.2; SAP on Oracle and Unix, PVCS, Banner, HP Teamwork [software/database analysis, design, modeling tools], Chameleon, Microsoft Office Professional [MS Word, MS Access, MS Excel]; Ancilla; pkzip; Major BBS; Ventura Publisher; WordPerfect.

Moorhead State University; Moorhead MN.

B.S. Secondary Mathematics Education, post graduate work Computer Science.

North Dakota State University, Fargo ND.

Completed all but thesis for M.S. Computer Science. Projects included writing assembler, compiler, operating system, designing and creating a relational database application in C using software engineering principles. Most projects were completed as a team of 3-4 graduate students.

Oracle Education, Oracle Corporation; Minneapolis, MN and Houston, TX.

Completed Oracle DBA Masters Certificate (June 28, 1996 in Houston): "Tune & Troubleshoot the Oracle7 Database" and "Tuning Oracle7 Applications"; as well as "Administer the Oracle7 Database I & II;" "Developing Complex Data Models and Designing Databases;" "Oracle Forms 4.5 "; Developer/2000 Foundation; and "Introduction to Oracle" (Covered SQL, SQL*PLUS, & PL/SQL).

Hewlett-Packard, Colorado Springs. 1986; HP Seminar: "Controlling Software Projects" (Yourdon methodology).

OXFORD INTERNATIONAL

[under contract to Play by Play – San Antonio TX]
Oracle DBA (Migration to Oracle Applications 10.7 P16 on 7.3.2 – Pentium/NT & DecAlpha/NT 4)

• Transferred some Unix environment expertise to DecAlpha/NT 4 environment: clone database, apply patch, copy files from one server to another server.
• Acquired Oracle Application patchset expertise: found and downloaded the latest patchsets to be applied; use pro-active techniques to solve problems before calling Oracle support. Documented patch process. Created spreadsheet for patchsets and tars/patches.

AMBIT TECHNOLOGY (formerly Contract Solutions)
[under contract to Bradlees, Inc. – Braintree MA - Boston]

Oracle DBA (Six database instances, HP-UX)

• Created script used to backup archive logs every two hours.
• Diagnosed and fixed problems with backups i.e. discovered file permissions incorrect on adsm install; verified SQL*Backtrack stored archived logs on adsm system by running point-in-time recovery followed by full restore of previous backup; added entry to .rhosts file to allow root to remsh from one machine to an oracle73 account on another machine.
• Upgraded SQL*Backtrack from 2.2 to 2.3.0.6 on six instances.
• Supported three developers who were using ERwin ERX 3.5.
• Prepared database for full import by dropping & recreating two tablespaces [index & data].

CENTENNIAL ASSOCIATES (affiliated with Oxford & Associates):

[under contract to Augusta State University – Augusta GA]

Oracle DBA (Five database instances, AIX/HP-UX)

• Trained newly promoted staff member to be Oracle DBA.
• Repaired database having missing datafile by dropping and creating RBS tablespace plus rollback segments.
• Cloned production database by copying files and running ‘create controlfile’ script generated by SQL command.
• Created two databases: determined Unix volume space requirements for mount points, as well as datafile sizes and locations. Modified .ora files (init.ora and config.ora). Wrote scripts to create database, run Oracle scripts, and create tablespaces. Used export/import to transfer data. Created and started SQL*NET listeners.

MAXIMGROUP Information Systems Consultants:

[under contract to Gaylord Entertainment – Nashville TN]

Oracle DBA (Production database – four microprocessors, 2 MB memory, mirrored RAID 1/0)

• Found source of performance problems by examining statisics on memory, space, disk and controller I/O statistics (disk I/O bottleneck aggravated by objects having multiple extents, shortage of library cache memory causing packages with high disk I/O requirements to be swapped in and out of memory, as well as running batch jobs during day with OLTP transactions).
• Applied patches to Oracle Application and Client Server.

OXFORD & ASSOCIATES:

[under contract to Scientific Atlanta - Atlanta GA]

Oracle DBA (Seven Databases: 1-130 Gigabytes)

• Refreshed development databases quickly by copying files from test databases followed by running create control file script. Create control file script was generating using ‘alter database backup control file to trace’ from test database.
• Created database objects in Oracle and SAP for SAP Serial Tracking application.
• Created snapshots, database links, and snapshot logs to move data from SAP/Oracle system to datawarehouse. Data was to be analyzed by Business Analyzer (aka Business Objects).
• Created database objects by moving developer scripts from PVSC [PC version control software] to server and running scripts on Oracle as SAPPRD.
• Documented my projects. Client appreciated documentation when used to answer questions and bring new developer up to speed quickly. Client requested enhancements i.e. show flow of data. Eventually documents served as communication tool for management, developers, and other DBAs.

MAXIMGROUP Information Systems Consultants:

[under contract to GE-Harris Energy Systems - Melbourne FL]

Oracle DBA (Eight Databases: 5-30 Gigabytes)

• Documented system/database administration procedures and policies. Provided Oracle DBA information to client IT manager. Enabled him to leverage 18 years experience from another technology to Oracle and make wise decisions i.e. "High-Speed Database Backup on Sun Systems" Included report of testing where backup transfer rates of one terabyte per hour to tape were achieved. Wrote paper: "Starting Up and Shutting Down the Oracle Instances and Listeners" which traced how the Unix inittab file calls startup/shutdown script(s) based on the running state of the machine. Discovered current value of LD_LIBRARY_PATH may allow wrong libX3.so.3 file to be used for linking. Developed Backup strategy spreadsheet for eight databases varying in size from 5-30 Gb.
• Performed database exports and imports (size: five gigabyte database).
• Created two databases.
• Started up and shut down the database instances, SQL*net listeners, and Concurrent Managers.
• Applied and maintained log of patches/TARS.
• Installed software (Oracle 7.3.3 RDBMS Server, Oracle Applications 10.7, 7.3.3.4 patch) on development Oracle 7.3.3 Server under mentorship of guru Oracle DBA consultant.
• Wrote Unix shell scripts: monitor_am.S to monitor database instances including overextended tables and indexes, database space, as well as calling other scripts i.e. modified utlbstat and utlestat scripts. Produced report including: count (could produce list also) of Concurrent Request logs and outputs that exceeded one Megabyte, was over 30 days old (by instance), as well as how to purge these files.

COMSYS Information Technologies: [under contract to TOPS/FINAST]

Oracle DBA (44 databases)

• Created spreadsheets to communicate understanding, encourage feedback, & involve manager in the process.
• Tuned data storage: wrote & used SQL reports to show 1) objects with multiple extents, 2) space used versus space allocated. Resized objects by altering storage specs for existing table & index scripts; broadcast altered scripts to all databases; added files to tablespaces; rebuilt tables & indexes using export, drop, import.
• Eliminated duplicates on large tables by exporting table, dropping table, building unique index, importing table.
• Established and implemented process to coalesce free space. Wrote & ran script to shrink rollback segments having greater than MAX extents.
• Served as resource; trained person to take over my responsibilities.

INTERACTIVE GROUP, INC./JIT Note: Interactive Group purchased JIT product line from Fourth Shift (below)

Systems Administrator, Technical Services

• Managed builds for software patch tapes; wrote/maintained shell scripts; developed interface for production installation script. Supported customers installing patch builds.
• Planned and implemented migration from Oracle V6.0.36 to V7.1.4.
  

Customer Support Analyst -> Admin/Tech

• Designed database. Developed Entity Relationship Diagrams (ERDs) using Oracle’s complex data modeling techniques. Built tables with contraints,.created queries, forms & reports to implement department database.
• Automated/improved processes: wrote scripts (Unix shell, PERL, & SQL*PLUS); used crontab & checklists.
• Created & maintained Web pages as Department Webmaster.
  

HIRS Inc., A subsidiary of Safety & Ecology Consultants, Inc.

Consultant

• Developed graphical user-interactive application(GUI). Application created physician profiles based on healthcare facility data. User given maximum flexibility by using the following techniques: 1) Created Recordsets using dynamic SQL statements, 2) Used Event-driven programming (Added Code Behind Forms - CBF), 3) Maintained Combo Box Lists "on the fly."

HEWLETT-PACKARD (HP), Logic Systems Division (LSD).

Technical Writer II

• Documented products in the Microprocessor Development Environment:
  HP Teamwork manuals documented a suite of Computer-Aided Software Engineering (CASE) tools used for logical data modeling (produces ERDs) while designing relational databases (Chen Methodology). Suite included tools to implement Structured Methodology (Structured Analysis and Structured Design) used to design software (Yourdon/Martin).
• Initiated weekly project status reports to promote communication and teamwork among the R&D, Publications, manufacturing, and shipping departments.
• Wrote "C" program and WordPerfect macros to convert files from Interleaf to Ventura Publisher format.

Regional Marketing Engineer - Eastern Region

• Initated field surveys to provide regional sales information to management for weekly meetings.
• Helped sales engineers win sales by providing product and configuration information via phone. Handled 25% of all calls - two people on the phones per region (Eastern region had the heaviest load).

Training Engineer

• Developed training materials for HP Teamwork products (See Technical Writer II) using skills-based training methodology.
• Presented classes on HP Teamwork products (See Technical Writer II).

North Dakota State University; Fargo, ND

Graduate Assistant and summer job

• Graduate assistant: taught computer literacy, programming fundamentals, and Algebra to classes varying in size from 30-175 students; managed up to five graduate assistants. Taught calculus labs.
• Systems analyst (Summer ‘84, at local company): worked with consultant to bring up payroll system for 200 employees, administered database, and established procedures for users.

Part-Time Instructor and Student Worker

• Taught computer literacy and fundamentals of computer programming as part-time instructor.
• Helped students debug their programs as programming assistant.

Other Achievements

• Membership chairperson for organization of executives/professionals. We accomplished the following tasks:
  
• Established process so new members would be productive ASAP.
• Computerized record of employer contacts.
• Upgraded system of alumni records to ensure accuracy of membership status.

• Designed ERD (logical data modeling), and created database to output ASCII text in ready-to-publish format.
• Presented paper at workshop on patient information resources at 1993 SCAMC conference.
• Passed actuarial exam #100 - Calculus/Linear Algebra (Note: only 37% of partipants passed this exam).
• Completed American Production & Inventory Control (APICS) classes for Inventory Management & MRP/CRP.
• Completed 44 semester hours in the Vanderbilt University School of Nursing's non-RN to MSN program.