PROFESSIONAL SUMMARY:

• Over 10 years of experience in various aspects of DB2 UDB LUW including physical and logical design, performance monitoring, maintenance, query analysis, optimization, backup and recovery, replication and migration.
• A Certified Database Administrator specializing in IBM DB2 UDB.
• Strong background involving DB2 Database administration on all phases of software development lifecycle i.e. Development, Analysis, Design, Testing and Implementation for various kinds of applications.
• Skilled in database administration tasks like SQL coding, Relational Design, Referential Integrity, Index strategies, and SQL Troubleshooting Using DB2 UDB.
• Having sound knowledge on RDBMS concepts and Database utilities.
• Having strong analytical, reasoning skills and active participation in team activities.
• Performing proactive analysis of infrastructure capacity and performance and Installs, maintains and upgrades the enterprise's production databases.
• Ensures the on - going operability of systems and data solutions in a production environment and responds/resolves production malfunctions.
• Having experience in Installations, maintenance and upgrading the enterprise production databases.
• Extensive experience in supporting SAP DB2 Databases.
• Review and determine required updates to software applications, releases and patches.
• Played a key role in several phases of implementation for various projects in Requirements Gathering, Analysis, Database Configuration and Design.
• Supports multiple servers and multiple databases of medium to high complexity (complexity defined by database size, technology used, system feeds and interfaces) with multiple concurrent users, ensuring control, integrity and accessibility of the data.
• Monitors and refines processes, procedures, and systems to optimize effectiveness, integrity and recommends or implements improvements.
• Ensures maximum uptime and performance of large-scale RDBMS environments and related applications.
• Independently manages projects related to the implementation of new database applications.
• Good Communication and Interpersonal skills. Technically sound, Result-Oriented with strong Problem-solving skills. Innovative & efficient. Capable of working as a Team Member or Individually with minimum supervision.
• Flexible and versatile to adapt to any new environment with a strong desire to keep pace with latest technologies.
• DB2 Installation on AIX, Linux, Unix and Windows.
• SQL Server installation, administration and troubleshooting issues.
• Working knowledge on SAP databases.
• Setting up backup strategies on SQL server based on the requirements and database size.
• Managing and Creating DB2 Instances, Databases and objects like tables, views, schemas, constraints, aliases, and indexes etc. using SQL statements.
• Performing database operations using Control Center.
• Establishing a connection to remote database using Cataloging commands.
• Configuring database manager parameters, database parameters and profile registry variables.
• Managing Tablespaces, Containers, Database Access, Roles and Privileges.
• Monitoring DB2 activities using different tools like Snapshots, Event Monitors and db2top.
• SQL Tuning using db2advisor and db2explain tools.
• Troubleshooting database issues using db2diag, db2pd, db2dart and db2inspect.
• Perform database enhancement and modification as per the requirements.
• Shell scripting experience in UNIX and Linux environments.
• Dealing with the table compression and estimating the compression ratio using db2inspect utility tool.
• Use of Data Movement Utilities in DB2: Export, Import, Load, db2move and db2look.
• Optimizing Data Access using maintenance utilities like REORGCHK, REORG and RUNSTATS in DB2.
• Replicating data between tables using SQL replication process.
• Implementing backup and recovery strategies (online, offline, incremental and delta backups) and Redirected Restore Operations.
• Granting / revoking various authorizations to different Users/Groups.
• Automating Tasks using cron jobs.
• Implemented and managed DB2 Security using OS group and user ID, DB Authentication, DB Authorization, and database object privileges.
• Performing database version Migration and Fix pack upgrade.
• Strong troubleshooting skills and be able to debug most of the DB2 LUW problems.
• Experience in mission-critical operations, ideally within a 24x7 large scale distributed and clustered environment.
• Configured and Worked on HADR.
• Knowledge on WebSphere Application Server, Oracle, IBM Mainframe, IBM InforSphere CDC for DB2, Teradata and UNIX Scripting.
• Knowledge on Database Partitioning Feature, PureScale, DB2 PA, Federation, Table Partitioning, MDC, MQT and Stored Procedures.

TECHNICAL SKILLS:

• Languages:: SQL, Shell Scripting
• RDBMS:: DB2 UDB ESE, EEE V 8.x, V 9.x, V 10.1, Oracle 11g, Sql Server
• Database Tools:: Control Center, DBI monitoring, Ignite DB monitoring, Foglight, Spotlight, Q - Replication, Federation, db2pd, SolMan, Nimsoft, db2top, dsmtop, db2audit, db2haicu, db2dart, db2inspect, MDC, Federation, IBM InforSphere CDC, SQL Optimizer, Topas, SFTP, SCP and SSH, SQLite Database Browser, Optim Performance Manager, InfoSphere Optim Configuration Manager.
• Operating Systems:: AIX 5.x, 6.x, Redhat Linux 4.x, 5.x, UNIX, Fedora, Ubuntu, Windows Server 2008, Solaris
• Other tools:: CVS Tortoise 2009, IBM Datastage, Casewise V2009.2, SQL Workbench, IBM Data Studio, Toad, OEM, Tivoli Workload Scheduler, HP ALM.

PROFESSIONAL EXPERIENCE:

Confidential, MN

DB2 Database Administrator

Environment: DB2 UDB v 10.1/10.5/11.1/11.5, SAP NW 7.4/7.5, AIX 6.1,7.1 UNIX, Linux, Tivoli Workload scheduler, HADR, TSM, NetBackup, HACMP, EMC, Q replication, RHEL 4, WebSphere 8.1, Ignite DB tool, Fog light, Data studio, Windows, Solaris, Sql, ServiceNow, Nimsoft.

Responsibilities:

• Supported 200+ instances and 300+ DB2 databases on LUW in development, test and production environment.
• Troubleshoot the databases using SAP T-codes (db02, db04, st04) and suggest notes implementations where required.
• Perform table moves using db6conv report in SAP to reclaim unused space and performance gains.
• Tuning SQL’s, parameters, bufferpools, indexes to improve the performance.
• Analyzed the queries using Explain tool and tuned them to reduce the time taken for execution.
• Binding the sql statements and run them as a package.
• Analyzed past trends using AIX OS reports and make suggestions to meet future requirements with respect to hardware capacity and performance.
• Worked on converting tablespaces to auto storage and rebalance them to distribute data equally across the containers.
• Performed RUNSTATS utility to update the statistics.
• Performed table/index REORG’s (offline/online) to reclaim the space, cleanup overflows etc.
• Performed analysis on SQL queries using Visual explain and made recommendations to application developers for performance issues.
• Worked on upgrading databases from 9.1 to 9.5 to 9.7 to 10.1 to 10.5 to 11.1 to 11.5 and Fix Pack upgrades.
• Worked on configuring High Availability Disaster Recovery (HADR).
• Database refresh from Production to Non-production databases as per the requirement.
• Used Import, Export, Load and db2move utilities to move the data from different databases.
• Managing the Database and backup of database. Offline Backup, Online Backup, tablespace backup.
• Work and trigger offline backups on databases copied using EMC Clone and db2inidb.
• Worked on configuring database backups to TSM and NetBackup clients.
• Configured Database and Database Manager Parameters as per the requirement.
• Implemented and managed DB2 Security using OS group and user ID, DB Authentication, DB Authorization, and database object privileges.
• Generated DDL Statements using DB2LOOK Utility for recreating the database objects.
• Replicating objects across schema’s using ADMIN COPY SCHEMA.
• Performed table moves using ADMIN MOVE TABLE procedure.
• Experience with Tivoli Workload Scheduler for running the DB jobs and troubleshooting when jobs fail.
• Worked on moving databases across data centers by coordinating with UNIX and Storage teams.
• Monitoring and providing 24x7 supports for production databases.
• Monitored Databases using db2top, dsmtop, MON GET table functions, snapshot monitoring and Event monitoring.
• Coordinating with development/application team to resolve various DB issues.

Confidential, TX

DB2 Database Administrator

Environment: DB2 UDB V9.1/V9.5/V9.7,AIX 6.1, UNIX, HADR, PureScale, DPF, HACMP, SQL server administration, RHEL 4, WebSphere 8.1,IBM Data Studio, IBM Optim Performance Manager, BMC Change Manager, Foglight, Data studio, Windows and Solaris, Sql, Toad.

Responsibilities:

• Supported 100+ instances and 200+ DB2 databases and SQL databases on LUW in production, test, and development environment.
• Involved in SQL server administration activities like backup scheduling, jobs running.
• Implemented backup strategy for various databases in DB2 and SQL.
• Tuning parameters, buffer pools, indexes to improve the performance.
• Analyzed the queries using Explain tool and tuned them to reduce the time taken for execution.
• Binding the sql statements and run them as a package.
• Working on implementing multiple HADR standby servers.
• Performed various admin tasks in PureScale environment.
• Analyzed past trends and make suggestions to meet future requirements with respect to capacity and performance.
• Performed RUNSTATS utility to update the statistics.
• Performed table/index REORG’s (offline/online) to reclaim the space.
• Involved in Tuning of queries which takes more time for execution.
• Performed analysis on SQL queries using Visual explain and made recommendations to application developers for performance issues
• Involved in migrating version 9.1 to 9.5 and Fix Pack upgrades.
• Troubleshoot the database problems using db2diag.log and notify logs.
• Database refresh as per the requirement.
• Have worked on replicating data through InforSphere CDC.
• Used Import, Export, Load and db2move utilities to move the data from different databases.
• Managing the Database and backup of database. Offline Backup, Online Backup.
• Configured Database and Database Manager Parameters as per the requirement.
• Implemented and managed DB2 Security using OS group and user ID, DB Authentication, DB Authorization, and database object privileges.
• Automating routine tasks like backups, load, export/import of data etc. with shell Scripting.
• Generated DDL Statements using DB2LOOK Utility for recreating the database objects.
• Monitoring system with Unix Shell scripts on the Develop, UAT, and Production environment.
• Replicating objects across schema’s using ADMIN COPY SCHEMA.
• Planned and implemented HADR (High Availability Disaster Recovery) environment by preparing Primary database and Standby database, configuring parameter, and cloning the primary database (backing up primary database and restoring to standby database).
• Monitoring and providing 24x7 supports for production databases.
• Monitored Databases using db2top, snapshot monitoring and Event monitoring.
• Capacity monitoring report using Korn shell scripts on DEV, QA(UAT), and PROD system
• Coordinating with development/application team to resolve various DB issues.

Confidential, MN

DB2 Database Administrator

Environment: DB2 UDB V9.1/V9.5/V9.7,AIX 6.1, HADR, RHEL 4, WebSphere Application Server 7.0, HACMP, Installation Manager, Windows, Solaris, TSM, Foglight Performance Analysis, EMC, Toad, IBM Data Studio, SAN,BMC, Spotlight, DB Visualizer.

Responsibilities:

• Supporting 9 applications installed
• Supporting 50+ instances and 150+ DB2 databases on LUW in production, test, and development environment.
• Tuned many queries based on their performance.
• Worked extensively on performance tuning.
• Migrated databases from version 8.1 to 9.5.
• Troubleshoot the database problems using db2diag.log and notify logs.
• Database refresh as per the requirement.
• Implemented backup strategy and troubleshooting related issue.
• Used Import, Export, Load and db2move utilities to move the data from different databases.
• Managing the Database and backup of database. Offline Backup, Online Backup.
• Configured Database and Database Manager Parameters.
• Implemented and managed DB2 Security using OS group and user ID, DB Authentication, DB Authorization, and database object privileges.
• Automating routine tasks like backups, load, export/import of data etc. with Scripting.
• Generated DDL Statements using DB2LOOK Utility.
• Monitoring system with Unix Shell scripts on the Develop, UAT, and Production environment.
• Replicating objects across schema’s using ADMIN COPY SCHEMA.
• Performed RUNSTATS utility to update the statistics.
• Performed table/index REORG’s (offline/online) to reclaim the space.
• Involved in Tuning of queries which takes more time for execution.
• Planned and implemented HADR (High Availability Disaster Recovery) environment by preparing Primary database and Standby database, configuring parameter, and cloning the primary database (backing up primary database and restoring to standby database).
• Monitoring and providing 24x7 supports for production databases.
• Monitored Databases using db2top, snapshot monitoring and Event monitoring.
• Capacity monitoring report using Korn shell scripts on DEV, QA(UAT), and PROD system
• Coordinating with development/application team to resolve various DB issues.
• Escalate issues to higher level where issue resolution is not achieved within a reasonable amount of time.