Meijer - Grand Rapids, MI 05/2005 - Current
Job Title: DB2 DBA

• DB2 UDB for ZOS database administration
• Create new Peoplesoft DB2 environments
• SQL performance tuning
• DB2 Group Bufferpool tuning
• DB2 Bufferpool tuning
• Stored procedure debugging
• Table alters
• Index tuning

UnivarUSA - Seattle, WA 02/2005 - 04/2005
Job Title: DB2 Performance Tuner

• RCT tuning
• DB2 ZPARM Evaluation
• DB2 Tracing
• DB2 Buffer Tuning
• DB2 Access Path Tuning
• DB2 Trouble Shooting

NCS Pearson - Iowa City, IA 01/2005 - 02/2005
Job Title: DB2 Performance Tuner

• DB2 ZPARM Evaluation
• DB2 Tracing
• DB2 Buffer Tuning
• DB2 Access Path Tuning
• DDL denormalization
• DB2 Trouble Shooting
• SQL walk through
• SQL Tuning
  

West Bend Insurance 01/2004 - 02/2004
Job Title Senior DB2 DBA

• Plan DB2 Connet V7 to V8 upgrade
• Test/Verify upgrade with existing applications
  
• Train existing staff on DB2 Connect usage
  
• Upgrade Development and QA environments
  
• Oncall support while client upgrades the production environment
• Setup Unix scripts for daily/weekly type monitoring and maintenance

State of Minnesota Department of Human Resources 08/2003 - 11/2003
Job Title Senior DB2 DBA

• DB2 for OS390 Capacity Planning
• Performance Evaluation
• DB2 ZPARM evaluation
  
• SQL tuning
  

Fidelity National Information Solutions 12/2002 - 08/2003
Job Title Senior DB2 DBA

• Install and migrate 3 DB2 for AIX EE databases to EEE
• Configure DB2 AIX EEE database for OLTP processing
• Maintain Schema changes/review
• Query/DB performance tuning
• Create Backup/Recovery strategy
• Create Standards Documentation
• Space management of 1 Terabyte of DB2 data on EMC Symmetric
• Daily Maintenance of PeopleSoft Financials/HRMS on DB2 NT
• Performance tuning DB2 parameters and indexes for PeopleSoft Financials/HRMS
• Move PeopleSoft HRMS to a new server on Windows DB2 NT
• Backup support for Oracle Remedy database

Raley's Food Store 8/2002 - 10/2002
Job Title PeopleSoft Architect/DBA

• Install and Configure DB2 Connect 7.2 on AIX SP node
• Install and Configure WebSphere 4.0 on AIX SP node
  
• Install ServerExpress 2.0.11 on AIX SP node
  
• Install and Configure PeopleSoft Financials 8.4 Demo environment 2 tier and 3 tier
  
• Install and Configure PeopleSoft PIA(Peoplesoft Internet Architecture) on AIX SP node
  
• Install and Configure Process Scheduler on USS(Unix Systems Services)
  
• Create PeopleSoft Financials Database on DB2 for OS390
  
• Performance tuning of existing PeopleSoft Financials 8.1
  
• Performance tuning of existing PeopleSoft Financials 8.1
  

Fantasy Sports 3/2002 - Current
Job Title System Designer/Developer

• Develop Relational Data model for a fantasy sports company
• Install, Configure, and Maintain DB2 UDB EEE 7.2 on Sun Solaris
  
• Performance tuning db2, sql, and application code
  
• Develop OO Java modules using J2EE and J2ME
  
• Swing GUI, Java2D, JDBC, MIDP

Winn Dixie 9/2001 - 03/2002 Jacksonville, FL
Job Title DB2 OS390 System Programmer

• Upgrade DB2 to V6 on OS390 6 subsystems
• Support 3rd Party Software from CA Platinum
  
• Optimize system parameters for DB2 V6
  
• Provide system plan for DB2 offsite recovery
  

Options Clearing Corporation- 2/2001-9/2001 Chicago, IL
Job Title DB2 UDB EE/OS390 Database Administrator

• Perform daily database modifications using and maintain current data models
• Migrate DB2 schema's across all database environments
• Modify UNIX scripts to include new tablespaces in daily backups and weekly reorgs
• Assist developers and designers with SQL and database questions
• Configure DB2 JDBC on UNIX and OS390
• New development data model walk thrus
• Install new DB2 EE Instances on Sun Solaris
• Install DB2 fix packs on Sun Solaris
• Install Third Party tools and upgrades
• Trouble shoot production and development database problems
• Install DB2 subsystems on OS390 for new releases of the development project
• Install and evaluated change managers and performance monitors for DB2 on OS390

American Family Insurance - 04/2000 - 02/2001 Madison, WI
Job Title: DB2 UDB EEE/OS390 DBA/System Programmer

• Install DB2 UDB V6.1 for OS/390
• Upgrade existing DB2 V5.1 subsystems including 2 Datasharing Subsystems
  
• Configure Datasharing environment 2-way
  
• Assist MVS System Programmers configuring and verifying WebSphere and DB2 for proof of concept
  
• Assist Unix admins configuring and verifying WebSphere and DB2 for proof of concept
  
• Upgrade DB2 UDB Extended Enterprise Edition Servers to V7.1 on AIX
  
• Reorgs, backups and recoveries on DB2 UDB EEE
  
• Support HACMP high availability with DB2 UDB EEE
  
• Install third party software BMC, Platinum, Omegamon
  
• Buffer pool tuning
  
• Configure Stored Procedures, Work Load Management address spaces
  
• Convert from non-SMS managed storage to SMS managed Storage
  
• Configure NetData, JDBC, and SQLJ
  
• Performance tuning for PeopleSoft Human Resources System
  
• Daily maintenance of PeopleSoft HRMS System

PeopleSoft Consulting - 1/00 - 4/00 Various Locations
Job Title: DBA/Application Server Tuner

• Configure PeopleSoft Application Server Domains
• Performance tuning Application Servers on NT and UNIX
  
• Performance tuning DB2 and MS SQL Server on NT and AIX
• Upgrade PeopleTools V7.5 to V8.0
  
• PeopleCode Customization

Bridge Stone Fire Stone - 9/99 - 1/00 Akron, OH
Job Title: DB2 UDB DBA/System Programmer

• Install new DB2 UDB V6.1 for OS/390
• Upgrade existing DB2 V5.1 subsystems
  
• Install Subsystems for testing Datasharing
  
• Installed SAP Business Information Warehouse
  
• Install third party software BMC, DB2PM, Omegamon, Bufferpool Tool
  
• Define RACF groups and users
  
• Configure ESCON connections for HOST to SP2 Node
  
• Configure DRDA communications with SNA and TCPIP
  
• Define and manage DASD
  
• Disaster recovery planning using snapshot
  
• Trouble shoot ICLI connections with SA

Commonwealth of Virginia CDCI: 4/99 - 8/99 Richmond, VA
Job Title: Year 2000 External Auditor

• Interview state agencies and access potential risk within 10 categories for Year 2000 issues
• Verify documentation exists for agencies to show Year 2000 efforts
  
• Write a report on the perceived risk for the agency
  
• Give report to Steering Committee, Project Managers, and Governor Staff

Aid Association for Lutherans: 10/98 - 3/99 Appleton, WI
Job Title: DB2 Database Administrator

• Performance tune online and batch SQL systems OS/390 and Windows NT
• Data model review for new system
  
• DB2 object creation for new system
  
• Buffer pool Tuning
  

Fireman Fund Insurance: 7/98 - 10/98 Novato, CA
Job Title: DB2 DBA/System Programmer

• Upgrade DB2 V4.1 to DB2 V5.1 on OS/390
• Object creation for PeopleSoft Financials V7.5
  
• Upgrade PeopleSoft Financials V7.0 to V7.5
  
• Develop Buffer pool Strategies for PeopleSoft Financials
  
• Develop Disaster Recovery strategies for DB2 and PeopleSoft
  
• DB2 utility scheduling

Budget Rent A Car: 6/97 - 7/98 Lisle, IL
Job Title: DB2 DBA/System Programmer

• Upgrade DB2 V3.1 to V4.1 to V5.1 on OS/390
• Upgrade and install third party software Platinum, Omegamon
  
• Trouble shoot DB2 problems and apply maintenance
  
• DASD management using SMS
  
• Disaster Recovery Planning and testing
  
• DB2 utility scheduling, object maintenance and creation
  
• Buffer pool tuning
  
• Assisted application programmers with performance problems

Advantis: 1/97 - 6/97 Schaumburg, IL
Job Title: DB2 System Programmer

• Apply maintenance and Upgrades for 63 DB2 subsystems at various release and maintenance levels
• Apply maintenance and Upgrades for Platinum, Omegamon, BMC, FileAid for DB2
  
• Trouble shoot system problems with appropriate vendor
  
• Various levels of disaster recovery planning and testing

Oregon Department of Motor Vehicles: 1/95 - 1/97 Salem, OR
Job Title: DB2 Database Administrator

• DB2 production support, utility creation and scheduling
• Install DB2 UDB V5.1 on multiple NT servers
  
• Support Law Enforcement special requests during investigations
  
• DB2 backup and recovery including PeopleSoft HRMS V6
  
• DB2 390 performance tuning and trouble shooting
  
• DB2 object creation
  
• DB2 authorizations
  
• Buffer pool tuning
  
• Data modeling

First Data Resources: 4/93 - 6/94 Omaha, NE
Job Title: Programmer Analyst

• Application programming Assembler 370, COBOL, SQL, CICS
• DB2 application programming
  
• Data Modeling
  
• Production application support
  
• New application development and testing
  
• Existing applications modifications and testing
  
• Visa/MasterCard regulation support

Central States of Omaha: 3/89 - 4/93 Omaha, NE
Job Title: Programmer Analyst

• Application programming Assembler 370, COBOL, SQL, CICS, Ideal
• Datacom and DB2 databases
  
• Support production applications
  
• New application development and testing
  
• Modify existing applications
  
• Data Modeling

Kearney State College Financial Administration: 7/87 - 12/93
Kearney, NE

• Computer Operator
• Data Entry
  
• Backup Planning
  
• Trouble Shooting

NationalCollege: 9/87 - 6/87 Rapid City, SD
Computer Room Assistant

• Tutor for programming languages
• Computer Operator
  
• Printer Operator