SUMMARY

• Specialist DBA in DB2 zOS V8, V9, V10, V11CM Systems, DB2 Connect Products, DB2 Utilities, UNLOAD, LOAD, CHECKDATA, REORG, RUNSTATS, RTS, BUILD COPY, RESTORE, RECOVERY and DSN1COPY etc.
• Data Architect using Erwin Data modelling tool, enforcing RI rules, Design, Planning & Implementations of Large Databases, Partitioning, Stored Procedures, MQTs, Triggers, Drive Data Archival/Purge, Retention and Security measures like Encryption etc.
• Specialist DB2 Performance Engineer on SQL, Application tuning, Stored Procedures, Batch Jobs, MQTs, Triggers, Identity Columns, Locking Strategies, Optimizing CPU Utilization impacting R4HR (Rolling 4hour Averages) MSU, IBM License costs (ULC) etc.
• Proficient in DB2 Software Upgrades, Apply RSU Maintenances, PTFs and Migrations to V10(CM,NFM), V11 CM, Data sharing, Install DB2 LUW CONNECT Servers/Gateways latest V10.5 and Data Server, Runtime Clients and Vendor Software (BMC, CA and Compuware).
• Proficient in Performing Disaster Recovery (DR) Exercises and Recover in Real Disaster scenario’s from DR Mainframe using Storage Flash and Implementation of Active - Active Replication using IBM Infosphere Queue Replication (QREP) Center.
• Specialist in DB2 System Tuning Active/Archive logs, ZParms, DBATs, Buffer pools, work file(DB07), Sort work, SMF Data extracts/Rexx, DB2PM, RMF Reports etc.
• Specialist on usage of IBM, BMC, CA, Compuware Tools like Catalog/Change Manager, Apptune, RC Query/Migrator, Data Studio Visual Explains, STMT CACHE, Strobe/iStrobe, File-Aid, Omegamon, SQL Performance Analyzer
• Specialist configuring and troubleshooting DB2 zOS/LUW/Aix connectivity for ODBC, Java/JDBC clients and applications.
• Proficient on DB2 LUW/Aix Data Refreshes, Operations on Aix & Windows with Crontab and Shell scripts.
• Experience in DB2 Adapter for z/OS Connect RESTful service web, mobile and cloud & z/OSMF workflows.
• Attended trainings & working knowledge in BigData/MongoDB/JSON, AWS Cloud/Web Services and MS SQL Server.
• Proficient with over 5 years of experience in Mainframe Application development (COBOL, JCL, DB2, Stored procedures, VSAM, IMS, Rexx, Unix Shell Scripts, Endeavor, CA7 scheduler etc.) and Data Warehousing applications with Teradata ETL utilities, BTEQ, Fast Load, Fast Export, MultiLoad, and Tpump.
• Over 14 years of experience in 24x7 Production Support & Operations, Working in Large Teams spread across onsite & offshore models, Project Management, which includes work planning, allocation, delegation, tracking and execution of projects, and conducting Technical trainings and Completing appraisals.

TECHNICAL SKILLS

Hardware: IBM Mainframe, Unix, AIX, Teradata, Windows

Operating Systems: z/OS, z-Linux, Unix, Aix,MVS, OS390, Windows 7, Windows 10

Databases: DB2 zOS V11 thru V6, UDB/LUW v10.5, v10.1,v9.7,v9.1,v8.1 on VSAM, IMS, MS Access, MS SQL Server2005/ Teradata V2R5

Languages/Scripts: COBOL, JCL, Stored Procedures, SQL, Native SQL SPs, Unix Shell Scripts, REXX, CLIST, Teradata BTEQ Scripts, CICS, Telon.

Tools: /Utilities: Database Administration: IBM Admin Tools, IBM Data Studio, Putty, F-secure, IBM Optim Performance Manager, DB2 Query Monitor, SQL Performance Analyzer, QMF, SPUFI, DB2PM Analyzer, BMC Apptune, BMC Change Manager and other BMC Tools, CA RC Query,RC Migrator, CA Detector and other Platinum and CA Tools, Compuware Strobe/iStrobe.

Data Modeling Erwin: Other Tools - Endeavor, Change man, Expeditor, Intertest, DFSORT, FILEAID, ICETOOL, CA7 Scheduler, Crontab, ACRBAL DATECARDs, Remedy PAC2000.MQ,FTP,CMT,BCF Teradata BTEQ, Fast Load, MultiLoad, TPUMP, Fast Export and Queryman.

Mail Clients: Lotus Notes, MS Outlook

PROFESSIONAL EXPERIENCE

Confidential, Auburn Hills MI

DB2 z/OS DBA & Data Architect

Responsibilities:

• Data Architect-
• Data Models using Erwin, Design & Implementation of Physical Database & DB2 Connectivity Configurations using ODBC,CLI, WebSphere Java/JDBC-4 drivers, Access and Security. involved in latest Cloud migration projects with AWS and BigData/MongoDB.
• Performance Engineer - Reviewing monthly mainframe performance charts, Analyzing TOP 20 Batch Jobs, Processes in terms of CPU usage, Elapsed time and MSU impact on 4Hour rolling Averages.
• Projects & Operations DBA-
• Regular Database object creations/DDL for Non-D, Development Projects
• Regular Database Maintenance tasks, Utilities (Backup, Recovery, Reorgs Data Refresh, Archival and Data Purge)
• Performance Tuning of DB2 SQL/applications with Stored Procedures, both Static/Dynamic/Online/Batch Build Indexes, Stats, Visual Explains, STMT CACHE, Resolving Contentions with efficient locking strategies,
• Database Catalogs and Configurations JDBC/ODBC for Clients, App Servers, MQHUB work stations and troubleshoot DB2 Connectivity.
• Presented a POC on Data Encryption for masking Social Security and Credit card info.
• Data Refresh on DB2 Aix 1TB data warehousing databases, Crontab scheduling
• Systems DBA -
• DB2 z/OS Software Upgrade to V10 CM, V10 NFM, V11 CM, including SMP/E work, CLISTs and Tailor/Customize the IBM provided DSN* Jobs and implementation
• Receive and Apply RSU Maintenance and PTF’s.
• Working with IBM, Compuware on PMRs, SRs in critical problem investigations.
• DB2 System Tuning, ZPARMS, Active/Archive Logs, Buffer Pools, DDF, DBATs, work file DB, Sort work etc.
• DR - Disaster Recovery Exercises.
• Support the Maintenance of Tools like TMON, BMC DB2 tools, QMF, iStrobe & File Aid.
• Migration to CA Tools RC Query, Migrator replacing BMC Catalog and Change Manager.
• Presented POC to prepare for Data Sharing Environment & Active-Active Replication, & Encryption, Data Archival using Temporal Tables.
• Install, Upgrade, Maintenance of DB2 Connect Gateway Servers V10.5/9.7 in Linux, Windows, and Fix packs for Distributed Clients.
• DB2 Runtime/Data server Clients on Aix/zLinux Application Servers, MQHUBs.

Confidential, Sacramento

DB2 z/OS Database Administrator

Responsibilities:

• DB2 z/OS Software Upgrade to V10 CM, CLISTs, Tailor/Customize the IBM provided DSN* Jobs.
• Create PMRs & work with IBM consultants on problem resolution.
• Install DB2 Connect, Runtime client software and troubleshoot connectivity problems.
• Participated in Configuring Data Sharing environment
• Data modeling, Data Structures, Index Designs, DDL creation for MMEF and MEDS Databases
• Create Physical Databases with Capacity Planning.
• Performance Tuning of Online and Batch DB2 Applications.
• Use of DB2 Utilities (LOAD, REORG, RUNSTATS, COPY, RECOVER and Explain) and CA and IBM Admin, Omegamon, JCL Tools.
• Conversion of CA Platinum Unload with IBM High Performance Unloads.
• Data migration from SQL Server with SSIS packages to DB2.

Confidential, Dallas

DB2 z/OS Database Administrator, Q-Replication Specialist.

Responsibilities:

• Working closely with Architects, Business Analysts to Design/Create DB2 Tables for new application.
• Application Tuning includes Review of Access paths, Index Redesigns and Large Table partitioning.
• Use of Omegamon, DB2 Query Monitor and SQL Performance Analyzer
• Database Maintenance, Monitor and Run the DB2 Utilities, LOAD, REORG, RUNSTATS, COPY, RECOVER and Explain as needed.
• Resolution of contention issues on online CICS transactions analyzing the Locking strategies, Lock size (Row, Page, Any), Lock type(Share, Update, Exclusive),Lock duration (Isolation level, UR, CS, RS, RR) and Bind Options Acquire(Allocate/Use), Release(Deallocate/Commit),
• Performance tuning of Long Running Batch process using DB2PM, RMF Reports analyzing the SMF data, Synchronous/Asynchronous I/Os, Prefetch’s, Buffer Pool hit ratios and Coupling Facilities. Replication DBA:
• Q-Replication using DB2 Connect Info Sphere Replication center and Dashboard.
• Creation/Maintenance new and existing Subscriptions.
• Monitoring the Dashboard to check the status of Subs, Queue Depth and Latency issues
• Monitor the Logs on Apply and Capture Tasks, Queues for any message overflows to dlqs and MQ Errors.
• Running ASNTDIFF utility and making sure tables are in sync between Primary and HA sites.
• Scheduling Batch Jobs and 24X7 Production Support for DB2 Jobs.

Confidential, Minneapolis

Data Architect, DB2 Database Admin

Responsibilities:

• Physical DB designs and DDL creation.
• Planning of outage and Implements Database Change Requests (DBCRs) and data repairs.
• Partitioning and Index redesigns on Large Tables.
• Q-Replication using DB2 IREP(Infosphere Replication) and Dashboard.
• DB2 Performance Tuning/Applications COBOL & Native Stored Procedures.
• Run Explain/Access path comparison and Index design, Use of BMC Apptune to optimize the resource utilization (CPU)
• DB2 Utilities, Unload, Load, Copy and Recovery of table spaces.
• Development and maintenance of Native SQL Stored procedures
• Participated in DB2 Migration Process to V10, Tailor Install Jobs and Configuring Data Sharing environment

Confidential

Mainframe Project Lead, DB2 Application DBA.

Responsibilities:

• Working closely with Architects, BAs and Functional Clients and Building the Functional and Technical Design documents
• Build the Scripts in COBOL, Stored Procedures, SQL, JCL, BTEQ Scripts.
• Building DB2 Database Objects in all Development DB2 subsystems.
• Data maintenance using UNLOAD, LOAD, Backup, Recovery, REORG, RUNSTATS and Data Purge.
• Performance tuning of SQL & Application code using Explains, Access path Comparison, BMC Apptune to meet SLA’s.
• Schedule and Run the Backups, Recovery and Reorgs as needed.
• Writing ETL BTEQ scripts using TERADATA Tools, BTEQ, FASTLOAD/EXPORT and MULTILOAD.
• Scheduling Batch Jobs and 24X7 Production Support of Mainframe Applications in COBOL/DB2/IMS and JCL.
• Training and mentoring the team on Application Development, Running Explains, Bind parameters and Tuning.
• Skill Set: DB2 v8 z/OS, COBOL, IMS, BMC Catalog Manager, Change Manager, BMC Apptune, CA Detector, RC Query,RC Migrator & Platinum tools, COBOL, JCL, VSAM, IMS, TERADATA ETL Utilities and SQL Assistant, PANVALET, ENDEVOR, and CA7.

Confidential

Systems Analyst

Responsibilities:

• 24x7 Production Support
• System Study and Identifying Improvement areas for the applications.
• Interact with BA’s in Analysis and Preparation & Review of Technical design documents
• Build/Upgrade scripts as needed for COBOL/IMS Programs, DB2 Load/Unload Utilities, JCL and Stored Procedures.
• Preparation of Test Plans and Unit and System testing.
• Drive the knowledge management activities in the team both onsite and offshore.