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).
• 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 (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.
• 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, Toad

ETL: Informatica, SSIS and SSRS

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

PROFESSIONAL EXPERIENCE

Confidential, New Jersey

Lead UDB DB2 DBA

Responsibilities:

• Hands on primary DBA design & support for establishing, upgrading, and maintaining the DB2 UDB data warehousing environments.
• 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.

Confidential

Senior UDB DB2 DBA

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
• 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.

Confidential

UDB DB2 DBA

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
• DBM configuration parameters, db2exfmt, using Explain Plain, and db2expln tools, and running the reorgchk, reorg, runstats and db2rbind commands.

Confidential

Database Developer

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.