SUMMARY:

• Customer - focused IT professional, expert in leading and contributing to projects designed to enhance system functionality and end-user productivity. A tenacious trouble shooter and a skilled Database Administrator who possess strong interpersonal skills with the ability to interact with Application development and System DBA teams. Acknowledged for capacity to tackle challenging issues, and provide innovative solutions that reside well within clients' financial and time frameworks
• Overall 30 years of Mainframe IT experience. For the last 15 years working as a DB2 Database administrator
• Worked in several fast paced projects, highly experienced in working with very large and complex Database applications.
• Well versed in providing 24x 7 production support for mission critical applications.
• Extensive experience in CA/IBM/BMC/Compuware DB Utilities and various performance turning tools.
• IBM Certified Confidential DB2 DBA (zDB2 v8 - v10)
• Experienced in Data Warehouse/ETL Design and Development.
• Production support and Database administration experience in Federal government, Automotive, Healthcare, Manufacturing and Banking projects.
• 4 years of IMS DBA support experience.

HARDWARE/SOFTWARE:

IBM: Many generations of IBM mainframes and their peripherals, from IBM 360 to Confidential platforms, AS/400, Sun, IBM Unix, Linux & AIX servers. DB2 v11, 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, CA (Platinum), CA Detector, BMC MainView, CA SYSVIEW, IBM CLONING TOOL, DASD MANAGER, Data Studio, Compuware Utilities and Administrative tools, JES2, ACF2, RACF, CA7, TMS, COBOL, CICS, BMS,VSAM, FILEAID, DB2 Stored Procedures, CHANGEMAN, ENDEVOR, INTERTEST, XPEDITOR, SAR, QUICK REFERENCE, Confidential SERVICE MANAGER, CA HELP DESK, ERWin Data Modeler, FTP, JCL, SYNCSORT, Visio, various MS Office products

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Develop and implement complex changes impacting several processes with minimal direction.
• Design, develop and deploy database objects as part of the Application change Control release based on customer requests on time.
• Monitor applications, interact with Application teams to resolve various database and performance issues using BMC and CA tools
• Create/maintain new processes and reports that improve reliability and task performance.
• Provide support for System and DBA tool upgrades and performance improvements.
• Execute DB2 Data refresh activities for CERT systems.
• Responsible for DB utility support and maintenance reports in order to provide optimal run-time performance.
• Provide 24x7 on call support for multiple database applications. Participate in all aspects of the DBA decision-making process along with application Dev team.
• Participate in DB2 Version 11 upgrade activities. Perform SQL code/performance and design reviews requested by the Application teams.
• Other responsibilities include DR, Review EXPLAIN results, improve Space allocations, DB2 Utility job improvements, Tune DSNZ Parms and other System resources.
• Create/maintain new processes and reports that improve reliability and task performance.
• Effectively use DB administration tool such as BMC Change MANAGE, CA SYSVIEW, IBM Cloning tool, Toad, CA Detector, Log Analyzer, OMEGAMON,CHANGEMAN, CA7, SMF, File Aid for DB2, SPUFI,QMF, QW Stored Procs, Triggers

Confidential

Responsibilities:

• Supported and Administered large scale data sharing DB2 databases (stored in 40 identical databases) in a 24X7 highly available, scalable Agile distributed 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 40 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.
• Created and executed various health check and Trend analysis reports.
• 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, Power Designer, UDF/RMF Data Studio, Native SQL Procedures, Dynamic SQL, Triggers, JAVA, WebSphere

Confidential

Mainframe IMS/DB2 DBA consultant

Responsibilities:

• Provided database support for various Confidential applications databases and subsystems.
• Performed various day to day database administration activities that include design, implementation, and maintenance and Performance tuning.
• Performed Database changes using CA/BMC tools and ERWIN Data Modelling tool
• 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 GM application development teams with their Database development needs.
• Performed database maintenance and support activities using IBM/Compuware utilities and monitoring using BMC-DB2Mon. Attended project management meetings to review health of the Databases.

DB2 DBA

Confidential, Pontiac MI

Responsibilities:

• Managed and perform physical database maintenance (including running of DB 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
• Created Stored PROCs and triggers for various applications and tables per customer request
• 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
• Provide application upgrade support and Perform Disaster Recovery Drills.
• Executed data refresh / load from Production to Non Production environments