PROFESSIONAL SUMMARY:

• Over 9 years 10 months of experience in Software engineering with the Knowledge in Database administration for DB2 on z/OS and DB2 system installation, SMPE process and maintenance.
• Experienced in identifying the root cause for performance bottlenecks and providing the solution in the effective way.
• Expertisein Job/Online threadmonitoring,DB2 SQL tuning, DB2 object modeling and maintenance, performance monitoring, manipulating the statistics, running DB2 utilities and collecting the performance reports.
• Around 7 years 6 months of experience as DB2 Database Administration on V8/V9/V10 and performance tuning in IBM S390 z/OS mainframes which has coupling facility and data sharing environment.
• Mainframe Technical lead responsible for formulating the requirements into design specifications, preparing system specifications, assigning tasks to team members, and tracking the progress. Extensive knowledge in onsite offshore model of working & Strong skills in support activities, analysis, technical design, testing, trouble shooting for both batch & online application programs in mainframe applications
• A good team worker with ability to handle projects independently.
• Capable of collaborating with Application Architects, Product Managers, Business Analysts and the Technical Management team to design, develop and document the databases, schema and all other aspects of the database.
• Specialized to handle severity 1 (mission critical, business loss situation) and escalated Issues.
• Installed DB2 V10 on IBM z10 EC.
• Maintaining the DB2 database environments and troubleshooting performance problems.
• Maintaining and providing operations and user support for system products like z/OS, DB2, CICS, and IMS.
• Expertise in application development support activities including database design, optimizing SQL queries, building complex SQLs, dynamic SQLs and triggers, effective binding of packages and plans, concurrency planning, data refreshing and database objects migration across regions.
• Designed, tested and debugged external and DB2 native stored procedures. Worked with remote stored procedure calls.
• Extensive experience in utilities and tools used for database monitoring (DB2 traces, online performance monitors, reports, EXPLAIN, DB2 catalog queries), data movement and organization (LOAD, UNLOAD, REORG), data consistency utilities and catalog manipulation utilities (RUNSTATS, MODIFY, STOSPACE), etc.
• Extensive experience In using DB2 Tools(DB2 OM, DB2 ADMIN, BMC Opertune, Main view, Apptune,DB2 PE) for DB2 support activities, DB2 platinum and RC Query for SQL Tuning activities, BMC products to analyze performance.
• Proficient in daily support activities which include maintaining and testing backups, monitoring logs, monitoring thread activity, resolving job abend issues, locking issues and contentions, scheduling administration activities.
• Knowledge and experience in data modelling, normalization and performance tuning of applications and database design.
• Worked with universal table spaces and hands on experience in exploiting the new features of version 9 and version 10 to improve overall system performance
• Database Administration and Programming experience in maintenance, production support, development and migration projects.
• Highly engaged in implementing new concepts from new DB2 releases to improve performance and Concurrency on DB2.
• Involved in setting up of process for weekly DB2 housing Keeping activities, Clean - up of SYSCOPY and IC datasets on Production regions.
• Had hands on experience on tuning DB2 SQl’s performance for production DB2 batch jobs which encapsulated in COBOL program.
• ITIL Process lead/IS Change coordinator for the Mainframe tower & other applications, Review/Coordinate & Approve the change’s for all activities. Perform Impact analysis of the new requirement or change request on the new/existing modules initiated by the client. Handling Service now, Incident management& BMC Remedy Change request tickets.
• Resourcing Lead responsible for Resource requirement for the project, Co-ordinate with RMG for resource requirement & BGC verification. Co-ordinate with Project lead for Resource allocation etc.
• Commitment to quality from requirements gathering through design, construction, testing, and installation.
• Highly motivated and capable of working both independently and as a member of the team.
• Proficient in Banking, Financial and Utilities environment.

TECHNICAL SKILLS:

Languages: COBOL, REXX, JCL, DB2SQL

Operating Systems: z/OS v1r7 to z/OS v1r11

Databases: Mainframe DB2 UDB V7/V8/V9/V10 for z/OS.

Database Tools: Db2Omega Mon, IBM Utilities, DB2 Connect, Spufi, QMF, File-Aid forDb2,BMC Mainview for DB2, BMC Apptune for DB2,CA/DB Management solutions for DB2 (RC/Query, RC/Secure, SQLEase,Plan Analyzer, Platinum tool for performance tuning), File Marvel, File Manager for DB2/IMS, DB2 Admin Tool, Table Editor, High performance unload, DB2 Change man,JHS,XACT,RACF, TSO, ISPF/PDF, SDSF, SCLM, SMPE, BMC, DB2 Utilities, Optim tools, Control-M, Content Manager On Demand product, ISPW & IBM CDC etc.

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

Senior Mainframe Database Administrator

Responsibilities:

• 24 x 7 Production DB2 database support.
• Participated in design review meetings, involved in logical design and in converting logical model into a physical database model.
• Analyzed index requirements and designed appropriate indexes.
• Responsible for Performance monitoring and tuning, backup and recovery, customer consultation, DBMS infrastructure creation and support, problem determination/resolution.
• Providing L3 Support to DB2 Related issues.
• Fine tuning the SQL’s in the program and providing necessary recommendations to the application users.
• DB2 thread monitoring and recommend the Application users with the solution to tune the troublesome queries if necessary. Root cause analysis and recommended performance improvement methods for the long running DB2 application batch jobs/online transactions
• Performing Health check of objects on regular basis.
• Perform Impact analysis for the packages. Troubleshoot & fix the -805 BIND errors.
• Handle multiple SQL error codes -805,-818,-904,-905,-911,-913,-204,-206,-922 etc..& provide the fix.
• Perform DATA REFRESHES from production to test environments, Database migration between the subsystems.
• CHANGE Management using BMC Remedy.
• Working with different DB2 utilities and maintaining databases.
• Troubleshooting the DB2 related issues and providing the Fix
• New Instance creation for DB2 z/OS.
• Perform backups (both online and offline), Reorgs, Runstats and Space monitoring.
• Excellent Interaction with Clients, Functional and business analysts, department Managers, different levels of users and developers and experience with Software Development Life Cycle.
• Work closely with Developers to create database objects (table spaces, schemas, tables, views, indexes, triggers, stored procedures etc.) as per the requirement.
• Creating EXPLAIN tables and testing queries using Platinum tool on SQL statements
• Develop scripts for regular maintenance activities like BACKUP, RUNSTATS and REORGS
• Involved in granting various authorizations and privileges to different users
• Proactively monitored and performed daily maintenance activities

Environment: DB2 10.1,DB2 Admin tool,QMF,File aid for DB2, Change man, Omegamon, File manager for DB2, Control-M, SPUFI, ISPF, SDSF,QMF,CQM DB2 QUERY MONITOR,DB2 performance Expert, Table editor,$AVRS JOB SELECTION & High Performance unload.

Confidential, Rosemead, CA

Senior mainframe Database/ System Administrator

Responsibilities:

• DB2 RSU/SMPE Hiper maintenance of 10 DB2 Data Sharing Groups and Deployment.Track HIPERs, PTF, APAR’s etc& do SMPE Apply Maintenance.
• DB2 and its program products upgrade and maintenance support. DB2program products we support are DB2 Administration tool, DB2 Performance Unload, Table Editor,DB2 High performance unload, Debug Tool, QMF, BMC Apptune and Opertune.
• DB2 Disaster Recovery Verification and Testing
• Plan, implement, and migrate z/OS workload to new data center (EC12) with geographic failover functionality for disaster recovery.
• Received appreciation from SME’s for outstanding performance during the transition.
• Working with Application team to gather the requirements to design and creation of database objects.
• Processing the SMT, service now, incident management tickets with in the given SLA to handle Database object creation(Database, Table space, Table, SP’s and UDF’s), Data movement, to provide security authorization across the objects, to run DB2 utilities (REORG/LOAD/UNLOAD/REPAIR/RECOVER/REBUILD/COPY/MODIFY/RUNSTATS).
• Analyzing the performance reports from DB2 PE Tables on regular/weekly basis to identify the long running/High resource Consuming batch jobs/ Threads/SP’s.
• Working with the application team on performance degradation by redesign the query, redesigning the db2 objects, redesigning the program code, re-evaluating the approach on running the utilities for data organization and stats collection, changing the access path, changing the object types.
• Monitoring DB2 OM tool to assess the resource spikes on the current circumstances.
• Handling DB2 SQL codes (-805,-904,-204,-911,-913 and many) to provide uninterrupted support for online threads/Batch with in the Given SLA.
• Monitoring the MSTR, DIST, DB2 WLM address space for Lock escalation, abends and for other issues
• Running EXPLAIN and Analyzing the access path and their SQL cost for both STATIC/DYNAMIC queries, analyzing buffer pool usage, analyzing catalog stats, analyzing Object design, and providing suggestion to improve the performance as the part of Daily activities.
• Handling DB2 Bind / REBIND Actives.
• Cleaning up of obsolete DB2 Objects on regular basis due to application Decommissioning.
• Running Housekeeping activities on weekly basis on DB2 objects.
• Setting up of IBM Traces to monitor the threads/Jobs .
• Running regular clean up on Image copy datasets in PRODUCTION environment
• Engaging in the implementation of new advantages from new DB2 releases.
• Performing the Regular Data refresh activities from PRODUCTION to NON-PROD for both DB2 and NON-DB2 objects
• Executing SP’s through Batch/Data studio as the part of regular ticket request.
• Identified and solved systems related issues, contention issues, Table/ Table space issues
• To handle the large DB2 UNLOAD/LOAD request, To identify the objects that need data to be reorganized, to send the batch status across the clients, to handle PRODUCTION DB2 object sync up.
• Provided 24*7 batch monitoring support and their escalation on daily basis.
• Provided suggestion on TWS schedule change to enhance the performance of the jobs.
• Handling File copy request / GDG creation across the LPARS on daily basis.
• Monitoring NON-DB2 file activities and their I/O to improve the performance.
• Communicate regularly with Project teams, appropriate stakeholders to understand constraints and ensure risks are managed.
• Acting as Change Coordinator and Approver for all Mainframe Changes.
• Improving the performance of the System by suggesting the performance measures for DB2 Runaway queries.
• Business data processing and handling day-to-day user queries.
• Remotely administer the production database 24/7 through VPN connection. This includes monitoring the database growth, checking for the performance bottlenecks, taking backups for disaster recovery and tuning SQL queries for better performance.

Environment: v9.1 and 10.1, IBM DB2 Admin tool, High performance unload, Optim,Table Editor, File Manager for DB2, QMF, JHS, SMPE, TWS, CM On Demand, CDC & Green Light.

Confidential

Sr. DB2 Database Administrator

Responsibilities:

• 24 x 7 Production DB2 database support on rotational basis.
• Participated in design review meetings, involved in logical design and in converting logical model into a physical database model.
• Analyzed index requirements and designed appropriate indexes.
• Responsible for Performance monitoring and tuning, backup and recovery, customer consultation, DBMS infrastructure creation and support, problem determination/resolution.
• Providing L2 Support to DB2/IMS Related issues.
• Fine tuning the SQL’s in the program and providing necessary recommendations to the application users.
• DB2 thread monitoring and recommend the Application users with the solution to tune the troublesome queries if necessary. Root cause analysis and recommended performance improvement methods for the long running DB2 application batch jobs/online transactions
• Monitoring all DB2/IMS related jobs and providing resolution for the abended jobs.
• Monitor DB2 tables and index space and system catalogs for space issues and also application-owned objects and take corrective action
• Analysis of Deadlock and Timeouts on weekly basis.
• Providing support on IMS database unavailable issues, IMS jobs abend.
• Analysis of Top CPU consuming packages on weekly basis in Test environments.
• Performing Health check of objects on regular basis.
• Incident/CHANGE Management using BMC Remedy & Service now.
• DB2 sub system level /application level Performance monitoring and tuning and provided recommendations using Mainview and Apptune tools
• Working with different DB2 utilities and maintaining databases.
• Troubleshooting the DB2 & IMS related issues and providing the Fix
• New Instance creation for DB2 z/OS.
• Perform backups (both online and offline), Reorgs, Runstats and Space monitoring.
• Excellent Interaction with Clients, Functional and business analysts, department Managers, different levels of users and developers and experience with Software Development Life Cycle.
• Work closely with Developers to create database objects (table spaces, schemas, tables, views, indexes, triggers, stored procedures etc) as per the requirement.
• Creating EXPLAIN tables and testing queries using Platinum tool on SQL statements
• Develop scripts for regular maintenance activities like BACKUP, RUNSTATS and REORGS
• Involved in granting various authorizations and privileges to different users
• Proactively monitored and performed daily maintenance activities
• Produced and analyzed DB2 performance reports.

Environment: DB2 9.1 and 10.1, BMC Mainview for DB2, BMC Apptune for DB2, CA/DB Management solutions for DB2 (RC/Query, RC/Secure, SQLEase,PlanAnalyzer), File Marvel, File AID for DB2, File Manager for DB2/IMS, DB2 Admin Tool, TSO, ISPF/PDF, SDSF, SCLM, CONTROL-M, XACT, Remedy & Service-now.

Confidential

DB2DBA

Responsibilities:

• Worked with various TCS clients as DB2DBA and supported as a DB2 System and application administrator for TCS in-house mainframe environment hosted in IBM System 390, Z900, Z990 and Z10 EC.
• Receiving, inspecting, installing and testing system software items like DB2,IMS and tools to support and monitor DB2 & IMS
• Maintaining and providing operations and user support for system products like z/OS, DB2, CICS, IMS
• Providing assistance to projects in system software related areas in debugging, performance, security, and application capacity planning aspects
• Developing tools for enhancing end-user productivity and for special project and system requirements
• Providing Support to Clients in application testing & Performance tuning before moves to production
• Providing expertise to TCS clients in all these areas.
• Supervision on DB2/IMS upgrade and install release and PTF’s from IBM.
• Involved in Db2 version migration from V8 to V9. Explored in SMP/E installation on TCS in-house mainframe.
• Involved in IPL activity as part of operations support.
• Had basic knowledge on other products like TCPIP, SMP/E, SMF, RACF, ACF, SMF, MQ, CICS
• Implemented security control processes for controlling /maintaining user access to the DB2 objects (databases, tables, views, plans and packages).
• Implemented DB2 Data sharing using parallel sysplex environment.
• DBD and PSB Creation in IMS.
• Database Migration & verification.
• Security Management using RACF - Profiles Creation, Access permissions & restrictions
• RACF Security Management for Projects

Environment: z/OS, COBOL, DB2 v 8.1 and 9.1, IMS v10,JCL, REXX, CLIST, COBOL, RACF, IBM DB2 Performance Monitor, QMF, DB2 Administration Tool, File Manager for DB2 & IMS, RACF.