Database Sql Server
Resume:
Name: Ganga Rao Phone: 609-***-****
Role: Lead/Senior DB2 UDB DBA E-mail: :***********@*****.***
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