EXPERIENCE SUMMARY:

7 years of experience in Information Technology. As a DBA, I have worked on all phases of DB2 applications from design to implementation. Provided 24x7 support with sense of urgency, accountability, reliability and quality. Extensive experience in onsite and offshore model. Extensive experience in working directly with Designers, Data Modelers, Business Analysts, Application developers, Testers and Customers to define their needs for quality solutions on time. Excellent time management, written, and verbal skills.

SKILLS INVENTORY:

Analysis/Design: Technical analysis, Logical design, and Physical design.

Quality Assurance: Extensively experienced in product testing such as regression testing, load testing, user testing, and other POC efforts.

Architecture/Development: Participated in Architecture and Development activities for databases. Migrated existing Architecture to new platforms.

TECHNICAL SKILLS:

DB2 DBA on AIX and LINUX

Versions: v10.5, v10.1, v9.7, v9.5, v9.1)

Production DB2 DBA AIX/LINUX

Application DB2 DBA AIX/LINUX

Migration DB2 DBA AIX/LINUX

DB2 product upgrades

Capacity management

Change Management

Server Consolidation

Database Migration

Data Migration

Federation

HADR

DB2 Admin tool

IBM Automation tool

IBM OPM Tool

Putty

DB2 Toad

SQL DBX

Insurance

Finance

Retail

CHRONOLOGICAL SUMMARY OF EXPERIENCE:

DB2 LUW PLATFORM LEAD/SENIOR DB2 DBA

Confidential, Louisville, KY

Responsibilities:

• Team Lead in charge of offshore DBA and Project DBA.
• Worked on engineering new solutions for Archiving Databases for Audit purposes.
• Worked on creating a project plan to upgrade environments from db2 9.7 to db2 10.5 while also working closely with IBM on PVU licensing.
• Worked on creating and DB2 LUW team culture and regular meetings to touch bases with all DBA s on my team also assigned work during this time and took status reports.
• SME for DB2 LUW on the WebSphere Portal V8 to V9 upgrade.
• Implemented best practices for DB2 once taking over the Platform.
• Created scripts to force idle threads and alert DBA/Application team when this happened.
• Worked closely with the Open Systems team (OS) to spec out new database LPARS of AIX.
• Conducted POC for different cloud solution.
• Performed an audit of the Database security and revamped the company s structure to simply security to implement LDAP solution.
• Worked on data to data DBA activities such as backup, reorgs, runstats, lock - waits, and performance tuning.
• Team Lead that was in charge of mentoring junior DBA s and helping them when the issue was escalated.
• Worked with directly with the Tivoli team to tune the Identity management and Access Management Database.
• Offered assistance to the OS team when there was I/O bottlenecks on the DB to help resolve OS performance issues.
• Point of contact for all DB2 LUW projects where I worked closely with Project Managers to establish deliverable task from a technical background.
• Created Knowledge documents so Junior DBA s could follow for basic trouble shooting and task.
• Monitored all db2 database lpar over 100+ to make sure they performed to an acceptable standard.
• Was select to the ITSS Leadership Development Program where I shadowed Senior Directors and worked with other peers that were select to come up best practices and solutions for Confidential .

SAP DB2 DBA UDB LUW

Confidential, Indianapolis, IN

Responsibilities:

• Lead DBA in charge of status reports, project estimation, DR, client coordination, and implementation of DB2 database solutions.
• Lead DB2 dba for TCS and worked with Client to come up with Capacity Planning, Database Upgrade Schedule, POC, and Debugging.
• Lead DB2 DBA for knowledge transfer to other TCS DBA on other platforms such as Oracle and SQL Server.
• Helped in the maintenance of SAP databases on DB2.
• DB2 upgrades to version 10.5 ftp 6 from V.9.5, V9.7, V10.1.
• Configuring HADR systems for the SAP Databases.
• Performed manual Hadr takeover for Primary and Standby databases.
• Participated in the migration of WMware to Extreme IO storage option.
• During Storage Migration migrated the database from 9 data containers to 4 data containers.
• Data/DDL Movement from database to database on separate servers.
• Database Restores.
• Database Backups.
• Database monitoring and performance tuning.
• Worked directly with the SAP Administrators on the Project to implement DB2 solutions.
• Created SOP documents for the Client.
• Worked to identify RCA with Database issues.
• Lead the DBA Team in maintaining project work for Z, D, J, Q, S, P, X, Y environments with multiple databases under them.
• Worked with very large databases some over 20 TB in size.

Senior DB2 DBA UDB Consultant

Confidential, Lawrenceville, GA

Responsibilities:

• Helping in the migration from DB2 z/os to DB2 LUW on AIX v10.5.
• Implementing different database jobs such as reorg, runstats, etc.
• Tuning Jasper reports that run on the database server.
• Backups, Restore, Tuning and debugging of the database.
• Maintaining a HADR cluster where the standby is read only and running reports off of.
• Working with the DBA team to come up with a security structure for the client's environment for DB2 LUW.
• Working with the developers to make code changes that are needed from Mainframe to LUW.
• Created and executed a data compression activity for Ricoh that saved them almost 3TB of space.
• Built out Ricoh s environment for Development, Month End, and Production.
• Performed fix pack upgrades for the client all the way to Fix Pack 3b on v10.5.
• Created Documentation for the client and to use for their reference to troubleshoot.
• Tuning Long Running SQL by creating indexes or working with the developer to optimize SQL statements.
• Created a solution for data migration to different target databases.
• Created Documentation for the client and to use for their reference to troubleshoot.
• Maintaining the user/group access to the AIX server until our Unix Engineers can take over.
• Working directly with developers to answers questions and recommend best practices for db2 udb on AIX.
• Created shell scripts needed for database Maintenance, health checks, and user interface script for data loading and unloading.
• Created a structured process to replatform the database from MF to LUW. Had to also come up with an error handling process to check DDL changes, Data exports (Mainframe), Data Loads (LUW), etc.
• Created Shell Scripts to automate process such as month end data unloads and loads.
• Performed Standard day to day activities as performance tuning databases for the best though put for users.
• Created the file system and the Database Architecture standard for Ricoh on DB2 LUW.

Senior DB2 DBA UDB Consultant

Confidential, Louisville, KY

Responsibilities:

• Helping in the migration from DB2 z/os to DB2 LUW on AIX v9.7.
• Implementing MDC partitioning on DB2 LUW databases .
• Bring my extensive knowledge in DB2 LUW to the migration team.
• Collaboration with the DBA team to come up with a standard process for the Migration.
• Scripting portions of the migration activities to significantly reduce time taken.
• Working with the DBA team to come up with a security structure for the client's environment for DB2 LUW.
• Actively performance tuning the databases for maximum efficiency/stability.
• Will be setting up HADR for the new DB2 LUW environments.
• Participating in POC for vendor tools to choose a replication tool and set a standard for the client.
• Working closely with the PeopleSoft team to troubleshoot problems they are facing.
• Sharing knowledge with DBA's present at the client site to further their db2 knowledge.
• Working on PeopleSoft upgrade during a parallel re - platforming of DB2 from z/os to LUW.
• Troubleshooting issues that arise during the migration with speedy turn around.
• Creating the zos db shell on LUW by getting information from the mainframe system tables.
• Validating object counts in between mainframe and the LUW shell.
• Normal Backup, Restore, Runstats, and Reorg for the databases.
• Created Federation for different databases.
• Migrated data from db2 on Mainframe to db2 on LUW.
• Conducting POC for db2 v10.5 for the client.
• Working on migrating databases from db2 v9.7 to db2 v10.5.
• Working on Peoplesoft suites CRM, HCM, FIN, and PRT re-platforming from zos to LUW.
• Creating Scripts for backup, restores, db health check, locking, and etc.
• Working with the different brands KFC, Pizza Hut, and Taco Bell to architect and engineer the design of the Non-PeopleSoft Databases.
• Setup Federated databases 3 HCM, FIN, and CRM for cross database quarrying.
• Migrated database from v9.7 to v10.5 fix pack 3.
• Maintained multiple TB size database environments.
• Developing Demo, Test, UAT, and Prod Servers for db2.
• Worked closely with the AIX team and the client to come up with a group standard for UDB.
• Worked closely with the Developers to change sql to be compatible with AIX federation standards.

Senior DB2 Development Database Administrator

Confidential, Roseland, NJ

Responsibilities:

• Helped in the migration from Sybase to DB2.
• Installation of DB2 V9.7 on new servers after Sybase Migration.
• Worked on design and creation for Prudential’s new DB2 environments for Group Insurance Division.
• Worked on multiple applications to insure best performance of Stored Procedures, Triggers, data loads (batch) and Database cfg.
• DBA on the team that was in charge of creation of Unix scripts to Scrub Privacy data in Development regions.
• Worked on scripts to automate Backups, Restores, Runstats, Reorgs, Table Space Reports, File System Reports, Log Compression, Database Privileges, etc.
• DBA that introduced an idea of server consolidation and design of to consolidate servers.
• Worked on partitioned data warehouse environment sized 10 TB.
• Lead DBA in charge of creating the design for multiple Development servers.
• DBA that Created Audit databases shell scripts for client audits.
• Created multiple Audit database for various fortune 500 hundred with all of them being successful (receiving high praise from Prudential and the Auditors).
• Worked closely with 4 application teams to develop new projects and gave input on how to optimize ddl, triggers, views, and stored procedures.
• Setup a standard in DB2 for release management to production.
• Used utilities like Db2 Top, Db2 Advice, and Db2 Explain to help trouble shoot.
• Identified security issues with database and created shell scripts to fix them.
• Coordinated release management to production.
• Worked vigorously on deadlocks and lock timeouts to fine tune the quarry and insure the problem was resolved.
• Performed regular day to day monitoring activities for the development server to ensure the best performance.

DB2 Production Database Administrator

Confidential, Atlanta, GA

Responsibilities:

• Create and maintain enterprise data warehouse sized 15 TB on DB2 AIX.
• Developed DB2 Environments from Unit testing to production.
• Extensively worked on all phases of DB2 application development.
• Monitoring database growth and capacity management.
• Tuned and fixed the hundreds of long running jobs.
• Extensively worked on DB2 product upgrades.
• Implemented HADR with HACMP on multiple production systems.
• Kept the DB2 environment healthy by doing regular maintenance like Partition rebalancing space alters, reorgs and Runstats etc..
• Played a key role setting up environment for India team and trained them.
• Participating on all day to day meetings like design, development, testing and release and providing solutions to Ad hoc DB2 issues.
• Co-ordination with Client to complete the scheduled task.
• Administration tasks such as monitoring, error checking, health checkup, troubleshooting, etc.
• Implement and maintain Database Security (maintain users, roles, assign privileges, profiles).
• Checking for errors and day-to-day troubleshooting.
• Creating databases, database objects and managing Database Users.
• Table space capacity planning and monitoring.
• Grant/Revoke privileges to the different users.
• Updating the dbm and db configuration parameter as per requirements following the Change Request procedures.
• Daily monitoring for file system usage and DB.
• Performed Runstats and Reorg(offline reorg over the weekends) Utilities.
• Performing Log Archiving for the databases & Making Tape Request for the same.
• Monitoring the database on Partitioned Environment.
• HACMP fail over testing for Database and applications availability - rotating resource group cluster.
• Performed migration of V8.2 Fixpack 7 servers to V9.5.
• Tuning the long running sql’s using db2explain, db2advis utilities.
• Deadlock monitoring and forcing down applications.
• Performance tuning by monitoring, taking snapshots.
• Handling problem tickets and meeting the SLA’s.
• Implementing various change requests.
• Provided 24X7 DB2 DBA support like creating new tables, altering existing tables based in requirement, Runstats, reorgs, back-ups, recovery and performance tuning.
• Participated in On-Call rotation policies.