PROFESSIONAL SUMMARY:

• Overall 10+ years of working experience in Z/OS IBM Mainframe System Administration and 7+ Years of Experience on Z/OS IBM Mainframe DB2 Database Administrator & LUW DB2 (DBA) in Banking, Finance, Insurance (BSFI) domain which with strengths in Data Base administration,24*7 Production Support, Database Objects Physical & Logical Design, Data Maintenance, Backup and Recovery, Utilities etc.
• 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.
• 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.
• Competent and experienced in using IBM utilities, Omegamon and other third-party tools like CA/DB2 tools (platinum products), TMON, Omegamon and BMC tools.
• Hands-on proficient in DB2 Database Administration for z/OS with specialization in planning, estimating, forecasting and resource allocation.
• Strong working knowledge of Insurance, Banking, Stocks & Financial Industries.
• Coordination with Onsite-Offshore teams for DB2 system maintenance, documentation, and development.
• Good exposure to Quality, CMM concepts
• Excellent foreseeing, issues resolving, task, people management, and interpersonal skills.
• Excellent team player, hard worker with a commitment to quality and excellence
• Highly motivated, fast and continuous learner with a burning desire to excel. Always willing to go the extra mile.

CORE COMPETENCIES:

• Mainframe DB2 Database Administration in z/OS
• Solving the DB2 requests using the tools like BMC App tune, CA Platinum, CA-Insight, CA-Detector, CA Log Analyzer, Visual Explain, DB2-PM, etc.
• DB2 Objects Estimation, Designing etc.
• Expertise IBM Utilities COPY, RUNSTATS, QUIESCE, REORG, LOAD, UNLOAD… on the tablespaces
• Performance tuning in DB2 SQL
• Good working knowledge of File-Aid, Endeavor by casting the packages, package approvals.
• RACF Administration over all the subsystems and managing the user and dataset profiles

TECHNICAL SKILLS:

Operating Systems: Mainframe MVS-Z/OS, Z14, MS-DOS, Windows XP, Linux

Tools: CA-Insight, CA-Detector, CA-Platinum, DB2-PM, CA RC/Migrator, CA Log Analyzer, BMC Apptune, Endeavor, File-aid, CICS Manager, DB2 Admin Tool

IBM Mainframe: DB2, JCL, VSAM, File-Aid, SQL, ISPF, TSO, RACF

Database: Z/OS DB2 Version 8,9,10,11 & LUW DB2 Version 9.7

PROFESSIONAL EXPERIENCE:

Confidential, New Jersey

DB2 Database Administrator

Environment: Operating Systems: Mainframe MVS-Z/OS, Z14, Windows XP

Tools: CA-Insight, CA-Platinum, CA-Detector, IBM DB2 command Editor, IBM DB2 Visualizer, Data Studio BMC Change Manager, Catalog Manager, BMC Apptune, Endeavor, File-aid, CICS ManagerCA-7, DB2 Admin tool, IBM Data Studio

IBM Mainframe: DB2, JCL, VSAM, SQL, ISPF, TSO, RACF, SPUFI

Database: Mainframe DB2 Version 10,11 & LUW DB2 Version 9.5,9.7

Confidential, Houston, TX

DB2 Database Administrator

Environment: Operating Systems: MVS-Z/OS, Windows XP

Tools: CA-Insight, CA-Platinum, CA-Detector, IBM DB2 command Editor, IBM DB2 Visualizer, Data Studio BMC Change Manager, Catalog Manager, BMC Apptune, Endeavor, File-aid, CICS Manager, CA-7.

IBM Mainframe: DB2, JCL, VSAM, SQL, ISPF, TSO, RACF, SPUFI

Database: Mainframe DB2 Version 10

Confidential

Senior Z/OS Mainframe Specialist

Environment: Operating Systems: MVS-Z/OS, Windows XP

Tools: BMC Change Manager, Catalog Manager, BMC Apptune, Endeavor, File-aid, CICS Manager

IBM Mainframe: Cobol, CICS, JCL, VSAM, SQL, ISPF, TSO, RACF

Confidential

Z/OS Mainframe Operation & Administrator

Environment: Operating Systems: MVS-Z/OS, Windows XP

Tools: DB2 Admin, Endeavor, File-aid, CICS Manager, CA-7, etc.

IBM Mainframe: Cobol, CICS, JCL, VSAM, SQL, ISPF, TSO, RACF

Database: DB2 Version 8

Responsibilities:

• Monitor database performance and recommend improvements for operational efficiency.
• Assist in capacity planning, space management, and data maintenance activities for the database system.
• Perform database enhancement and modification as per the requirements.
• Maintain database security and disaster recovery procedures.
• Resolve any database issues in accurate and timely fashion.
• Monitor databases regularly to check for any errors such as existing locks and failed updates.
• Index reorg on databases.
• Oversee utilization of data and log files.
• Manage database logins and permissions for users.
• Offer DBA DB2 support for application development team.
• Designs and executes overall database architecture strategy, standards, and practices.
• Works closely with project teams to develop data models that support business processes.
• Works with application development to ensure database changes adhere to best practices and are properly prioritized and scheduled.
• Supports all areas of the enterprise - ensures that all databases run at optimal performance
• Proactively identifies and troubleshoots databases performance issues
• Monitoring and tuning databases to ensure peak performance.
• Designing/implementing backup and recovery solutions.
• Providing assistance to associates to resolve technical/critical issues.
• Documenting and implementing best practices for the database environments.
• Establishing standards, controls, and procedures to ensure data integrity and security.
• Performing capacity planning and projection for future growths.
• Providing on-call support on a rotation basis.
• Helping with Data Modeling, Physical & Logical Data Model Diagrams
• Implementing new database instances, create indexes, performance System DBA Tasks, Table Space maintenance, backup/restore, run stats /reorg, database migrations and upgrades.
• Proficient in administering and tuning DB2 on z/OS environment, experience with administering/tuning multi-partition databases preferred
• Significant experience with database backup/recovery strategies
• Performing routine database administration and performance tuning on mainframe DB2 systems.
• Install, Configure and Manage IBM DB2 in the high available clustered environment.
• Work closely with the application development team and run the data creation and data loads.
• Perform Data Migrations.
• Run reports periodically to check the database health.
• Manage multiple database environments.
• Structural object changes such as additional columns/constraints/index (restructures and reorgs)
• Space monitoring and expansions as required
• Index maintenance such as reorg index and rebuild indexes
• Planning and implementing back-up and recovery of databases.
• Performing troubleshooting and resolving recurring problems.
• Performing database Maintenance utilities like Reorg, Runstats, Image Copy and when to use them
• Performing data refreshing utilities like Load Resume, Load Replace, Unload
• Creating table & index partitions - optimizations and resolve contention issues if they arise.
• Querying DB2 Catalog Tables to improve the performance of applications
• Optimizing & improving system throughout includes index etc. Also, designing & programming to improve parallel processing
• Analyzing customer needs and ensuring solutions adopted are appropriate to meet such needs.
• Performance Tuning - Work includes analysis of access patterns to determine indexing and buffering needs.
• Creating database objects - database, tablespaces, tables, indexes, views…
• Altering the structure of objects - adding new columns, constraints, indexes etc., and object definition - parameter changes
• Refreshing data - unloading data from higher environment and loads into the lower environment based on the request.
• Maintenance of Database objects by running IBM utilities such as COPY, REORG, RUNSTATS…
• Monitoring growth of tablespaces and fixing space issues (if they arise) - max. extents reached, etc.,
• Bind the packages if any changes on the application DBRM members in all environments
• Moving DBRM members from application lib to system DBRM lib
• Providing privileges to database objects such as grant access and revoking access to objects
• Migrating database objects from one system to another system
• Investigating long running queries and give the solution to fix the issues
• Implementing changes on databases based on the change request (DB2 objects updates and bind packages and so on)
• Fixing scheduled/batch DBA job abends - jobs like reorg, rebind, runstats, image copy, unload, load etc.,
• Understands written business requirements and translates them into technical design
• Responds to business requests in a professional manner with a high sense of urgency
• Works well under high levels of stress
• Participates in on-call rotation and occasional off-hours activities (DR tests; upgrades, etc.)
• Performs other duties as required or assigned which are reasonably within the scope of the activities enumerated above.
• Administered DB2 subsystems in Prod, UAT, Test and Development regions
• Participated in design review meetings, involved in the logical design and in converting the 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
• Performed tablespace, dataset and transaction recoveries under various circumstances.
• Involved in capacity planning and storage management along with the system administrator.
• Worked with DDL/DML/DCL whenever it’s required right from Lower regions to Production.
• Worked with Splitting the schema during an upgrade or after.
• Worked with migrating DB2 objects from lower environment to higher environment and vice-versa using CA RC/Migrator.
• Worked with unloading LOB objects and loading.
• Worked with DML activity analyze using CA Log Analyzer.
• Running the migrate System script to migrate updated rules objects from PEGA V6.1 update (combined data and rules) to new PEGA V7.1 rules schema.
• Worked with Grants/Revoke on DB2 objects from the users.
• 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.
• Setting up DBA maintenance jobs Reorg, Runstats, Copy, Modify Recovery, etc. for brand new objects and Scheduling them in CA7.
• Raising RFC/Change ticket for every test/Production Activity and supporting all Production activities which will occur in Off-Business Hours/Business Hours and on weekends.
• Analyze the DB2 Performance and tuning the same whenever it's necessary and coordinating with the DB2 performance team
• Involved in running Data Consistency Utilities like Check.
• Involved in running Back up Utilities like Copy, Recover, Quiesce, Modify Recovery
• Involved in running Data Organization Utilities like Load, Unload, Reorg, Runstats
• Monitoring the DB2 space and Tuning the DB2 Unused Space and space management.
• Involved in Performing Data Definition Tasks such as Creation of Database, Tablespace, Tables, Indexes, Views, Alias, Synonyms, Alter Objects, Drop Objects.
• 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
• Working in 24*7 Production On-Call Support.
• Monitor automated and manually submitted customer batch jobs.
• Invoke resolution and restart procedures in case of failures in the batch jobs.
• Perform root cause analysis, resolution and/or escalation of production systems.
• Execute and reply to console commands.
• Validating severity classification of the problem.
• Add, Modify, Delete, Complete the Jobs and application in the Current Plan.
• Copy, Delete, Move and rename the datasets.
• Late Job Analysis.
• Modifying service class, initiators, the priority of jobs.
• Adding ad-hoc applications, monitoring error list, holding & releasing jobs, modifying existing occurrences.
• Workstation Changes, Workstation Link/unlink start/stop.
• Schedule on-request batch jobs that require immediate execution.
• Initial diagnosis of JCL abends and fix a minor issue.
• Expanding Instream Procedures and Submitting the jobs
• Add/Delete Dependency for jobs and Applications.
• Copy from queue to dataset and empty the queue.
• Delete specific messages from a queue.
• Delete expired messages from a queue
• Perform automated startup and shutdown of the production operating system.
• Performing HMC tasks such activating & de-activating LPAR's; Reset clear and Loading.
• Perform root cause analysis, resolution and/or escalation of production systems.
• Execute and reply to console commands.
• Performing system health checks.
• Handling resource contentions, conflicts on a production system.
• Handling tape and DASD related issues, like varying it online/offline.
• Manage JES spool and diagnose hardware and software problem escalating to the support team
• Incident documentation - opening, closing, and updating Clarify tickets
• Swap tape drives as needed and vary drives/devices online or offline
• Attending daily and weekly turnovers and Morning status calls
• Monitoring and Responding to Outstanding Replies
• Bringing up / draining initiators and assigning/changing class of the initiators
• Know when to start Day initiators and when to start Night initiators
• Involved & initiated various conference calls in resolving issues
• Involved and worked with Incident management team for all type of outages
• Doing a copy, compile Bind and List for programs and changing the environment to production
• Fixing the program when it abends while doing a copy function by deleting the archived files using ELIPS
• Editing the JCL to fix Abends like SB37, S222, 501, -911 and Defining GDG files for a job that abends with a checkpoint restart
• Fixing jobs that ABEND due to dataset contention, utility contention
• Monitoring IMS (Main view) and Help Support Teams during a Code Push.
• Finding out the transactions that are queuing up and make corrective actions.
• Dequeue transactions on IMS when the customer demands if a transaction queues to make a flood condition.
• Creating the Database Design and managing them in Migration, Load, Unload, etc.
• Creation and administration of DB2 Objects like Storage Groups, Databases, Tablespaces, Tables, Views, Synonyms, etc.
• Granting and revoking privileges to users on the DB2 Objects.
• Creating Image Copy jobs through COPY utility and scheduling them through CA7.
• Creating RUNSTATS jobs through RUNSTATS utility and scheduling them through CA7.
• Creating REORG jobs through REORG utility and scheduling them through CA7.
• Creating QUIESCE jobs through QUIESCE utility and scheduling them through CA7.
• Running REPAIR utility on tablespaces to remove copy pending, check pending in test environments.
• Solving the problems in DB2, faced by the developers from the projects like plan authorization failure, Resource unavailable, etc.
• Database, Tablespace, Table Structure migration from Development to Production regions.
• Maintaining the Databases, Tablespaces, Index spaces in good condition.
• Monitoring the Databases, Tablespaces, Index spaces on daily basis and sending the Health Check Report to the various project teams.
• Perform automated startup and shutdown of the production operating system.
• Performing HMC tasks such activating & de-activating LPAR's; Reset clear and Loading.
• Perform root cause analysis, resolution and/or escalation of production systems.
• Execute and reply to console commands.
• Performing system health checks.
• Handling resource contentions, conflicts on a production system.
• Handling tape and DASD related issues, like varying it online/offline.
• Manage JES spool and diagnose hardware and software problem escalating to the support team
• Incident documentation - opening, closing, and updating Clarify tickets
• Swap tape drives as needed and vary drives/devices online or offline
• Attending daily and weekly turnovers and Morning status calls
• Monitoring and Responding to Outstanding Replies
• Bringing up / draining initiators and assigning/changing class of the initiators
• Know when to start Day initiators and when to start Night initiators
• Involved & initiated various conference calls in resolving issues
• Involved and worked with Incident management team for all type of outages
• Doing a copy, compile Bind and List for programs and changing the environment to production
• Fixing the program when it abends while doing a copy function by deleting the archived files using ELIPS
• Editing the JCL to fix Abends like SB37, S222, 501, -911 and Defining GDG files for a job that abends with a checkpoint restart
• Fixing jobs that ABEND due to dataset contention, utility contention
• Monitoring IMS (Main view) and Help Support Teams during a Code Push.
• Finding out the transactions that are queuing up and make corrective actions.
• Dequeue transactions on IMS when the customer demands if a transaction queues to make a flood condition.