Data Support

MELVIN MICHAEL

Bentonville, AR *****, 479-***-****, ******.*******@*****.***

PROFESSIONAL SUMMARY

• Over 13 years of experience in IT industry as Mainframe Db2 z/OS database administrator in V8, V9, V10, V11 and V12.

• Hands on experience in maintaining complex data sharing environment, consisting of 6 sysplexes and over 25+ LPARs

• Thorough understanding on relational database concept

• Expertise in SQL query tuning thus helps reduce MIPS consumption

• Design, develop, build, and monitor through automation on database backup strategies for healthy system

• Designed and build Dynamic statement cache process to capture dynamic SQL queries

• Designed automation to capture DBATs as part of monitoring DBAT connection

• Proficiency in Db2 serialization and in application deadlock / timeout issues

• Expertise in handling Db2 utilities

• Worked extensively in maintaining security and integrity of data

• Exposure to Db2 maintenance and upgrade

• Understanding on SMPE concepts

• An excellent team player and a mentor

• Worked on Db2 connect

• Knowledge in IMS database administration

• Experience in working 24*7 environment and provide application support SKILLS

• DB2

• SQL

• JCL

• REXX

• UNIX commands

• RC-Migrator

• RC-QUERY

• RC-UPDATE

• Detector

• Log Analyzer

• Mainview

• SPUFI

• Admin tool

• QMF

• Service now

• Remedy7

• JIRA

• SMPE

• IMS

CAREER SUMMARY

Sr. Lead DBA, Brillio LLC.

Client: IBM-Walmart

Aug 2009 – present

During this tenure, provides 24/7 support to Mainframe DB2 z/OS databases of one of the world’s largest retailers, at Bentonville, AR location. Supports complex data sharing environment consists of 25+ LPARs and over thousands of databases. Roles and Responsibilities:

• Provides 24/7 support to production and development database and db2 system related issues

• Performance tuning of SQL queries

• Design and implement new data objects

• Perform database utilities as and when needed

• Maintain Db2 database backup and develop recovery strategy

• Db2 system tuning – DBATs, Buffer pool, Sort workspace, RID pool, EDM pool

• Liaising with application programmers and help resolve database related issues

• Maintain the security and integrity of data

• Troubleshoot and root cause analysis of issues

• Monitor data objects size and perform the necessary operation

• Monitor system related activities like – DBATs, EDMPOOL, RID pool, Buffer pool, Sort work file usages and perform necessary analysis/ operation

• Worked on Db2 connect and perform database catalog

• Exposure to Db2 system maintenance and upgrades

• Knowledge on SMPE concepts

• Performs catalog of db and node directories and install db2 drivers

• Provides support IMS database related issues

Technical Associate, Tech Mahindra, India

Client: British Telecom

Jan 2007 – July 2009

During the tenure, provided Mainframe Db2 on z/OS database support to British Telecom. Roles and Responsibilities:

• Creating / Alter of database objects

• Perform Backup and Recovery

• Perform disaster recovery

• Bind / re-bind db2 plan package.

• Execute Db2 utilities like Reorg, Runstats, COPY, MODIFY, LOAD, UNLOAD, DSN1COPY, Check Data etc.

• SQL query tuning

• Provide 24*7 support to production databases

• Liaising with application developers and helps troubleshoot database related issues and improve application process

EDUCATIONAL QUALIFICATION

Bachelor of Engineering in Electronics & Communication Visveswaraiah Technological University, Belgaum, Karnataka, India Aug 2002 – July 2006

Contact this candidate