SUMMARY

• Over 10 years of IT consulting experience as DB2 DBA on LUW
• Complete Physical Design of VLDB UDB DB2 databases across multiple physical nodes, in both SMP and MPP environments.
• Hands on experience and familiar with Oracle Database
• Involved and familiar in SAP HANA database setup
• Worked extensively on SAP systems with DB2 UDB as backend
• Implemented disaster recovery plans using DTHA, HADR, HACMP, HADR with HACMP and/or HADR with TSA (Tivoli Software Automation)
• Implemented Data server manager, monitoring tool for DB2 UDB databases
• Experienced in DPF and business warehousing database systems
• Worked with and experienced in various ticketing tools such as Remedy, Service now etc.
• Worked with Unix system administrator team in designing of Physical Volumes, Logical Volumes, Large File Enabled JFS, NFS file system
• Worked with system administrator and storage engineer in setting up storage level disaster recovery (which includes backup of the large database).
• Worked with environments that include third party vendor products like WebSphere Commerce Suite, Transport management system and Warehouse management system with DB2 as backend.
• Strong communication, verbal and written skills to effectively communicate, guide, document process and responsibilities.
• Strong technical background in Client - Server, n-tier Web technology and architecture.
• Used DB2expln and DB2advis to tune the expensive queries that ran against the production data.
• Used DB2 utilities like Snapshots, DB2top, DB2pd, DB2batch, DB2exfmt, event monitor, for performance tuning and monitoring
• Expertise in creating naming conventions or following the existing standards for the databases and instances.
• Maintained the database integrity, and created check points to avoid any database misuse, by implementing DB2 Audit facility across all Production Servers
• Worked on long term assignments handling Decision Support Systems (DSS) with DB2 as backend.
• Instrumental in physical designing of DB2 Database Servers on both UNIX (AIX) and Linux environments.
• Handled different Backup policies and performed hands on restores (version and point-in-time) and redirect restores as and when needed.
• Written good portable shells scripts to implement SQL replication on DB2 Servers.
• Understands the OS level to the extent the DBA is needed to, to interact or work hands-on to layout DB Servers, file system perspective.
• Experienced in disaster recovery methodologies like HACMP and HADR and HADR with TSA (Tivoli Software Automation)
• Used shell scripts to automate and maintain DB Server activities.
• Experienced in performance tuning and monitoring of OLTP applications and DSS applications.
• Worked as both Application DBA and Production Support DBA.
• Worked as Database engineer and heavily involved in POC, testing and certifying new tools.
• Understands the pro-activeness needed for the DBA, and resorts to automate most of the administrative tasks.
• Evaluated DB2 new versions and features and suggested migrations from DB2 lower versions to current versions.
• Delegated work to the DBA offshore team members by giving required check lists for the DBA’s to follow for lower life cycle and production systems.

TECHNICAL SKILLS

Industries/Domains: Retail, Manufacturing, Insurance, Mortgage, Energy

Operating Systems: IBM-RS/6000, IBM-OS/360, Linux, Unix, AIX, Windows NT, AIX P-Series

Software’s: Tivoli Workload Scheduler, Tivoli Storage Management, Tivoli System Automation

RDBMS: DB2 LUW 8.x/9.x/10.x/11.x, Oracle, SQL server, SAP HANA

Applications: Transport Management System, Warehouse Management System, Ab-Initio, Cognos 8.0, SAP BASIS, SAP BW, B2B, MS Project 2003, 2007, WebSphere Commerce Suite.

Database Tools: TOAD, Quest, DB2TOP, DB2PD, Control Center, Data server manager, Visio, Quest Central, SQLGUY, BMC Products, ERWIN Modeling, Visio, TOAD, DBI Brothers, OPM, Infosphere Data Architect, DSM, Q-Replication Dashboard.

PROFESSIONAL EXPERIENCE

Confidential, Detroit, MI

DB2 UDB Database Engineer/Production support DBA

Responsibilities:

• Involved in the design and Implementation of DB2 databases based upon application requirements and the resources required
• Participated on, project planning, system design, development and testing, security, and documentation implementation on the entire project
• Involved in yearly database upgrades projects and end of year lifecycle project
• Worked on Oracle Databases decommissions/retirements
• Familiar with SAP HANA and its setup/layout and recovery strategies.
• Worked with SAP BASIS system/teams on the SAP DB2 UDB Databases implementation/upgrades and troubleshooting
• Perform analysis of long running SQL’s, determine lock time out scenarios and work on performance tuning of the database.
• Involved in design/maintaining inhouse DR solution, DTHA.
• Design HA and DR solutions on new and existing databases based on the application criticality and requirements
• Worked with Tivoli team in setting up to configure DB2 LDAP with Group Plugin method
• Installed and maintained HADR for various applications/databases.
• Installed Data Server Manager Enterprise edition for DB2 UDB Databases.
• Tested and analyzed the capabilities and monitored performance of the 3rd party tools and prepared the Project plan.
• Worked extensively in gathering requirements and interacted with IBM to perform the pilot install of DSM V2.1
• Prepared SOP’s for installation and monitoring of new Databases tools and prepared Checklist for the work performed.
• Perform maintenance, performance monitoring, tuning and capacity planning for mission critical Enterprise Data warehouse and OLAP environment.
• Suggestions to the developers in terms of logical model, creation of appropriate indexes, MQTs, Views, triggers, finding out relationships, automating data loads on relational environments without letting tables into check pending states
• Installed the DB2 binaries in the new database servers and created the instances and databases.
• Provided suggestions and recommendations for ESE (DPF) logical design in the Data warehouse.
• Supported conversion team with Database Activities, helping them to tune their LOAD performance queries.
• Worked on capacity planning for storage that will be required and file system layout along with volume groups and provided the template to the system admin for the new databases servers. This also included providing the memory and CPU needed as per the application.
• Worked on SAP BW systems with few TB in size
• Follow and create the change order process for changes to the production environment
• Perform online/offline backups and restore/redirect restore of the same.
• Perform cross platform database restores as and when required
• Worked extensively with SAP Databases and performance tuning of the SAP systems
• Perform backup/restores on the SAP systems.
• Creation of new Dev, Test and Production databases and tables.
• Prepare work orders, requests and change requests using Data service ticketing system.
• Use different tools and inbuilt scripts for identifying performance problems and improve the same

Confidential

DB2 Database Engineer and Development DBA

Responsibilities:

• Involved in Database creation, Database replication and Schema Replication along with Database objects.
• Worked extensively with Build and Deployment team in new releases and code fixes from Database side.
• Heavily involved in DDL and DML Deployments.
• Worked in conjunction with the Data Architect based on the Projects requirements and Database structure.
• Installed different versions of DB2, mostly V9 and V10 various fix packs for new built Servers and Databases.
• Performed numerous version and Fix Pack upgrades in DEV and SIT region.
• Prepared SOP and Installation guide for Version and Fix pack installation and upgrades.
• Maintained, controlled and implemented more then 50+ schema along with Database objects in more than 30+ UDB DB2 Databases and 20+ servers.
• Used clear case tool for maintenance of the codes and baselines for different projects.
• Worked with system admins to create, layout and provide requirements for File Systems, CPU’s, Memory, Space and OS requirements for new built.
• Maintained the Database versions and code level according to Database/Environment/Schema and at Server level.
• Did hands on restores and backups as and when required.
• Scheduled and monitored DB2 utility scripts to run against the databases.
• Creation and maintenance of multiple schemas for different projects in Non-Production Databases.
• Worked extensively with Data Modelers for creation of new tables/indexes and objects based on the new Project requirements.
• Heavily involved in execution and debugging of DDL’s and DML’s provided by the data team.
• Hands on experience with Access Database and Enumerations
• Created User and Groups and maintained/managed using them MAC request tool.
• Extensively used Remedy Ticketing system for Incidents, Work Orders and CRQ’s.
• Involved in the design and Implementation of PE HA selling System
• Built HADR solution for the PE selling system
• Implemented TSA on the HADR system
• Prepared SOP’s, Implementation plan and Run book for HADR with TSA
• Worked extensively with IBM for the implementation and deployment of the PE HA solution
• Worked as Confidential ’s SME for HADR with TSA
• Implemented HADR on both AIX and Linux platforms
• Worked extensively in setup, troubleshoot and use TSA (Tivoli System automation) tool.
• Worked with Middleware engineering for Web logic changes required for HADR
• Worked with system admin to fine tune the Operating system parameters for smooth application failover after disaster in Linux, AIX and Sun Solaris operating systems.
• Involved heavily in testing the Database and application failover and failback.
• Extensively used Unix OS performance tools like NMON, TOP, VMSTAT, IOSTAT etc. to identify any resource bottlenecks.
• Did hands on restores and backups as and when required.
• Scheduled and monitored DB2 utility scripts to run against the databases.
• Provided bi-weekly status and training to Production Support DBA’s for HADR with TSA during the built phase of the HA Project
• Provided on-call and on-site support during the go-live of the HA Project in Production to the Production Support DBA’s and resolved issues with the implementation of the HADR.
• Prepared technical HADR and TSA documents for troubleshooting and maintenance of the HA environments after the Project went live.

Confidential

Production Support LUW DB2 DBA

Responsibilities:

• Supported more than 100 plus production servers with different application on each server and provided on-call support as and when needed.
• Experienced with IBM workload scheduler such as Maestro job scheduler to automate and schedule database jobs and utilities.
• Provided input and improvement in performance of current and new setup
• Used Remedy ticketing system to create, record, support and resolve incident tickets.
• Heavily involved in DR tests and in planning, designing and implementation of Disaster Recover methodologies such as HADR, Periodic dump and restore, log shipping, BCV copy and HACMP.
• Upgraded several numbers of servers from v8 to v9 and from v9 to v10.
• Involved with new server built, instance creation and new database built.
• Used perl scripts to automate database utilities such as backup, runstats, rebind, reorg on daily, weekly and monthly basis.
• Followed the change management methodologies, documented the defects and the root cause of the defects, and the resolution in the defect tracking system.
• Used Optim Performance Manager (OPM) to get Database health summary, details on locking problems, bufferpool hit ratio, memory consumption, disk space consumption and top dynamic SQL’s.
• Guided, supported and prepared documentation for offshore team for database recovery, upgrades and other database related tasks.
• Setting up schemas, tables and cleanup of the same
• Performed backup, restore and redirect restores as and when needed.
• Heavily involved with data movement using utilities such as imports, exports and load.
• Executed DDL, DML and Stored Procedures on UDB.
• Managed space in database, backup, transaction log and archive log filesystems by looking at database activity and growth
• Prepared capacity requirement documents and followed the CPM process to get the space (SAN) added to the server as and when required.