Resume

Sign in

Manager Sap

Location:
Rockville, Maryland, United States
Posted:
December 28, 2018

Contact this candidate

Resume:

Name: Shih-Liang Chao (Jason Chao)

***** ****** ** *********, ** 20852

Google phone: 571-***-****

ac72je@r.postjobfree.com

PROFESSIONAL SUMMARY

Shih-Liang Chao (Jason Chao) has more than 20 years of experience in Relational Database Management. His career has focused on Relational Database as Sr. Z/OS DB2DBA, SAP HANA DBA/SA/basis/Architect. His most notable clients include SAP America Inc., Ariba/SAP, Sempra Utility SDGE, FDIC, DHS/CBP, SSA, CMS, MD, NY State, HUD, Lockheed Martin, GEICO, Bell Atlantic/Verizon, and Navy Federal Credit Union. He has SSA/DHS/CBP TS & FDIC clearance.

EXPERIENCE

Skills Utilized:

IBM mainframe – Systems 370/390, Z/OS V2.1 Operating System, LINUX/AIX/UNIX/PC,DB2 V11 Zparms, NDM,FTP, ZLINUX

BMC DASD/Catalog/Change/Backup/Recovery Manager; System and SQL Perf; Opportune/Apptune and Log Master DB2 V10 tools, Allusion Erwin 4.1.4.; DB2 OMEGAMON, IBM JCL, COBOL, IBM Utilities, TSO, FILEAID, ENDEVOR, QMF, VSAM, IMS DB,zEC12

CA Platinum DB2 Utilities : RC/Query, RC/Update, RC/Migrator, Plan Analyzer, Database Analyzer and DETECTOR, Data Sharing,TMON,CDB Online Reorg,CICS/TS 1.4, Log Analyzer,SAS

SAP Netweaver, SAP DB2 & DB6(DB2 UDB/Linux) Database assessment & performance tuning, SAP CoE RCA root cause Analysis, ABAP performance analysis, HANA Database DBA, ERP/ECC 6.0, BW, ABAP stack, ORACLE Database, SAP BASIS administration all SAP Tcodes, SAP Solman Solution Manager, SAP CRM, PI and Portal, SAP BusinessObjects Data Quality Management (SBOP DQM),Business Intelligence/Business Objects (BI/ BO),GRC, involving SAP Configuration and Customizing in full cycle, SDLC, TOGAF, SAP ASAP

PuTTY, WinScp, Python, FTP,SUSE Linux 11 HANA database server, HANA Data studio & Client,Cloud & Mobile, Lumira, SRS SAP Replication Server, Jira, perforce P4, P5,HANA DBA Primary, secondary & standby cluster scale-out with muti TB DB sizes, Python cdpy; DBACockpit

DB2 V10 IBM ADMIN DBA tool ISPF, IBM DB2 Data studio 4.1 Eclipse framework, Oracle V11R2 OTG Oracle Transparent Gateway for DB2 DRDA Gateway PeopleSoft HCM;CRM Oracle 11g RAC ASM AIX, OEM cloud control 12c, RMAN,Toad, FTP, Data Guard, IBM InfoSphere Change Data Capture for DB2 on z/OS

MOST RECENT POSITION:

Company and Title of Position: Sempra SDGE/ATOS/MergeIT Sr. Z/OS DB2 DBA

Date of Employment: August 2015 to present

Number and Type of personnel supervised: DBA group and user group

Brief description of Duties and Responsibilities: Provide DB2 DBA support for Production (on call), Integration, Development and Verification total 14 DB2 environments for Sempra Utility SDGE San Diego Gas & Electric CISCO;SORT Billing & financial thru service tickets.

Immediate Supervisor and Telephone number: Robinson, Barry (C) 469-***-****

Skills Utilized:

IBM mainframe – Systems Z/OS 2.1 Operating System, DB2 V11, Personal Computer Window 7.0

DB2 CA Platinum DB2 Utilities;QMF;DB2 Insight for Database performance tuning; and CA Log Master DB2 V10 tools; Z/OS 2.1. FTP, REXX, CLIST, IBM JCL, IBM Utilities, TSO, FILEAID, ENDEVOR

Helping and tuning Tool for handling Data from ORACLE into DB2 CISCO database.

Helping DB2/CICS RCT Resource Control Table define CICS transition and DB2 plan and granting access

Health checks and system copy/clone activities, which includes Incident/Problem/Change management activities thru service-now ticket.

Provide DB2 DBA support for Production (on call), Integration, and Development and Verification 14 DB2 environments. Perform weekly PROD DB2 tables Reorg & biweekly backup 13 Non-PROD DB2 platforms & quarterly Runstates for Production DB2 tables & archived Giant 109 billion rows Smarter Meter tables’ stable better DB2 performance. Implemented on projects related to database administration for CISCO, SORT service-now several thousand tickets. Coordinate and help PROD release and problem solving and DB2 performance monitoring, Tasks included: Create & Maintenance Databases, Migrating DDL thru CA DB2 tool from DEVL, QUAL to PROD platforms, Identifying and analyzing required meeting user requirements for mission-critical databases, maintaining, administering application database security in accordance with RDBMS and organizational approved standards and procedures. Implemented backup/recovery strategies to ensure RDBMS and application databases are available within an acceptable time frame after loss of production system. Assisted in functions of DBA to provide a support of projects database on full life-cycle development.

PRECEDING POSITION 1:

Company and Title of Position: Ariba SAP/Latitude360 Sr. HANA cloud DBA

Date of Employment: April 2015 to June/2015

Number and Type of personnel supervised: DBA group

Brief description of Duties and Responsibilities: Provide HANA cloud DBA support for Ariba SUSE Linux 11 HANA DB V85, Ariba production Hana SV cluster expanded from 3 nodes to 6 nodes in both US & EU data centers, SRS Sybase Replication Server migrating from Oracle DB to HANA Primary, Secondary, Standby cluster with An commercial network buyers & Sellers Lumira thru Jira, perforce P4, P5, Putty, Hana Studio, WinScp

Immediate Supervisor and Telephone number: Deo Caruana (O)650-***-**** (C) 408-***-****

Skills Utilized:

SUSE Linux 11 HANA V85 cloud appliance, Install HANA Studio, HANA client, HDBSQL, HDBnsutil primary fail secondary take over, Python sapcontrol HDB start, stop, HDBsetup, HDBlcm, as SAP Super User all grants for SAP incident, Personal Computer Window 8.0

SRS Sybase Replicate Server, Lumira Server V1.25, Python cdpy, HANA Admin with HDBSQL

Provide Sr. HANA DBA support for Ariba/SAP for buyers & Sellers HANA database by using HDBSQL, HANA Studio database monitoring tool for alert, performance tuning, table distribution, MVCC control, modify config ini file 'memorymanager','allocationlimit', monitoring HANA Memory, CPU usage to avoid OOM out of memory, Savepoint analysis, MVCC analysis, Analyze I/O through put,HANA Configuration parm check, Delta Merge check, fixed HANA slow issue owing to global.ini internal_hostname_resolution for Primary, secondary, standby for 10.200.200.4 hana140, 10.200.200.3 hana160,10.200.200.2 hana141,10.200.200.1 hana134, provide HANA SQL Trace, JDBC trace, Performance trace, renew HANA licenses, Kernel profiler HANA engine check, provide SAP SRS RepServer & Rep Agent configuration, Provide HANA Failover improvements AUTORestart and AUTOfailure parm set up will guarantee HANA restart covered, Review SAP HANA SRS – Site Replication Server installation for LUNA project, configure the Replication Server Work SRS - Luna 1.0 incident Update,Review SAP Lumira install & configure

PRECEDING POSITION 2:

Company and Title of Position: NY State NYSLRS/Accenture/UCINY Sr. Z/OS DB2 DBA(Oracle)

Date of Employment: Sep 2014 to April 2015

Number and Type of personnel supervised: DBA group

Brief description of Duties and Responsibilities: Provide DB2 DBA support NYSLRS for creating MEBEL RPINT, RPSST, RPERF, RPTRD, RPTRP, RPUAT DB2 databases, using Oracle DRDA Gateway for DB2 and PeopleSoft ORACLE AIX RAC ASM HCM, & CRM V9.2 ;ORACLE 11g DRDA Gateway OTG OEM 12c RMAN DATA GUARD, IBM DB2 Data studio Eclipse framework

Immediate Supervisor and Telephone number: Russ Hoyer (O) 518-***-****(C) 518-***-****

Skills Utilized:

IBM mainframe – Systems Z/OS 2.1 Operating System, DB2 V10, Personal Computer Window 7.0

DB2 Admin DBA tool; IBM DB2 Data Studio and DB2 TMON DB2 V10 tools; Z/OS 2.1. FTP, CLIST,ISPF, IBM JCL, IBM Utilities, TSO, FILEAID, ENDEVOR, DSN1copy refresh DATA

Creating views for PeopleSoft ORACLE extracting DB2 DATA thru ORACLE Gateway DRDA, installing DB2 View & Store procedure in DB2 side for PeopleSoft Oracle extracting & making OTG calls from PeopleSoft ORACLE AIX, IBM InfoSphere Change Data Capture for DB2 on z/OS

Review ORACLE DRDA data port, rdb_map; DRDA parms; BIND Oracle packages in DB2 side for DB2 & ORACLE mutual select;delete;insert;update; thru Oracle Gateway DRDA OTG Oracle Transparent Gateway for DB2

PeopleSoft software HCM;CRM ORACLE Database with RMAN/RAC, Toad, OEM cloud control 12c AIX ORACLE Data guard TMON RMAN

Provide DB2 & ORACLE DBA support for NY State MEBEL training, performance testing, Integration and Verification environments with PeopleSoft ORACLE OTG gateway DRDA. Installed RPINT, RPSST, RPERF, RPTRD, RPTRP, RPUAT DB2 V10 databases, created DB2 View & Store Procedure for MEBEL thru DB2 Admin tool, using OTG Oracle Gateway for DB2 and ORACLE for DRDA DATA retrieve, created DB2 360 degree Views for PeopleSoft ORACLE/AIX/LINUX database retrieve DB2 data, use IBM Data Studio for creating DB2 store procedure which was triggered by DB2 trigger to insert PeopleSoft ORACLE table thru ORACLE DRDA Gateway & OTG. Use IBM DBA utility DSN1copy refresh DATA between DB2 platforms.

.

PRECEDING POSITION 3:

Company and Title of Position: FDIC/CTI/L3 Sr. Z/OS DB2 DBA co-operation Lead

Date of Employment: March 2014 to July/2014

Number and Type of personnel supervised: DBA group and user group

Brief description of Duties and Responsibilities: Provide DB2 DBA support for Production (on call), Integration and Verification DB2 environments for CBIS, VISION, SOD, NFE financial and CTM thru BMC Remedy tickets.

Immediate Supervisor and Telephone number: Tito Farrales (O) 703-***-**** ( C )703-***-****

Skills Utilized:

IBM mainframe – Systems Z/OS 2.1 Operating System, DB2 V10, Personal Computer Window 7.0

DB2 BMC DASD/Catalog/Change/Backup/Recovery Manager; System and SQL Perf; Oppertune/Apptune and Log Master DB2 V10 tools; Z/OS 2.1. NDM, FTP, REXX, CLIST, IBM JCL, IBM Utilities, TSO, FILEAID, ENDEVOR

Perform ORACLE GAO uploading and by using FTP between SQL Server Database and DB2 database for DB2 database SOD, CTM.

Migrate DATA from PROD to QUAL by using BMC Recovery & NDM DATA mover

Review PeopleSoft software for FNE Financial ORACLE Database with RMAN/RAC, Toad, OEM

Provide DB2 DBA support for Production (on call), Integration and Verification environments. Worked at on projects related to database administration for CBIS, VISION, and CTM & SOD thru BMC Remedy tickets. Tasks included: Create & Maintenance Databases, Migrating DATA thru BMC Recovery from PROD to QUAL platforms, Identifying and analyzing required meeting user requirements for mission-critical databases, maintaining, administering application database security in accordance with RDBMS and organizational approved standards and procedures. Implemented backup/recovery strategies to ensure RDBMS and application databases are available within an acceptable time frame after loss of production system. Assisted in functions of DBA to provide a support of projects database on full life-cycle development.

PRECEDING POSITION 4:

Company and Title of Position: SAP America Inc. /Jason Roberts Inc./S4IT Sr. SAP DB2 DBA; Basis Administrator

Date of Employment: September 2013 to March 2014

Number and Type of personnel supervised: SAP Z/OS DB2 Database assessment & performance tuning for SAP customer’s (Walmart, VF services, AIG (American Home Assurance Group), Hallmark cards, Home depot, Exxon-mobile

Brief description of Duties and Responsibilities: Provide SAP Z/OS DB2 DBA support for database assessment & performance tuning based on KPI CPU, I/O, Memory on SAP ERP, ECC, SCM, CRM, PI and Portal, FI,SRM,BPC,CRM,BW Data warehouse NW7.5, SAP Solman Solution Manager, SAP CRM, PI and Portal, SAP Business Objects Data Quality Management (SBOP DQM),Business Intelligence/Business Objects (BI/ BO),GRC, DBACockpit. involving SAP Configuration and Customizing in full cycle, SDLC, TOGAF, SAP ASAP BWA,OLTP, OLAP for Earlier watch alert, Volume of testing, Go Live and Post watch and on acceleration monitoring & tuning request; Month & Year-end closing SAP process for any Z/VM application server on ZLinux, Database server on Z/VM Z/OS DB2 platform. By using SAP Solution Manager for performance tracing and DB monitoring, SAP ABAP STACK BASIS administration for DB2 and DB6 – DB2 UDB under AIX, UNIX, and SUSE LINUX, ZLINUX. Installed the SAP HANA database studio & Client for HANA Database Server on SUSE LINUX 11.

Immediate Supervisor and Telephone number: Cassidy, Erin

Phone Number: (O) +1-610-***-**** (Cell) +1-484-***-****

Skills Utilized:

IBM mainframe – Z/OS V2.1 Operating System,DB2 V10; Z/VM, ZLINUX, Z/OS DB2,

DB6 (DB2 UDB) Niping for Network performance analysis, SAP Solution Manager Solman, SAP ABAP Stack Basis Administration, SAP Solman Solution Manager, SAP CRM, PI and Portal, SAP Business Objects Data Quality Management (SBOP DQM),Business Intelligence/Business Objects (BI/ BO),GRC, involving SAP Configuration and Customizing in full cycle, SDLC, TOGAF, SAP ASAP

Z/OS DB2 DBA support for database assessment & performance tuning for SAP AGS standard Assessment service (FC, TIC, SMA) & AGS standard Optimization services (BPPO, VTO)

SAP support Portal Link and SAP Notes for DB2 System Zparms, CPU,I/O & Memory tuning

SAP Netweaver for SAP installation, upgrade, operations, maintenance; SAP PAM Product Availability Matrix & SAP system landscaping & Sizing

SAP HANA in memory real time Database powered by HANA database

PuTTY; FTP for SUSE 11 Linux HANA database server, HANA DB studio & Client,Cloud & Mobile

DB2 & DB6 Database assessment & performance tuning, Coe RCA root cause Analysis, ABAP performance analysis, ADM315 workload analysis,USAPTEC,HANA Database DBA, ERP/ECC, BW, ABAP stack, Oracle DB migration, SAP BASIS administration all SAP Tcodes & DBAcockpit

As SAP Sr. DB2 DBA, SAP Basis Administrator, provide TICx, Technical Integration Check for SAP customer AIG (American Home Assurance Group) on Application server @ ZLINUX, Z/VM Z/OS DB2 database server for implement the DB2 Zparms parameters. “SAP Note Number: 1476146 - DB2-z/OS: CCMS: Installation Parameter Settings for DB2 10”.

Perform DB2 database Reorg for detected advisory REORG-pending (AREOR) table spaces or indexes Z/OS DB2 DBA database assessment & performance tuning support for all Z/OS DB2 related SAP customer's (Walmart, Philip, VF services, AIG(American Home Assurance Group), Hallmark cards, John Deere, Bridgestone, Home depot, Kimberly Clark, MeadWestvaco, Whirlpool, Exxon-mobile, Dow Chemical, Pepsi cola, Coca cola, Thomson Reuters Corporation, Bernhard Glaser, Development Architect IBM System z & DB2 for z/OS).

Provide help for ExxonMobil to implement SAP Z/OS DB2 database AUFK & AFPO tables for Exxon-Mobile's SAP month-end & Year-end closing process by the expected improvement for old index versus proposed new index to keep access path to use Index columns MANDT, PROJN & by adding column DAUTY column to have about 0.18% improvement.

PRECEDING POSITION 5:

Company and Title of Position: AgileX Technology at DHS/CBP Sr.Z/OS DB2 DBA; Oracle DBA

Date of Employment: October 2012 to July/2013

Number and Type of personnel supervised: DBA team and System Engineer team

Brief description of Duties and Responsibilities: Provide DBAs support for DHS/CBP mainframe Z/OS DB2 & Datacom Database convert to ORACLE database project in DHS/CBP. Use Raincode software to convert Datacom Database to ORACLE DB; Use Oracle Workbench to convert DB2 Database in Z/OS to LINUX Tuxedo ORACLE database open system for DHS/CBP CARGO/QUOTA & BEMS/COSS CBP application.

Immediate Supervisor and Telephone number: Harless, John

Phone Number: (O) 703-***-**** (Cell) 540-***-****

Skills Utilized:

IBM mainframe – Z/OS V2.1 Operating System, DB2 V10; CICS; ORACLE Database Version 11G2 /ASM/RAC Exadata; LINUX V6 ORACLE Workbench Eclipse (IDE); FTP; Linux korn shell ;Datacom Database Version 12R; Raincode; Dataquery 12R; Oracle Tuxedo; UNITED; Oracle Goldengate and TSAM.

DB2 Utilities; SPUFI; IBM JCL, IBM Utilities, TSO, FILEAID, ENDEVOR, MS Outlook, MS Office XP; Virtual PC and Virtual Machine; Micro Focus COBOL; COBOL-IT.

PuTTY;WinSCP;Xming;UltraEdit;Hudson tool

Provided DB2 DBA; ORACLE DBA; Datacom DBA support for DHS/CBP CARGO/QUOTA and BEMS/COSS application conversion from DB2 DB & Datacom DB with CICS in Z/OS to Open system Oracle Tuexdo/Oracle ART WorkBench/Linux platform.

Use Raincode software to convert Datacom Database with CICS in Z/OS to Oracle Linux Tuexdo platform.

Use ORACLE WorkBench tool to convert DB2 mainframe Database into ORACLE Database in Linux/Oracle Tuexdo platform. Extract COSS DB2 database DDL structure in Z/OS; convert to ORACLE database; Create COSS ORACLE Database in Linux/Tuexdo;Unload COSS DB2 data from Z/OS, FTP from Mainframe Z/OS to Linux/Tuexdo and Loaded DATA with CICS RDO extracted file convert from EBCDIC -> ASCII into LINUX/Tuexdo platform.

Provide DB2 Database space usage in Mainframe to estimate ORACLE database creation in Open system side. Perform verification/testing for converting DB2 DB with CICS in Z/OS platform, use SPUFI & DB2 Utility tools, JCL, Endeavor, FTP remote file transfer from Mainframe to Open system ORACLE database LINUX.

Provided technical projects related to database administration. Tasks to include: Identifying and analyzing data required to meet user requirements for mission-critical databases. Maintaining, administering application database security in accordance with RDBMS and organizational approved standards and procedures. Implementing of backup/recovery strategies to ensure RDBMS and application databases are available within an acceptable time frame after loss of production system. Assisted with DBA functions to provide a support of projects database on full life-cycle development for DHS/CBP CARGO/QUOTA & BEMS/COSS application conversion.

Participated as a member of an Agile team, providing expertise in DB2 DBA; DATACOM DBA ORACLE DBA support.

Attended and participated in all Scrum meetings including the Daily Standup, Backlog Grooming, Sprint Planning, Sprint Retrospective and Sprint Review.

PRECEDING POSITION 6:

Company and Title of Position : Lockheed Martin /ACI/at SSA; Principal Database Management Specialist / Sr. Z/OS DB2 DBA

Date of Employment: April 2008 to October 2012

Number and Type of personnel supervised: 10 plus DDBS DBA in Testbase databases group

Brief description of Duties and Responsibilities: Provide DB2 DBA support & Install for Testbase; TADz; CICS/IA Production, Integration and Verification and Development environments at SSA. Helping DCPS SSA/Lockheed Martin as a Sr. DB2 DBA.

Immediate Supervisor and Telephone number: Anderson, Richard Alan, Lockheed Martin Task Manager (O) 443-***-**** (Cell) 410-***-****

Skills Utilized:

IBM mainframe – Systems 370/390, Z/OS 2.1 Operating System, Personal Computer

DB2 V8/V9;Z/OS 2.1;CA Platinum DB2 Utilities;QMF;DB2 OMEGAMON for Database performance tuning; IBM JCL, IBM Utilities, TSO, FILEAID, ENDEVOR, QMF, MS Outlook, MS Office XP. AllFusion ERwin.

Provided general DB2 DBA database support for TestBase Master Earnings;Medicare;Numident; Tax Levy;IRMMA; Garnishment; DB2 databases in development and Production support. Install a Lite TestBase system beside Repository thru DRDA to reduce the Coupling Facility time usage. Serve as a coordinator to migrate all SSA TestBase DB2 Databases to new SMS storgroup. Perform verification/testing when convert DB2 V8 to DB2 V9 in Z/OS 2.1 platform. ERwin V7.3 logical & physical model,Reorg/resize Production DB2 databases DB2 V8/V9,Z/OS 2.1,use CA/Platinum unicenter; Omegamon DB2 tools, JCL, Endeavor, NDM,CyberFusion remote file transfer; QMF;SPUFI.

Lead to install CICS/Interdependency Analyzer for Z/OS as a DB2DBA Helping to install IBM Tivoli Asset Discovery/TADz product for Z/OS as a DB2DBA. Both DBA functions are including create DB2 database/resizing/reorg/performance issue.

Provided technical projects related to database administration. Tasks to include: Identifying and analyzing data required to meet user requirements for mission-critical databases. Maintaining, administering application database security in accordance with RDBMS and organizational approved standards and procedures. Implementing of backup/recovery strategies to ensure RDBMS and application databases are available within an acceptable time frame after loss of production system. Assisted with DBA functions to provide a support of projects database on full life-cycle development.

PRECEDING POSITION 7:

Company and Title of Position : ACS, Inc/Gantech/Becket consulting at DHR Maryland

Project Manager / Sr. DB2 DBA

Date of Employment: August 2007 to January 2008

Number and Type of personnel supervised: technical staffs, including 2 DB2DBA, 2 Production control, 2 DB2 system programmers, CICS;MQ; Storage group team contacting; DB2 UDB DBA

Brief description of Duties and Responsibilities : Lead teams of DB2 system; DB2DBA; Production control; QA and CICS; MQ; Storage group; Application team to Provide DB2 V7/V8 conversion project for DHR Department of Human Resource at MD.

Immediate Supervisor and Telephone number: Robert Sangster, ACS Director (O) 410-***-**** (Cell) 443-***-****

Skills Utilized:

IBM mainframe – Systems 370/390, Z/OS 1.7 Operating System, AIX, Personal Computer

DB2 V8;Z/OS 1.7;CA Platinum DB2 Utilities;QMF;DB2 OMEGAMON for Database performance tuning; AIX 5.2 DB2 UDB V8.1; UDB for Windows; Microsoft Project Management plan, IBM JCL, IBM Utilities, TSO, FILEAID, ENDEVOR, QMF, MS Outlook, MS Office XP.

Provided technical project management on projects related to database administration. Set up Project plan by using Micro Software Project plan software to convert DB2 V7 to DB2 V8 in Z/OS 1.7 platform. Tasks to include: Identifying and analyzing data required to meet user requirements for mission-critical databases. Maintaining, administering application database security in accordance with RDBMS and organizational approved standards and procedures. Implementing of backup/recovery strategies to ensure RDBMS and application databases are available within an acceptable time frame after loss of production system. Assisted with DBA functions to provide a support of projects database on full life-cycle development.

PRECEDING POSITION 8:

Company and Title of Position : Maricom Inc. /Becket consulting at CMS Center of Medicare/Medicaid (Depart of Health and Human services)

Central DBA/ Sr. DB2 DBA

Date of Employment: July 2006 to July 2007

Number and Type of personnel supervised: DBA group and user group

Brief description of Duties and Responsibilities : Provide DB2 DBA support for Production (on call), Integration and Verification DB2 environments.

Immediate Supervisor and Telephone number: Sr. DB2DBA/ Maricom Manager Stan Smanski (O) 410-***-**** X214

Skills Utilized:

IBM mainframe – Systems 370/390, Z/OS 1.7 Operating System, Personal Computer

BMC DASD/Catalog/Change/Backup/Recovery Manager; System and SQL Perf; Oppertune/Apptune and Log Master DB2 V8 tools, AllFusion Erwin 4.1.4.; Z/OS 1.7. DB2 OMEGAMON, QREP Data Migration between DB2 and Oracle, IBM JCL, COBOL, IBM Utilities, TSO, FILEAID, ENDEVOR, QMF, EZTRIEVE, MS Outlook, MS Office XP

Provide DB2 DBA support for Production (on call), Integration and Verification environments. Worked at CMS Center of Medicare/Medicaid (Department of Health and Human Services) on projects related to database administration. Tasks included: Identifying and analyzing data required to meet user requirements for mission-critical databases, maintaining, administering application database security in accordance with RDBMS and organizational approved standards and procedures. Implemented backup/recovery strategies to ensure RDBMS and application databases are available within an acceptable time frame after loss of production system. Assisted in functions of DBA to provide a support of projects database on full life-cycle development.

PRECEDING POSITION 9:

Company and Title of Position : GEICO / Senior DB2 DBA

Date of Employment: February 2000 to May 2006

Number and Type of personnel supervised: Perform DBA function

Brief description of Duties and Responsibilities : Provide DB2/DBA support for Production and Test environments. Worked at GEICO as a Senior DB2 DBA assigned project in COOLGEN Billing, PMSC OASIS, APC, Marketing and Billing Interface.

Immediate Supervisor and Telephone number: GEICO DBA manager Teddy Blandy 301-***-****

Skills Utilized:

IBM mainframe – Systems 370/390, Z/OS 1.6 Operating System, Personal Computer

DB2 utility, Platinum DB2 tools: RC/Query, RC/Update, RC/Migrator, Plan Analyzer, Database Analyzer and DETECTOR,Z/OS 1.6, DB2 V8.1 Data Sharing,TMON,CDB Online Reorg,CICS/TS 1.4, DB2 performance tuning, IBM JCL, COBOL, IBM Utilities, TSO, FILEAID, ENDEVOR, VSAM, QMF, EZTRIEVE, MicroS, Office NT, sysplex DB2 Data Sharing

Provided DB2/DBA support for Production and Test environments. Worked on projects related to database administration. Tasks included: Identifying and analyzing data required to meet user requirements for mission-critical databases. Maintaining, administering application database security in accordance with RDBMS and organizational approved standards and procedures. Implementing of backup/recovery strategies to ensure RDBMS and application databases are available within an acceptable time frame after loss of production system. Assisted in functions of DBA to provide a support of projects database on full life-cycle development.

PRECEDING POSITION 10:

Company and Title of Position : FDIC; COMSO, INC/Pinkerton consulting, Inc. /FDIC DB2 DBA

Date of Employment: May 1998 to November 1999

Number and Type of personnel supervised: Perform DBA function

Brief description of Duties and Responsibilities : Participated FDIC (Federal Deposit Insurance Corporation) as a DB2 DBA; worked on projects in DOF Data warehouse, NCS, AMS/CTM, CIS, REOMS, CBIS, and WALKER.

Immediate Supervisor and Telephone number: Manager David C. Rothfuss 703-***-****; Joseph Philips 703-***-****

Skills Utilized:

IBM mainframe – Systems 370/390, MVS Operating System, Personal Compute

DB2 utility, DB2 BMC Catalog Manager, Change Manager, DASD Manager, Activity Monitor, Apptune, Opertune for DB2, Recovery Manager, XBM, LOGMAX, MVS/ESA OS390, DB2 V5.1, CICS, ERWIN ERX3.5, IBM JCL, COBOL, IBM Utilities, TSO, FILEAID, ENDEVOR,, VSAM, QMF, MS Outlook, MS Office XP.

Provided DB2 performance tuning in all DB2 production, quality, and development platforms. Provided DB2 DBA production on call support. Worked on projects related to database administration. Tasks included: Identifying and analyzing data required to meet user requirements for mission-critical databases. Maintaining, administering application database security in accordance with RDBMS and organizational approved standards and procedures. Implementing of backup/recovery strategies to ensure RDBMS and application databases are available within an acceptable time frame after loss of production system. Assisted in functions of DBA to provide a support of projects database on full life-cycle development.

PRECEDING POSITION 11:

Company and Title of Position : Bell Atlantic/Verizon DB2 DBA

Date of employment: January 1997 to May 1998

Number and Type of personnel supervised: Perform DBA function

Brief description of Duties and Responsibilities : Participated Bell Atlantic Strategic Billing System Express TRAK as a DBA (1450 tables). As DB2 DBA, took turns on call for Production, PLT, IT, System Test, and Development problems.

Immediate Supervisor and Telephone number: Manager David Beulke 703-***-****

Skills Utilized:

IBM mainframe – Systems 370/390, MVS Operating System, Personal Computer

DB2 V4.1,DB2PM, DB2 OMEGAMON Monitor, Window NT, DB2 BMC Utility, DB2 utility, DB2 BMC Catalog Manager, Change Manager, IBM JCL, COBOL, IBM Utilities, TSO, FILEAID, ENDEVOR,, VSAM, QMF, MS Outlook, MS Office XP.

Set up Partitioning strategy for very large tables. Conducted System Test and Integrating Testing. Worked on projects related to database administration. Tasks included: Identifying and analyzing data required to meet user requirements for mission-critical databases. Maintained and administered application database security in accordance with RDBMS and organizational approved standards and procedures. Implementing of backup/recovery strategies to ensure RDBMS and application databases are available within an acceptable time frame after loss of production system. Assisted in functions of DBA to provide a support of projects database on full life-cycle development.

PRECEDING POSITION 12:

Company and Title of Position : Navy Federal Credit Union DB2 DBA

Date of employment: July 1996 to Dec 1996

Number and Type of personnel supervised: Perform DBA function

Brief description of Duties and Responsibilities : Participated Navy Federal Credit Union IBM ImagePlus DB2 Database,R/DARS, FAF(Folder Access Facility) image object deletion when OAM

(Object Access Method) image objects expired. In-house JVS(Journal Voucher System) physical Database modeling implementation. Using DB2V3.1,CICS/ESA 3.3, MVS/ESA 5.2.2, JCL, DB2PM, DB2 OMEGAMON Monitor, DB2 BMC Utility, OS/2, Window 3.1, NOVELL LAN, DB2 File-Aid.

Immediate Supervisor and Telephone number: Manager Carpenter, Mike 703-***-****

PRECEDING POSITION 13:

Company and Title of Position : EDS SAMS HUD project DB2 DBA

Date of employment: Jan 1995 to July 1996

Number and Type of personnel supervised: Perform DBA function

Brief description of Duties and Responsibilities : Participated EDS SAMS HUD project, implemented and maintained DB2 physical database with 250 tables and 5 Vary Large database Tables using DB2 utilities, GDG tapes, BMC DB2 tools, Microsoft WORD, EXCEL to calculate DB2 Tablespaces & Indexes, MS Mail thru LAN and IRMA, Norman, CICS,Reorganized the DB2 Tablespaces & Indexes to help DB2 achieve a better performance. Served as EDS HUD SAMS DB2 DBA on call.

Immediate



Contact this candidate