DB2 DBA

Dennis McClure

**** *. ********* ****., ***. ****, Irving, TX 75063

214-***-**** ***************@*****.***

Skills: DB2 LUW, SQL Server, SQL, SAP on DB2, ksh, perl, C++, AIX, Linux, Solaris

Work History:

10/2013-7/2017 – PrimeSource Building Products - Database Administrator for DB2 9.7 and 10.5 LUW and SQL Server 2008, 2012, and 2014 databases. Responsible for three - 2 TB SAP databases on DB2 on Windows and three - 1TB data warehouses on DB2 on Windows. Used DBI BrotherPanther for SQL tuning for the SAP and data warehouse production databases. Responsible for 70 SQL Server databases. Migrated 20 databases from DB2 to SQL Server. Deployed and maintained bar code scanners, label printers, and other duties as assigned.

8/2011-9/2013 – MedSynergies – Database Administrator for DB2 LUW. In addition to the activities below I migrated the DB2 database to SQL Server 2008R2. I made extensive use of ksh and sed scripts working with db2look to extract the DB2 structure and transform to the SQL Server 2008 structure. Used bulk_copy to load the data.

1/2010-8/2011 – TrueBridge Consulting, consulting to MedSynergies. DB2 9.7 single node database DBA on Linux. New product to process both claim submital and remittance processes. Maintained a DB2 v8.2 single node database on AIX used for medical payment remit processing.

2010-12/2010 – CSI Technologies, consulting to HMS. DB2 LUW DBA for a Linux based data warehouse. Assisted with daily date maintenance.

9/1998-5/2010 – JCPenney – Database Administrator for DB2 LUW. Data warehouse of approximately 68 TB and several smaller database instances. The warehouse databases were in two remote data centers. Maintained backups, did restores, did tablespace and table management, allocated space, granted user access. Did database migrations, installed special builds to solve problems, and opened trouble tickets with the vendor. Fluent in ksh and perl as well as SQL.

Established BMC Patrol as the corporate standard for server monitoring. Wrote a C++ daemon to store and forward error messages from the Patrol agents to the corporate consoles for trouble ticket maintenance and escalation.

3/1996-9/1998 – Baxa Corporation – Programmed an Intel based computer system in C. This system was used by hospitals to formulate IV bags for hospital use. Wrote code for pump and valve actuation and monitoring. Wrote in Objective Pascal for database access for formulation calculations.

1995-1996-Ciber Consulting – Wrote C++ programs for customer service applications.

1994-1995-Best 1 Consulting – Wrote C++ modules use in the Customer Service system for the McCaw Cellular phone company.

1981-1994-Boeing Company – Wrote C++ modules for a system that graphically displays the total mechanical assembly of an aircraft. Wrote assembly language programs for equipment used to maintain flying avionics. Taught an off-hours C programming course that was credited through Seattle Pacific University in Seattle, Washington.

1979-1981-GenRad – Wrote circuit testing programs in assembly language. Introduced VisiCalc to the accounting department.

1977-1979-Honeywell, Marine Systems Division-Wrote assembly language components for several Sonar simulators used by the US Navy and taught the system programming to US Navy personnel.

1975-1977-Delphi Corporation – Wrote circuit board test programs in assembly language. I was first introduced to Unix as the operating system for the Delphi phone answering system.

1971-1975-Rockwell International – Wrote and maintained assembly language program for a system flying aboard the B-1 bomber and performed field test processes for the on-board system. Wrote FORTRAN data conversion programs.

Education: BS Electrical Engineering, Colorado State University, 1971

Contact this candidate