Mohamed Shajahan

abhhkp@r.postjobfree.com

862-***-****

DATABASE ADMINISTRATOR – DB2 FOR Z/OS

Dynamic and accomplished professional with 10+ years of experience in IT industry

OBJECTIVE: Proactive decision maker, seeking to be a Senior Database Administrator/Program

Manager/Delivery Manager with a well established and globally reputed organization.

DATABASE ADMINISTATOR ROLE RESPONSIBILTIES

Worked as the Primary DB2 for Z/OS Database Administrator in the Centralized Database

Administration Team for Prudential and Lloyds Bank and as a backup DBA for DB2 LUW.

Efficient Team Leader with sound communication, interpersonal, negotiation and problem solving skills. Also

very good analytical, leadership and multiple task managing capabilities.

Involved extensively in Performance Tuning of Application SQLs.

o Good knowledge on IBM’s Performance Tools like Data Studio, Visual Explain and Platinum

Detector for Z/OS

o Sound knowledge on PLAN_TABLE – and manual EXPLAIN, to survive in the world of No

Performance evaluation tools

Sound knowledge on Database Administration Utilities – like COPY, UNLOAD, LOAD, REORG,

RUNSTATS, MODIFY, REBUILD, REPAIR, CHECK, QUIESCE, RECOVER, STOSPACE.

Played a key role in Upgrade of 3 DB2 Versions – from DB2 V7 to DB2 V8, DB2 V8 to DB2 V9, and DB2

V9 to DB2 V10 in Prudential Insurance Co. Of America

Worked in changing Logical Data Model to Physical Data model, using ERwin to design Database objects for

applications from scratch. Also to enhance existing relational databases.

Worked in IBM Websphere Replication Server for Z/OS. Setting up Capture, Apply tables for replication of

data

Worked in Infosphere Q Replication for Z/OS – that replicates data from 4 instances to an Operational Data

store.

Worked on Sybase to DB2 Migration project in transforming a large number of Stored Procedures for a

Group Insurance application.Also worked on a DB2 Z/OS to DB2 LUW Migration to retired a Legacy

application

Career Highlights

Played a major role in the design of a Performance Monitoring System for DB2 applications

•

Involved in Performance Tuning of DB2 Queries and saved more than half a million dollars in CPU Time for

•

Prudential

Planned, Designed and executed the DB2 Version 8 and Version 9 upgrade for DB2 Z/OS. Currently

•

involved in DB2 V10 Migration

Primary DBA for a 24 x 7 mission critical application – with volumes ranging in 100 200 millions.

•

Career Overview

Acting as Senior DBA with good knowledge on Database, and supporting multiple application teams across

•

Prudential

Acting as a Lead managing different applications to successfully deliver projects of various sizes.

•

Recommending efficient System solutions for

•

o Critical Reports

o Projects involving cleaning up of large amount of data.

o Projects involving update of large amount of data

Performing Database Requirement Analysis, Database Design.

•

Maintained Database Security by providing proper authorities and privileges.

•

Developing Data Definition Language for implementation across End to End, QA, UAT and Production

•

Performing proactive Database Maintenance, Improving Space Utilization and thereby cost

•

Conducting volume testing, performance tuning

•

Providing periodical status report including plan, progress and risks to the stakeholders to ensure smooth

•

progress of project activities.

Periodically monitoring & improving system performance.

•

Mentoring & training junior DBAs to attain overall project & organizational objectives.

•

Conducted business & system impact analysis, risk assessment, end to end effort estimation.

•

Translated business requirements into detailed specifications and managing design & development activities.

•

Academics

Bachelor of Engineering (Computer Science and Engineering), University of Madras

•

Technical Skill set

Database & Tools : DB2 for Z/OS, SPUFI, QMF,Platinum Detector,Data Studio, BMC Change Manager

•

Languages : COBOL, JCL, Rexx, ISPF Panels, VB.NET(Developed a small application)

•

Operating Systems : MVS,OS/390

•

File Management : VSAM, File Aid

•

Communication : CICS, TSO/ISPF

•

Other Tools : Changeman, Strobe, Omegamon

•

Application Package : MS Office (Excel, PowerPoint, Word), MS Visio

•

Professional Experience

Annexure

#1 Project : ADM DBA Group

Platform : Z/OS 390

Software/Tools : DB2 Utilities

Database : DB2 Z/OS V8, DB2 Z/OS V 10

Duration : Jan 2013 to Till Date

Client : Lloyds Banking Group (New York, NY)

Designation : Senior Database Administrator/Architect

Description

Lloyds Bank is one of the largest Bank in the United Kingdom, providing a range of Banking and Financial products.

Lloyds built an Operational data store, to store transaction data of different types using a product called Financial

Transaction Manager.

ADM DBA group is a centralized group of Database Administrators for LLoyds that supports databases of huge volume.

Working as an active member of this team, supporting applications that use DB2 Z/OS databases.

Role in Projects:

Working as a DB2 Specialist/Architect and since this operational data store is in the receiving end, analyses the

impact w.r.t DB2

Database Administrator for Development, SIT, ST, OAT Databases.

Involved in the Database Requirement Analysis, Database Design.

Creation of Database objects like Tablespace, Tables, Indexes, Views, Stored Procedure, Triggers

implementation across Development, QA, End to End, User Acceptance databases.

Coordinating implementation of Database Objects in Production Databases

Running Backup Image Copies, Unload at regular intervals or on an On Demand basis.

Restoring Database or specific tables, with Image Copies, Unload Files

Maintained Database Security by providing proper authorities and privileges.

Performing REORG, RUNSTATS, MODIFY and other maintenance activities for all the databases at regular

intervals.

Analyzing Performance Problems for different application SQLs, using Plan Tables, Visual Explain, Detector

etc.

Tuning the existing SQLs, Suggesting Indexes to save the CPU time and the Run Time.

Working on Tools like BMC Change Manager, CA Detector, SQL Explorer which helps in the definition and

performance monitoring

DB2 Migration

o Documenting the new features of DB2 V9, V8 based on the upgrade

o Coordinating with application teams, to benchmark performance and functionality in lower version.

Compare, analyse the performance in the upgraded version

Performing the following activities as a backup DBA for DB2 UDB on AIX 6

o Enhanced application performance by running RUNSTATS, REORGCHK and REORG utilities.

o Insert data into application tables using IMPORT command and LOAD Utility

o Recover data to a particular point using ROLL FORWARD command

#2 Project : DBA Technology Group

Platform : MVS, Z/OS 390

Software/Tools : DB2 Utilities

Database : DB2 Z/OS V8, DB2 Z/OS V 9

Duration : October 2007 – Dec 2012

Client : Prudential Insurance Company of America, (Newark, NJ)

Designation : Senior Database Administrator

Description

Prudential Insurance Company of America is one of the largest Insurance Companies in the United States, providing a

range of Insurance, Investment Management and Other Financial Products.

DBA Technology group is a centralized group of Database Administrators for Prudential that supports a huge number of

databases, across a variety of systems that include DB2 Z/OS, DB2 UDB, Oracle, SQL Server 2005, and Sybase.

Working as an active member of this team, supporting applications that use DB2 Z/OS databases.

Role in Projects:

Database Administrator for Development, Quality Assurance, End to End and User Acceptance Databases.

Involved in the Database Requirement Analysis, Database Design.

Database objects like Tablespace, Tables, Indexes, Views, Stored Procedure, Triggers implementation across

Development, QA, End to End, User Acceptance databases.

Coordinating implementation of Database Objects in Production Databases

Running Backup Image Copies, Unload at regular intervals or on an On Demand basis.

Restoring Database or specific tables, with Image Copies, Unload Files

Maintained Database Security by providing proper authorities and privileges.

Performing REORG, RUNSTATS, MODIFY and other maintenance activities for all the databases at regular

intervals.

Analyzing Performance Problems for different application SQLs, using Plan Tables, Visual Explain, Detector

etc.

Tuning the existing SQLs, Suggesting Indexes to save the CPU time and the Run Time.

DB2 Migration

o Documenting the new features of DB2 V9, V8 based on the upgrade

o Coordinating with application teams, to benchmark performance and functionality in lower version.

Compare, analyse the performance in the upgraded version.

#3. Project : Agencies Database System

Platform : MVS,Z/OS 390

Software/Tools : DB2 Utilities

Database : DB2 Z/OS V8, DB2 Z/OS V 9

Duration : September 2005 – September 2007

Client : Prudential Insurance Company of America,(INDIA)

Designation : Database Administrator/Team Lead

Role in Projects:

Database Administrator for Development, Quality Assurance, End to End and User Acceptance Databases.

Involved in the Database Requirement Analysis, Database Design.

Database objects like Tablespace, Tables, Indexes, Views, Stored Procedure, Triggers implementation across

Development, QA, End to End, User Acceptance databases.

Coordinating implementation of Database Objects in Production Databases

Running Backup Image Copies, Unload at regular intervals or on an On Demand basis.

Restoring Database or specific tables, with Image Copies, Unload Files

Performing REORG, RUNSTATS, MODIFY and other maintenance activities for all the databases at regular

intervals.

Maintained Database Security by providing proper authorities and privileges.

Analysis, Design and SQL Coding

Worked in all phases of Software Development Life Cycle

Involved in Analysis of Business Requirements, Project Estimation and Resource Planning.

Involved in Preparing System Design Document, Installation Guidelines and Detailed Test Plan.

Involved in high level design for major projects.

#4. Project : Agencies Database System

Platform : Z/OS 390

Software/Tools : DB2 Utilities

Database : DB2 Z/OS V8, DB2 Z/OS V 9

Duration : September 2004 – August 2005

Client : Prudential Insurance Company of America, (INDIA)

Designation : Application Team Lead

Description

Prudential Insurance Company of America is one of the largest Insurance Companies in the United States, providing a

range of Insurance, Investment Management and Other Financial Products.

Agencies Database System houses the information of all the agents involved in various channels of sale. The data flows

into the system using the Online CICS transactions, which involves approximately 400 user screens.

Data migrated into the system is passed to the downstream systems using the VSAM File, and is accessed by 80

downstream systems.

Role in Projects:

Worked as a Tech Lead

Involved in the Database Requirement Analysis, Database Design.

Worked as a Module Leader and lead a team of 10 associates.

Worked as a Module Leader for Production Core Remedy Fix team.

Involved in Analysis of Business Requirements, Project Estimation and Resource Planning.

Involved in Preparing System Design Document, Installation Guidelines and Detailed Test Plan.

Involved in high level design for major projects.

Development of new Mainframe Application Programs(CICS DB2 and COBOL DB2)

Review the work items developed by the team members

Development, Testing and Documentation of all the projects.

Coordinating the Business Requirements, Delivery with the Onsite Team.

#5. Project : Yeni Turkish Lira Conversion

Platform : MVS, Z/OS 390

Software/Tools : DB2 V8.1

Database : COBOL, JCL, VSAM, CICS

Duration : April 2004 – September 2004

Client : Yapi Ve Kredi Bankasi(INDIA)

Designation : Developer

Description

Central Bank of Turkey announced that the Turkish Lira has to be re denominated on 1st of January 2005 by dropping six

zeroes off the currency. The Multiple Zeroes cause difficulties in Expressing Monetary Values, Transaction at the

Cashier’s Office, Book Keeping and Statistical Records, Payment System, Price Tagging and many other areas of day to

day life from Taxi meters to Gas Stations.

Role in Projects:

Worked as a Team Member

Involved in the Database Requirement Analysis, Database Design.

Involved in Analysis of Business Requirements, Project Estimation and Resource Planning.

Development/Enhancement of Mainframe Application Programs(CICS DB2 and COBOL DB2)

Development, Testing and Documentation of all the projects.

Coordinating the Business Requirements, Delivery with the Onsite Team.

Contact this candidate