SUMMARY

• 7+ years of experience with Database Administration at all phases of software development lifecycle i.e. Development, Analysis, Design, Testing and Implementation for various applications.
• Worked as a DB2 UDB V8.x, 9.5, 9.7, 10.1, 10.5 Database administrator on UNIX, LINUX and Windows platforms, with expertise in online transaction processing and multi - user systems involving large and distributed databases.
• Involved extensively in Installation and Configuration, upgrading, and troubleshooting DB2 databases.
• Skilled in database administration tasks like Referential Integrity, Index strategies, and SQL Troubleshooting Using DB2 UDB.
• Migrated DB2 UDB databases from old to newer versions and applying FIXPACKS to keep DB2 at most recent level.
• Experienced in OLTP & OLAP database environments which include Single Partitioned and Multi-Partitioned Databases (DPF).
• Perform AUDIT on the Databases to give users bare minimum privileges on the Database and Database objects.
• Expertise in projects like SRM Build, SAP BW support, DB2 UDB HADR and Solution Manager Unicode migration.
• Backup and Restore, Replication, Performance tuning, Maintenance, Migration, shipping archival logs, Corruption and Recovery, Managing login/permissions.
• Experienced in working with large tablespaces, processing and maintenance of partitioned tablespaces, NPIs and DPSIs.
• Trouble shooting Data Propagator replication (DpropR) in associating with all Control tables and Source Table, Apply and capture Problems.
• Create and change application databases, Table spaces, tables and indices in DB2 UDB running on AIX, Linux and Windows NT.
• Worked with universal table spaces and hands on experience in exploiting the new features of version 9 and version 10 to improve overall system performance.
• Knowledge with carving and implementing Backup/Recovery strategies for clients to have desired recovery models.
• Implemented High Availability strategy in checking standby databases. Recovering Damaged Table spaces, Crash Recovery and Disaster Recovery
• Exposure to HA setups like Clustering, HADR, etc.
• Setting up monitoring for the database like Snapshots, Event monitoring, Traces, etc.
• Primary DBA for ECC6 upgrade on the DB2 Linux Unix and Windows platform; participant ofbringing SAP to latest version.
• IBM Tivoli Administration and Symantec VERITAS Netback Administration.
• Hands on Experience in Physical and Logical Design.
• Exposure to Data Design, Data modeling, Relational database applications using client server -Internet computing model and mission.
• Good Hands on Experience in UNIX SCRIPTING.
• Proficient in daily support activities which include maintaining and testing backups, monitoring logs, monitoring thread activity, resolving job a bend issues, locking issues and scheduling administration activities.
• Strong analytical ability, communication skills and problem solving capability.
• Versatile, flexible and ability to work on multiple assignments in a given time frame.
• Experienced in supporting critical production databases and worked on 24*7 production support

TECHNICAL SKILLS

Database: DB2 UDB V8.x/V9.x/V10.x, oracle 10g

GUI Tools: IBM Data Studio, DCW Tool, OPM, TSA

Operating System: AIX, Linux, Windows

Other Tools: DB Artisan, Exceed, Erwin, BMC, DPropR, ODBC, SQL*Loader, TSM, DB2 Connect, and ERWIN

Languages: SQL, C, Unix Scripting, Perl/Java Scripts, shell scripting, PHP, Batch files, AWK, SED, SQL, Visual Basic, C++, Java

Markup Language: HTML5, CSS5, Xml

ERP: SAP R/3, PeopleSoft

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Sr.UDB DB2 LUW Database Administrator

Responsibilities:

• Database administration for single partition DB, single instance multiple databases, SetupHADR on Production systems (3rd site auxiliary standby).
• Install and configure Flash Copy Manager for all SAP production environments.
• Database utility experience including reorg, runstats, rebind, export, import, load, auto- load, backup, restore and recover database utilities.
• Install, configure and upgrade Optim Performance Manager V5.3.
• Migration of DB2 from v9.7 to 10.5
• Perform rolling fixpack apply on HADR environments.
• Perform instance/database move from one server to another server.
• Perform data refresh from Prod to lower environments using redirected restore across different backup/recovery solutions.
• Install and configure EMC Avamar Data Domain (ddboost for DB), TDP (Tivoli Data.Protection), TSM (Tivoli Storage Manager), FCM as backup and recovery solution.
• Install/Upgrade DB2 Server, DB2 Client, Db2 Connect as per Solution requests/Changes.
• Create Instances and databases as per Solution Requests.
• Experienced in UNIX shell scripting and troubleshooting. Use of shell scripting to monitor different aspects of database.
• Apply Security Patches and Fix Pack Updates on all instances.
• Database backup and recovery experience with online full and incremental backups,online and offline transaction log archiving, restore and roll-forward (including redirected restore), and recover database utilities.
• High availability (HA) and disaster recovery (DR) experience with DB2 HADR offlinetransaction log shipping, data replication using SAN subsystems.
• Database and SQL access plan optimization experience with DB2's Explain, Visual Explain, and Design Advisor tools. Stored procedure (SP), user defined function (UDF), and userdefined table function experience with DB2 SQL/PL.
• Experience automating database maintenance and monitoring with shell scripts including automating system event logging, e-mail alert notification, and reporting using the DB2utilities and Command Line Processor (CLP)
• IBM Problem management, and resolution (PMR) experience with DB2 diagnostic logfacility, administration notification log, trace facilities, DB2 inspect, DB2 database analysisreporting tool (db2dart).
• Perform administration tasks such as database backup and restoration, Monitoringdatabase health in terms of memory, CPU utilization, disk space and security.
• Responsible for running optimizer plans for slow performing queries, running trace and create standard reports on query performance and Database recovery. Performance tuningusing OPM, db2advis, db2expln for query optimization.
• Experience in good troubleshooting techniques to ensure quick and successfulresolutions (snapshot, db2pd, db2top etc.).
• Managing Database user privileges (granting & revoking permissions after proper analysis& approval).
• Generated different types of reports like user query, data analysis, performance, replication etc.,

Environment: DB2 UDB v9.1/9.5/9.7 ESE/10.5 AESE, AIX 5.1/6.0/7.1, Linux, Windows XP/7/2000/2003, Shell Scripting, BMC Remedy, Putty, Citrix, TSM, EMC 1.0/2.5

Confidential, Kansas City, MO

DB2 UDB Database Administrator

Responsibilities:

• Worked as the 24/7/365 Product DBA for multiple DB2 Servers running on AIX/Linux and Windows.
• Done DB2 Database migration from lower versions to higher versions on LUW environment
• Applied fixpack’s to upgrade DB2 Instances.
• DB2 Upgraded from 9.7 to 10.1
• Setup and modified database manager configuration parameters and database configuration parameters.
• Troubleshot and fixed both development and operational systems (Development/Testing and Production).
• Installed new DB2 subsystems on Unix, SAP based environments.
• Acquired specifications from business analysts and Development groups.
• Worked with Logical and physical data modeling group.
• Designed Data modeling (logical and physical data modeling using ERWIN).
• Experimented with Indexes and employed Index Advisor to improve user report and speed ETL runtime.
• Created and maintained Instances, databases, tablespaces, schemas (both administrative and development) in DB2UDB for developers
• Used REORGCHK, REORG and RUNSTATS to further performance goals.
• Used DPropR replication tools to transfer data remotely in a secured fashion.
• Designed ERD's using ERWIN.
• Migrated databases from V 8.2 to V 9.2 in Unix environment.
• Tweaked the Instance level and Database level configuration parameters to optimize the system performance
• Analyzed user requirements to design star schema to implement Data Mart.
• Involved in the homogeneous migration of database for changing of schemas on R/3 platform.
• Supported users in various SAP modules like IS-T, HR- Event and Training Management and likewise.
• Supported SAP R/3 and Enterprise Portal environment.
• Responsible for backup, restore and migrating data between different databases/ servers.
• Performed Database sizing, table spaces, indexes and log spaces design & implementation work.
• Provided Database security & Audit Design, test & implementation.
• Created Database and associated objects using BMC.
• Performed Initial Space estimation along with growth using BMC.
• DB2 monitoring using BMC utilities.
• DB2 management using Quest Central.
• Set up DB2 UDB/AIX production and development environments.
• Database maintenance for development, and synchronizing it with the production database.
• Database Clean up (development database) scripts (Unix Shell Scripts, Cron, & SQL) for automated clean up every week.
• Daily, weekly and monthly basis administration activities
• Transport management for indexes
• Setting up connect.ini file for new systems
• Archiving Support and administration
• SAP performance tuning, special parameter settings for BW & APO landscapes
• Opening SAP messages for issues and also opening connections for SAP
• Server Builds for SAP SRM 7.0 Implementation

Environment: DB2 V8.18 & DB2 V 10.5/10.1/9.5/9.1.3/8.2 , AIX 5.3, TOAD, DB2 UDB Database consisting of SAP R/3 4.6C, UNIX Shell Scripts (Ksh) and BMC Utilities, Erwin, Windows.

Confidential - Keene, NH

Database Administrator

Responsibilities:

• Instrumental in providing end-to-end solutions to business critical implementation of SAP technology with an aggressive timeline working with a diverse group of professionals.
• Performed Database Performance using tools such as DB2ADVIS, DB2top db2pd utilities
• SQL Tuning using EXPLAIN tools to determine issues with the data quiries
• Performed Weekly/Monthly database maintenance such as RUNSTATS, REORG, BUCKUPS
• Production support of high visibility multi-terabyte databases comprised of key SAP financial warehouses and several OLTP applications combined.
• Create and setup DPF "Data Partition Feature" with 13 Nodes on three servers for DWE database.
• Designing and developing the relational database using ERWIN Data Modeler tool.
• Replicating data across various sites using Data propagator (DPropR).
• Implemented several DR solutions using HADR and custom log shipping scripts to suit varying needs and business requirements.
• Used DB2 features such as compression, automatic storage and self-tuning memory management to provide scalability and maximize return on hardware investment.
• Monitored databases with a combination of custom scripts and third party tools such as SAP GUI and Spotlight for DB2 and DBA Cockpit.
• Eased maintenance of very large databases using SAP transaction codes and utilities for movement of object in its own data classes and helped development efforts by refreshing databases using system copy, through DBA Cockpit.
• Created and maintained file systems for all Data and Indexes growth.
• Participated in a 24x7 on-call support of both development and production databases.
• Entered and updated incident details using our CRM system.
• Performed simple software upgrades such as firmware upgrades, DB2/SQL Server fix packs, service packs or updates.
• Produced and maintained work instructions when required.
• Understood and troubleshooted hardware and peripheral concepts, architecture, and installations. Displayed strong software troubleshooting and diagnostics skills.

Environment: DB2 UDB AIX v8.1, v8.2, v9.1, v9.5, v9.7, SAP R/3, DPF and DPropR.

Confidential - Jersey City, NJ

Database Administrator

Responsibilities:

• Installed, Configured and upgraded DB2 server software and related products on Mainframe environment.
• Troubleshoot day-to-day problems encountered on production, development and test database environment.
• Designed, implemented and administered DB2 UDB for development, test and production environments.
• Migrated Development (DEV), Test (UAT) and production (PROD) databases from DB2 9.5 FP 5 to DB2 9.7 FP 4.
• Developed and implemented standards to create databases and various database objects
• Managed database loading, migrating and maintaining data with LOAD, EXPORT, IMPORT DB2LOOK.
• Put AutoSys job scheduling daily based for Backup, reverse engineering, Size of tablespaces, snapshot and runstats scripts
• Took online and offline backups as well as wrote shell scripts and scheduled them
• Requested space for file system and raw-devices to UNIX group
• Wrote shell scripts in Unix (AIX/Solaris/HP) with a good understanding of UNIX servers and architecture
• Cataloged multiple instances and configuring connectivity to databases from remote clients
• Tuned Database Manager configuration parameters as needed
• Bind the server DB2 utilities to the databases
• Tuned DBM configuration parameters and DB configuration parameters
• Drop and add users, logins, aliases, and groups to the databases and granting/revoking permissions on Database objects.
• Installed DB2 10.1 AESE on sandbox and working on Prototype scenarios for replication.
• Extensively involved in Application Support, Design, User Administration, Security, Performance Tuning, Optimization and Backup/Recovery
• Supported On call weekly based 24/7.

Environment: IBM DB2 V 9.1, 9.5, 9.7,10,1, Data studio, AIX 5.x, 6.x, Foglight V4.2, 5.6Toad, Networker, TSM, MQ Series, BMC Remedy.

Confidential, Houston, TX

Database Administrator

Responsibilities:

• Worked on creating Staples internal portal, which is live now and has replaced the existing home portal. Created the environment from the scratch which consists of 54 Databases.
• Compressed 100s of multi 100 GB tables and was able to save more than 8 TB of space from the EDW (data warehouse).
• Upgraded many Fix Packs in version 8 and 9.
• Supported v 9.1 to v 9.5 migration.
• Created backup and recovery strategy and implemented and schedules the activities.
• Supported many development projects which include creating the tables, views, indexes, stored procedures and triggers in both OLTP and OLAP environments.
• Intensively worked on DB performance tuning and dealing with STMM, AUTO MAINT, Health Monitors, etc.
• Was involved in deploying Stored Procedures using Developer Work Bench.
• Created Backup Reporting model to send daily detailed reports to the team about the success and failure with the failure reason.
• Created and scheduled automated REORG/RUNSTATS scripts to perform automatic maintenance activities on different environments depending on the system needs.
• Familiar with different utilities like DB2TOP, SMITTY, DB2LOOK, etc.
• Dealt with different issued regarding FS usage, Grants, Profiles, Variables, etc.
• Worked with IBM to open PMRs and found solutions for different priority issues. This included performing diagnostic tests, data collection and sending it to the IBM.
• Encountered many APARs in the environment and worked with the DB and application teams along with IBM to implement the hot fixes/FPs and then monitor the performance.
• Worked with DAs and used forward/reverse engineering from Erwin to update the model or DB.
• Involved in reducing HWM and free the space and add it to the File System.
• Proficient with required UNIX commands and scripting.
• Worked in the Onsite/Offshore model.

Environment: DB2 UDB v8.1, v8.2, v9.1, v9.5, v9.7, DPF, UNIX (AIX), Linux.

Confidential

Database Administrator

Responsibilities:

• Performed DBA duties including: database backups, restores, performance tuning, and capacity analysis on SQL Server 2000.
• Performed all responsibilities of an Application DBA involved with the DDL statements to create, modify or Alter Database Objects and also involved with performance tuning of complex SQL Queries.
• Tuned LOCKLIST parameter and Upgraded DB2 UDB instance from 32 bit to 64 bit and installation of latest Fixpack.
• Created/Altered database objects (tablespaces, schemas, tables, views, indexes, triggers, stored procedures etc).
• Automated backups (both online and offline), Reorgs, Runstats, Space monitoring, moving db2diag.log, monitoring size of tablespaces by setting up a threshold
• Worked heavily with data movement utilities IMPORT, LOAD, and EXPORT under high volume conditions
• Developed groups of Views organized by multiple table schemas which allow different sets of users to selectively access different subsets of data by different naming conventions, but allow all users access to the same underlying physical data. Supported this on the security level by developing GRANT scripts to allow only appropriate user's access to certain Views
• Demonstrated ability in database design and implementing appropriate changes to the physical database (indexes, database and server configurations, etc.) as needed for optimal performance
• Creating EXPLAIN tables and running visual explain utility on sql statements
• Tuned database and Database manager configuration for optimum performance. Experimented with changing buffer pool and table space page size to improve time taken by ETL to build data marts
• Performed database loads and unloads.
• Supported PeopleSoft Applications in a DB2 UDB EEE Environment.
• Used TSM for backups and User Exit for archival logging

Environment: DB2 UDB for LUW, Fix pack, AIX, Oracle, IBM Migration Toolkit, Erwin, Linux, PeopleSoft, TSM, SQL Server, Quest Central and Toad.