SUMMARY:

• Over 9+ years of experience in the IT industry as DBA on DB2 UDB, ESE and EEE v8.2, v9.1, v9.5, v9.7, v10.1 and v10.5 on Linux, Unix, Windows LUW and AIX v5.1, 6.2 . Knowledgeable in all aspects of database administration, maintenance, migration, upgrade and architecture. Proven ability in sizing, tuning and optimizing databases.
• UDB DB2 Database installations starting from EEE/8.1 and ESE V9.x (9.1, 9.5, 9.7 & 10.5).
• Extensive with OLTP and Data Warehouse systems, Application development life cycle methodologies, Database and Application performance tuning and Advanced Replication in OLTP environment
• Done migrations from UDB DB2 V8.2 to V9.1 and V9.5. to V9.7. Upgraded multiple databases and Fix pack upgraded for UDB DB2 V8.2 to DB2 V9.1, V9.5, V9.7, V10.1 and V10.5.
• Participated in DB2 logical database design and been instrumental in doing DB2 on AIX physical design for large Data warehouse environments and also highly transactional customized OTLP databases.
• Worked on the 16 Partitioned Data Warehouse database, each partitioned DB is about 2 TB size.
• Implemented DB2 DWE to interact with AIX DB2 data warehouse environments.
• Done large implementations of OLAP environments using DB2 DWE, to facilitate report generation of DB2 queries for the Business Intelligence teams.
• Database utility experience including reorg, runstats, rebind, export, import, load, auto - load, backup, restore and roll forward utilities.
• Documented test plan including the testing of data partitioning (DPF), table partitioning, multi-dimensional clustering (MDC), XML support, and data compression. Improved performance by 40% by converting tablespaces to multiple partitions with DPF.
• Collaborated with Technical Project Services Group to deliver comprehensive database solutions supporting business functions, OLTP systems, Information Integration, Data Marts and other enterprise data stores.
• Excellent work experience on ETL tools.
• Worked with third Party utilities and tools like QUEST tools, IBM data studio, BMC tools, ToadOptim tools etc.
• Scripting experience using both the shell programming and batch programming.
• Database recovery experience with backup, restore, roll-forward, and log archival, and the DB2 advanced database recovery tool (db2dart).
• High availability (HA) experience with HACMP and HADR and Manage maintenance of production application databases, disaster recovery testing,
• Database monitoring and tuning experience using DB2’s Performance Monitor, Snapshot Monitor, Event Monitor, Explain, Visual Explain, and Index Advisor performance tools.
• Extensive experience working on Work Load Manager WLM . I have setup the Workload manager for mul
• System, instance, and database security and auditing experience using table definitions, triggers, data replication, and the DB2 Audit Facility.
• Stored procedure, user defined function, and user defined table function experience with DB2 SQL/PL
• Problem identification, management, and resolution experience with DB2 diagnostics, trace facilities, and database analysis reporting tool (DART).
• Database benchmarking experience using Quest Software Benchmark Factory and Mercury Interactive Load Runner benchmarking tools.
• To Carried pager 24/7 On-call rotation team, performed On-Call duties taking care more than 60 UDB databases various client servers during the regular time and off hours. Resolved many on Non-production and production issues like, failed backups, archiving to TSM, Tablespaces & filesystem maximum used file systems limit alert, and databases down, etc.
• Capturing the long running queries and executing Explain and db2advis to create indexes and examine the access plan.
• Addressing the DB issues submitted on PR Ticket with Sev 3 to Sev 1. And also reported the PMR Tickets for the various issues on db2
• Able to perform change/problem management activities using standard change/problem processes in support of application database related changes.

TECHNICAL SKILLS:

• DB2 UDB V 10.5/10.1 9.7/9.1
• 9.1/8.2
• DB2 for Z/OS 11
• Oracle
• SQL Server
• AIX V 4.3.2 on RS/6000
• AIX v5.1 v6.1
• Snapshot and Flash clone technology
• DB2 EEE
• OLAP Integration Server
• Brio
• COBOL
• DPROPR
• Optim Performance Manager (OPM)
• Data Joiner
• REORGCHK
• RUNSTATS
• event monitors
• snap shots using shell scripts
• Quest Central
• Embarcadero
• DBArtisan
• SQLGuy
• SQL Compare
• SQL Sentry
• SQL Profiler
• MS Office
• Putty
• TOAD
• SSMS
• Erwin
• DB2 Text Extender
• Db2 Explain
• DB2 Connect
• Data Propagator
• DB2 Replication Center (DB2RC).

WORK EXPERIENCE:

Confidential, Harrisburg, PA

DB2 UDB Database Administrator

Responsibilities:

• Application DB Support for Integrated Eligibility Support Database which include creating Tables, Logical Tables, Stored Procedures, Triggers, sequences and various other Database objects.
• Installing DB2 products in Client and Server machines to setup Database Environments.
• Performing silent Installations using response files to setup and bring Databases up and running quicker.
• Setting up federation between two different environments and creating wrappers, servers and nick names
• 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, Tablespaces, Buffer Pools, User Roles, User Defined Types (UDT) and functions.
• Restoring Databases from backup copies using both online and offline backup copies. Performing rollforward operation to restore to a point in time, end of logs and end of backup
• Analyze production Databases for Performance Issues, generating package cache reports using MON GET PKG CACHE STMT view and identifying queries for performance tuning
• Working with Developers in Query Tuning, generating explain plans, Implementing indexes and query rewriting using db2exfmt, db2advis, db2expln and IBM data studio tools
• Comparing different DB2 databases for difference in database object structures and synchronizing them using TOAD and DB SOLO tools
• Partitioning tables and Redistributing data among Tablespaces.
• Moving tables to different tablespaces using ADMIN MOVE TABLE procedure
• Dropping, recreating and extending table partitions based on application needs
• Executing database maintenance activities like REORG, RUNSATS, purging old archived log files
• Worked with data movement utilities like load, export, import for data migration tasks between prod and staging
• Developing PL/SQL packages, stored procedures and triggers for various functionalities provide by client
• Develop scripts to automate regular maintenance activities like backups, forcing idle connections, space monitoring etc.
• Created scripts using SYSIBM,SYSIBMADM catalog views to monitor and maintain databases
• Creating event monitor to capture DEADLOCK, LOCKWAITS & LOCKTIMEOUTS and generate reports for analysis
• 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).
• 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.
• Monitoring Tablespace utilization, Diaglog, Disk I/O, CPU utilization on a regular basis.
• 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, Dublin, OH

DB2 UDB Database Administrator

Responsibilities:

• Served as the DB2 DBA SME for various applications like RBC, Order Express, Dot Com, GWSA, ADC, PMOD, DAM, Migration from 9.7 to 10.1 & 10.5, Migration from AIX to LINUX, RHEL, UNIX and vice versa.
• Provided consultation to application development teams on DBMS product technical issues, techniques and SQL review.
• Experience with SQL tuning and analysis.
• Coordinated with system engineers to configure servers for DBMS product installation and complex database creation.
• Performed database related optimization, diagnose system bottlenecks and application related bottlenecks.
• Served as resource for database server consolidations project, collapsing multiple database servers to form large SMP environment.
• Performed checks that are run against specific databases to identify specific conditions or vulnerabilities using McAfee Vulnerability Manager.
• Created and maintained UDB DDL for databases, table spaces, tables, views, triggers, and stored procedures. Resolved lock escalations, lock-waits and deadlocks.
• Expert experience in database performance tuning and troubleshooting.
• Experience with ETL tools (Informatica, Data Stage, etc) preferred Experience with DBI Monitoring and Performance tools Experience with WLM (Work Load Manager).
• Experience with DB2 Federated databases Experience collecting database statistics for forecasting, key performance indicators and SLA statistics.
• Established, maintained, troubleshot SQL Replication. Worked with TSM and VERITAS net backups
• Designed the disaster recovery strategies, which involved the backup and recovery procedures, setting up of HADR across UNIX clusters, HADR with TSA (Tivoli Software Automations) Implementations.
• Scheduled the self-written shell scripts to do periodic runstats, reorgchks and REORGS if required (during the maintenance window) and all other database maintenance activities, like tablespace, container space monitoring, and database sizing scripts for Servers running on UNIX Operating Systems.
• Worked extensively on db2move, Export, Load for exporting it to a file and then importing from the file to the database respectively i.e. moving the data from one database to the other one.
• Responsible for successful execution of the ticket, documenting status, providing feedback to the owner and closure of the tickets.
• Managed database storage and capacity planning on DPF and Non-DPF databases. · I have expertise in application development support activities including database design, optimizing SQL queries, building complex SQLs, dynamic SQLs and triggers, effective binding of packages and plans, concurrency planning, data refreshing and database objects migration across regions.
• I have designed, tested and debugged external and DB2 native stored procedures.
• Worked with remote stored procedure calls.
• Analyzed index requirements and designed appropriate indexes.
• Performed SQL tuning and bind plan/package creation for enhancements and developments
• Support production environments, configuration, testing, and performance tuning of all DB2 database environments. Verify the database support requests and execute them in timely manner as the business SLA's.
• 24X7 Production DBA support for application development, deployment and support activities.
• Responsible for performance tuning, support, analysis and resolution of database problems that occurs during the critical time processing.

Environment: DB2 Version 10.1/10.5, AIX, LINUX, IBM CDC Data replication DB2 Connect V 10.1, Service Now Ticketing tool, Shell Scripting, BPM, Websphere, McAfee Vulnerability Manager, DPF, Work Load Manager WLM .

Confidential, Seattle, WA

UBD DB2 Database Administration

Responsibilities:

• Monitoring of the activities in the databases with Snapshots and Event Monitors and recommending measures for optimizing the db performance.
• Working on the migration plans for moving over to v9.7 from v8.18.
• Capturing the long running queries and executing Explain and db2advis to create indexes and examine the access plan.
• Designed, debugged and implemented stored procedures and triggers
• Identified problematic SQL and optimized SQL queries that helped improve application performance.
• Implemented HADR for 6 databases in Dev, QA and Production and configured TSA to automate the HADR process.
• Restored the databases using offline and online backups. Redirected restores were also done.
• Use MEET tool to evaluate compatibility of client database objects between Sybase and DB2.
• Install and configure DB2 SQL skin, IBMDMT and DB2 migration tool kit.
• Analyze data criticality to devise data migration strategies using DB2 backup/restore or DB2 export/load.
• Worked with client DBA on space/memory allocation for DB2 instances/databases.
• Worked in SAP environments with database sizes up to 6 terabytes.
• Handled Db2 Database on SAP Environment, Implemented the SAP Notes on the Database.
• Project Planning - Preparing detailed plan, providing estimates for tasks, Scheduling tasks.
• Follow-up with software updates and fixes following bug resolution.
• Performance monitoring of the complete DB activities which include Lock/Deadlock situations, Log archiving, tablespace size issues.
• Updating the progress of the new projects at the daily meetings.
• UDB DB2 database tuning by dealing with Database & Registry variables to enable speedy transactions.
• Written shell scripts to automate the Offline and Online backups. Scripts backup the db to disk and to the TSM tapes.
• Upgraded Database and Applied database Fixpaks for current version.
• Established the 3-tier architecture using the IBM WebSphere Database model and done physical design of the DB2 database.
• Participated in weekly on-call production support.

Environment: DB2 V8.18 & DB2 V 10.1/9.7/9.5/9.1.3/8.2, AIX 5.3, HADR with TSA v2.2 (Tivoli System Automation), Quest Central, TOAD, DB2 UDB Database consisting of SAP R/3 4.6C, BW 3.1C, IBM Websphere Commerce Suite, DB2 migration tool kit.

Confidential, Detroit, MI

UDB DB2 LUW Database Administrator

Responsibilities:

• Supported and maintained IMS and DB2 Databases.
• Administration of database, table and table spaces.
• Moving 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. Migrated from V8.2 to V9.1
• Initiated and executed maintenance schedules for production performance monitoring
• Seamlessly instituted new IMS Databases and DB2 Tables
• Proactively participated in DR exercises
• Create and modify databases and database objects as per application requests.
• Provided on-call support and well exposed to 24x7 environments.
• Daily and weekly database Maintenance activities such as backup, runstats, reorg and all related activities for databases.
• Worked on 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.

Environment: DB2 Version 9.7/9.5.x/9.1.x/10.1, DB2 for Z/OS 10.1/11, COBOL, DB2 Connect 9.5.x/9.1.x, AIX 6.1/5.3, Web sphere Federation Server 9.5.x, DB2 Client 9.5.x/9.1.x, BMC Patrol, HP Service manager, Control-M

Confidential, Roswell, GA

UDB DB2 LUW Database Administrator

Responsibilities:

• 24x7 production database support which includes handling pager calls, problem identification & resolution of DB2 systems.
• Project involves production, test, and development administration and support for client's existing DB2 UDB platform running DB2 UDB v9.1 and v8.2 on servers under various operating system platform (UNIX, Linux and Windows environment)
• Initial responsibilities include: stabilizing environment, monitoring, tuning, and problem management reporting (PMR).
• High availability, maintenance, monitoring, and problem management reporting.
• Additional tasks included documenting platform configuration, maintenance, security, standards, and high availability disaster recovery
• Migrating and maintaining data with LOAD, EXPORT, IMPORT and DB2MOVE utilities
• Performance tuning of the DBM and DB configurations.
• Monitoring of the activities in the databases with Snapshots and Event Monitors and recommending measures for optimizing the db performance
• Addressing the DB issues submitted on PR Ticket with Sev 3 to Sev 1. And also reported the PMR Tickets for the various issues on db2
• Alter the tablspaces from 4K page size to 8K, 16k and 32 K page sizes.
• Refresh production database in to the PPD and other environments from the TSM.
• Update TSM NODENAME and TSM pasword for Refresh QAT/PPD environment from production database
• Coordinated and supported various teams on the deployment from QAT/PPD and PROD databases built
• Installing and Maintaining DB2 environment including creating Databases, Buffer pools, logical and Physical design of database storages using DMS tablespaces
• Refreshment of Test, development with copy of production databases. Support at the time of moving from test, development to production systems.
• Migration from one environment to another at database, schema and table levels.
• Maintaining job scheduling utilities for all database maintenance scripts Online/ Offline backup strategies, archive Logs, db2 issues error alerts in db2diag log, reorgchk, reorg, tablespaces maximum used space alert, db sizes, and etc., via Unix and Window cron job scheduler.

Environment: AIX, Linux, Windows, ODBC, Data Propagator replication (DPropR), Smitty, Enterprise Manager,DB2 UDB, ER Studio, BMC, UNIX Shell Scripting (Ksh, Bash).