SUMMARY

• 12+ years of experience in the field of IT industry.
• Strong 10+ years of Experience in Database Administration for DB2/UDB
• Good Experience in Database Administration for SQL,Sybase and Oracle.
• Extensive Experience as Db2 UDB DBA in AIX, Solaris, Linux, Z/Linux and Windows environments ( DB2 for LUW)
• Good experience as AIX systems administrator and in the usage AIX SMIT tool.
• Good knowledge in HADR,PURESCALE and DPROP configuration and monitoring.
• IBM certified professional Db2 UDB database administrator with extensive hands on experience with IBM db2 UDB database technologies.
• Expertise DB2 UDB Database Installation, design, maintenance and performance tuning
• Trained on SAP BASIS Administration & SAP FICO module, AIX administration and Oracle database administration.

TECHNICAL SKILLS

OS Platform: AIX, SOLARIS,Linux,Z/Linux, WINDOWS XP,NT, 95/98, OS/390 and AS 400

Skills Languages: Shell scripting, SAP FICO,SAP Basis, PL/SQL.NET,A.S.P,HTML,XML

Tools: DB2MON,ErwinTSO,SMIT,Query Patroller, Toad, Replication center,DB2 CCA,DB2 Control Center, Remedy, HP Service Desk management tool. Site Scope, Visual Basic.

Databases: DB2 UDB V 7.2,8.2,9.1,9.5,9.7, 10.1/10.5 ORACLE 8.0 and MS SQL SERVER .

MICRO SOFT: MS ACCESS,MS WORD, MS EXCEL,POWER POINT,OUTLOOK.

Hardware: Sun Sparc E450, IBM RS 6000/SP,Intel Pentium Work stations.

PROFESSIONAL EXPERIENCE

Confidential, Saint Paul, MN

Database Administrator

Responsibilities:

• Build, monitor, and perform maintenance on DB2 LUW DB servers.
• Providing 24 x 7 on - call support for production databases.
• Define and validate design technology strategies and DB standards.
• Provide security compliant database controls and reporting.
• Provide support for physical database design and database optimization.
• Provide DBMS technical support to IT staff for the application development and testing.
• Assist development and testing teams for fine tuning query statements
• Executing approved database structural changes on all environments.
• Analyzes and recommends database changes to improve efficiency, lower costs, and enhance the quality of business applications.
• Author and validate DR plans and act as a primary point of contact to other domain leads.
• Performing DB2 installations, instance creations and setup databases.
• Migrating databases & applying fix packs for db2 UDB databases on Aix &Linux servers.
• Managing Database user privileges (Granting & Revoking permissions after proper analysis & approval from Customer).
• Analyzing, troubleshooting & fixing all database related issues.
• Configuring HADR setup with TSA from Non prod to Production implementation.
• Worked with ETL team in resolving the ETL cycle issues and performance tuning of long running queries.
• Monitoring CPU, Memory, Paging space, load tests using topas,db2top & db2pd tools.
• Performed REORGCHK, REORG, RUNSTATS and REBINDS as and when necessary to eliminate the defragmentation and improving performance .
• Creating database objects like instances, databases, tablespaces, tables, views stored procedures, event monitors.
• Cataloging databases on client systems for accessing remote server databases.
• Monitoring and Handling tablespace and file systems space issues.
• Generating DDL’s and executing scheduled change management tickets and service requests for database structural changes .
• Extensively used different Data movement utilities like IMPORT, EXPORT, and LOAD utilities to load data.
• Opened several SEV1 PMRs with IBM to troubleshoot and resolve critical issues.
• Involved in capacity planning and space management. Worked on space estimate and tablespace design to accommodate large amount of data in data warehouse environment

Confidential, Camphill, PA

Database Administrator

Responsibilities:

• Migrated db2 instances and database servers from V10.1 to 10.5.
• Applied DB2 LUW fix packs and Client installations.
• Installed service packs and hot fixes on SQL servers.
• Environment setup from scratch point like (Creating instances, databases Crontab setup, updating DBM and db cfg parameters).
• Updating registry variables and environment variables according to the environment.
• Restoring databases including various redirect restores.
• Performed backups like offline, online and incremental on DB2 LUW and SQL servers.
• Executing data fixes on all db2 environments.
• Performed data loads using db2move, export, Import and load operations.
• Managed/executed database maintenance tasks (REORG, RUNSTATS utilities)
• Find out long running queries for tuning and recommending indexes by using IBM data studio and Db2advis utilities
• Experience in SQL query performance tuning by creating, managing, reorganizing and rebuilding indexes.
• Worked on HADR setup and troubleshooting HADR issues.
• Monitoring locks & Deadlocks and Identified application deadlocks and resolve them by using DB2top and db2pd utilities
• Monitoring and handling table space and file systems space issues on UNIX servers
• Scheduling and monitoring regular dba jobs and job logs.
• Monitoring all database server and bring them up when databases are down.
• Working with IBM support for solving PMR critical database issues.
• Responsible to provide on-call support on 24*7 basis with rotating basis to keep the system running smooth and handle any problems very efficiently.
• Worked closely with application teams for resolving database access issues.
• Creating Roles and Users and managing database user privileges (Granting & Revoking permissions after proper analysis & approval from Customer) .
• Supported to development teams by providing assistance with database structural changes and database access issues.
• Monitoring paging space and CPU memory usage and taking appropriate actions when they are reaching threshold values
• Creating and dropping of database objects as per customer requirements.
• Creating database objects like instances, databases, tablespaces, tables, views stored procedures, event monitors.
• Cataloging databases on client systems for accessing remote server databases.
• Executing scheduled change management tickets and service requests.

Confidential, Houston

Database Administrator

Responsibilities:

• Updating registry variables and environment variables according to the environment.
• Restoring databases including various redirect restores.
• Performed backups like offline, online and incremental on DB2 LUW and SQL servers.
• Executing data fixes on all db2 environments.
• Performed data loads using db2move, export, Import and load operations.
• Managed/executed database maintenance tasks (REORG, RUNSTATS utilities)
• Find out long running queries for tuning and recommending indexes by using IBM data studio and Db2advis utilities
• Monitoring and handling table space and file systems space issues.
• Monitoring locks & Deadlocks and Identified application deadlocks and resolve them.
• Moving databases for various environments using utilities like db2move.
• Performed backups with online full and incremental backups.
• Scheduling and monitoring regular dba jobs and job logs.
• Moved data across databases using db2move,IMPORT, EXPORT LOAD utilities.
• Managed/executed database maintenance tasks (REORG, RUNSTATS utilities).
• Monitoring all database server and bring them up when databases are down.
• Working with IBM support for solving PMR critical database issues.
• Worked on restores and roll forward restores including redirect restores.
• Experience in SQL query performance tuning by creating, managing, reorganizing and rebuilding indexes.
• Worked on HADR setup and troubleshooting HADR issues.
• Monitoring locks & Deadlocks and Identified application deadlocks and resolve them by using DB2top and db2pd utilities
• Monitoring and handling table space and file systems space issues on UNIX servers
• Scheduling and monitoring regular dba jobs and job logs.
• Monitoring all database server and bring them up when databases are down.
• Working with IBM support for solving PMR critical database issues.
• Responsible to provide on-call support on 24*7 basis with rotating basis to keep the system running smooth and handle any problems very efficiently.
• Worked closely with application teams for resolving database access issues.
• Creating Roles and Users and managing database user privileges (Granting & Revoking permissions after proper analysis & approval from Customer) .
• Supported to development teams by providing assistance with database structural changes and database access issues.
• Monitoring paging space and CPU memory usage and taking appropriate actions when they are reaching threshold values
• Creating and dropping of database objects as per customer requirements.

Confidential

Database administrator

Responsibilities:

• Creating instance and database objects(databases,tablespaces,tables,indexes and views) as per customer request.
• Providing support to system Administration (SA) in database installation, instance creation, instance upgrade and version migrations on production servers.
• Managing Database user privileges (Granting & Revoking permissions after proper analysis & approval from Customer) .
• Performing all system admin tasks related to db2 dba tasks on dev and test servers .
• Database monitoring (Free space in table space, event monitor outputs, security reports)
• Performing database security audit reviews by using db2cops and db2shc tools and removing all the violations.
• Migrating databases db2 v8.2 to db2 V9.5 versions on Aix servers.
• Database backup & recovery experience with offline, online full & incremental backups and restores & roll-forward including redirected restores.
• Configuring and Monitoring the HADR setup on the database servers.
• Setting propagation from source databases to target databases.
• Monitoring the capture process Confidential source servers and Apply process Confidential target servers.
• .Supported to development teams by providing assistance with database structural changes and database access issues.
• Worked with different GUI tools like db2mon.control center, command center, replication center, client configuration assistant tools .
• Monitoring paging space and memory usage and taking appropriate actions when they are reaching threshold values.
• Increasing file systems and logical volumes as in the process of adding space to table spaces and file systems.
• Cataloging databases on client systems for accessing remote server databases.
• Monitoring all scheduled jobs and job logs and taking actions if any jobs stopped.
• Responding calls from operations and resolve all database issues.
• Resolving the Problem tickets of different severity levels during off shore support.
• Monitoring all database servers and bring them up when databases are down.
• Troubleshooting & fixing problems faced by application developers.

Confidential

Database Administrator

Responsibilities:

• Creating instance and database objects as per requested
• Monitoring and Handling tablespace and file systems space issues.
• Responding calls from our operations if database or prop is down and make sure that database and prop is up and running.
• Data replication experience using DProp on DB2 client/server databases.
• Granting authorizations to users to access db2 database as per customer request.
• Creating file systems, create logical volumes and assign them to table spaces.
• Increasing file systems and logical volumes as in the process of adding space to tablespaces and file systems.
• Setting propagation from source database to target database.
• Removing props to source database to target database.
• Monitoring the apply process Confidential source server and capture process Confidential target server.
• Resetting users passwords, User's Failed Login Count & Unlock a User's Account.
• Removing users, groups, file systems and logical volumes.

Confidential

Database Administrator

Responsibilities:

• Implemented db2 Fix packs and did migrations, client installations and upgrades.
• Setting Crontab, scheduling jobs like backups, reorgs, run stats, space checks and Monitoring scheduled jobs for new database environments.
• Monitoring locks & Deadlocks and informing to application teams.
• Loading data from production servers to development and testing servers as per customer request.
• Worked on DPF(Data partitioning feature) servers.
• Modified and enhanced existing databases objects as per customer requests.
• Executing scheduled change management tickets and service requests.
• Increasing space to DMS table spaces when they are reaching to threshold values .
• Restoring database production to different test and development environments.
• Creating event monitors for monitoring deadlocks and analyzing outputs.
• Worked on export, import, load and db2look utilities.
• Monitoring and solving log space and temp space issues.
• Creating and dropping of database objects as per customer requirements.
• Granting and revoking user and groups permissions as per customer requests.
• Provide troubleshooting and problem solving on critical issues.
• Monitoring queries through query patroller and fixing query issues.
• File system and table space monitoring using Korn shell scripts .

Confidential

Database & System administrator

Responsibilities:

• Creating instance and database objects(databases,tablespaces,tables,indexes and views) on development servers.
• Monitoring and Handling tablespace and file systems space issues.
• Granting authorizations as per customers request.
• Data movement by using Export, import and load utilities
• Cataloging and un cataloging databases as per the customer request
• Performing database maintenance activities like reorg, runstas and backup
• Health monitoring of critical production servers.
• Capacity planning report of non prod and prod servers
• User and Password validation issues
• Involved in installations, upgradations and applying fix packs on development, staging and QA systems
• Creating & mounting file system in AIX servers.
• Creating users and groups and adding users to groups.
• Worked on installation of different versions of DB2 UDB on AIX & Windows servers.