CAREER SUMMARY:

• Having 8+ Years of total IT experience in DB2 as a DB2 UDB (LUW) Administrator, And Developer
• Experience on DB2 utilities, handling production and Development Issues, and I have a good knowledge on ITIL.
• I have good knowledge on SAP Basis. As a proactive team member, able to handle good organizational, communication skills.
• DB2 installations, configurations, patching and upgrades in Production, Q/A, Test and Dev environments.
• Experience on DPF environment.
• Experience on creating the new database and maintaining database objects.
• Providing technical expertise to design most efficient and cost - effective solutions for DB2 based database systems.
• Automating repetitive task.
• Advanced performance tuning, advanced troubleshooting and problem determination.
• Create DB2 database online/offline backups.
• Experience on creating the new Table Spaces (DMS).
• Hands on experience in maintaining Table space spaces, Tables in DB2 databases running on LUW platforms.
• Experience on maintaining Database Manager and Database Configuration Parameters.
• Expertise in using DB2 Movement Utilities like Export, Import and Load.
• Troubleshooting database issues using db2diag, db2pd, Snapshots and event monitors.
• Experience in replication (both SQL and QREP). understanding of HADR Database and storage technologies like Data replication, SRDF/non-SRDF.
• Able to resolve performance issues using various tools.
• Application Control Management system (ACMS).
• OpenVMS clusters.
• Digital Command Language (DCL).
• CPU-independent SAN technology.
• OpenVMS capacity planning performance management and system utility tools.
• Participate in Database Maintenance and DR activities.
• Build and configure multiple DB2 databases, clustered, non-clustered and virtual environments.
• Experience in administering and supporting Confidential iSeries.
• Strong Shell Scripting experience in RedHat and SUSE Linux.
• Performance tuning by monitoring, taking snapshots.
• I have knowledge of Oracle Enterprise Manager(OEM).
• Opening PMR with Confidential through phone or tickets in case of Database failures or any support required & driving them to closure.
• Determine table attributes, primary, and alternate keys for multiple databases.
• Troubleshoot root cause of database issues and recommend solutions or workaround.
• Implement database monitoring procedures to maximize availability and performance of the database.
• Interact with staff from areas outside of Management Information System (MIS) to participate in and/or organize projects that are short/long term.
• I have experience with TSAMP in a production environment.
• I worked supporting DB2 in a WCS (WebSphere Commerce Server) environment.
• Expertise in running REORGCHK, REORG and RUNSTATS for better performance of the database.
• Experience on DB2 Installation, Planning, Migration and Maintenance activities.
• Experience in Control and Maintenance of DB2, Commands & Utilities.
• I have experience on BMC Tools.
• Create and deploy CRs for DB stability & application release.
• Writing and testing shell scripts for automating database activities.
• Experience implementing and supporting DB2 Connect software.
• I Perform periodic capacity analysis.
• Peak season readiness & support.
• Improve automation to reduce manual effort & reduce cost through CSIs.
• Automate and optimize database maintenance.
• Perform DB Refresh from production to another environment.
• Table space management - Adding, dropping, extending, reducing and resizing table space containers.
• Backup & Recovery of Database, Online database backup, archived log files and Offline.
• Experience on Set up SQL replication for new table.
• Promote database changes from one environment to other.
• Set up DB2 Table editor in new environments.
• I have a knowledge on SQL and PL/SQL.
• I do have knowledge on health care industry.
• Provide database solutions to developers and customers.
• Implemented DB2 Security, Locking and Concurrency Control using Isolation levels.
• Good knowledge on Incident, Problem and Change management process.
• Managing P1/P2 Bridge Calls.
• Strong collaboration, team building, interpersonal, communication skills with proficiency. f grasping new technical concepts quickly.

TECHNOLOGY PROFICIENCY:

RDBMS: DB2 UDB LUW on 8.x, 9.x, and 10.5, SQL Server and Oracle

Database Tools: Change Data Capture (CDC), Optim Performance Manager, DB2 Performance Expert, Erwin, ER/Studio, Rational Data Architect, DProp, DB2 Replication Center, DB2 connect, and Quest Tools, Veritas NetBackup, TSM, DB2 Federation, DB2 Query Patroller, DB2 Governor, db2top and db2pd

Application Server: WebSphere, WebLogic, JBoss

Languages: SQL, Shell Scripting, awk, sed

Operating Systems: Linux (Red Hat and SUSE), UNIX (AIX, Solaris), Windows

PROFESSIONAL EXPERIENCE:

Confidential, INDIANAPOLIS, Indiana

DB2 - DBA

Environment: DB2 V10.5 FP7 . 1V9.7 FP 10, Sun Solarise, AIX P6, Linux, Oracle, Confidential Data Stage and Netezza

Responsibilities:

• Experience on creating the new database and maintaining database objects
• Experience on Creating the new table Space
• Addressing all database server alerts with in SLA
• Capacity planning, sizing and designing
• Defining consolidation deployment and migration methodologies and cost-effective solutions
• Automated or simplified routine tasks such as backups/reorgs/runstats/binds, purge jobs and replication setup via Perl and shell scripting.
• Hands on experience in maintaining Table spaces, Tables in DB2 databases running on LUW platforms
• Experience on maintaining Database Manager and Database Configuration Parameters
• Expertise in using DB2 Movement Utilities like Export, Import and Load
• Troubleshooting database issues using db2diag, db2pd, Snapshots and event monitors
• Expertise in running REORGCHK, REORG and RUNSTATS for better performance of the database
• Designed and implemented strategy for running data reorg/runstats on timely basis for large tables to avoid data fragmentation and improves performance and system throughout.
• Experience in resolving incident management tickets of Database Environment
• Change Management - Schedule change, get approvals, do broadcast and work on change tickets.
• Supported and built active-active databases using update anywhere replication via SQL and Q-replication technologies.
• Data refresh at table level and database refreshes across prod/non-prod environments
• Used Remedy for Change Control/Change Management
• Moving databases from Development to Production after successful completion of application testing.
• Experience in DB2 High Availability (HADR, TSA, HACMP)
• The internal drive, intellectual curiosity, ability to learn, and desire to help the customers succeed.
• Experience on Trouble shooting database issues using db2diag and notification logs, snapshot, event monitor, db2hc or enabling hmon.
• Table space creation on DPF environment
• Constantly migrated instances, databases to current level of DB2 versions/fix packs to in corporate the new functionalities.
• Created and modified databases and database objects as per application requests.
• Daily data refresh from production to QA environment
• Performance tuning by monitoring, taking snapshots
• Backup & Recovery of Database, Online database backup, archived log files and Offline
• Granting / revoking various authorizations to different Users/Groups.
• Experience on Optim info sphere tools. TDM, Guardium, S-gate & OPM. "Experience on ETL. Experience on Data studio”.
• Experience on Provide day-to-day database support for the CCTI/CCP data warehouse environment.
• Provide support for data replication between production site and disaster recovery site -Provide support for performance testing the CAE and CCP applications -Assist with troubleshooting of system and application performance related issues and recommend fixes.
• Experience in Performance monitoring/testing COGNOS applications -Experience reviewing SQL to address performance problems
• Resolution of user queries: Resolution for the user queries for all above tasks and application errors which are affected due to database level issues in day to day basis
• Knowledge on complex SQL, stored procedure, UDT, trigger, views etc.
• Monitoring the database on regular basis for performance and other issues
• Tuning of DB and DBM configuration parameters
• Database (DB2 UDB) maintenance and support
• Performance tuning the database for better and faster results
• Providing weekend on call support
• Perform backup and restore activities
• Supported on-call DBA responsibilities in UDB off-hour (24/7).

Confidential, IL

DB2 - DBA

Environment: DB2 UDB v 9.1, V9.5, AIX, Linux.

Responsibilities:

• Administration DB2 V9.7 databases on LUW platform.
• Installed and configured DB2 v8, v9, V9.5, V.9.7on Linux, AIX and Windows.
• Database creation and designing.
• Fixpak installation.
• Performance Tuning
• Backup and Recovery and Problem Solving.
• Database migration
• Working and troubleshooting on day-to- day problems via opening and closing tickets.
• Explain and Snapshots, Buffer pools performance optimization, SQL performance evaluation, analysis, and optimization.
• Federation of DB2 databases across the environments.
• Developing the database codes, scripts for databases
• Deploying store procedures for application users.
• Based on the security level granting privileges to users.
• Involved in production/development setup, configuration and support
• Reverse engineering, schema generation & Complete compare using Erwin tool.
• Monitored backup operations, and schedules manual backups as needed
• Usage of tools like DB2 Load, Import, Export and Reorg, Runstats, Reorg Check, Backup, Restore, Db2move, and Db2look
• Performed Redirect restore.
• Performed Database migration/upgrades between multiple versions.
• Performed Server migration.
• Provide 24/7 On call support on rotational basis.
• Experience in Performance monitoring/testing COGNOS applications
• Experience with RDBMS like Oracle or Microsoft SQL Server
• Experience reviewing SQL to address performance problems
• Experience with WLM, DSM, Optim data growth
• Setup and maintain documentation and standards.

Confidential, CA

DB2 - DBA

Environment: DB2 UDB V9.1, v9.5,v9.7&v10.1, v10.5,OS - AIX, Linux

Responsibilities:

• Installation and Configuration of DB2 environment in LUW.
• Stabilizing the DB2 environments and streamlined the systems.
• Identifying key milestones and deliverables.
• Up gradation of database from v9.5 fp10 to v9.7 fp7.
• Configuring the High Availability techniques like HADR& HACMP.
• Installing and configuring the databases to Confidential OPM tool for proactive monitoring of DB2 databases.
• Extensive experience in fine tuning of long running queries.
• Extensive experience in loading large volumes of data across DB’s.
• Backup & Recovery of Database, Online database backup, archived log files and Offline.
• Granting / revoking various authorizations to different Users/Groups.
• Capture and analyze Explain and Visual Explain information.
• Usage of tools like DB2 Load, Import, Export and Reorg, Run stats, Reorg Check, Backup, Restore, DB2move and DB2look
• Creation and management of both system level and object level roles and privileges for various users. Killing sessions and granting/revoking user privileges and roles.
• Exposure on DR test & strategies like Failover Clustering/HADR.
• Cataloging Databases on various nodes.
• Involved in physical database layout design.
• Working with apps team to deploy the releases on time and more accurately.
• Snapshot monitoring was done to detect deadlocks, buffer pools and lock escalations.
• Provide assistance to the development team on performance tuning, resolving locking situations, assist data modeler with SQL scripts.
• Responsibilities include disaster recovery, capacity planning and Real Time monitoring, troubleshooting and proactive maintenance.
• Perform file system copy from production to non-production using TSM backup and recovering DB2 databases in non-production environment.
• Implemented Database partitioning and Archival logging in DB2 UDB.
• Troubleshoot the issues as and when required.
• Attending Weekend calls with offshore and onsite teams.

Confidential

DB2 - DBA

Environment: DB2 V9.1 FP 4, V9.5 FP 1, AIX P6, P7, Lin

Responsibilities:

• Responsible for enterprise architecture and performance of DB2 LUW.
• Planned and designed enterprise wide deployment strategies for DB2 installations/fixes, database builds and standard operating procedures.
• Automated or simplified routine tasks such as backups/reorgs/runstats/binds, purge jobs and replication setup via Perl and shell scripting.
• Supported and built active-active databases using update anywhere replication via SQL and Q-replication technologies.
• Mentored and guided developers and application support on DB2 database technology.
• Performed POC's and document latest technologies on new features of DB2
• Coordinated and performed migration of DB2 LUW servers to VMWare cloud environment.
• Supported large number of servers around 200 efficiently using automation and scripts.
• Create scripts for Bench mark testing of DB2 servers.
• Administered database, table and table spaces.
• Moved the data by using EXPORT, IMPORT, LOAD, db2move utilities.
• Monitored Databases using snapshot monitoring and Event monitoring.
• Database backup & recovering the database as per business requests.
• Implemented DB2 Security, Locking and Concurrency Control.
• Constantly migrated instances, databases to current level of DB2 versions/fix packs to in corporate the new functionalities.
• Created and modified databases and database objects as per application requests.
• Provided on-call support and well exposed to 24x7 environments.
• Performed SQL Tuning using db2advisor and db2explain tools.
• Updated the DBM and DB configuration parameter.
• Generated SQL Statements using DB2LOOK Utility.
• Worked as part of a database administration team and provided support for critical and non-critical implementation and maintenance issues.
• Performed performance tuning and capacity planning using the parameters of DBM configuration file &DB configuration file and various DB snapshots.