Professional Summary

• 6 years of IT experience in database administration and software programming
• Database Administrator for DB2 in z/OS environment for more than 5 years
• 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
• Competent and experienced in using IBM utilities, Omegamon and other third party tools like CA/DB2 tools (platinum products), TMON, Omegamon and BMC tools.
• Experienced and programmed REXX tools to simplify database administration
• 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.
• Co-ordinated and actively worked in database version migrations DBA support team
• Experienced in working with large tablespaces, processing and maintenance of partitioned tablespaces , NPIs and DPSIs
• 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.
• Experienced in supporting critical production databases and worked on 24*7 production support.
• Ability to work independently or as an effective team player
• Proficient in Insurance and Telecom domains.
• IBM Certified DB2 V9 Database Administrator (for z/OS)

Skills

• Operating System: z/OS, z/VM , Windows, UNIX
• Databases : DB2 , Oracle
• Languages: VS COBOL II, REXX, JCL,CICS,PL/I
• Software: TMON, Omegamon, ERwin Data Modeller, CA tools (Platinum Products),IBM Utilities, BMC tools,DB2 Connect, Spufi, QMF, VSAM, Endevor,File-Aid, MQ series,VB Demo, CA7

Education
Bachelor of Technology in Electronics and Instrumentation |Andhra University, India

Certifications
IBM Certified Database Associate – DB2 Universal database V8.1 Family (Test 700)
IBM Certified Database Administrator – DB2 9 DBA for z/OS (Test 732)

Work Experience

Confidential,

DB2 DBA for z/OS – Litigation Systems Maintenance

Maintenance and enhancement of a suite of 15 systems collectively referred as Litigation Systems. These systems provide support in the litigation process related to claims.

Responsibilities:

• Administered DB2 subsystems in Prod, Qual, Test and Development regions
• 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.
• Performed SQL tuning and bind plan/package creation for enhancements and developments
• Prepared test environments and performed data refresh
• Designed , debugged and implemented stored procedures and triggers
• Identified problematic SQL and optimized SQL queries that helped improve application performance
• Ensured proper backup and recovery by maintaining DB2 image copies and recovery JCLs
• Performed data maintenance using LOAD,UNLOAD,REORG,RUNSTATS
• Implemented REXX programs that aid in database maintenance and developed a REXX program to automatically send and receive files from z/VM to z/OS environment and vice versa
• Performed tablespace recovery, data set recovery and transaction recovery under various circumstances
• Involved in capacity planning and storage management along with the system administrator.
• Efficiently carried out DBA responsibilities in planning DB2 version migration activities, in migration phases and in performing post migration tasks
• Monitored and managed DB2 thread and locking issues
• Involved in granting various authorizations and privileges to different users
• Proactively monitored and performed daily maintenance activities
• Produced and analyzed DB2 performance reports
• Provided 24*7 support on rotation basis

Environment:z/OS , COBOL, DB2 (Version 9),Endevor, IBM utilities, VSAM, JCL, Visual Explain, Omegamon, CA Log Analyzer,VB Demo

Confidential,

DB2 DBA (z/OS) - PHtool

PHtool (Parameter Handling) tool supports all activities of parameter handling and parameter setting in the Product Management, Source System Design and Global/Market Application system (GAS/MAS).

Responsibilities:

• Monitored and administered Ericsson’s AXE software tools databases which aid in controlling critical switching equipment in the telephone exchange
• Performed database maintenance activities like monitoring partitions,data set extents, executing data consistency, catalog manipulation utilities like RUNSTATS and data reorganization utilities like REORG ,etc
• Performed tablespace ,dataset and transaction recoveries at various instances.
• Maintained efficient and reliable backup and recovery routines
• Supported application programmers and users in their daily interactions with DB2.
• Actively involved in designing and implementing database objects
• Created COBOL stored procedures and triggers
• Used Erwin data modelling tool for designing logical and physical data models
• Extensively used CA/DB2 tools to migrate database objects (CA RC/migrate), to monitor thread activity (Detector) ,etc
• Managed database accesses, addressed needs for Grant/Revoke and DBADM Authorizations, user creation and object level privileges using Platinum products (RC/Secure)
• Planned performance monitoring using TMON, omegamon reports and traces to capture storage usage , buffer pool usage and analysis, EDM pool usage and data on deadlocks, lock escalations, etc.
• Provided performance improvement solutions that helped reduce the Parameter Handling application’s search functionality response time by 20%
• Setup environments for DB2 connectivity through JDBC and SQLJ drivers for JAVA based applications
• Investigated complex issues and provided solutions under tight SLAs and schedules
• Performed migration activities as part of version 7 to version 8 migration
• Provided 24*7 production support on rotation basis.

Environment:z/OS, DB2 (Version 8), COBOL, JCL,VSAM,PL/I,REXX, Platinum products (RC/Query, RC/Secure, detector) TMON,Omegamon, IBM utilities,SPUFI, QMF, Visual Explain, CA-7,DB2 connect

Confidential,

DB2 Application Developer - AIGWR ISD Billing Transfer

The Investigative Services division (ISD) billing cycle is separated from the AIG Claims Systems billing flow and is transferred to the AIG World Investigative Resources department.

Responsibilities:

• Analyzed business and technical specifications
• Worked with end users to assess requirements and provided feasible solutions
• Prepared design document for the requirements.
• Designed and developed a high performance database withefficientuse of indexes, views and triggers
• Programmed ,tested and debugged remote stored procedures and COBOL-DB2 stored procedures
• Designed , tested and scheduled batch jobs
• Created GDGs and VSAMs in test environments
• Created test environments for the new database and populated test databases with relevant data from various production files and databases
• Performed data consistency checks
• Resolved space related issues
• Resolved security and authorization issues
• Prepared Unit testing documents.
• Performed testing on daily, weekly and monthly batch cycles.
• Verification and validation of billing details in the existing and new application for various lawsuits.
• Ensured error free code migration across regions using ENDEVOR and migration of database objects using platinum RC/Migrator.
• Created packages and co-ordinated production moves
• Performed post production verification activities

Environment: z/OS , COBOL, DB2 (Version 8), VB Demo, JCL, IBM tools and utilities, Endevor, platinum tools (RC/Migrator, RC/query,RC/secure)

Confidential,

DB2 Application Developer – AXA Mainframe Data Integration

This Project involves data migration of the personal lines and commercial lines from one system (IRS) to the other (CORE)

Responsibilities:

• Analyzed business and technical requirements
• Actively participated in design review meetings
• Performed loading of data from flat files (importing Oracle dumps) to the migration environment
• Data profiling on the source data loaded
• Worked on transformation of the source data based on the mapping details provided by the client
• Validated the extracted data
• Extracted the target data in Migration environment , into ASCII files
• Converted ASCII data files into EBCDIC files (VSAM files) using PWX
• Performed transfer and loading of files to DB2
• Ensured data consistency between the source and target databases.
• Prepared unit testing documents
• Resolved issues raised in user testing and maintain all those in the quality center.
• Co-ordinated with users and provided post production support

Environment:z/OS, DB2 (Version 8), Oracle , COBOL, REXX, Informatica PWX,JCL,VSAM