SUMMARY:

• Senior/Consulting/Principal Application Database Administrator (DBA) with extensive experience designing, coding, testing and supporting DB2 systems. Proven ability to lead seamless implementations and deliver next - generation technical solutions, improving overall system performance and workplace productivity. Proven track record of problem solving and implementation of Repeatable Processes thru innovation and process automation, leading to improved productivity and quality of deliverables. Twenty-
• Five + years working with DB2 Databases, Programs, Utilities, and Tools. Excellent leadership,
• Communications, and Coaching skills.

TECHNICAL SKILLS:

Systems: DB2 z/OS Mainframe; IBM-Db2 IDAA; DB2 UDB/LUW; IBM OS/390; IBM MVS/CICS; IBM MVS/DOS; AlX/Unix: Oracle; SQL Server; HP; Data General; Wang-VS; Solaris: VMS; NetWare; OS/2; Windows; Lawson/lnfor ERP; WebSphere

Languages: Cobol/Cobol2; C/C++; Clipper; Clist; Datacom DB; Fortran; SQL; REXX; RPG; Pascal; PL1; Shell/Korn Scripting; HTML

PROFESSIONAL EXPERIENCE:

Confidential, Cincinnati, OH

Senior Database Administrator and Team Lead

Responsibilities:

• Lead team of 6 to 8 DB2 DBAs, In a Z/OS (with some LUW DB2) large mainframe shop, for a growing technology company. Key technical role working with application teams on Banking/Credit Card processing and financial applications. Provide Operational and Production support of existing database environment: s. Provide guidance and coaching to junior DBAs and Offshore contractors. Team Lead role in Automating DB2 Utilities and Performance Monitoring. Working with very large databases/tables (Multi -
• Billion rows) and competitive service levels requirements. Lead role in the analysis and implementation f technology upgrades to reduce technical depth. Implementation of Data Replication and Automation. Lead role in the Implementation and support of the IBM Db2 Analytics Accelerator (IDAA) and Change Data Capture (CDC) for replication to the IDAA. Implementation and customization of 3rd-party Java applications systems. Providing every-day support of Backup/Recovery, Reorgs, Runstats, Partitioning and Re-partitioning of multi-billion row tables. Lead role in providing peak-season system preparation, and System Resumption Planning (DR Planning). Provide On-call (24hr) Production support.
• Lead role in the design, implementation, and rollout of the IBM Db2 Analytics Accelerator (IDAA), leveraging query acceleration in the OLTP transactional databases, as well as, on the data warehouse analytics data.
• Lead the design and implementation of complex data replication processes. Replication of Db2 data, using Change Data Capture (CDC) and IDAA Loads (Stored Procedures), to the IDAA appliances.
• Fully automated (using Rexx, SPs, and JCL) the Monitoring & Alerts process to ensure data integrity between the source Db2 data and the IDAA appliances.
• Lead the implementation (3rd - party software) PEGA PRPC for automated disputes/Charge back.

Confidential, Nashville, TN

Consulting Database Administrator

Responsibilities:

• Consulting Database Administrators are leaders within the Data Management organization, and provides perational support of existing database environments, development support for the creation of new applications and for the implementation and customization of 3rd - party applications systems, as well asguidance and expertise for the continuous improvement of uninterrupted operations. Lead
• (Senior/Consulting) role in Production support and data management of 50+ terabytes of data across multiple ERP systems and Legacy applications. I played a key role in providing root cause analysis and problem solutions for Cobol, Java, and .Net applications, using my extensive DB2 knowledge while applying problem solving and innovation skills. Work closely with Lawson (COBOL, Java, SQL) application development teams to ensure optimal DB2 performance. Review user requirements and project scope in determining resource allocations for design and implementation. Provide recommendations for application/systems improvements. Implementation of DB2 security and data access strategy using RACF groups/IDs to meet audit requirements (SOX compliance). Work closely with ther DBA teams (Oracle, SQL Server, DB2 LUW) to implement cross-platform systems (Linus, UnixWindows) with DB2 (Z/OS) as the back-end database. Daily DB2 Performance analysis, Tuning, and problem resolution using IBM DB2 Utilities, BMC DB2 tools, DB2 Log Analyzer, Omegamon, CA DB2 tools:, CDB DB2 tools, Rexx, ISPF, JCL, DASD and Tape Management, InfoSphere Replication Server
• (Data Propagator; SQL/Qrep replication from DB2 to Oracle and DB2 to SQL Server), InfoSphere Optim
• Archive for zseries, DB2 Connect, IBM Data Studio, Zeke, etc. The planning and Implementation of all
• DB2 (z/OS) Performance Maintenance, including daily, weekly, and monthly maintenance (RunstatsReorgs, Copies, Modifies, etc.) ensuring DB2 availability and system performance. Lead role in DB2 migrations and product upgrades. Provide leadership and coaching to junior and entry level DBAs.
• Lead DBA role in implementation and rollout of the Lawson - ERP systems (Lawson/lnfor is an
• ERP software similar People-Soft, and SAP). The first rollout and full deployment (throughout
• Confidential 200+ hospitals and facilities) was the HR/Payroll modules. Subsequent rollouts included
• Billing (Invoice Billing), Accounts Payable, AP Workflow, and Corporate Financials/General
• Ledger (GL). Database and application support from user requirements, design, code, test, and production implementations. Lead DBA role in DB2 migrations/upgrades (i.e. DB2 V8 to V9 on z/OS and LUW; DB2 z/OS V9 to VI0). Technical Environment: DB2 z/OS; DB2-UDB LUW;
• AlX/Unix, Cobol, Java, DB2 Connect; Data Studio; Web Sphere, Oracle, Business Objects, Data
• Replication (DB2 Propagator/Replication Server/Federation Server).
• Lead design and implementation of complex data replication processes. Replication of DB2 data
• (using InfoSphere Relication Server/Data Propagator) to several sources, including the Enterprise
• Data Warehouse (in Teradata), Operational Data Stores (in Oracle), and Business Objects universe for financial reporting systems and decision support systems. Complete automation of replication processes using Unix/AlX Shell/Korn scripting, DB2-UDB/LUW, DB2 z/OS, SQL, JCLand Rexx. Automation includes auditing and discrepancy reporting, as well as, critical and warning message alerting (via email and On-call support).
• Championed the implementation of building 'Repeatable Processes' among the Confidential DB2 DBA team and other Information technology teams. Developed streamlined procedures, processes and systems that decreased labor time, reduced redundancies, and increase quality of deliverables to the customers. Introduced root cause analysis and problem solving techniques to reduce the DBA teams' monthly job abends. The DBA team's monthly abends report saw a massive decreased (from an average of 250+ job abends to as low as 20 abends per month)which equates to less On-call and problem tickets for the DB2 DBA team. Because of this great success, I was asked to work with other teams in the Information Technology & Services group to help them reduce their monthly production abends.
• Automated previously manual, time-consuming processes to drive gains in data migrations/data copies accuracy, workgroup efficiency and productivity. Implementation and customization of the
• Rexx Automated Utility system (RAUS) - To automate the JCL creation for all DB2-DBA functionality (e.g. generation of Image Copies, Restores, Runstats, Reorgs, Unloads, Loadsetc.). Today, this Rexx tool (RAUS) is the back-bone on which the DB2 DBA team is able to move several terra bytes of data from production to several different DB2 environments (TestQA, Performance Testing, and ). Recently, Confidential demo a similar tool offering from third-party vendor (Automation Tool for Z/OS), which carries a million dollar price tag, but the third-party vendor tool fell short in functionality and customization when compared to the implementation of my Rexx Automated Utility system tool.
• Automation of DB2 monitoring, including critical DB2 limits (i.e. DB2 Partitioned Tablespace and dataset space and extents limits) monitoring and reporting. When at risk limits are detected, the system sends alert messaging to the DBA email box for DBA intervention. Automation and scheduling of Weekly and Monthly DB2 Reorgs to ensure 100% availability of DB2 systems on z/OS mainframes. Implementation of the use of DB2 Real-Time Statistics (RTS).
• Lead role in the implementation of HR/Payroll Archive/Purge for Confidential systems. Worked with 3rd party vendor (IBM) to install and implement the IBM InfoSphere Optim (Archive/Purge) tool for
• DB2 z/OS. Worked extensively with lead developers creating the data model and archive definitions/relationships. Worked closely with z/OS mainframe services team on capacity planning, to establish DASD (space) and storage requirements for implementation. Successfully led project thru the entire life cycle. Worked extensively with developers (Cobol, Java, .Net, etc.) to identify (using CLI traces, BMC Mainview, DB2 Explain, etc.) long running SQL (and programs) and implement DB2 optimization corrective actions.
• Design and implementation of Backup & Recovery strategy and procedures, as well as, Disaster
• Recover/System Resumption planning and testing for all DB2 systems. Scheduling and management of large DB2 z/OS Data-sharing Sysplex environment with DB2 CICS, DB2 BatchDB2 LUW, DDF, DRDA, TCP/IP, DB2 Connect, WebSphere, and Data replication processes.
• Implemented the use of DB2 Real-Time Statistics (RTS) in the DB2 Reorg (maintenance) schedule.

Confidential, Laurel, MD

Senior Database Administrator (DB2)

Responsibilities:

• Reduce a 48 - hour Production Database Migration (Unloads/Loads/Copies) Process to10-hourwith optimal use of DB2 utilities, DASD and Tape usage.
• Streamlined and Automated DB2 DBA daily functions, reducing system resources consumption and Increasing Quality.
• Backup and Recover planning and implementation, Including Test data migration management.
• Analysis and evaluation of 3rd party software and made purchasing recommendations to top level management.
• Design, developed, and implemented (DB2) test data migration system, saving the company
• Support and maintenance of all DB2 (& DB2/CICS) test and production environments, including
• Disaster Recovery Planning & Testing.
• Implementation of large-scale Telecommunication Billing System for Verizon (formally Bell

Confidential, Fairfax, VA

Database/Repository Administrator

Responsibilities:

• • Re-development, maintenance, and support for the RIS Data Warehouse (of the FDIC), one of the largest in the industry, at the time.
• • Data Mining and Logical Data Modeling and maintaining the Meta-data repository.
• • Developed streamlined COBOL programs and JCL used to extract, analyze, and transform data into information and meta-data for RIS.

Confidential, Beltsville, MD

Programmer/System Analyst

Responsibilities:

• Conversion of complex ISAM and VSAM Cobol code to DB2 Cobol code.
• Provided key Performance Tuning and DB2 SQL standards, yielding more efficient DB2 code.
• On - call Production Support working with outside vendors and interfaces to the Invoice Billing.

Confidential, Rockville Centre, MD

System Engineer

Responsibilities:

• Application development, debug, and testing using DB2/DB2 - CICS/COBOL. Performance tuning f application code for optimal SQL (DB2) performance
• Conducted Software Feasibility studies and Risk Analysis of legacy systems.
• Design and development of flexible software in COBOL for large gas companies with mainframe systems, as well as, small companies using mid-range and small systems. My team developed this flexible software in micro-focus COBOL, C/C+, FORTRAN, Turbo Pascal.
• Reversed engineered executable code to re-establish lost source code of older systems.

Confidential . Owego, NY

Engineer/Programmer

Responsibilities:

• Worked full - time (while attending Graduate School) for the largest (as that time) printed circuit board manufacturer in USA. Worked as an engineer, programing numerical control electronics testing devices.
• Later, move into the Computer Services department, working on COBOL programs on a Wang-VS system. Also, performed end-user support and .