DB2 UDBfor Z/OS V2, - Worddocx.com

sunfloweremryologistΔιαχείριση Δεδομένων

31 Οκτ 2013 (πριν από 3 χρόνια και 10 μήνες)

175 εμφανίσεις

Chad Breiner

3S004 Timber Drive

Warrenville, IL 60555

(630) 373
-
0221

chad@cbiconsulting.com


Technical Knowledge:
Databases:


This word document was downloaded from
http://www.worddocx.com/

please remain this
link
information when

you

reproduce , cop
y
, or use

it.

<a href='http://www.wordwendang.com/en'>wor
d
documents</a>





DB2 UDB for Z/OS V2, V3, V4, V5, V6, V7, V8



DB2 UDB for LUW V5, V6, V7, V8, V9



Datacom



Teradata

DB2 Administration:



Quest Central



DB/Artisan



Control Center



BMC



Platinum

DB2 Utilities:



Reorg, Backups



ImageCopy



Restore



Redirect restore



Log
recovery



Quest Spotlight



Platinum



BMC



GrangerSQL,



Snapshot



Event Monitors

Data Modeling Tools:



Erwin



S
-
Designer



ER/Studio

Unix:



Korn Shell



Perl



cron



smitty



x
-
windows



OS390:



TSO



SMPE



ISMF



ISPF



IDCAMS



TMONDB2



Omegamon

Operating Systems:



OS/390



AIX



Sun Sola
ris



Linux



Windows XP/2000/NT



OS/2

Languages:



SQL,



Korn Shell



REXX



Perl



Stored Procedures



Java



C/370, C, C++



370 Assembler



COBOL 370, Microfocus COBOL



ISPF Dialogs



PeopleCode, PeopleTools, SQR

Other:



WebSphere Application Server



MQ Series



Tuxedo



PeopleSoft

Financial V6, V7, V8



PeopleSoft HRMS V6, V7, V8



PeopleSoft EPM V8



SAP R3 V4.5 BI



Walker Financials


Education/Qualifications:

College:




Bachelor of Science Business Management of Technical Services



Bellevue University, Bellevue Nebraska 3.8 GPA

User Gr
oups:



IDUG International DB2 Users Group



MWDUG Midwest DB2 Users Group

Certifications:



IBM DB2 UDB Certified Database Specialist V8



IBM DB2 UDB Certified Database Administrator LUW V8



IBM DB2 UDB Certified Database Administrator ZOS V8





Professional Expe
rience:


The Bank of New York Mellon


New York, NY, MN 07/2007


10/2007

Job Title: DB2 Database Administrator



DB2 LUW V8 Performance Tuning



PeopleSoft EPM BASEL II performance tuning



DB2 LUW SQL tuning



DB2 LUW trouble shooting



Korn Shell Scripting


Ande
rson Trucking


St Cloud, MN 08/2007


08/2007

Job Title: DB2 Database Administrator



DB2 LUW Redirect restores



DB2 LUW Log file placement



DB2 LUW Tablespace placement



Korn shell scripting


Berkley Technology Services


Luverne, MN 02/2007


07/2007

Job Ti
tle: DB2 Database Administrator



DB2 LUW V8/V9 upgrades



DB2 LUW V8/V9 fixpack applies



DB2 LUW V8/V9 environment planning and installation of multiple instances



DB2 LUW performance tuning/snapshot/event monitoring



DB2 LUW trouble shooting



Korn Shell Scripti
ng


Blue Cross Blue Shield of Kansas


Topeka, KS 12/2006


01/2007

Job Title: DB2 ZOS Health Check



DB2 Z/OS V8 ZPARM Evaluation



DB2 SMFACCT Tracing for Class2/Class3 DB2 time



DB2 SRTPOOL tuning



DB2 BP7 tuning



DB2 VSAM Placement


Sonoco


Hartsville, SC 01
/2006


02/2006

Job Title: DB2 LUW Health Check



DB2 Z/OS V8 ZPARM Evaluation



DB2 SMFACCT Tracing for Class2/Class3 DB2 time



DB2 SRTPOOL tuning



DB2 BP7 tuning



DB2 VSAM Placement


Berkley Technology Services


Luverne, MN 03/2006


11/2006

Job Title: DB2 Dat
abase Administrator



DB2 LUW V8 fixpack applies



DB2 LUW V8 environment planning and installation of multiple instances



DB2 LUW performance tuning/snapshot/event monitoring



DB2 LUW trouble shooting



Korn Shell Scripting


NCS Pearson


Iowa City, IA 01/2006


02/2006

Job Title: DB2 Health Check



DB2 Z/OS V8 ZPARM Evaluation



DB2 SMFACCT Tracing for Class2/Class3 DB2 time



DB2 SRTPOOL tuning



DB2 BP7 tuning



DB2 VSAM Placement



LabCorp


Burlington, NC
-

08/2005


12/2005

Job Title: PeopleSoft DB2 UDB DBA DB2



DB2 env
ironment planning/creation.



DB2 upgrades and fixpack applies



DB2 Backup/Recovery planning documentation



DB2 Performance Tuning for Peoplesoft Applications Financials/EPM



SQL Tuning



Documentation


Meijer


Grand Rapids, MI 05/2005


08/2005

Job Title Senior

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/200
5

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



DB
2 Buffer Tuning



DB2 Access Path Tuning



DDL denormalization



DB2 Trouble Shooting



SQL walk through



SQL Tuning


Bandag


Muscatine, IA 11/2004


12/2005

Job Title: DB2 for ZOS System Programmer



Resolve outstanding SMPE holddata from upgrade to V8



Run SMPE app
ly for action/doc ptf’s



Verify functionality


Blue Cross Blue Shield of Illinois 06/2004


12/2004

Job Title: DB2 UDB DBA DB2 upgrades and fixpack applies



DB2 Backup/Recovery planning documentation



DB2 Redirected Restores



Configure Tivoli for db2 on multi
servers



DB2 Performance Tuning



DB2 Trouble Shooting



SQL walk through



SQL Tuning



Documentation


Banta


Menasha, WI
-

03/2004
-

06/2004


Job Title: PeopleSoft DB2 UDB DBA DB2



DB2 upgrades and fixpack applies



DB2 Backup/Recovery planning documentation



DB2 Per
formance Tuning



SQL Tuning



Documentation


Wal Mart


Bentonville, AR 02/2004


03/2004

Job Title: DB2 Performance tuner



DB2 for OS390 V7 performance tuning



Peoplesoft Global Payroll 8.3 for 85,000 people



Evaluate indexes on poor running queries



Redesign Bu
fferpool to isolate high activity tablespaces



Reorg DSNDB06/DSNDB01 for better dynamic sql performance



Modify custom queries and dms queries where needed



Resize sort pool/rid pool/edm pool for better performance


West Bend Insurance


West Bend, WI 01/2004



02/2004

Job Title Senior DB2 DBA



Plan DB2 Connect V7 to V8 upgrade



Test/Verify upgrade with existing applications



Train existing staff on DB2 Connect usage



Upgrade Development and QA environments



On call support while client upgrades the production envi
ronment



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 B
ackup/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



Create PeopleSoft Financials Da
tabase on DB2 for OS390



Install and Configure Process Scheduler on USS(Unix Systems Services)



Performance tuning of existing PeopleSoft Financials 8.1



Performance tuning and recommendations for Peoplesoft Financials V8.4



Fantasy Sports 3/2002


8/2002

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 D
B2 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 Su
n 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 manage
rs 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 Subsyst
ems



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 Enterpri
se 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 addre
ss 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 Locati
ons

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 Customizati
ons


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 snaps
hot



Trouble shoot ICLI connections with SAP


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 exi
sts 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 Admini
strator



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 sched
uling


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 usi
ng 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



Appl
y 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 requ
ests 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


Mutual of Omaha Insurance: 6/94
-

1/95 Omaha, NE

Job T
itle: Data Analyst



Application programming COBOL, SQL



Data modeling for a Data warehouse using Teradata



Tuning SQL statements



Trouble shooting performance problems


First Data Resources: 4/93
-

6/94 Omaha, NE

Job Title: Programmer Analyst



Application progr
amming 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 Om
aha: 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 Mode
ling


Kearney State College Financial Administration: 7/87
-

12/93

Kearney, NE



Computer Operator



Data Entry



Backup Planning



Trouble Shooting


National College: 9/87
-

6/87 Rapid City, SD

Computer Room Assistant



Tutor for programming languages



Computer Op
erator

Printer Operator


This word document was downloaded from
http://www.worddocx.com/

please remain this
link
information when

you

reproduce , cop
y
, or use

it.

<a href='http://www.wordwendang.com/en'>word docume
nts</a>