EXPERIENCE SUMMARY:

• Senior IMS/DB2 DBA with 10 years of combined Database administration experience.
• 8 years of combined IMS application and IMS DBA support experience.
• Certified z/OS DB2 DBA (v8 - v10)
• Overall 25 years of IT experience and has worked in all phases of Mainframe Applications.
• Expertise in Database design, application development, deployment, DB administration, DB migration, SQL query optimization, dynamic SQLs and triggers and stored procedures
• Proficient in working with HALDB, DEDB, IMS TM and Logical relationships
• Experience in Automotive, Healthcare, Manufacturing and Banking industry related applications
• An inventive team player who promotes improved methods, a tenacious trouble shooter who looks for better solutions and new learning opportunities.

HARDWARE/SOFWARE:

IBM: Many generations of IBM mainframes and their peripherals, from IBM 360 to z/OS platforms, AS/400, Sun, HP and IBM Unix, Linux & AIX servers. DB2 v10, DB2 Connect, DATA STUIDO, TERADATA, IMS DB/DC, HTML, ISPF, QMF,SPUFI, Insight, T-MON, OMEGAMON, APPTUNE, ESP, CATALOG and CHANGE MANAGER, TOAD, DBA X-pert, IBM, BMC, CA (Platinum), CA Detector, BMC MainView, DBRC, IBM Info sphere Data Replication, Compuware, Utilities and Administrative tools, JES2, ACF2, RACF, CA7, TMS, Unix, DOS, OS/2, Windows, COBOL, EON, CICS, BMS,VSAM, FILEAID, DB2 Stored Procedures, CHANGEMAN, ENDEVOR, INTERTEST, XPEDITOR, SAR, QUICK, HP SERVICE MANAGER, ERWin Data Modeler, FTP, JCL, SYNCSORT, Visio, various MS Office products

PROFESSIONAL EXPERIENCE:

DB2/IMS DBA - Consultant

Confidential

Responsibilities:

• Develop and implement complex changes impacting several processes with minimal direction.
• Perform IMS DB2 Database object changes in a multiple/Data sharing environments.
• Monitor applications, resolve various database and performance issues using BMC MainView CA/Detector and IBM Omegamon tools
• Perform Database and job changes using ChangeMan, VA7 and ITSM
• Perform IMS DBDGEN, PSBGEN and ACBGEN per application request.
• Create/maintain new processes that improve reliability and task performance.
• Maintain and Replicate data from source to target Systems using IBM Info Sphere Data Replication for DB2
• Setup/Execute and monitor IMs/DB2 utilities such as REORG, IC, RUSTATS, LOAD/UNLOAD etc.
• Perform database/application performance tuning, data transformation/mapping, backup, and recovery of application databases including design and development of disaster recovery procedures which ensure enterprise data consistency.
• Execute IMS and DB2 Data refresh activities for TEST systems.
• Develop Standards and Best Practices for IMS and DB2 databases.
• Automated Utility process/Jobs for scheduled production releases to reduce errors
• Participate in all aspects of the mainframe environment decision-making process.
• Cross-trained associates in the mainframe environment
• Supported and Administered large scale data sharing DB2 databases (stored in 38 identical databases and growing) in a 24X7 highly available, scalable Agile development environment.
• Designed, Created, Altered and Maintained database solutions across multiple applications to meet business needs and optimal performance.
• Managed database administration in multiple databases with more than 25 TB of PROD data, growing at the rate of 80MB/week that include big partitioned tables, BLOB, CLOB and XML table spaces.
• Performed quarterly data refresh to multiple TEST environments.
• Attended Daily Kanban stand ups to provide update on tasks in progress and completed
• Determined and documented various testing scenarios for various DB2 upgrades (v10).
• Monitored physical DBMS for performance and capacity requirements before and after the implementation.
• Identified and optimized poorly performing queries, analyze index requirements using EXPLAIN and APPTUNE. Performed DB recovery as needed. Monitored and resolved DB2 thread and locking issues especially during peak seeding and harvesting seasons.
• Created and ran DB Utilities - Reorgs, Run Stats, Unload/Load,/IC, Refresh, Restore etc.
• Provided 24x7 on call support for multiple database applications. Help in problem resolution when database issues were suspected.
• Executed Bi-weekly Sprint database DB Changes in support of Agile App Dev environment and propagated to QUAL and LOAD TEST & CERT using ESP.
• Investigated complex issues and provided solutions under tight SLAs and schedules
• Used DB2 tools to efficiently manage multiple application DBs using APPTUNE, Catalog Manager, Change Manager, OMEGAMON, ESP, Toad, Data Studio etc.

Confidential

Mainframe DB2/IMS DBA

Responsibilities:

• Provided database support for various Confidential Europe applications databases and subsystems.
• Performed various day to day database administration activities that include design, implementation, and maintenance and tuning.
• Monitor physical DBMS for performance and capacity requirements before and after the implementation.
• Implemented procedures, process automation and support tools for standard, repeated tasks used by the DB2 Database Administration.
• Performed Utilities - Reorgs, Run Stats, Unload, Load, Image copy, Refresh, Restore etc.
• Monitored and managed physical space usage of databases
• Provide 24x7 on call support for multiple database applications. Helped in problem resolution when database issues were suspected.
• Performed IMS DBDGEN, PSBGEN, ACBGEN per Application request.
• Executed physical database Changes in support of major database design Changes.
• Managed database accesses, addressed needs for Grant/Revoke and DBADM Authorizations, user creation and object level privileges using Platinum products Performed database maintenance and support activities using IBM/CA utilities. Attended project management meetings to review health of the Databases.
• Executed data refresh / load from Production to Non Production environments
• Supported Confidential application development teams with their Database development needs.

IMS DBA

Confidential

Responsibilities:

• Supported the Database Administration activities required for the Adjudication System of Confidential
• Provided day to day Application DBA support.
• Performed PSB/ACB GEN DB utility requests, Change requests
• Monitored database performance and space utilization and tuned databases
• Created implementation plan and executed implementation tasks for various subsystems (Provider, Member, Benefits etc.)
• Monitored physical DBMS for performance and capacity requirements before and after the implementation.
• Created DB2 jobs for Reorgs and Run Stats, Unload, Load, Image copy, Refresh etc.
• Provided application support, recommended and implemented changes in Production.
• Provided 24x7 On call support for the existing DB2 application.

Confidential

Mainframe DB2 DBA Consultant

Responsibilities:

• Managed and perform physical database maintenance (including running of appropriate utilities, jobs, scripts)
• Performed database reorganization to improve performance, reclaim space, etc.
• Provide 24 x 7 on-call problem resolution DBMS support for production application databases
• Setup and retain use of DBMS system administration ID and privileges Manage database availability and resources, Manage database space
• Performed database support using agreed upon products and/or tools
• Monitoring of physical DBMS for performance and capacity requirements (space and health of objects - Reorg/Runstats requirements)
• Maintained database backup/recovery solution according to Customer's requirements
• Participated in incident reviews as required
• Executed physical database Changes in support of major database design Changes
• Provided time estimates for database related tasks within project plans
• Reviewed all database related Changes as per change management process
• Maintained operational database documentation
• Attended project and service management meetings.
• Executed data refresh / load from Production to Non Production environments
• Executed any Physical DBA named tasks required in Non Production environments
• Reviewed database code as part of data object review
• Defined entities, attributes and relationships and assist in Data modeling
• Provide application upgrade support and Perform Disaster Recovery Drills.

Confidential

Data Analyst

Responsibilities:

• Analyzed the existing Database in order to understand the current process and inputs.
• Conducted workshops and business gathering sessions with business owners and users to design and develop logical data models.
• Created application process documentation and reviewed with Business owners. Defined and created new DB2 database objects (DB2 tables, views, Indexes, columns etc.)
• Updated Data Dictionary, Backup, Copy and reorganization JCL streams to support the changes
• Mainframe Analyst/ETL Designer
• Designed and developed a Data warehouse for Policy and client administration system.
• The task included analysis of DB2/IMS/VSAM Legacy applications, in order to understand current process and design and development of ETL Process flows, Database objects (tables, indexes, views, etc.).

Confidential

Mainframe Programmer

Responsibilities:

• Worked as a Mainframe programmer/Analyst for various clients using COBOL, DB2, IMS DB DC, MVS, VSAM, ISPF, CICS, JCL and various mainframe tools developing/maintaining Batch & Online applications.