TECHNICAL SUMMARY / ACHIEVEMENTS

• Lead System Specialist - DB2 DBA with extensive data base administration experience. Areas of expertise include DB2, Oracle, DB2's Replication, DB2's Deep Compression, HADR, Netbackup, Netapps Filer, Golden Gate, IBM's Content Manager OnDemand CMOD , IMS DB/DC. Operating Systems include Linux, Solaris, AIX, MVS, z/OS and Windows Server. Experienced as an ISO 9000 auditor. Flexible with strong organization skills and outstanding record of completing multiple projects simultaneously. Team member designing, developing, implementing, and maintaining DB2 databases supporting essential company applications supporting production systems for nationwide FiOS business.
• DBA experience maintaining and supporting five applications containing 21 schemas, including development and production servers, loading initial, upgrades, and software patches. Products include DB2, DB2's Replication, Warehouse EEE databases, DB2 tools and Deep Compression, SQL, PL/SQL. Analyzed all database updates to insure integrity of database design.
• Most recently provided 24x7 system support on three primary applications 1 terabyte that ran on UNIX platforms and two applications 600 gig on Linux operating systems. Experience with DB2 and Replication and all versions of DB2 through version 9.7. Maintained uptime of 99 .
• Distributed all application and Java code to primary production servers, which included maintaining application code on 21 UNIX/LINUX servers throughout the Verizon footprint, maintaining uptime of 99 .
• Retired three replication servers through proactively reviewing these servers and discovered another cost free method to obtain the data needed by these servers.
• Monitored resource utilization from both database and O/S level making suggestions for upgrades for software and hardware which reduced planned expenditures by 400K, using DB2 Deep Compression. Worked closely with OS System Administrators on monitoring disk and CPU usage to determine server purchasing and hardware upgrades.
• Converted eleven UNIX servers supporting 12 schemas from DB2 9.1.5 to 9.7.5 to fix several production problems: improved performance, closed security breaches, and provided faster algorithms. Project completed before target due date. Upgraded test servers from 9.7.5 to 10.1.
• Spearheaded project to move entire database servers from one data center to another. This involved complete planning, designing, testing, and implementing plans to recreate the database servers in the new data center before target date.

COMMUNICATIONS AND LEADERSHIP

• Lead DBA training junior DBAs as they enter team.
• Created several proactive scripts to automate daily functions, and to monitor databases to prevent outages and to provide database metrics.
• Provided excellent communications with customers of the DBA group, developers, System Administrators, Hardware groups, and end users. Received numerous letters of appreciation.
• Worked with a cross functional team, with a sense of urgency and pulled together a team, and delivered a solution ahead of plan when reducing replication servers.

EMPLOYMENT SUMMARY

INDEPENDENT CONTRACTOR

Confidential

Administrator Consultant. Provide DB2 evaluation of DB2 v9.7 environment AIX operating system . Resolved backup/restoral and DR issues by providing a strategy, scripts and documentation. Introduce database monitoring scripts to proactively monitor database health.

Confidential

IT Consultant for Cincinnati Bell, IBM's Content Manager OnDemand CMOD . Provide backup strategy and documented processes for IBM's CMOD product. Assist in building a robust test system for IBM's CMOD product.

Confidential

IT Consultant provided company-wide processing improvements across several existing processes with documentation.

Confidential

Lead System Specialist- DB2 DBA

• Provided nationwide 24x7 DBA support for essential production systems encompassing applications supporting FiOS operations. Applications support auto discovery, configuration, inventory and activations of millions of home network devices. Supported application by distributing application code to remote servers, installing patches and upgrades to existing DB2 servers.
• Provided expertise for rebuilding 21 database servers to transition a third of the FIOS/landline business to Frontier Communications spanning 13 States nationwide.
• Worked with programming team to provide tuning and installation of triggers and stored procedures. Added and modified table definitions and maintained all UNIX scripts and cron jobs, resulting in the scripts monitoring system processes and database objects maintaining 99.6 reliability.
• Upgraded version 9.1.5 DB2 servers to version 9.7.5 on UNIX / AIX / Linux platforms. Successfully managed project and completed conversions on time.
• Developed and maintained a Disaster Recovery plan using IBM's DB2 HADR which responded to a past failure within 15 minutes with little to no user impact.
• Selected and trained as ISO 9000 auditor, provided documentation and set up test environments to ensure compliance with standards.
• IMS and DB2 Production Support Database Administration. Moving the logical design to physical design used in production. Analyzes, tests, and implements changes into the production database. Measures and uses proactive scripts to maintain databases integrity, verify data integrity, verify health of database, and to prevent downtime maintaining 99.9 reliability.

Confidential

Linux, Solaris, and MVS Systems Administration. Oracle Master in Database Administration and Oracle Internet DBA Certificate, IBM DB2 Database Administration, and Informix Database Administration Certificates, IBM's Content Manager OnDemand CMOD , Golden Gate, ERWIN, Bachman. Numerous company sponsored courses.