DB2 UDB DBA

Michael R. Fatula

**** ********* ****

Camp Hill PA. 17011

Home Phone: 717-***-****

Cell Phone: 717-***-****

Career Objective

Information Technology Professional – Database Administrator, Data Warehouse Technical Support.

Personal Summary

Information Technology professional and Database Administrator with diverse technical background and 20+ years of experience with the Commonwealth of PA. Good written communication skills, a positive attitude, customer-focused with a proven ability to successfully implement new technologies to solve business problems.

Work Experience

4/01/08 – Present Homeland Security and US Customs and Border Protection

 Install and implement Tivoli LDAP 6.1, DB2 9.2, MQ Message Broker, etc…… The Agency had a need to replace and existing LDAP system because of performance reasons. This part of the Agency is not familiar with UDB and Tivoli required it. They brought me on to manage DB2. 9.2 on LINUX. I set up the DB2 UDB environments for parallelism and disk access. I set up archive Logging and recovery. Performed db2moves, Etc… These databases will also now be used for Passenger monitoring and will be loaded with much more data. I’m used to a much more hands on role. The LDAP group believes they can handle everything because they have been supplied LDAP commands. I’m installing db2 8.2 on 20 LINUX servers for an MQ project. These servers are going to be used to distribute the queues across the network. I’m really don’t have all the details to date. I’ll tune accordingly. I am familiar with scripting and can write them. As for the Control Center, I prefer commands and scripts. When I started using the Control center back in the 90’s, let’s just say it was a pain. I learned to do everything natively.

12/01/07 - 4/01/08 Citigroup

New Castle Delaware

Senior DB2 UDB DBA

 In-house implementation of Credit Card transaction repository. TRX had been running the applications for several years. Citi expects to save 17 million a year by running in-house. TRX used Linux as their front end. All scripts and code had to be changed to work on AIX instead. In addition to the daily support for application, I set up DB2 recovery and scheduling etc…. This was a very intense conversion and the DBA’s where expected to know the applications

1990 - 2007 Pa. Higher Education Assistance Agency

1200 North 7TH Street

Harrisburg Pa. 17102

Senior DBA

 Manage the development of DB2 systems on the AIX and Linux open system platforms, methodology, processes, procedures, and roles and responsibilities in support of these Systems.

 Oversee the development of policies and standards within each of the established servers.

 Interface with CIO’s, Agency IT managers, and others to promote, establish and maintain effective channels of communication.

 Work with Agency CIO’s, Directors, and Managers on Technology Infrastructure Plans and Implementations.

 Work with many in-house Systems Developers on achieving performance and answering technical concerns about platform dependency.

Accomplishments:

• Starting in 1997 the Agency rewrote a Loan Guarantee System. I was the lead DB2 UDB DBA. The System was taken off the Mainframe and written using Microfocus Cobol. Because the system was now platform independent we ran on AIX and could sell to others or run for them. This was a hugh leaning curve, but I did receive allot of practical hands on experience along with training.

• Played leading rule in getting COBOL application to compile and execute on the AIX Platform. The Programs had to be able to run on any platform.

• Defined and managed DB2 Web Databases running on SuSE Linux Mainframe

• Developed methods, workflow and procedures to support and manage open system databases.

• Played a lead role in establishing the first warehouses on the Open systems platform using both ETL and DB2 Propagator.

• Developed and fully tested all disaster recovery procedures.

• Implemented first interfaces with Websphere MQ and DB2.

• Installed and tested first XML DB2 tables incorporating the compose and decompose stored procedures.

• Developed code to automate Warehouse releases and update control tables both on the mainframe sources and AIX targets without using the manual GUI.

• Attended many IBM classes on AIX, DB2, Replication, XML and Microfocus Cobol. Several hundred hours of technical training.

• IBM certified in DB2.

• CICS Systems Programmer.

• Developed and Implemented HSM and related software procedures for DASD management.

• Researched Derived data tools and options available to allow replication from the mainframe to the AIX platform.

• Researching Legacy Systems Transformation vs Web Enablement as the Agency moves forward with Web development.

1987 – 1990 Pennsylvania Department of Transportation

Bureau of Information Systems

Systems Programmer

 Installed, customized and maintain software products for the full MVS/XA operating system.

Accomplishments:

• Installed and implemented CICS and DB2.

• Installed all the current releases of these products and attended many hours of IBM Education Classes.

• Wrote both CICS and DB2 programs to either enhance their Performance or in the case of DB2 to take over old database system functions.

Education

Attending Harrisburg Area Community College - working on a General Studies Degree Completed 52 credits to date.

Computer Systems Institute - Associate Degree in Specialized Business (Computer Programming). Certificate of Proficiency in Accounting.

Over 900 hours of vendor technical training including:

Course Provided by Course Hours

DB2 UDB Installation IBM 40 hrs

DB2 UDB Performance IBM 40 hrs

DB2 for AIX Database Admin IBM 40 hrs

DB2 for Linux IBM 40 hrs

CICS Tuning Amdahl 32 hrs

AIX Basics IBM 40 hrs

AIX Performance IBM 40 hrs

AIX Tuning IBM 40 hrs

DB2 Replication IBM 15 hrs

DB2 Replication & adv topics IBM 25 hrs

XML and DB2 Protech 40 hrs

Administering SQL Server Protech 40 hrs

Fundamentals of Data Comm IBM 15 hrs

DB2 Version2 Trans IBM 40 hrs

MVS JCL & Utilities IBM 40 hrs

IMS/VS Concepts IBM 40 hrs

SNA Fundementals IBM 15 hrs

CICS COBOL HACC 100 hrs

Assembler Amdahl 40 hrs

HSM Administration IBM 40 hrs

AIX shell scripting IBM 40 hrs

SQL performance IBM 40 hrs

BMC Patrol BMC 40 hrs

IBM DB2 Monitor IBM 40 hrs

DB2 IDUG’s Vendors 100 hrs

Member of the DB2 discussion group.

Member of the International DB2 users group.

Contact this candidate