SUMMARY

• Having around 8 Years of total IT experience in DB2 as a DB2 UDB (LUW)Administrator Experience on DB2 utilities, handling production and Development Issues. As a proactive team member, able to handle good organizational, communication skills.
• Experience on DPF environment.
• DB2 installations, configurations, patching and upgrades in production, Q/A, Test and Dev environments.
• 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 tasks
• 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 Managerand Database Configuration Parameters
• Expertise in using DB2 Movement Utilities like Export, Import and Load
• Troubleshooting database issues using db2diag, db2pd, Snapshots and event monitors
• Understanding of HADR Database and storage technologies like Data replication, SRDF/non-SRDF.
• Good knowledge of SQL replication.
• Knowledge of SQL programming, Database and SQL performance tuning
• Able to manage and deploy application database modifications
• Knowledge of LDAP role-based authentication usage within DB2 LUW environments preferred
• Experience with partitioned and non-partitioned environments preferred
• Able to resolve performance issues using various tools
• Participate in Database Maintenance and DR activities
• Build and configure multiple DB2 databases, clustered, non-clustered and virtual environments.
• Generating DDL using DB2LOOK utility.
• Strong Shell Scripting experience in Red Hat and SUSE Linux
• Performance tuning by monitoring, taking snapshots
• Opening PMR with IBM through phone or tickets in case of Database failures or any support required & driving them to closure
• I do have experience on Problem Resolution, Configuration Management, Capacity Management
• I worked supporting DB2 in a WCS (Web sphereCommerce Server) environment
• Expertise in running REORGCHK, REORG and RUNSTATS for better performance of the database.
• Table space management - Adding, dropping, extending, reducing and resizing table space containers
• Backup & Recovery of Database, Online database backup, archived log files and Offline
• Granting /revoking various authorizations to different Users/Groups
• Implemented DB2 Security, Locking and Concurrency Control using Isolation levels.
• Good knowledge on Incident, Problem and Change management process
• Managing P1/P2 Bridge Calls
• May manage smaller projects/initiatives as an experienced individual contributor with specialized knowledge within assigned discipline
• Performs DB2 database testing
• Leverages understanding of database technologies and supporting technologies to build and maintain databases
• 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, C

RDBMS: IBM DB2 UDB LUW V9.1, V9.5, V9.7, V 10.1&V10.5, SQL Server 2005/2008/2012 , Oracle (OEM), Netezza

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,Cognos

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

PROFESSIONAL EXPERIENCE

Confidential, IN

Database Administrator

Environment: DB2 UDB V9.7, V10.1, V10.5, V11.1 OS - AIX, LINUX

Responsibilities:

• Developed and Maintained Development, Test and ProductionDB2 UDB Linux/Unix/Windows(LUW).
• AIX / Linux / CRON job experience
• PerformedSQL Tuningusing EXPLAIN,tuning Database/ Database Manager configurationparameters 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.
• Maintained database security byGranting/Revokingusers/role (v.10.1) authorizations and privileges
• I Do have a experience in UNIX with AIX 5.x/Linux preferred.
• Experience on DB2 Installation, Planning, Migration and Maintenance & upgrading activities.
• DB2 Cataloging Databases on various node directory / catalog configuration.
• Database performance tuning using DB2dart, DB2explain utilities.
• Maintained database concurrency by setting properIsolation LevelsandLocksfor queries
• Extensive experience in fine tuning of long running queries.
• Worked on data movementIMPORT,EXPORTand LOADutilities.
• I have a Knowledge on SQL and PL/SQL
• Experience on database physical and logical design principals
• Experience in DB2 High Availability (HADR, TSA, HACMP).
• Solid knowledge of high availability using Tivoli / TSAMP policies.
• Performed database maintenance tasksREORGCHK, RUNSTATS, REORGon daily/weekly basis
• Experience with RDBMS like Oracle or Microsoft SQL Server
• Experience in Performance monitoring/testing COGNOS applications
• Experience reviewing SQL to address performance problems
• 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
• Experience with testing methods
• Experience in at least one DB2 database technology, technical or application area
• Design experiences, preferably with database architecture standards or frameworks
• Experience designing, modeling, creating and maintaining databases based on business requirements
• Writing and testing shell scripts for automating database activities
• I do have a experience Table space management - Adding, dropping, extending, reducing and resizing table space containers
• Identifies what needs to be done and accepts task responsibilities and is results-driven. in clustered environments, and full application SDLC.
• Done Backup (online and offline), Restore and Redirect Restore
• Experience installing and supporting DB2LUW on both Windows and Linux
• Experience database performance tuning is expected.
• Experience on Backup and recovery methods including point in time recovery.
• Setup and maintain documentation and standards.
• Perform defect prevention plan and continual improvement tasks.
• Resolve issues related to data propagator SQL replication.
• Experience in multiple operating systems like Red Hat Linux Advanced forDB2(LUW).
• Experience with change control management for moving changes from Development to Production.
• Experience with Content Management, Business Intelligence systems, And with Big Data
• Experience Use of problem and change management tools & Managing Archive log files
• Involved in L2 and L3 activities.
• Attending Weekend calls with offshore and onsite teams
• Supportedon-call DBAresponsibilities in UDBoff-hour (24/7).

Confidential

DB2 DBA

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

Responsibilities:

• Worked as a DB2 Database Administrator in setting up the HADR environment on the DB2 Workgroup Servers.
• Highly involved in the project capacity planning and gathering prerequisites for the project.
• Applied Fix-packs to the most recent level of the DB2 version.
• Worked with instance and database configuration parameters to automate tasks, such as logging, memory management and database storage.
• Generated and implemented DDL for several projects from the logical model, using Erwin Data modeling.
• Migrated the database servers to the latest version which was 9.5.8 to 9.7.4 Pure Scale.
• Worked with the Operations DBA’s assisting them with the issues related to the production.
• Constantly migrated instances, databases to current level of DB2 versions/fix packs to in corporate the new functionalities.
• Setup HADR between primary and secondary servers to ensure High Availability, using db2haicu and TSAMP.
• Suggested Backup policies as per the requirement (offline/online; incremental/delta) and implemented the same and tuned the parameters accordingly.
• Responsible for database backup and recovery (offline and online backups - Full, Incremental and Delta Incremental). Database cloning, using Redirected Restores.
• Worked with various Data Movement Utilities, like Load, Import, Export, db2move, Replication for timely movement of data.
• Scheduled database changes, using ITSM tool.
• Used Data Warehousing concepts and WebSphere.
• Provided support on replicating data, using Q-Replication.
• Performed Scheduled maintenance on the databases, such as reorg and runstats in purging the older logs and backup images.
• Created and maintained documentation, such as functional design documents, detailed design documents, data flow diagrams, data entity relationships, security baseline checklist, transition checklist, test case checklist documents for the project.
• Implemented CIS standard security baselines while making data available to those authorized to have access.
• Worked with the IBM vendors to implement the design plans and provide solution architecture.
• Performed knowledge transfer to the remotely working DBA’s for the operations support.
• Provided DB2 support services in staging and production environments to the Operations DBA’s.
• Worked with various teams, such as Architecture design, Network Support, Windows, UNIX, and SAN to setup the clusters.

Confidential, OH

DB2 DBA

Environment: DB2 UDB V9.5, V9.7, V10.1, V10.5 5fOS - AIX, LINUX

Responsibilities:

• Designing and Implementing Database objects
• Creating and Altering DB2 objects like Databases, Tablespaces, Tables, Indexes
• Planning and Implementing Backup and Recovery strategy.
• Performing online utility such as Load, Copy, Reorg, Runstats
• Tuning utility job to improve performance
• 24/7 on call support.
• Hands of experience in migration of DB2 versions from V9 to V10
• Setup of HADR to ensure high availability2
• Took Offline and Online backup as well as wrote shell scripts and scheduled them.
• Put AutoSYS job scheduling daily based for Backup, Reverse engineering, Size of tablespaces, Snapshot and Runstats scripts
• Extensively used DB2TOP for monitoring database both in irrespective and Batch modes.
• Altered tables and added check constraints and referential integrity.
• Checked consistency of the databases, using DB2 commands.
• Implemented DB2 Security, Locking, Concurrency Control

Confidential

DB2 DBA

Environment: DB2 V9.1,V9.5,V9.7,V10.1 Sun solarise, AIX, LinuxOracle, IBM Data Stage and Netezza

Responsibilities:

• Create and Manage Servers, instances and databases
• PerformedSQL TuningusingEXPLAIN,tuningDatabase/ Database Manager configurationparameters for optimal database performance
• Worked on Workload Manager to explicitly control and influence resources during execution by mapping all the queries to service classes.
• Maintained database concurrency by setting properIsolation LevelsandLocksfor queries
• Worked on data movementIMPORT,EXPORTand LOADutilities.
• Recovered database usingcrash, version and roll-forwardrecovery methods.
• Experience in setting up and maintaining High availability disaster recovery (HADR).
• Performed database maintenance tasksREORGCHK, RUNSTATS, REORGon daily/weekly basis.
• ImplementedDB2 Performance Expertmonitoring tool on Dev, QA and Prod servers.
• Useddb2expln, db2ckbkp, db2look, db2move, db2pd, db2rbind and db2mtrkutilities
• Wroteshell scriptsand setting upCRONjobs 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.
• Maintaining and troubleshooting health parameters of the database such asDeadlocks, Lock timeouts/escalations, Buffer Pool/Cataloghit ratio, Utility/Databaseheaps.
• Monitoring Tablespace utilization,Diaglog, Disk I/O,CPU utilizationon a regular basis.
• Establish standards and procedures to implementdatabase securityandauditing procedures
• Involved in applying latestfixpakson all UDB databases.
• Troubleshoot database production problems and database connectivity issues
• Implement Business Continuity Solutions such as Database refresh, cloning, Database Backups, etc.
• Monitoring the database environment on a regular basis for performance and other issues
• Configure and maintain database high availability
• Monitoring all the database and Instance parameters usingFoglight monitoringtool.
• Responsible for designing, implementing and testing Disaster Recovery procedures and processes
• Experience on that Computer Security Policies, General IT and SOX Controls are followed
• Experience on compliance with naming standards
• Participate as a team member in projects that require outages, upgrades and patches to databases
• Produce documentation and procedures regarding the proper use and operation of the DBMS
• Capacity Planning
• Coordinate the resolution of DBMS problems that require DBMS vendor intervention
• OpenedPMR'sandService ticketsto get the resolution fromIBMfor critical database issues
• Experience with change control management for moving changes from Development to Production.
• Supportedon-call DBAresponsibilities in UDBoff-hour (24/7).

Confidential

DB2 DBA

Responsibilities:

• Tuning of DB and DBM configuration parameters
• Database version upgrade, patching
• Database maintenance scripting and automation of database admin related activities.
• Monitored the table space’s growth and added/extended the containers accordingly
• Worked with data movement utilities IMPORT, LOAD and Export
• Deploy database components by DDL/DCL.
• 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
• Configuration and administration of HADR.
• 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.
• 24/7 on call support.