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 HA, DR 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 IBM iSeries
• Strong Shell Scripting experience in Red Hat and SUSE Linux
• Performance tuning by monitoring, taking snapshots
• I have knowledge of Oracle Enterprise Manager(OEM)
• Opening PMR with IBM 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 other 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 of grasping new technical concepts quickly.

TECHNICAL SKILLS:

Operating System: Linux (SUSE and Red Hot),AIX, Unix, Sun Solaris, Windows

Languages: SQL, UNIX, Shell Scripting, awk, java

IBM: DB2 UDB LUW V9.1, V 9.5, V9.7, V 10.1&V10.5,SQL Server2005/2008/2012, Oracle (OEM) PL/SQL

DBA Tools: Putty, IBM data studio,DB2 control center, 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,SRDF/non-SRDF

Application Server: WebSphere, WebLogic, JBoss

Reporting Tools: Service Now, CA ( SDM ),JIRA, Remedy

PROFESSIONAL EXPERIENCE:

Confidential, Jersey City, NJ

Sr. Database Administrator

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

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)
• Experience with Oracle RDBMS R11 and R12
• Experience on Oracle Data Guard with ASM ( Automatic storage management),RMAN(Recovery Manger)
• Support of Production and Non-Prod Oracle databases. Version 11 and 12.
• Experience with CA7 Scheduling Software
• Experience with RDBMS like Oracle or Microsoft SQL Server
• Experience in Performance monitoring/testing COGNOS applications
• Experience reviewing SQL to address performance problems
• Experience with WLM, DSM, Optim data growth
• 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 incorporate 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, NY

DB2 Database Administrator

Environment: DB2 V9.5, V10,V10.5 Sun solarise, AIX, Linux, Oracle, IBM Data Stage and Netezza

Responsibilities:

• Create and Manage Servers, instances and databases
• Developed and maintained Development, Test and Production DB2 UDB Linux/Unix/Windows(LUW).
• Performed SQL Tuning using EXPLAIN, tuning Database/ Database Manager configuration parameters for optimal database performance
• Created Database Objects like Schemas, Tables, Views, Stored Procedures, Indexes, Triggers, Table spaces, Buffer Pools, User Roles, User Defined Types (UDT) and functions.
• Worked on Workload Manager to explicitly control and influence resources during execution by mapping all the queries to service classes.
• Maintained database security by Granting/Revoking users/role (v.10.1) authorizations and privileges
• Maintained database concurrency by setting proper Isolation Levels and Locks for queries
• Worked on data movement IMPORT, EXPORT and LOAD utilities.
• Recovered database using crash, version and roll-forward recovery methods.
• Experience in setting up and maintaining High availability disaster recovery (HADR).
• Implemented table partitioning in Dev, RT, UAT and Prod environments.
• Performed database maintenance tasks REORGCHK, RUNSTATS, REORG on daily/weekly basis .
• Implemented DB2 Performance Expert monitoring tool on Dev, QA and Prod servers.
• Used db2expln, db2ckbkp, db2look, db2move, db2pd, db2rbind and db2mtrk utilities
• Wrote shell scripts and setting up CRON jobs to take backup, runstats, reorg, disk space monitoring, I/O contention, log growth and rate of database growth.
• Expertise in SQL tuning, DB/DBM parameter tuning, different levels of memory allocations.
• Monitored databases using snapshot and event monitoring for troubleshooting.
• Maintaining and troubleshooting health parameters of the database such as Deadlocks, Lock timeouts/escalations, Buffer Pool/Catalog hit ratio, Utility/Database heaps.
• Monitoring Tablespace utilization, Diaglog, Disk I/O, CPU utilization on a regular basis.
• Establish standards and procedures to implement database security and auditing procedures
• Involved in applying latest fixpacks on all UDB databases.
• Monitoring all the database and Instance parameters using Foglight monitoring tool.
• Opened PMR's and Service tickets to get the resolution from IBM for critical database issues
• Experience with change control management for moving changes from Development to Production.
• Supported on-call DBA responsibilities in UDB off-hour (24/7).

Confidential, CA

DB2 Database Administrator

Environment: DB2 UDB V9.1, v9.5,v9.7&v10.1, 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 IBM 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.
• Setup and maintain documentation and standards.

Confidential

Database Administrator

Environment: DB2 UDB V9.7, OS - AIX, LINUX

Responsibilities:

• Providing support to System Administration(SA) in database installation, instance Creation and instance upgrade
• Tuning of DB and DBM configuration parameters
• Weekly database size report and table space utilization report
• Database (DB2 UDB) maintenance and support
• Performance tuning the database for better and faster results
• Worked on EXPORT, IMPORT and LOAD utilities, moving Data between servers
• Daily and weekly database Maintenance activities such as backup, reorgchk, reorg, runstats and all related activities for OLTP database
• Table space creation on DPF environment
• Table space management - Adding, dropping, extending, reducing and resizing table space containers
• Restoring the database as per client requirement on test environment
• Stored Procedure compilation and execute privileges to user
• Granting & revoking various authorizations to different user/groups
• Database monitoring using Snapshots and Event monitoring
• 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

Confidential

Database Administrator

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

Responsibilities:

• Tuning of DB and DBM configuration parameters
• Monitored the table space’s growth and added/extended the containers accordingly
• worked with data movement utilities IMPORT, LOAD, and EXPORT
• Reorganizing Tables and Indexes for improving performance
• Altered Buffer pool size and Threshold.
• Monitored Databases using Database monitors, Snapshot Monitor, and Event Monitor.
• Generating DDL using DB2LOOK utility
• Done Backup (online and offline), Restore and Redirect Restore
• Checked the database backup image's integrity using db2ckbkp
• Granting database privileges to the users
• Performance tuning the database for better and faster results
• Table space management - Adding, dropping, extending, reducing and resizing table space containers
• Exporting the data from production and loading it in test boxes
• Sending daily and weekly reports and handovers.