Database Administrator Resume
Charlotte, NC
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.