SUMMARY:

IT professional with 20 Years of work experience, which includes: Extensively working on DB2 DBA and System Programmer activities on Mainframes, Mainframes administration/Support and CICS RACF Administration experience.

Aspiring for a long time career and challenging work environment as z/OS DB2 DBA/ IMS DBA /Systems Administrator in a Firm Which would utilize and enhance my technical consultative and analytical skills in alignment of technology with business results.

TECHNICAL SKILLS:

Operating systems: O/S , Z/OS, MVS, Windows NT/ 2000 Server.

Development tools: JCL, REXX, VSAM

Administration tools: DB2-BMC- CATALOG MANAGER, DASD-MANAGER, CHANGE MANAGER, RC PLATINUM, MAINVIEW, DB2 ADMIN TOOLS, ETI, SMP/E, LOG ANALYZER, SPUFI, QMF, OMEGAMON etc.

PROFESSIONAL EXPERIENCE:

Confidential

Role: Senior Lead DB2 DBA /Tech Lead Star Membership Billing.

Responsibilities:

• Support users with the SQL errors such as -805, -904, -911.
• Work Extensively on DDL/DML/DCL.
• Performing Z/OS DB2 DBA Support for WellPoint Subsystems in Test and Production Environment.
• Requirement gathering for new application in Well Point Support Systems.
• Work extensively in designing new services for SMPE Changes, RPC Changes for Front end users.
• Managing Well Point application thru Marvin, TSRM, File net and Soup Tester.
• Work Extensively on TSO/ISPF/SPUFI/QMF.
• Work Extensively on utilities such as Reorg, Runstats, Load,Unload ,Image copy , Rebuild Index.
• Tuning and optimizing the complex queries for better performance using BMC Main View.
• Database Administration includes Set up of DB2 database environments for Development,
• Test and Production Environment thru BMC Catalogue Manager .
• Work Extensively on Monitoring Tools Mainview.
• Work extensively on BMC Catalogue Manager, Change Manager, TSRM Change Tool.
• Work extensively in designing new services for SMPE Changes, RPC Changes for Front end users.
• Managing Well Point application thru Marvin, TSRM, File net and Soup Tester.

Environment: IBM z/OS, JCL, DB2 v8.1 / v9.1, CICS, VSAM, VTAM, BMC ,Catalogue Manager ,

BMC Change Manager ,TSO / ISPF, SQL, TSRM Tool for Service Request.

Confidential

Role: Senior Lead DB2 DBA

Responsibilities:

• Perform the 24 x 7 round the clock support for DB2 subsystems for Allstate. The Allstate Mainframe DB2 environment supports 2 Datacenters and 40 LPARs.
• Each DB2 group consists of individual DB2 data sharing members' spread across the mainframe CPU's running in a Sysplex.
• The Mainframe Server Z10 DB2 Database Administrator primarily support Mainframe DB2 groups and perform the following day-to-day activities on shared DB2 database groups.
• Setup and customization of the DBMS services. This includes the DB2 catalog tables and indexes, system logs, buffer pools, and related supporting services.
• DB2 Database backup and recovery of all the DB2 groups for all the applications across various mainframe environments.
• Database application performance guidance.
• Database performance/availability monitoring and maintenance.
• Monitoring the DB2 VSAM datasets utilization and plan the DB2 DBA activities, as per requirement during weekdays and Weekends on call.
• Provided the day-to-day support and administration activities of DB2 subsystems across various LPARS
• Perform the Analysis of DB2 batch job failures
• Perform the Database design and sizing was performed as per each application architectural design.
• Resolve the DB2 Error states for all production DB2 operations across Z10 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 Z10 mainframe LPARS.
• Granting and Revoking DB2 object privileges to DB2 Objects across Z10 environments
• Perform the DB2 bind process for various DB2 database groups across LPARS across all the applications.
• Performance study and improvements along with backup, recovery, REORGS, RUNSTATS, etc.
• Tuning and Optimizing the complex queries for better performance using Mainview

Environment: IBM z/OS, JCL, DB2 v8.1 / v9.1, CICS, VSAM, VTAM, BMC ,Catalogue Manager , BMC Change Manager ,TSO / ISPF, SQL, HPSM Ticketing Tool for Service Request.

Confidential

Sr. Lead DB2 DBA

z/OS DB2 DBA Production Support and DB2 Development DB2 DBA Experience:

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

Responsibilities:

• 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.
• Database performance/availability monitoring and maintenance.
• Monitoring the DB2 VSAM datasets utilization and plan the DB2 DBA activities, as per requirement during weekdays and Weekends.
• Provided the day-to-day L2 support and administration activities of DB2 subsystems across various LPARS of Z/OS mainframe systems.
• Monitoring the helpdesk queues and resolve production and QA tickets
• Monitoring the jobs, processes and interfaces.
• Perform the Analysis of DB2 batch job failures
• Perform the Database DB2 on Z/OS servers design and sizing was performed as per each application architectural design.
• Ad-hoc interaction with the databases including data extracts, minor database updates
• 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 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
• Granting and Revoking users thru CICS CEDA
• Perform the DB2 bind process for various DB2 database groups across LPARS across all the applications.
• Participated in 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, etc.

Environment: IBM z/OS, JCL, DB2 v8.1 / v9.1, CICS, VSAM, VTAM, CA-PLATINUM, IMS, TSO / ISPF, SQL, Remedy

Confidential

DB2 DBA

Responsibilities:

• Involved in requirement gathering for designing the physical and logical data model
• Involved in Mainframe hardware up gradation
• Involved in DB2 Migration from version 7 to version 8
• Created database object in both development and production Environment
• Monitored performance using BMCDSN and tuning
• Build JCL and Tune JCL
• Involved In analyzing the present system and made changes as per client requirement
• Performed running utilities like copy, load, unload, reorg , run stats, Check, repair
• Involved in changes of db2 components, monitoring db2 dasd, db2 cluster Ratio, encryption of db2 tables
• Added spaces thru VSAM, DFDSS
• Involved in the performance monitoring using SMF, RMF and tuning
• Tuning SQL using DB2 Query Monitor
• Monitoring performance using BMC Main view
• Involved in maintaining data integrity by DB2 log analysis tool
• Monitoring processes running on mainframe thru BMC
• Coordinated in Partitioning database
• Performed Database Design, Creation of objects
• Monitoring performance statistics such as disk utilization, memory utilization, CPU utilization
• Monitoring tools like db2batch, explain utilities
• Tuned DB2 objects
• Involved in Mainframe hardware up gradation enhancement
• Involved in Encryption of Data
• Performed Decommissioning of Database

Environment: IBM S/390, IBM Enterprise COBOL for s/OS, JCL, DB2 v7.1 v8.1, COBOL, CICS, VSAM, VTAM, BMC, IMS, TSO / ISPF, SQL,

Confidential

DB2 DBA

Responsibilities:

• Involved in requirement gathering for designing the physical and logical data model.
• Involved code changes in Cobol programs for NCANDS interface
• Involved in analyzing the System
• Building DB2 stored procedures for NCANDS interface
• Tuning and optimizing JCL for better performance
• Fixing Screen stored procedures as per Alabama standard
• Build Extract stored procedure as per requirement
• Extracting data's from state of Alabama and Transferring to federal system.
• Creation of Database for NCANDS system
• Creation of SMS, DMS for NCANDS system
• Performance monitoring through snapshot
• Monitoring DB2 performance Tools
• Monitoring DB2 Health Centre
• DB2 Connect for Client
• Involved in online application program for DB2 stored procedures
• Data Sizing, Memory management, Capacity Planning
• Designed DB2 physical objects such as database, tables pace,
• Tables and storage groups
• Did analysis over capacity planning, memory management etc
• Tune and rewrite complex SQL
• Tuned Sql's to improve performance
• Running data utilities like load, unload, image copy, reorg, run stats
• Involved in configuring HADR Environment
• Involved in performance monitoring through DB2 EXPLAIN
• Read in data from an existing permanent SAS data set
• Sample job which runs PROC CONTENTS on an existing permanent SAS
• Dataset on disk
• Sample job which creates a new sequential disk file from in stream input data
• Worked in CICS CEDA to connect users
• Maintaining and monitoring databases using Omegamon

Environment: IBM S/390, IBM Enterprise COBOL for s/OS, JCL, SAS, DB2, CICS, VSAM, BMC MAINVIEW, RACF, SMF, RMF, SPUFI, TSO/ISPF, SQL, DB2V 7.1,DB2V8

Confidential

DB2 DBA

Responsibilities:

• Helped design the physical model, databases, maintaining databases, coding
• Proc JCL
• Optimizing JCL for system
• Worked in stored procedures
• Create job which reads in data from an external data file
• Create job which creates a new permanent SAS data set
• Create job which reads in data from an existing permanent SAS data set
• Create job which runs PROC CONTENTS on an existing permanent SAS dataset on disk
• Involved In analyzing the present system and made changes as per client requirement
• Sample job which creates a new sequential disk file from in stream input Data
• Creation of objects
• Involved in the performance monitoring and tuning
• Involved in maintaining and monitoring system using SMF, RMF
• Running tools like reorg, run stats, copy, Export, Import
• Establish and implement performance tuning for the database, applications, and reports
• Involved in disaster recovery and HADR
• Involved in knowledge transfer to offshore team
• Performed primarily in the roles of DB2 Database Administrator and CICS RACF online
• Systems Programmer
• Involved in customizing and tuning SQL using DB2 Query Monitor
• Involved in performance monitoring and tuning CICS TS using BMC Mainview
• Involved in maintaining data integrity by DB2 log analysis tool
• Involved in Partitioning database
• Involved in Database Design, Creation of objects
• Monitoring performance statistics such as disk utilization, memory utilization, CPU Utilization
• Involved in monitoring tools like db2batch, EXPLAIN utilities
• ADSM backups and storage management of DB2 databases and also OS file Systems
• Automation of regular DB2 maintenance processes using Shell scripting using Tivoli Work
• Load Scheduler and also CRON utility

Environment: IBM S/390, IBM Enterprise COBOL for s/OS, JCL, DB2, COBOL, CICS, VSAM, SAS, VTAM, OMEGAMON, IMS, TSO / ISPF, SQL, FILE-AID,

DB2 v 8.1

Confidential

DB2 DBA

Responsibilities-:

• Involved in production support comparing the input from different service systems and merge into one
• Compared the record of different dates and check for order type
• Involved in coding Cobol subroutine for btn edit, coding procedure JCL for the system
• Providing support for db2 region
• Adding RACF dataset profiles through CEDA
• Data encryption and decryption through CICSRACF
• Monitoring bmc main view tools
• Knowledge transfer to offshore team
• Involved in performance tuning, DB design, implementation, configuration, and management of the DB2 Subsystem, monitoring and tuning, capacity planning
• Involved in system and database backup and recovery
• Worked with developers to tune SQL statements and enforce SQL standards and to provide production support
• Involved in the team to migrate version from DB2 7.2 to DB2 8.2 and the database migrations
• Implemented delta and incremental backup with compression utility
• Implemented DMS tablespaces with autoextend features
• Implemented a Disaster Recovery Solution for the database
• Did capacity planning for the existing database when the data was supposed to increase and new schemas added
• Tune and rewrite complex SQL Queries
• Tuned SQL to improve performance by over 40

Environment: IBM S/390, IBM Enterprise COBOL for s/OS, JCL, DB2, COBOL, INFOMAN, ENDEVOR, INSYNC, VTAM, BMC MAINVIEW, OMEGAMON, RACF,SPUFI, TSO/ISPF, SQL, DB2 V 7.1

Confidential

DB2 DBA

Responsibilities:

• Involved as one of the database administrator in this conversion and enhancement project
• Converted all applications from IMS to DB2 database using dl/2 and vs/2 migration tool
• Designed DB2 physical objects such as database, table space, and storage group
• Involved in logical and physical database design using Erwin data modeling tool
• Creation of tables using DDL
• Conversion of type1 and type2 index
• Normalized data
• Maintaining DB2 catalogues
• Program preparation using plan, bind/rebind and explain
• Copying data's from one database to another database using platinum tools
• Running data utilities like load, unload, imagecopy, reorg, runstats, tuning and optimizing JCL for better performance
• Maintaining and monitoring databases
• Authorizing grant and revoke privileges to users
• Also involved in defining VSAM datasets such as KSDS ,ESDS and RRDS
• Fix defects on DB2 databases
• Involved in HADR CONFIGURATION
• Monitoring performance through CICS CEDA
• Monitoring mainframe-using SMF, RMF
• Connecting consultants through access ids
• System trace monitoring and statistics
• Mentoring junior employees

Environment: IBM z/800, IBM Enterprise COBOL for s/OS, JCL, DB2V8.1, MVS, CICS, IMS DB /DC, MQ SERIES.WEBSPHERE

Confidential

DB2 Consultant

Responsibilities:

• Review database before it was promoted to the production web environment
• Analyzed database and made recommendations for tables, table spaces, buffer pools, and SQL Advised client on database and instance configuration parameters
• Mentored the client staff and recommended solutions for encryption, performance, and daily database tasks
• Provided a number of crone jobs that will help the client maintain a high-performance database with minimal intervention

Environment: IBM z/800, z/OS, IBM Enterprise COBOL , ADABAS, DB2V8.1, SQL, CICS, JCL, REXX, CLIST, AND VSAM

Confidential

DB2 Consultant/ Mainframe Consultant

Responsibilities:

• Responsible for Performance Monitoring and Tuning Databases.
• Involved in designing modules such as Account Maintenance, EOD End of Day activities, Loan Maintenance
• Loan maintenance involves providing support for different loans available at the bank such as student loan, housing loan, vehicle loan, and education Loan etc
• The EOD Activity, which involves the processing of the current day transaction and posting in the ledger all the EOD programs, are batch programs
• Enhancement for Code expansion and NRE deposit creation
• Account Maintenance - providing support for various types of accounts such as Individual Accounts, Time Deposits
• Responsible for screen design, program analysis and documentation
• Responsible for Creation of objects like Table spaces, Tables, Indexes, Views
• Responsible for SMF log monitoring and system monitoring

Environment: S/390, O/S, IBM Enterprise COBOL, MVS/ESA, VS COBOL II, ADABAS, IDMS, VSAM and JCL

Confidential

DB2 DBA/ Mainframe Programmer

Responsibilities:

• Maintaining and monitoring databases
• Responsible for creation of VSAM-KSDS file structure
• Responsible for creation of Add, Update, Delete And Browse using pseudo-conversation
• Responsible for Creation of Tablespaces, Tables, Indexes, Views
• Responsible for Performance monitoring and tuning Database
• Running data utilities like load, unload, image copy, reorg, run stats, tuning and optimizing JCL for better performance
• Authorizing grant and revoke privileges to users
• Also involved in defining VSAM datasets such as KSDS, ESDS, and RRDS
• Fix defects on db2 databases
• Monitoring performance through CICS CEDA
• Connecting consultants through access ids

Environment: z/800, S/390,O/S z/OS, IBM Enterprise COBOL , DB2V7.1, SQL, CICS, JCL, AND VSAM

Confidential

Programmer

Responsibilities:

• Designed forms front office management system for hotel industry
• The forms maintained all the information about Customer Booking, Corporate Booking, Maintaining day-to-day business activities in Restaurants and Employee Files.
• Responsible for Screen Design, program analysis, documentation, code generation and testing

Environment: MF-COBOL, UNIX

Confidential

Programmer

Responsibilities:

• Responsible for coding door enquiry and generating weekly report based on the enquiries
• Designed db2 table for various departments
• Involved in employee in-out time report generation
• Involved in payroll generation based on in-out report

Environment: MF-COBOL, UNIX

Confidential

Programmer

Responsibilities:

Responsible for coding the voters List .