OBJECTIVE:

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

SUMMARY:

Information technology professional with over 28 years of IT and Engineering experience. As a professional DBA and Developer, I have worked for many well respected firms. I have been hired as a DB2 consultant by Confidential on six DB2 projects. Author of technical eBook ‘Introduction to DB2 UDB Client/Server’

TECHNICAL SKILLS:

Software: DB2 UDB LUW 10.5, IMS DB/DC, UDB ESE Database 9.7, CA - RC Tools, 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, Changeman, CA-7, CA-AllFusion, CA-11, JCL, ERStudio, MySQL, UML, RUP, Quest, DB2 Data Sudio

Languages: DB2/SQL, UDB, COBOL, COBOL II, COBOL/400, PL/1, JCL, C, AIX script, Unix script, Korn shell, LISP, Prolog, Visual Basic, HTML, CICS, SQL, CL, Java, Java Script, VB Script, IMS DB/DC, CSP, Perl, SDF, 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.

PROJECT EXPERIENCE:

Confidential

Sr. DBA/Management Consultant

Responsibilities:

• Creation of new database backup and restore strategy for a large UDB LINUX financial system. Provide IT management consulting, risk management, leadership consulting for special projects.
• Korn shell script writing for AIX and LINUX UDB LUW database infrastructure systems.
• TSM Tivoli Storage Manager Disk backup and TSM database archival methods. Perl Scripting.
• Performance tuning for a large DB2 LUW/AIX data warehouse system. Evaluation of swap memory,
• System cache, real memory, DB2 configuration parameters, registry variables and other parameters.
• Performed LUW UDB work on version 10.5 and AIX 6.1, Linux, Windows, and Solaris.
• Assisted in the development of a PureScale DB2 application and OPM Optum Performance Manager.
• Created a DB2 Q replication system for bi-directional q replication between two LPARS.
• Created MQ Queues, subscriptions, and Q rep tasks for a large financial application.
• 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.
• DB2 Z/OS Reorg, Runstats, jcl, Image Copy, Check, Load, Unload, CA Tools, Confidential tools
• Created several JCL jobs for DB2 Maintenance to run on Zeke scheduler.
• Perform maintenance on 8 node PDF UDB DB2 LUW AIX system. Eight Logical and physical nodes.
• Performed data migration and data replication using DB2LOOK and DB2MOVE utilities.
• Installed fix packs/patches for UDB LUW version 8 upgrades. Installed UDB thin-client configuration.

Confidential

Responsibilities:

• Created a b-directional Q replication system for data transfer between two lpars
• For a Z/OS DB2 system.
• Created DB2 databases for a VSAM to DB2 conversion project using Confidential VT Tool.
• Performed data migration for data transfer between a two lpar systems.
• Resolved various issues for a DB2 application developer group.
• Creation of project plans and estimates for milestone delivery.
• Trained staff in the Confidential Q replication technology and its applications.
• 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: pSeries Server, DB2 UDB, UDB EEE Database 8.1, SQLJ, AIX Windows XP, DB2 Connect, UDB 8.2, Oracle 9i

Confidential

Responsibilities:

• 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: Confidential Z/OS, Confidential PC, AIX, Windows, Confidential Mainframe, QMF COBOL II, SQL, Abend-Aid, JCL, File-Aid, SPUFI, DB2 Utilities, JCL

Confidential

Responsibilities:

• Created DB2/COBOL application programs for a customer management 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

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

Confidential

Responsibilities:

• Created solutions for the year 2000 change over.
• Maintenance for the primary system.
• Interface with NASCO on new system architecture.
• Analyzed user requirements and business rules.

Environment: Confidential mainframe, SQL, JCL, IMS, SPUFI, COBOL, Xpediter, SQL EXPLAIN, QMF