PROFESSIONAL SUMMARY

• 5.5+ years of experience in IT as a Database Administrator in Mainframe DB2 Z/OS and IMS.
• Currently working at Confidential since Jan 2011 as a DBA (Z/OS and IMS) .
• Worked with Confidential as Junior MF DB2 DBA .
• Strong technical and problem solving skills related to Mainframe DB2 DBA and Control M Admin activities.
• The Main concentration being in the modules: DB2 Objects, DB2 Utilities, Catalog tables, plans and packages, Application performance tuning, and DB2 V10 features.
• Sound knowledge on DB2 Utilities like Load, Unload, Reorg, Recover, Quiesce, Copy, CopytoCopy, Merge Copy, Check data, Check Index, Rebuild Index, Repair, Runstats, Modify Recovery, Report etc.

TECHNICAL SKILLS

Operating Systems: OS/390, Z/OS,Unix

Languages, Packages: JCL,COBOL, REXX, C, C++, ISPF, SQL, Perl

DBMS: IBM DB2 on Z/OS, IMS, RDBMS

Special Software / tools: Performance monitor, IBM personal communication, File - Aid for DB2 & IMS, BMC catalog manager, BMC DASD manager, BMC Catalog Manager and Apptune, BMC SQL Explorer,IBM QMF, IBM Omegamon, CA JOBTRAC, Infoman, Manage Now,Service Now tool, IBM Database utilities for DB2 & IMS, BMC Database Utilities for DB2 & IMS, CDB Database utilities for DB2, Neon tools for IMS, Putty, SQL Developer

PROFESSIONAL EXPERIENCE

Confidential

Database Administrator and Control M Administrator

Responsibilities:

• Design of databasesCreation and deployment ofDatabases/PLSQL objects in Production
• Performance optimization and tuning of stored procedures and queries
• Monitoring of database performance and working on long running jobs.
• RefreshingEnvironments and environment delivery
• Working on Build and deployment activities.
• Working on Control M to monitor production batch jobs and coordinate with application team in case of issues
• Investigating and troubleshooting database problemsincluding job failures
• Working on some L3 activities such as applying patches, changing DBs from archive log to no archive vice versa.
• Discussions with the clients,gather and understand business functions and requirements.
• Design, creation and deployment of database/ instances in production.
• Performance tuning of SQL queries and optimization.
• Maintenance of production database and development database which includes tablespace space management, user creation, privileges, roles etc.
• Investigating and troubleshooting critical database problems/tuning issues and provide root cause analysis to prevent future issues and ensure database availability 24*7.
• Debugging, troubleshooting PL/SQL packages, stored procedures and functions.
• Analyzing, validating and modifying database objects to implement new business logic.
• Coordinate with Onshore and offshore team

Confidential

Database Administrator

Responsibilities:

• Designing & Creating Database objects, Table spaces, Tables, Views, Indexes etc.
• Database maintenance with regular reorganizations, database backups, update statistics.
• Performance optimization and tuning of SQL
• Investigating and troubleshooting database problems
• Familiar with different IBM/BMC/CDB utilities like REORG, COPY, RUNSTATS,MODIFYRECOVERY,LOAD,UNLOAD,RECOVERYand other standalone utilities which are used to carry out the production maintenance activities.
• Handling requests for granting privileges to do DML/DDL operations with proper approvals
• BIND/REBIND Plan and Packages and assisting application teams in resolving bind related Issues.
• Building of test cases for testing purposes in the test environment before deployment in production
• Decommissioning of old databases
• Monitoring the health of database/objects on regular basis and ensure that database are available all the time
• Production database monitoring for size, estimating their growth for IMS/Db2 Databases
• Setting up and monitoring of Maintenance Jobs. Activities involved creation of database utility jobs.
• Designing & Creating Database objects, Table spaces, Tables, Views, Indexes etc.
• Investigating and troubleshooting Database problems and provide RCA to avoid future abends.
• Taking image copy, loading and unloading of data.
• Tuning of DB2 queries as part of production database support
• Monitoring overall status of the databases and their availability.
• Altering the standard tables or table spaces to support new features of DB2 during version upgrade.
• Conversion of classic partition TSs to UTS PBR in DB2 V10.
• Perform validations on the DB2 objects during version upgrades.
• Identifying the objects which can lead to disk saves and CPU saves.
• Assist in circumvention of any critical issues requiring involvement of decisions related to database design changes, as well as following up with further robust and long term solutions to the same.
• Analysing the space report and taking the necessary actions like expansions and redistribution of data.
• Recovery of the database in case of system failure or loss of data.
• Database image copy failure reporting and fixing these failures.
• Database modifications to implement new business logic.
• Identifying business rules and logic for database model
• Investigating and troubleshooting Database problems

Confidential

Junior Database Administrator

Responsibilities:

• Setup of databases/objects and users/privileges in both development and production environment.
• Create plans/packages for COBOL-DB2 programs
• Create test setup and provide support to application teams while their testing
• Created new jobs and scheduled in to production for the enhancement projects
• Removed the CHKP status on one of the table space in production and avoided outage
• BIND/REBIND Plan and Packages and assisting application teams in resolving bind related Issues
• Help application teams to resolve issues related to DB2 with their jobs
• Database health monitoring
• Database maintenance with regular reorganizations, database backups, update statistics, database load, unloads etc.a, India