Objective:

Interested in various technical jobs such as Sr. DBA/Data Architect or IT Manager.

Summary

Information technology professional with over 23 years of IT and Engineering experience. As a professional DBA and Developer, I have worked for many well respected firms including General Motors, American Express, IBM, and others. I have been hired as a DB2 consultant by IBM on six DB2 projects. Author of technical ebook ‘Introduction to DB2 UDB Client/Server’ copyright John Kesh. Author of ‘DB2 Z/OS V10 Migration Guide’.

Software:

DB2 UDB 9, IMS DB/DC, UDB ESE Database 9.1, VSAM, XPEDITER, VM/CMS, VMS, File-aid, SDF II, Focus, BTS, QMF, MQ Series, BMS, Clist, REXX, RDO, LU6.2, BMC Tools, FrontPage, PowerDesigner, Bachman, MetaData model, Star-Schema Model, Cube Model, Snow-Flake Model, Fact Table, ETL Process, Inmon Methods, Kimball Methods, Referential Integrity Model, ERWin, SPUFI, SQL EXPLAIN, JDBC, Xpediter, Knowledgecraft, ODBC, DB2 Connect, IDCAMS, Oracle 9i, UDB 8.2, UDB 9.0, Changeman, CA-7, CA-AllFusion, CA-11, JCL, ERStudio, MySQL , UML, RUP, Quest

Languages:

DB2/SQL, UDB, COBOL, COBOL II, COBOL/400, PL/1, Fortran, C, AIX script, Unix script, Korn shell, LISP, Prolog, Visual Basic, HTML, CICS, SQL, JCL, CL, Java, Java Script, VB Script, IMS DB/DC, CSP, Microfocus Cobol, SDF II, OPS5/OPS83, BMS, MFS, CLIST, DDL, REXX, UDB Stored Procedures

Project Management:

Responsible for coordinating USA Front office and India Back office operations to provide 24X7 DBA
Services for a multi-national company. Project scheduling and project reporting for several projects.
Applications project lead for health care system development. Leadership and mentoring of junior level
DBA and junior level programmer/analysts.

Education

• Bachelor of Science Mechanical Engineering
  

Project Experience

Confidential
Sr. UDB DB2 DBA/Data Architect
May 1997 – Present

• Created DB2 Q replication system for bi-directional q replication between two LPARS
• For a large financial application. Created MQ Queues, subscriptions, and Q rep tasks.
• Created Capture and apply started tasks for a db2 q replication system. Created DB2 databases
• including STOGROUPS, TABLESPACES, TABLES, INDEXES, JCL streams, LOAD, UNLOAD,
• IMAGE COPY, RECOVER, and other items for a large Financial application.
• Performance Tuning for a large financial broker data warehouse with DB2 UDB.
• Perform maintenance on 8 node PDF UDB DB2 AIX system. Eight Logical and physical nodes.
• Performed data migration and data replication using DB2LOOK and DB2MOVE utilities.
• Installed fix packs/patches for UDB version 8 upgrades. Installed UDB thin-client configuration.
• Performance tuning for deadlock/lock wait issues for a large UDB WINDOWS system.
• Created Codd data models in 3rd and 5th normal form using normalization methods.
• Added new columns to data warehouse tables. Performed Reorg/Runstats on DW tables.
• Created Korn Shell script for automating the Grant and other processes for the data warehouse.
• Solved various production problems for maintenance of the broker data warehouse.
• Installed UDB Thin-Client configuration and installed UDB fix packs and upgrades.
• Production support for a DB2 to Oracle customer information data migration system.
• Creation of DB triggers to process simulated real-time data transfer from DB2 to Tibco/Oracle DB.
• Created UDB DDL and SQL database build scripts for creation of a DB2 system in
• a Z/OS environment. Utilize DB2 CONNECT for Z/OS remote link.
• Design of a UDB database for a 10 node UDB partitioned EEE environment.
• UDB Database migration from pSeries to pSeries machines using DB2LOOK and
• DB2MOVE utilities. Creation of physical database design document.
• Lead DB2 DBA for a major automotive firm responsible for daily DBA tasks on Z/OS.
• Performed DB2 Utility jobs, DB2 problem resolution, production system problem solving on Z/OS.
• Provide DBA leadership for application groups with light DB2 experience. Perform image copy back-ups, database recover and restoration of data, load and unload utility, grant authorization to databases on Z/OS parallel sysplex.

Environment: IBM UDB DB2, PC, AIX, Windows, SQL, UDB DDL, Solaris Server, UDB Run-Time Client, IBM mainframe, JCL, Cobol, Platinum tool kit, VSAM, JCL, Z/OS, Erwin, DB2TOP, DB2 Connect
DBA Tools: DB2 Admin tool, BMC, CA RC, Platinum, IBM PM, Q REP Dashboard, Quest , Omegamon

Project: Confidential

• Provided production support for a mainframe data warehouse accounting system
• Performed load and unload operation for a DB2 DoD accounting system
• Resolved copy pending problems for a DoD DB2 database
• Use of Start Force commands. Resolved production problems for a DoD accounting database
• Instructed other team members on the fundamentals of the AIX operating system
• Performed runstats and reorg on DB2 objects
• Used the QMF query tool for data manipulation.
• Solved problems in Cobol II programs.
  

Environment: IBM Z/OS, IBM PC, AIX, Windows, IBM Mainframe, QMF
COBOL II, SQL, Abend-Aid, JCL, File-Aid, SPUFI, DB2 Utilities, JCL

Project:Confidential

• Development of AIX SQL scripts for banking financial applications.
• Used the Import, Export, and Load utilities.
• Executed the DB2 unload utility.
• Created AIX Korn shell scripts for running SQL scripts and migrating data with the NDM utility
• Created temporary work tables for data migration
• Installation of DB2 UDB version 8.1 run-time client. Utilized stored procedures and DB2 Connect. Data migration from UDB to Oracle 9i.
  

Environment: IBM pSeries Server, DB2 UDB, UDB EEE Database 8.1, SQLJ, AIX,
Windows XP, DB2 Connect, UDB 8.2, Oracle 9i

Project: Confidential

• Performed production problem solving on DB2 UDB 7 and IMS system for large automotive engineering parts release system
• Solved various production problems for a large DB2/IMS/COBOL database system using the Xpediter debugging system
• Provided physical DB2 database analysis and DB2 database modifications
• Conducted performance tuning and SQL EXPLAIN statement
• Handled various on-line IMS MFS-related problems
• Established stored procedure model and sysroutine catalog entry
• Instituted new data definitions for system enhancements
  

Environment: IBM OS/390, IBM DB2 UDB version 7.2, SQL, JCL, IMS, SPUFI, COBOL, Xpediter, AIX scripts, SQL EXPLAIN, File-Aid for DB2, QMF, JDBC, ODBC, SQLJ, Changeman

Project: Confidential

• Created a DB2 UDB data warehouse for a web internet customer information system
• Converted DB2 programs to DB2 stored procedures
• Established stored procedure DB2 objects in the sysroutines catalog table
• Originated program specifications for COBOL programmers
• Provided project milestone planning and estimating
• Instituted data dictionaries for new data items
• Analyzed user requirements and business rules
• Implemented COBOL/IMS Checkpoint/Restart software
  

Environment: IBM DB2 UDB version 7.2, COBOL II, IMS, Xpediter, JCL, File-aid
DB2, QMF, SQLJ, Stored Procedures, Changeman

Other software projects: 1984 – 1997

Commendations and Testing

• Letter of Excellence from EDS Corporation
• Letter of Excellence from Department of Defense, US Government
• Scored top 10% on Prove-IT DB2 DBA test, 02/2001 DB2 UDB Tech Tip of the Day:

BufferPool Tuning:

Check and make sure your BP page size is the same as your tablesapce page size.
These two page sizes must match.