PROFILE:

• Database systems professional experienced with DB2 LUW versions 8 through 10.5 on AIX, Linux and Windows, SQL Server 2012 and 2014 and Netezza.
• Excellent, even unique organizational, people and communication skills.
• Solid background in software engineering and the development and implementation of Capability Maturity Model (CMM) based methodologies.

TECHNICAL OVERVIEW:

Database systems include: DB2 UDB LUW on Linux and AIX, Netezza, SQL Server and exposure to PostgreSQL,Teradata and Oracle.

Tools: and Software includes: Optim, Tivoli System Automation, HADR, Change Data Capture, Guardium, SQL Replication, DBI Tools (Sysadmin), Netbackup, Quest Central, Toad, Foglight, Spotlight, BMC Smart DBA, Patrol.

PROFESSIONAL HIGHLIGHTS:

Database Administrator

Confidential, Charlotte, NC

Responsibilities:

• Supporting DB2 version 9.7 and 10.5 in an EDW environment, Netezza, SQL Server 2012 and 2014 and PostgreSQL.
• Spearheaded Toward Operational Excellence project to improve IT maturity.
• Completely revamped DB2 monitoring, backup and log archiving enabling seamless restores.

DB2 LUW Database Administrator

Confidential, Dublin, OH

Responsibilities:

• Supporting DB2 version 9.7 and 10.1 in a major Oracle to DB2 migration project.
• Upgraded standards and processes and auditing scripts for the DBA team.

DB2 LUW Database Administrator

Confidential, Dublin, OH

Responsibilities:

• Tuning efforts on the Fusion Real Time database resulted in nearly doubling processing efficiency.
• Supported DB2 version 8 .1 through 9.7 on Linux, Unix and Windows including DPF and clustered databases in a 1000 plus DB2 database environment.
• Spearheaded the upgrade of over 360 DB2 instances from version 8 to version 9 on both AIX and Windows.

DB2 on AIX Database Administrator

Confidential, Dublin, OH

Responsibilities:

• Supported the upgrade of the Siebel CRM application to version 7.8 via support of DB2 LUW 8.2 database systems.
• Designed and implemented database tuning program which included a complete rewrite of all database maintenance scripts.

DB2 LUW and IMS Database Administrator

Confidential, Columbus, OH

Responsibilities:

• Model, design, install, maintain, tune, back up and recover DB2 UDB ESE (formerly known as EEE), WSE, versions 8.1 and 8.2 on AIX, IMS, SQL Server 2000/2005, and DB2 on Z\OS databases in a production environment.
• Instrumental in the development, testing and implementation of a web accessible claims automation process utilizing a Siebel Systems front end and DB2/Informatica OLTP and OLAP database back end.
• Developed, tested, and installed complete rewrite of all database maintenance shell scripts.

DB2 LUW and IMS Database Administrator

Confidential, Greenville, SC

Responsibilities:

• Model, design, install, maintain, tune, back up, recover DB2 on AIX, and IMS databases in a production environment.
• Developed, tested, implemented new database maintenance architecture which reduced processing costs and times by over 40%.
• Team lead and project manager for major disaster recovery exercise.

Database Administrator, Quality Assurance Engineer

Confidential, Austin, TX

Responsibilities:

• Performed DBA duties, with emphasis on modeling, design, development and implementation for Extract, Transform, Load and Data Warehousing operations primarily using DB2 UDB and Oracle in a Unix (AIX, Solaris, HP)/Linux environment.
• Designed, developed and implemented new CMM based methodology which was accepted and implemented by the Quality Assurance Team.
• Assisted in quality assurance testing and tuning of database related parameters in ETL and Data Warehousing operations.

Cobol Programmer and DB2 and IMS DBA

Confidential, Columbus, GA

Responsibilities:

• Maintain, tune, back up, recover IMS and DB2 on Z\OS and DB2 on Unix databases in a production environment.
• Spearheaded development and implementation of CMM based documentation for both departmental and vendor use.
• Analyzed, designed, developed, tested, debugged, and maintained COBOL, and CICS programs, with JCL and procs, in a TSO ISPF MVS mainframe environment.