Manager Project

POOJA JADHAV

SUMMARY

Pooja is a motivated, versatile DB2 Database administrator with 5 yrs. of experience in Mainframe Database Administration (ZOS platform). Her emphasis in database administration is on technical skills, taking initiatives, excellent communication and understanding client’s requirements and fulfilling them before deadlines. She has excellent experience with Database Administration, maintenance & Production, Application support 24*7env,Job Monitoring, Develop physical & logical DB, Performance Tuning, Data refresh, Data movement, DB2 objects physical structure creation, modification. She has managed database distribution, security, and access. She is responsible for database integrity, database backup and recovery by running data maintenance online & standalone IBM utilities, BMC utilities. She has build complete new environment using BMC tools. She has done Performance tuning using IBM & BMC tools.She has very knowledge in analysis the data & implements the required physical, logical structural changes in DB structure. She was involved in improving, SQL programming, provide performance monitoring and tuning recommendations, cost estimates on client requirement. As a team member she was responsible to identify and correct software errors, which include defining, determining the cause, formulating solutions and implementing them through Change Management process, ITIL process. She is highly motivated with strong commitment to quality and customer service.

TECHNICAL SKILLS

Database : DB2 Z/OS, Teradata

Languages : JCL, SQL, COBOL

Other Tools : IBM DB2 Admin tool, BMC Tools Change Manager, Recovery Manager, Catalog Manager, DASD manager, CHANGEMAN, SQLPA (Performance analyzer),SPUFI, QMF, TSO, ISPF, ITSM (Ticket tracking tool), Remedy,ESP schedular

Utilities : All Online and Standalone IBM utilities, BMC Utilities

Job Functions : Mainframe Production support & Application support, Database Administration on Z/OS

Others : Knowledge of ITIL & Change Management Process (Configuration Management)

EMPLOYEMENT HISTORY:

Senate Technologies INC,Florida

Amdocs DVCI, India

Patni Computer System, India

Fujitsu Consulting India Pvt Limited

Futurism Technologies Pvt Limited, India

EXPERIENCE

Client: Frontier,Piscataway,NJ Dec 2010 – Till Present

Position Title: Sr.DB2 Database Administrator

• Production & Application Support, maintenance of existing DB2 system infra-structure & application databases

• Design & developed complete new environment using BMC tools. Scheduled new backup & recovery jobs.

• Running All Online and standalone IBM Utilities i.e. Unloading, Loading, Reorg,DSN1COPY,etc and collecting statistics for the same

• Running all BMC utilities. Compare and migration of structures of different environments using BMC tool,Change Manager,Catalog Manager,Recovery Manager,etc.

• Communicate with developers & users regarding their issues & provide solutions.

• Review Physical & logical data design & create new DB2 objects or modify existing, define stored procedures. Bind plans & packages.

• Analyze data & develop and execute appropriate DDL to support projects.

• Defining stored procedures and creation of stored procedures

• Authorization and privileges for DB2 access

• Check database status, monitor daily,monthly batch cycle, resolve any job abends in production environment

• Responsible for database integrity & database backup and recovery.

• Provide query performance monitoring and tuning recommendations, cost estimates, tuning using SQL P/A, DB2 Explain utilities

• Removing the restriction of pending status against DB2 object. Backup and Recovery of Db2 objects. Data refresh & maintenance.

• Removing the restriction using Pre and Post trail image copies & .Removing pending status against DB2 objects

• Provide change management and documentation for database changes.

• Creating production packages using CHANGEMAN tool.

• Carry out troubleshooting and debugging using industry best practices for any problem found in the operation of DB2 Databases.

• Timely resolve & respond technical problems with the database.

• Health checks.

Client: AT &T, St. Louis, MO Dec 2009 – Dec 2010

Position Title: Sr.DB2 Database Administrator

• Production & Application Support, maintenance of existing DB2 system infra-structure & application databases

• Review Physical & logical data design & create new DB2 objects or modify existing, define stored procedures.Bind plans & packages.

• Analyze data & develop and execute appropriate DDL to support projects.

• Defining stored procedures and creation of stored procedures

• Authorization and privileges for DB2 access

• Running All Online and standalone IBM Utilities i.e. Unloading, Loading, Reorg,DSN1COPY,etc and collecting statistics for the same

• Running all BMC utilities. Compare and migration of structures of different environments using BMC tool.

• Check database status, monitor daily batch cycle, resolve any job abends in production environment

• Responsible for database integrity & database backup and recovery.

• Provide query performance monitoring and tuning recommendations, cost estimates, tuning using SQL P/A, DB2 Explain utilities

• Removing the restriction of pending status against DB2 object. Backup and Recovery of Db2 objects. Data refresh & maintenance.

• Removing the restriction using Pre and Post trail image copies & .Removing pending status against DB2 objects

• Provide change management and documentation for database changes.Creating production packages using CHANGEMAN tool.

• Carry out troubleshooting and debugging using industry best practices for any problem found in the operation of DB2 Databases.

• Timely resolve & respond technical problems with the database.

• Health checks.

Client: MetLife, Somerset, NJ Dec 2008 – Nov 2009

Position Title: DB2 Database Administrator

Role:

• Analyzing the Requirements of project/work requests using ITSM

• Authorization and privileges for DB2 access & troubleshoot issues with DB2 embedded within COBOL programs

• Usage of database catalogs. Package approval & creation.

• Database performance tuning using SQL P/A, DB2explain utilities.

• Unloading, Loading the database, Reorg and collecting statistics for the same

• Reorganization of Table space &Collecting Statistics using Runstats

• Removing the restriction of pending status against DB2 objects

• Running Online and standalone Utilities

• Backup and Recovery of Db2 objects

• Compare and migration of structures of different environments

• Develop and execute Data Definition Language (DDL) to support projects

• Providing DBA approval for production packages

• BMC Tools includes Recovery/DASD/CATALOG&CHANGEMAN / DB Admin Tool

• Carry out troubleshooting and debugging using industry best practices for any problem found in the operation of DB2 Data Bases.

• Health Checks for many applications

Client: Rockwell Automation,Canada Nov 2007 – Dec 2008

Position Title: Application Developer & DB2 Database Administrator

Role:

• Handling client requests by supporting the application issues, development and testing the solution and then implementing it.

• Implementing the changes through RFC (Request for change) process

• Creating the standard implementation plan, testing results documents

• Unloading, Loading the databases and collecting statistics for the same

• Running standalone and online utilities. Reorganization of Table space & collecting statistics using Runstats

• Removing the restriction of pending status against DB2 objects

• Backup and Recovery of Db2 objects

• Compare and migration of structures of different environments

• Develop and execute DDL to support projects

• Providing DBA approval for production packages

• Analyzing the Requirements of project/work requests using ITSM

Client: Futurism Technologies Pvt Limited, India Sep 2006 –Oct 2007

Position Title: Application Developer & DB2 Database Administrator

Role:

• Analyzing and Gathering and documenting Requirements as per client by directly interacting with them.

• Impact Analysis of the changes.

• Identify and document job processes and problems using structured, analytical skills.

• Modifying the existing program as per the Requirements.

• Identifying the bugs in the existing system.

• Implementing the change through RFC (Request for change).

• Creating the standard implementation plan, testing results documents.

• Communicates project status and problems to Project Manager.

Education/Certification

• Bachelor of Engineering Pune University.(2006)

• Mainframe Application Certification.

• Change Coordinators Certification.

• DB2-DBA certification.

• Teradata internal training.

• Achievement in Rockwell Project: Received Appreciation certificate from VP of Fujitsu consulting India ltd.

Contact this candidate