SUMMARY

• A Certified Database Administrator specializing in IBM DB2 UDB with overall 8+ 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.
• 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.
• Played a key role in several phases of implementation for various projects in Requirements Gathering, Analysis, Database Configuration and Deisgn.
• 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.
• 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.
• Establising 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.
• 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, anddatabase objectprivileges
• Performing database version Migration and Fixpack upgrade.
• Configured and Worked on HADR
• Knowledge on WebSphere Application Server, Oracle, Teradata and UNIX Scripting.
• Knowledge on DPF, Purescale, DB2 PA, Table Partitioning, MDC, MQT and Stored Procedures.

TECHNICAL SKILLS

Languages: C, C++, SQL, Shell Scripting

RDBMS: DB2 UDB EEE, WSE V 8.x, V 9.x, V 10.1, Oracle 11g, Sql Server

Database Tools: Control Center, Foglight, Spotlight, Q-Replication, Federation, db2pd, DB2 Connect, SQL Optimizer Topas, SFTP, SCP and SSH.

Operating Systems: AIX 5.x, 6.x, Redhat Linux 4.x,5.x, Unix, Windows Server 2008, Solaris

Other tools: CVS Tortoise 2009, Casewise V2009.2

PROFESSIONAL EXPERIENCE

Confidential, Irving, TX

DB2 Database Administrator

Environment: DB2 UDB V9.1/V9.5/V9.7,AIX 6.1, HADR,DPF, HACMP, SQL server administrationRHEL 4, WebSphere 8.1, Foglight, Data studio, Windows and Solaris.

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, 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 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.
• 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, anddatabase objectprivileges.
• Automating routine tasks like backups, load, export/import of data etc. with Scripting.
• Generated DDL Statements using DB2LOOK Utility for recreating the database objects.
• Monitoring systemwith 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 PrimarydatabaseandStandby database, configuring parameter, and cloning the primarydatabase(backing up primarydatabaseand restoring tostandby database).
• Monitoring and providing 24x7 supports for production databases.
• Monitored Databases using db2top, snapshot monitoring and Event monitoring.
• Capacitymonitoringreport using Korn shell scripts on DEV, QA(UAT), and PROD system
• Coordinating with development/application team to resolve various DB issues.
• Escalate issues to a higher level where issue resolution is not achieved within a reasonable amount of time.

Confidential, Minnetonka, MN

DB2 Database Administrator

Environment: DB2 UDB V9.1/V9.5/V9.7,AIX 6.1, HADR, RHEL 4, WebSphere 7.0, HACMP, Windows and Solaris

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 trouble shooting 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, anddatabase objectprivileges.
• Automating routine tasks like backups, load, export/import of data etc. with Scripting.
• Generated DDL Statements using DB2LOOK Utility.
• Monitoring systemwith 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 PrimarydatabaseandStandby database, configuring parameter, and cloning the primarydatabase(backing up primarydatabaseand restoring tostandby database).
• Monitoring and providing 24x7 supports for production databases.
• Monitored Databases using db2top, snapshot monitoring and Event monitoring.
• Capacitymonitoringreport using Korn shell scripts on DEV, QA(UAT), and PROD system
• Co-ordinating with development/application team to resolve various DB issues.
• Escalate issues to a higher level where issue resolution is not achieved within a reasonable amount of time.

Confidential, Chicago, IL

DB2 Database Administrator

Environment: DB2 UDB V8.2/V9.1/V9.5,AIX 6.x, HADR, Q-replicaiton, Foglight Performance Analysis, Toad, RHEL 4, WebSphere 7.0, HACMP, Windows and Solaris

Responsibilities:

• Installed DB2 UDB ESE V9.1 on AIX, Linux and Windows, created instances and databases on different servers and provided connectivity to development, test, staging and production databases.
• Expertise in SQL tuning, DB/DBM parameter tuning, different levels of memory allocations, various tools like export, import, load, autoloader and experience with all kinds of database snapshots.
• Creating and Monitoring Users, authorities and responsibilities and password management.
• Developed automated scripts using Unix Shell and Perl for performing RUNSTATS, REORGCHK, REORG, REBIND, BACKUP, LOAD, PRUNING, TABLESPACE THRESHOLDS and other related to database activities and used Cron for scheduling.
• Enhanced application performance by running RUNSTATS, REORGCHK and REORG utilities.
• Monitored and managed disk space, I/O contention.
• Setup and monitored Replication between Operational Database and Reporting Database.
• Clear understanding of relationships between the databases with the help of (RDBMS) Relational Database Management Systems.
• Designed and implemented backup and restore procedures.
• Monitored databases using database monitors, snapshot monitoring and event monitoring.
• Performing full version Upgrades and applying Fixpacks when necessary.
• Generated reports of database structure using DB2LOOK Utility.
• Recovered data to a prior point in time using ROLLFORWARD command.
• Implementing capacity planning and partition table/index for very large and fast growing tables.
• Recovering the database using High Availability & Disaster Recovery (HADR) techniques.
• SQL tuning and query optimization.
• Day-to-day attending to user queries in sorting out database problems.
• Coordinating with user departments and attending their requirements for smooth functioning.
• Upgraded instances regularly with latest fixpacks and alternate fixpacks.

Confidential Communications, India

Database Administrator

Environment: DB2 UDB V8.2/V9.1,Red Hat Enterprise Linux 4, WebSphere v6.1, SAP, Windows

Responsibilities:

• Supported 50 instances and 80 DB2 databases on LUW in production, test, and development environment.
• Database installations on AIX servers.
• Performed RUNSTATS utility to update the statistics.
• Involved in Tuning of queries which takes more time for execution.
• Involved in Fix Pack upgrades.
• Trouble shoots the database problems using db2diag.log.
• Database refresh as per the requirement.
• Developed and implemented backup (online, offline), runstats, reorg, rebind, and tablespace.
• Worked on creating instances using db2icrt command, and also created databases inside the instances.
• Used Export and Load utilities to move the data from different databases.
• Managing the Database and backup of database. Offline Backup, Online Backup.
• Capacitymonitoringreport using Korn shell scripts on DEV, QA(UAT), and PROD system
• Configured Database and Database Manager Parameters.
• Automating routine tasks like backups, load, export/import of data etc. with Scripting.
• Generated DDL Statements using DB2LOOK Utility.
• Monitoring and providing 24x7 supports for production databases.
• Monitored and tuned DB system analyzing log files, Snapshot monitors, and Event Monitors for

Development, QA and Production environment databases.

• Monitored Databases using snapshot monitoring and Event monitoring.
• Escalate issues to a higher level where issue resolution is not achieved within a reasonable amount of time.