Name: Ganga Rao Phone: 609-***-****

Role: Lead/Senior DB2 UDB DBA E-mail: :acpb8m@r.postjobfree.com

Professional Summary:

• Over 8+ Years of IT Experience as Lead/Senior Database Administrator in DB2 UDB V8.1,

V9.5, V9.7 on WINDOWS, LINUX and AIX platforms.

• Provide primary DBA design & support for establishing, upgrading, and maintaining the DB2

UDB data warehousing environments.

• Responsible for a wide variety of tasks, including installing, configuring, and maintaining

database and middleware systems, writing relevant processes and procedures, scripting, and

support.

• Extensive experience in DB2 UDB V9 Development.

• Performed database system and SQL performance tuning by rewriting SQL and using

Snapshot, Table Function, Event Monitor, and OS commands( topas, vmstat, and iostat),

updating DB and DBM configuration parameters, using Explain Plain, db2exfmt, and

db2expln tools, and running the reorgchk, reorg, runstats and db2rbind commands.

• Implemented and managed DB2 Security using OS group and user ID, DB Authentication,

• DB authorization, and database object privileges.

• Provide expert assistance in database and SQL statement tuning to improve using software

packages (e.g. BMC Patrol) and/or local scripts, monitor performance, space, DB2 UDB Data

Warehouse database parameters and tune as required.

• Assists developers with debugging of Stored Procedures and Triggers.

• Implements batch schedules for utility processing (Image Copy, Reorg, Runstats and

Modify).

• Performance Tuning of DB2 PURE XML features including XQUERY, XPATH,

XMLTABLE,

• Managing Security on Database objects (groups, users and roles).

• Configure TSM and perform cross node recovery, redirect restore databases.

• Performance this includes, but is not limited to, re-writing SQL statements, creating new

indexes and altering existing indexes.

• Planned, designed, implemented, and promoted the physical databases, table spaces, tables,

views, Indexes.

• Established backup and recovery strategies (Full, Online backup).

• Involved in implementing HADR (High Availability Disaster Recovery ) environment by

preparing Primary database and Standby database, configuring parameter, and cloning the

primary database (back up primary database and restore to standby database).

• Implemented Database Clustering in windows 2008R2 as High Availability techniques and

extensively worked on Active-Passive Fail-Over Clustered environment.

• Database performance tuning and taking care of DB alerts.

• Servers Maintenance related to Financial, Health Care, and Insurance.

• Working on Informatica transformations and SSRS simultaneously.

• Installing DB2 on Linux, Aix and Windows Server and applying fix packs.

• Strong experience on Multi-Partitioned DB2 UDB (EEE/DPF) database systems.

• Experience with data replication, middleware, integration and ETL tools (Informatica, IBM

SQL and Queue Replication etc.) is strongly preferred.

• Data Migration from one Database to another (Ex: SQL Server to DB2/Oracle to DB2...etc.).

• Designed and implemented logical and physical database.

• Planned, Designed, and implemented MQT, and Data partitioning for improving

performance.

• Developed and implemented backup(online, offline), run stats, reorg, rebind, and table

space capacity monitoring report using shell scripts on DEV, QA (UAT), and PRODUCTION

systems.

• Participate in staff rotations of “on-call” responsibilities. Performed DB2 Database Server

migration.

• Work directly with developmental staff and supervise level I database administrators while

implementing applications or packages.

• Experience of db2pd, db2advis, db2expln etc.

• Worked on configuration/troubleshooting federated database environment.

• Performed Database migration/upgrades between multiple versions.

• Ability to adapt quickly to Changing Environments.

• Provided 24 X 7 Production Database On-Call Support.

TECHNICAL SKILLS:

Operating system AIX 6, Linux(Red hat, SUSE), Windows 2008R2

RDBMS DB2 UDB V8/V9

Case Tool Erwin

ETL Informatica, SSIS and SSRS

Language SQL, SQL/PL, Stored Procedure, JAVA, C Language, Shell Script

EDUCATION:

Masters in Computer Applications.

•

PROFESSIONAL EXPERIENCE:

Client : Horizon Blue Cross Blue Shield (BCBS) of New Jersey Mar 2014 – Till Date

Role : Lead UDB DB2 DBA

Description: The project is aimed at providing support in maintaining the Horizon Blue Cross Blue Shield of

New Jersey is best known for our managed care and traditional indemnity plans for individuals and

employers. Horizon performs utilization review and management services for Horizon BCBSNJ customers

receiving mental health and substance abuse treatment. This also evaluates an individual's needs, then finds

the most appropriate care and setting for treatment.

Responsibilities:

• Hands on primary DBA design & support for establishing, upgrading, and maintaining the

DB2 UDB data warehousing environments.

• Worked on database system and SQL performance tuning by rewriting SQL and using

Snapshot, Table Function, Event Monitor, and OS commands(topas, vmstat, and iostat),

updating DB and DBM configuration parameters, using Explain Plain, db2exfmt, and

db2expln tools, and running the reorgchk, reorg, runstats and db2rbind commands.

• Implements batch schedules for utility processing (Image Copy, Reorg, Runstats and Modify).

• Planned, designed, implemented, and promoted the physical databases, table spaces, tables,

views, Indexes.

• Established backup and recovery strategies (Full, Online backup).

• Implemented Database Clustering in windows 2008R2 as High Availability Techniques

extensively worked on Active-Passive Fail-Over Clustered Environment.

• Database performance tuning and taking care of DB alerts.

• Installing DB2 on Linux, Aix and Windows Server.

• Applying fix packs.

• Data Migration from one Database to another (Ex: SQL Server to DB2/Oracle to DB2...etc.).

• Designed and implemented logical and physical database.

• Participate in staff rotations of “on-call” responsibilities.

• Experience of db2pd, db2advis, db2expln etc.

• Performed Database migration/upgrades between multiple versions.

Client : Uttarakhand Power Corporation Ltd Mar 2010 - Jan 2014

Role : Senior UDB DB2 DBA

Description: Restructured-Accelerated Power Development & Reforms Program – Uttarakhand

Power Corporation Ltd, Is a flagship program of Ministry of Power having focus on actual,

demonstrable performance of distribution companies in terms of sustained loss reduction, to establish

reliable and automated systems for sustained collection of accurate base line data, The program is

designed to facilitate adoption of modern technology in the areas of energy accounting as part of the

government’s program of rolling out projects for strengthening distribution.

Responsibilities:

• Provide expert assistance in database and SQL statement tuning to improve.

• Established backup and recovery strategies (Full, Online backup).

• Using software packages (e.g., Ideara & BMC Patrol) and/or local scripts, monitor

performance, space, DB2 UDB Data Warehouse database parameters and tune as required.

• Assists developers with debugging of Stored Procedures and Triggers.

• Performed database system and SQL performance tuning by rewriting SQL and using

Snapshot, Table Function, Event Monitor, and OS commands(topas, vmstat, and iostat),

updating DB and DBM configuration parameters, using Explain Plain, db2exfmt, and

db2expln tools, and running the reorgchk, reorg, runstats and db2rbind commands.

• Planned and implemented batch schedules for utility processing (Image Copy, Reorg,

Runstats and Modify) performance this includes, but is not limited to, re-writing SQL

statements, creating new indexes and altering existing indexes.

• Designed, planed, implemented, and promoted the physical databases, table spaces, tables,

views, Indexes.

• Provided 24 X 7 Production Database On-Call Support.

Client : IDHA Soft Ltd Feb 2008 – Mar 2010

Role : UDB DB2 DBA

Description: IDHA Soft Ltd is a leading Software Company. Designed and developed IDHA

Healthcare Management Information Systems (IHMIS) for Healthcare Organizations to provide the

finest automation and messaging systems. The solution has been designed keeping in mind today’s

complex processing requirements and stipulations. The system is reliable and scalable.

Responsibilities:

• Managing Security on Database objects (groups, users and roles).

• Trouble shooting on stored procedures, triggers and altering database objects.

• Configure perform cross node recovery, redirect restore databases.

• Data Migration from one Database to another (Ex: SQL Server to DB2/Oracle to DB2...etc.).

• Designed and implemented logical and physical database.

• Implemented, Designed, and MQT, and Data partitioning for improving performance.

• Planned, designed, implemented, and promoted the physical databases, table spaces, tables,

views, Indexes.

• Established backup and recovery strategies (Full, Online backup).

• Worked on database systems and SQL performance tuning by rewriting SQL and using

Snapshot, Table Function, Event Monitor, and OS commands(vmstat, iostat and topas),

updating DB and DBM configuration parameters, db2exfmt, using Explain Plain, and

db2expln tools, and running the reorgchk, reorg, runstats and db2rbind commands.

Client : Task Hub Pvt Ltd Jan 2007 – Dec 2007

Role : Database Developer

Description: Task Hub is a total business solution that incorporates business process management

together with ERP. Developed in a J2EE environment, Task Hub enables excellent dissemination of

information as well as co-ordination between the various functions such as Sales, Purchases,

Logistics, Warehouse management, Account Payables, Account Receivables, Work Order, Trade

Finance and Human resource in the organization. It also has different type of Reports, based on

Accounts Receivables, Accounts Payable and Sales Analysis.

Responsibilities:

• Assists developers with debugging of Stored Procedures and Triggers.

• Implements batch schedules for utility processing (Image Copy, Reorg, Runstats and Modify)

performance this includes, but is not limited to, re-writing SQL statements, creating new

indexes and altering existing indexes.

• Planned, designed, implemented, and promoted the physical databases, table spaces, tables,

views, Indexes.

• Established backup and recovery strategies (Full backup)

• Creating tables, views, triggers, store procedures, cursors, indexes, schemas and managing

table spaces for availability of database.

Contact this candidate