PROFESSIONAL SUMMARY:

• Confidential 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.
• 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

PROFESSIONAL EXPERIENCE:

Confidential

Sr . Z/OS DB2 DBA

Responsibilities:

• Provide DB2 DBA support for Production (on call), Integration, Development and Verification total 14 DB2 environments for Confidential Utility Billing & financial thru service tickets.
• 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.

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.

Sr . HANA cloud DBA

DBA group

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

Responsibilities:

• 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

Confidential

Sr . Z/OS DB2 DBA(Oracle)

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

Responsibilities:

• Provide DB2 & ORACLE DBA support for NY State MEBEL, 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.

Confidential

Sr . Z/OS DB2 DBA co-operation Lead

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

Responsibilities:

• 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.
• 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.

Confidential

Sr. SAP DB2 DBA; Basis Administrator

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. As SAP Sr. DB2 DBA, SAP Basis Administrator, provide TICx, Technical Integration Check for SAP customer Confidential (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
• 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.

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

Confidential

Sr.Z/OS DB2 DBA; Oracle DBA

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.
• 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.

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