SUMMARY:

• Senior DB2 DBA, Technical Lead, and DBA Manager with strong experience leading teams in support of very large application development projects in IBM mainframe/DB2/IMS/COBOL/CICS environments.
• Certified in IBM database administration; deep skills in all phases of data management and database administration, Application and Production support, and disaster recovery.
• Exceptional skills in performance tuning at the program and system levels.
• Trained and experienced in distributed database processing with Oracle 11g and DB2 LUW.
• Has written many research reports, proposals, procedure manuals, and is an experienced public speaker and presenter.
• Meets deadlines and solves problems under pressure in 24/7/365 environments, stays organized in fast moving projects, and develops excellent client relationships.
• Succeeds with an attitude to deliver service, add value, and share knowledge.

SYSTEMS AND TECHNOLOGY:

Applications: Medicare/Medicaid, Transportation (Railroads), Welfare and Child Support, Retail, Manufacturing (Steel, Outerwear), Hospitality and Lodging, Student Loan Origination, US Postal Service Operations

Operating Systems: z/OS, Linux/UNIX, Windows

DBMS: DB2 10 for z/OS, DB2 LUW, Oracle 11g, IMS DB/DC

Languages: COBOL, CLISTs, REXX, Assembler

Hardware: IBM and Amdahl mainframes

Software: Cognos BI 10, ERWin, ER Studio, TSO/ISPF, QMF, CICS, JCL, Oracle Enterprise Manager, Microsoft Office, Endevor, OPC/ESA, Confidential Utilities for DB2, CA Utilities for DB2, Syncsort, DFSORT, ACF2 Security, OPTIM, TN3270

Performance Monitors: DB2PM, Mainview for DB2, DETECTOR, Omegamon, Omegaview, TMON, STROBE/DB2

PROFESSIONAL EXPERIENCE:

Senior DB2 DBA

Confidential, Etters, PA

Responsibilities:

• As a DB2 DBA staff augmentee, modified DB2 tables to add Confidential to enable encryption of the table data.
• Performed benchmarks of the performance of queries before and after encryption to determine any problems prior to cutover to Production.

Senior DB2 DBA

Confidential, Arlington, VA

Responsibilities:

• Senior DB2 DBA supporting Confidential mainframe applications.
• One of two DB2 DBAs providing Application and Production support for 7014 DB2 tables in each of three regions. Workflow is governed by Remedy problem tickets.
• Perform Production cutovers of medium to high complexity.

Manager, Consulting

Confidential, Washington, DC

Responsibilities:

• Tuned long running Oracle reports for a Dept. of Justice project.
• Trained onshore and offshore personnel in DB2 for z/OS.

Senior DB2 DBA/Manager

Confidential, Washington, DC

Responsibilities:

• Wrote a Procedures Manual for the DBA team.
• Created a Security Audit Report which used DB2 log information to identify unauthorized updates and updaters of sensitive DB2 tables.
• Implemented data replication using Confidential Log Analyzer.

Independent Computer Consultant

Confidential, Baltimore, MD

Responsibilities:

• Created an IMS HDAM Tuning Procedures Guide for reference by the DBAs.

Senior DB2 Database Administrator

Confidential, Bloomington, MN

Responsibilities:

• Staff augmentation.
• Created and maintained new databases to accommodate new client data from Confidential and major healthcare insurance clients.
• Performance and tuning for very large databases having extended addressability.

Senior DB2 Database Administrator

Confidential, Essex, MD

Responsibilities:

• Application and Production DBA for Welfare and Child Support applications.
• Recovered $70,000 in cpu costs by tuning batch programs.

Senior DB2 Database Administrator

Confidential, Baltimore, MD

Responsibilities:

• Application and Production DBA for Constellation’s mainframe systems.
• Supported DB2 systems upgrade to DB2 v.8.
• Production support for a DB2 UDB LUW OnDemand application.

Technical Consultant/Architect

Confidential, Baltimore, MD

Responsibilities:

• Developed DB2 - based statistical solutions for Risk Adjustment reports.
• Logical and physical data modeling for a Microstrategy reporting project.

Database Administrator

Confidential, Bethesda, MD

Responsibilities:

• Production and Application Support DBA for Confidential ’s Consumer Marketing Systems.
• Analyzed and revised online Confidential jobs to eliminate application lockouts and improve on the 99.98% uptime of the systems.

Lead Database Administrator

Confidential, Baltimore, MD

Responsibilities:

• Supervised eight DBAs in support of the Medicare Advantage Prescription Drug ( Confidential ) project.
• Delivered efficiently performing databases under tight deadlines and national scrutiny.
• Implemented procedures for reviewing all new, changed, and existing programs for efficient SQL and efficient DB2 programming techniques.
• Set up procedures for moving data from the legacy system into Confidential during conversion.
• Standardized procedures for working with Confidential Catalog Manager and Confidential Change Manager. Wrote the Disaster Recovery Manual.

Senior Database Administrator

Confidential, Washington, DC

Responsibilities:

• Shortened, by hours, the overnight ETL batch jobs to conform to service level agreements.
• Implemented new physical designs for 30 DB2 tables. Analyzed and defined buffer pool assignments and sizing.
• Researched, tested, and installed TN3270 as the standard terminal emulator for the project.

Project Database Administrator

Confidential, Washington, DC

Responsibilities:

• Sole DBA for DOIS, a $40M, 8000-user Confidential system which automates carrier scheduling, routing, and time accounting in post offices.
• Created DB2 naming standards to accommodate DB2 object names in fourteen Test and Production regions. Upgraded ERWin modeling software; converted and maintained the DOIS data model.
• Determined Performance Reporting specifications and set up regular performance reports using Mainview and DB2PM.

Manager, Database Administration

Confidential, Essex, MD

Responsibilities:

• Recovered 11,000 man hours of expected down time for Baltimore City workers by tuning the batch jobs for the conversion of Baltimore city welfare and child support beneficiaries into the state system.; reduced the conversion run time by thirty hours.
• Cut in half the time to produce the monthly Production-to-Test data refreshes.
• Established training presentations for the DBA team.