SUMMARY

• Ten years of experience in database administration, maintenance and performance tuning using DB2 LUW on UNIX and LINUX .
• Extensive DB2 UDB DBA experience on version 8.1/8.2/9.1/9.5/9.7/10.1/10.5/11.1 with activities involving design, installation, configuration, requirements gathering, data modeling, tuning, security, backup, recovery and integration of database applications.
• Experience in data Warehousing and OLTP databases with strong experience in handling critical applications running 24/7
• Extensive experience with planning, documenting and performing Database upgrades and migration.
• Extensive experience with setting up new database environments and create database servers and database server moves.
• Provided DBA 24x7 on call Support for companywide UDB Production databases
• Experience in database software management (patch and version management).
• Experience in problem analysis and troubleshooting database related issues. Provide performance tuning support to development teams for resolving issues with space usage, stored procedures, SQL Tuning and application monitoring.
• Experience with case management of IBM DB2 technical support
• Experience with column organized BLU tables in 10.5.
• Experience in Performance Tuning, Space Management and Planning Backup & Recovery strategies.
• Preformed multiple installations and upgrades of DB2 across different versions and fixpacks.
• Implemented DB2 Row/Index Compression .
• Setup HADR environments using TSAMP with virtual IP.
• Worked with Gaurdium and Vormetric for monitoring and database encryption.
• Performing day - to-day database administration maintenance tasks.
• Proficient in shell scripts for various kinds of administration tasks.
• Ability to work within cross-functional teams.

PROFESSIONAL EXPERIENCE

Confidential, Reston VA

Database Engineer

Responsibilities:

• Certify new versions and fixpacks of DB2.
• Create BladeLogic packages/scripts to automate teh DB2 installation (DB2 9.7,10.1,10.5,11.1)
• Support production DBAs in resolving any level 3 issues
• Assisted developers with teh performance test initiatives. Performed index analysis and made recommendations to development teams.
• Review and validate teh database requirements for any new applications
• Create teh SOP documents for multiple database related activities, which are used by teh production DBAs.
• Setup IBM IIDR 11.3 (CDC) for DB2
• Setup IBM DSM for database monitoring
• Worked on multiple database upgrade projects.
• Created multiple shell scripts for maintenance activities.
• Completed a POC on IBM BLU
• Created scripts for database creation, retirement, database capacity, etc..
• Worked on a 30 TB, 33 node DPF database migration from AIX to Linux
• Tested and setup EMC DDBOOST as a replacement for IBM TSM for backups.
• Setup multiple HADR environments with TSAMP.
• Extensively involved in capacity planning for databases.
• Setup a Gloden Gate environment for DB2 replication.
• Worked on setting up a MongoDB environment for a POC.
• Completed a POC on virtualization of Db2 databases using Delphix.
• Environment: UDB DB2 9.7, 10.1 and 10.5, AIX, Linux, Solaris,TSM, IBM DSM, IIDR

Confidential, Columbus OH

DB2 UDB Database Administrator

Responsibilities:

• Instance and database creation and configuration.
• Database utility experience including reorg, runstats, rebind, export, import, load utilities.
• Database backup and recovery experience with online full and incremental backups, nline and offline transaction log archiving, restore and roll-forward (including redirected restore)
• Worked with multiple applications using Websphere Commerce,ICM, Portal and SAP ECC,BI.
• Good working noledge of SAP Cockpit for LUW V9.x, V10.x.
• High availability (HA) and disaster recovery (DR) experience with DB2 HADR, offline transaction log shipping, split mirror images.
• Performed multiple upgraded from DB2 9.7 to 10.1 and 10.5.
• Install and configure DB2 UDB new releases, upgrades, and patches.
• Performing SQL tuning, DB/DBM parameter tuning and different levels of memory allocations.
• Instance and database monitoring and tuning experience using teh Snapshot and Event monitors to monitor and optimize instance and database configuration parameters, table spaces, and buffer pools.
• Extensively involved in performance tuning, recommending SQL queries for better performance using visual explain, index adviser, db2expln, db2exfmt.
• Interface with business analysts & developers with regards to application, logical & physical database design, create and maintain logical entity relationship diagrams, transform logical models into physical data models.
• Changing instance level and database level configuration parameters for database concurrency, autantication, performance and allowing remote clients accessing server.
• Assisting with teh creation and modification of primary database storage structures (tablespaces) and primary objects (tables, views, indexes).
• Perform capacity planning and analysis and implement required changes on teh database servers.

Environment: UDB DB2 V9.5, 9.7, 10.1 and 10.5, AIX, Linux, Optim Performance ManagerNetbackup, IBM Data Studio

Confidential, Seattle WA

DB2 Database Administrator

Responsibilities:

• Installed DB2 V9.7 FP5 on over 300 servers, production and dev included.
• Upgraded approximately 300-400 databases and instances from V9.1 to V9.7.
• Migrated version 8 instances and databases to version 9.7
• Applied fixpacks to DB2 V8.1 instances.
• Performed multiple fix-pack upgrades.
• Performed backups/restores.
• Upgraded teh servers from 9.1 to 9.7 with HADR databases.
• Was involved in performance tuning of slow running queries.
• Resolved DBA help desk tickets.
• Built out new servers.
• Rebuilt indexes.

Environment: UDB DB2 V9.1, V9.5, V9.7 UNIX-Sun Solaris / AIX, DB Visualizer

Confidential, Tampa FL

DB2 Database Administrator

Responsibilities:

• Upgraded production systems from 9.1 to 9.5 and from 9.5 to 9.7
• Involved in new server builds and installations.
• Was responsible for data migration from Confidential to Confidential .
• Identified and corrected data functions that are slow or expensive in terms of system resources.
• Supported high transaction OLTP databases.
• Developed queries to isolate, correct or eliminate redundant or bad data.
• Experience with enterprise backup and recovery strategies.
• Creating primary database storage structures (tablespaces etc.).
• Creating primary objects (tables, views, indexes etc.).
• Collecting database resource & CPU utilization in busy hours & idle hours and doing maintenance through reorganizing, collecting statistics and rebinding of packages.
• Modifying teh database structure, as necessary, after collecting information from application developers and based on statistics gathered.
• Configuring high availability & disaster recovery.
• Monitoring and optimizing teh performance of teh database, tuning database performance.
• Backing up and restoring teh database, bringing database from no archive to archive mode, maintaining archived data on tape.
• Monitor and estimate teh disk requirements.
• Stand-by database management, log shipping and applying, DR drills to ensure smooth working of standby database in event of disaster, switch-over.
• Data maintenance through import, export & load.
• Handling database related production issues.
• Extracted data from DB2 for migration to Oracle and worked with teh ETL teams.
• Provided 24x7 on call support.

Environment: UDB DB2 V9.1, V9.5, V9.7 UNIX-Sun Solaris / AIX, Quest Central

Confidential, Tampa, FL

DB2 Database Administrator

Responsibilities:

• Supported DB2 UDB databases on Versions 8.2 and 9.1 on both OLTP and DW environments.
• Providing support to System Administration (SA) in database installation, instance creation, instance upgrade and version migration from V 8.2 toV 9.1.
• Design, analysis and creation of new databases (analysis about number of database partitions, available memory, database size, database & database manager configuration options).
• Tested and implemented teh row compression feature to save disk space in production environments.
• Managing Database user privileges (granting & revoking permissions after proper analysis & approval).
• Database performance tuning and troubleshooting, resolving database issues for teh dev support.
• Responsible for creating databases and objects such as table-spaces, tables, primary keys, indexes etc.
• Supported Data Migration for Confidential databases. Maintained referential integrity and referential constrains, using both EXPORT and IMPORT for data move to Confidential Servers.
• Query tuning for teh problematic queries sent by application developer or identified during database monitoring.
• Database monitoring (free space in tablespaces, event monitor outputs, security audit reports, performance reports etc.).
• Database backup & recovery (offline & online backups, Full, Incremental & Delta Incremental) High Availability Disaster recovery (HADR).
• Database cloning using redirected restores.
• Perform capacity planning and analysis and implement required changes on teh database server.
• Analyze application SQL for performance improvement opportunities and work with DB2 support on problems and questions.
• Supported high transaction OLTP databases.
• 24*7 Support for availability of Mission Critical Databases.

Environment: UDB DB2 V8.1/8.2/9.1, Windows NT, UNIX-Sun Solaris / AIX, Quest Central