Professional Summary:

• IBM Certified DBA with more than 7 years of DB2 Database Administration and around 10 years of overall IT experience
• Expertise as DBA on Linux/AIX/Solaris/Win and ZOS/OS390 platforms
• Expertise in complex and critical OLTP/DWH Databases with terabytes of data security, architecture, infrastructure and Integration
• Expertise in analysis, design/Model, develop/deploy databases,
• Expertise in Database monitoring, optimize/Performance tuning, maintenance, identifying / troubleshooting / provide solutions for production / development related issues / problems
• Experience in Database Capacity planning, HighAvailability and Disaster recovery
• Expertise in IBM, CA, BMC, QUEST DBA utilities and tools suites
• Experience in wide variety of projects including Financial, telecom and Retail
• Team Player with ability to work independently and as part of team and having excellent communication, problem solving, mentoring, working effectively under stress, debugging, logical and analytical abilities

Technical Skills:

• Operating System : Red Hat Linux, IBM AIX, Sun-Solaris, Windows 2K, NT, XP,
• ZOS /OS-390, AS400
• DBMS : DB2 UDB LUW/ZOS/OS390, SQL SERVER, INFORMIX,
• IMS, Netezza.
• DBA Tools
• Utilities : IBM DataStudio, Quest Central - Foglight / Spotlight,
• DB2TOP, IBM table functions for monitoring, CA-Unicenter for
• DB2, BMC DB2 DBA Tools and Utilities, Autosys scheduler
• Princeton Softech's relational tools,TMON, IBM/Candle-
• OMEGAMON, STROBE, ISTROBE, VISUAL EXPLAIN,
• TSM, Compuware DB2-FileAid, IBM RMF, IBM OSC, IBM
• Performance expert, ITDS,
• Languages : JAVA, PERL, COBOL
• Mainframe : CICS, JCL, VSAM, ABENDAID, FILEAID, XPEDITER,
• INFOPAC, REXX, JHS
• JAVA Web : J2EE, Websphere Portal, JDBC, VB, ASP, HTML, XML, XSL,
• JavaScript, MS Visual Interdev
• Middle ware : MQ-SERIES
• Version Control : Changeman, Panvalet, Endeavor, PVCS, Visual Source Safe
• Project Management : Planning, Tracking and Time Estimates, Staffing and
• Supervision, Requirements, Functional, Design and Technical
• Specifications, SDLC, Communication and Leadership Skills
• Others : IBM Filenet, IBM Content Manager for Multiplatforms,
• Websphere portal, IBM Tivoli directory services / LDAP, PERL,
• Korn Shell, ERWIN, Visio,Lotus Notes, Excel, Word,
• PowerPoint DB2 DBA on LUW Z/OS Environment

Responsibilities:

• Model, develop/deploy databases and related objects
• Perform pro-active resource and performance monitoring/tuning of databases and servers
• Identify and troubleshoot problems/issues and pursue/suggest/implement alternate solutions.
• Assist development staff in SQL Query optimization/tuning and learning effective SQL programming techniques
• Communicates with customers, maintains positive relationships and assist /handles customer inquiries and resolve issues quickly
• Participate in organization's High Availability, Disaster Recovery Planning Testing HADR

Environment: DB2UDB/DPF 9 on AIX 6 / Solaris 11 / Red Hat Linux Enterprise 6 / ZOS / Windows / IBM Data Studio, DB2TOP, QUEST CENTRAL, IBM HADR services, IBM FILENET Content Managerment. IBM/Princeton Soft tech Relational DBA Tools, iSeries SQL Navigator. INFORMATICA, IBM Tivoli Storage Manager TSM , DB2 Connect, IBM Websphere Portal, IBM Tivoli Directory services ITDS/LDAP , IBM utilities

Confidential

DB2 DBA on Z/OS System Environment

Responsibilities:

• Worked on VSAM to DB2 migration project as an application DBA. Involved in Logical and physical design of DB2 Database. Implemented the AT T naming standards to the newly created objects.
• Worked on setting up the database, storage group, table space, table, Index and access.
• Assisted the application team in Loading, Unloading, Restore, and Recovery of application table during the VSAM-DB2 migration process.
• Worked on Setting up the standards on isolation levels, Lock size, Lock duration, Commit frequency ,Rollback, Checkpoint and LOCKMAX parameters to achieve optimum data access and data concurrency.
• Worked on Setting up the BIND, PLAN, COLLECTION and Execute authorization for DB2 object.
• Worked on creating BMC REORGPLUS, COPY PLUS, LOAD PLUS utilities with SHARELEVEL CHANGE to achieve high availability environment.
• Worked on generating RMF reports from SMF records and DB2 PE, to determine the usage of
• I-O, DASD, Get page, CPU, Buffer pool, global lock, latch and lock contention.
• Worked on Buffer pool tuning and recommended buffer pool size changes to reduce
• synchronize I-O.
• Worked on DB2 data Base size calculation and recommended storage requirement to DASD team.
• Worked on Create DB2 Q-replication between 2 SYSPLEX using MQ-serious in Z/OS environment.
• Worked on Setting up the Q-replication started task, Capture task, apply task
• Dash Board monitoring for Q-latency and Q-depth, Created more 200 Q-subscription and activated.
• Worked on scheduling the DB2 daily and weekly maintenance JOB through ESP tool.

Confidential

Sr.DB2 DBA on LUW Z/OS SAP system Environment

Responsibilities:

• Strong working experience with DB2 LUW 8.x and 9.x family install, setup, upgrade, configuration and application of fix packs.
• Extensive experience in administering, maintaining, developing and implementing policies and procedures for ensuring the security and integrity of the corporate database.
• Extensive experience in resolving database performance issues, database capacity issues and other distributed data issues.
• Strong in performance monitoring and fine-tuning of growing voluminous database for optimal performance of SQL queries.
• Automation of database maintenance routines like backups, REORGCHK, REORG, RUNSTATS, event monitors, snap shots using shell scripts, tools like QUEST, CONTROL CENTER and Performance Expert.
• Formulated backup and recovery strategies.
• DB2 DBA Z/OS Production Support and DB2 Development
• Perform the 24 x 7 round the clock support for DB2 subsystems of Wal-Mart. The Wal-Mart Mainframe DB2 environment supports 18 terabytes of table and index data for 335,000 tables in over 22,000 databases across 76 DB2 groups.
• Each DB2 group consists of individual DB2 data sharing member's spread across the mainframe CPU's running in a sysplex.
• This group/member structure provides increased availability and capacity for DB2 applications. Maintenance can be applied to individual members without impacting the group and workload can be spread across members to provide necessary performance.
• The 76 DB2 groups are organized as follows:
• 11 Production DB2 groups on sysplex01 US Domestic Operations
• 11 Production DB2 groups on sysplex02 International Operations
• 13 Development DB2 groups on sysplex03
• 11 Prod SAP DB2 groups on sysplex0Y
• 30 Non-Prod SAP DB2 groups on sysplex0Z
• Infrastructure Support for Wal-Mart DB2 Database subsystems
• The Mainframe Senior z/OS DB2 Database Administrators primarily support Mainframe DB2 groups and perform the following day to day activities round the clock for support of shared DB2 database groups.
• Analyzing DB2 batch job failures across Z/OS LPAR systems
• Resolve the DB2 Error states for all production DB2 operations across Z/OS mainframe systems.
• Database Administration includes Set up of DB2 database environments Production / Development / Test , Creation of databases, table spaces, tables, indexes and other DB2 objects from logical data models and worked closely with developers to design and tune the database of various business applications.
• Performed the core DB2 administration activities viz., performing image copies of various databases, load /unload the data to/from database, creation / rebuilding the indexes, validating the data, repairing the table spaces, Quiesce the databases, archiving the DB2 active logs and restoration of DB2 logs, perform the lock escalations and concurrency states and other related activities.
• Perform the database sizing and performing the online / offline REORG activities of various databases.
• Perform the DB2 performance and tuning of DB2 Databases for all the applications across the Z/OS mainframe LPARS.
• Granting and Revoking DB2 object privileges to DB2 Objects across Z/OS environments
• Perform the DB2 bind process for various DB2 database groups across LPARS across all the applications.
• Perform the DR test plans for all 76 DB2 databases groups across different Z/OS environments Production / Development / Test
• Performance study and improvements along with backup, recovery, REORGS, RUNSTATS.
• Perform the Analysis of DB2 batch job failures.
• Worked on SAP DB2 Z/OS COCKPIT.