SUMMARY

• Over all 9+ years of working experience, 7+ Years of Experience on Z/OS - IBM Mainframe DB2 Database Administrator (DBA) in Banking, Finance, Insurance (BSFI) domain which with strengths in Data Base administration, Production Support, Database Objects Physical &Logical Design, Data Maintenance, Backup and Recovery, Utilities etc.
• Having experience in DBA activities like implementing Database design, data maintenance, and authorization privileges for db2 access, regular backups and recovery activities.
• Experience in operational 24x7support, best practice trouble shooting, monitoring and strong proactive team player.
• Expertise in understanding the Business and Technologies of the company & deliver high-quality results along with the extensive application designing experience.
• Extensive experience in utilities and tools used for database monitoring (DB2 traces, online performance monitors, reports, EXPLAIN, DB2 catalogue queries), data movement and 3organization (LOAD, UNLOAD, REORG), data consistency utilities and catalogue manipulation utilities (RUNSTATS, MODIFY, STOSPACE), etc.
• In-depth knowledge of all phases of Software Development Life Cycle (SDLC) with concentration on requirements analysis, technical systems design, development and implementation of various applications
• 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
• Excellent work experience in detailed Mainframe System Administration both in Hardware and Software
• Experience working with developers on the enhancement ofCuramSoftware frame work
• Strong working knowledge in Banking, Stocks & Financial Industries
• Coordination with Onsite-Offshore teams for DB2 system maintenance, documentation and development.
• Equipped with the knowledge of various software’s, organizing technical demonstrations, with sound understanding and skill of creating new software’s & systems, designing, analysis, testing, database development and coding for modules while structuring customized solutions to meet customer’s specific needs
• Comprehensive problem solving abilities, ability to deal with people diplomatically, willingness to learn, Key team player, hard worker with good communication skills and been a part of team-mentoring activities
• Good exposure to Quality, CMM concepts
• Excellent foreseeing, issues resolving, task, people management and interpersonal skills.
• Excellent team player, hard worker with commitment to quality and excellence
• Highly motivated, fast and continuous learner with a burning desire to excel, always willing to go extra mile
• DB2 Database Administration in z/OS
• Solving the DB2 requests using the tools like BMC Apptune, CA Platinum, CA-Insight,CA-Detector, CA Log Analyzer, Visual Explain, DB2-PM, etc.
• Using IBM Optim to support test data to Application development team.
• COPY, RUNSTATS, QUIESCE, REORG, LOAD, UNLOAD on the tablespaces
• Performance tuning in DB2 SQLs
• Good working knowledge in File-Aid, Endeavor by casting the packages, package approvals.
• CICS Administration like defining the CICS entries like Files, Clusters, Tran Ids. etc.,
• Experience working with developers on the enhancement ofCuramSoftware frame work
• RACF Administration over all the subsystems and managing the user and dataset profiles

TECHNICAL SKILLS

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

Tools: CA-Insight,CA-Detector,DB2-PM,CA RC/Migrator, CALog Analyzer, BMCApptune, Endeavor, IBM Optim, File-aid, CICS Manager, Curamsoftware Business suite

IBM Mainframe: Cobol, CICS, DB2, JCL, VSAM, File-Aid, SQL

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Sr.DB2 DBA

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
• Supported teams with masked Test data using IBM Optim for multiple environments.
• 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 migrating DB2 objects from lower environment to higher environment and vice-versa using CA RC/Migrator.
• Worked with an unloading LOB objects and loading.
• Worked with DML activity analyze using CA Log Analyzer
• 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 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 Like Creation of Storage Group, Database, Table space, 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.

Environment: Operating Systems: MVS-Z/OS, Windows XP CA-Insight, CA-Platinum, CA-Detector, IBM DB2 command Editor, IBM Optim, IBM DB2 Visualizer, Data Studio BMC Change Manager, Catalog Manager, BMCApptune, Endeavor, File-aid, CICS ManagerCA-7, Curamsoftware Business suite.

Confidential, Atlanta, GA

Senior Database Administrator

Responsibilities:

• Perform Online DB Maintenance - Alter space, perform Reorgs, Runstats, Backup, Rebalance
• Perform online and offline backups for both incremental and full copies depending on the application updates/inserts.
• Implement new database objects Modify existing objects, Drop database objects.
• Execute DCL, DDL, and DML on database objects using JCLs and SPUFI.
• Expertise in IBM Utilities like COPY, MODIFY, REORG, RUNSTATS, QUIESCE, REBIND etc.
• Security audits which includes granting and revoking privileges, authority to users, plans & packages, collections.
• Expertise in performance tuning of bad SQL’s using BMC Apptune
• Refresh data from production to test environment on request from application team.
• Documentation of best practices, procedures followed in the organization.
• On call on shift basis to attend problems in production, development and test region.
• Involved in many project releases in production, testing and development environments.
• Involved in migration activities from DB2 V8 to V9.
• To execute validation scripts to test new features of DB2 Version 8.
• Root cause analysis on the jobs running for long time.
• Solving Production On-calls on the job abends.
• Creating the maintenance jobs like MODIFY, COPY, REORG, RUNSTATS, QUIESCE and schedule them in Production through CA-7.
• Solving the change requests through BMC Remedy system for UAT and Production.
• Solving the change requests through Emails in UNIT and INTG.

Environment: Operating Systems: MVS-Z/OS, Windows XP BMC Change Manager, Catalog Manager, BMC Apptune, Endeavor, File-aid, CICS Manager

Confidential

Database Administrator

Responsibilities:

• 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, Indexspaces in good condition
• Monitoring the Databases, Tablespaces, Indexspaces on daily basis and sending the Health Check Report to various project teams

Environment: Operating Systems: MVS-Z/OS, Windows XP DB2 Admin, Endeavor, File-aid, CICS Manager, CA-7, etc Cobol, CICS, JCL, VSAM, SQL

Confidential

System Administrator

Responsibilities:

• Creating the TSOIDs and granting access rights to the users.
• Revoking the TSOIDs and resuming the same after expiry date.
• IPL - Initial Program Load of the Mainframe in weekends and Shut down of the Mainframe in weekends for Maintenance purposes.
• 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.
• RACF Administration, MVS administration, CICS administration, etc.
• Creating PPT, PCT, RCT entries in CICS regions for the online programs.
• Monitoring the long running jobs in JES and taking appropriate actions.
• Monitoring the long running transactions in CICS and killing them.
• Taking full volume backups and system volume backups in weekends through tape.

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