SUMMARY

• Over 8 years of educational and professional RDBMS experience with DB2 UDB on Linux, Unix, Windows (DB2 for LUW) and Solaris platforms. Possessing a strong background in SQL, AIX, Linux and shell scripting.
• Supported business applications on various platforms in clients like Target, Macys, Amex and Suntrust Bank.
• DB2 Installation, configuration, and upgrade experience including version migration and fix - pack migration.
• Instance and database creation and configuration (including auto-configure) in non-partitioned and partitioned database servers including multiple logical (MLP) and multiple physical partition (MPP) configurations.
• Client server communications configuration experience using TCP/IP, NetBIOS, SNA (APPC), IPX/SPX, and clustering over system area networks with TCP/IP and Virtual Interface Architecture (VIA) protocols.
• Database utility experience including reorg, runstats, rebind, export, import, load, auto-load, backup, restore and recover database utilities.
• Database backup and recovery experience with online full and incremental backups, online and offline transaction log archiving, restore and roll-forward (including redirected restore), and recover database utilities.
• High availability (HA) and disaster recovery (DR) experience with DB2 HADR, offline transaction log shipping, split mirror images, and data replication.
• Instance and database monitoring and tuning experience using the DB2 Health Center, Snapshot and Event monitors to monitor and optimize instance and database configuration parameters, table spaces, and buffer pools.
• Modified various alert scripts that page DBA for certain space reports.
• Setup daily dataload scripts on various servers which helped dumping daily data to RTP servers.
• Database and SQL statement access plan optimization experience with DB2’s Explain, Visual Explain, and Design Advisor tools.
• Data replication experience using DB2 Data Replication (DPropR) from DB2 mainframe and DB2 to DB2 client/server databases including Replicas (update anywhere) subscriptions.
• DB2 stored procedure (SP), user defined function (UDF), and user defined table function experience with DB2 SQL/PL.
• Database analysis, design, and reverse-engineering experience using Power Designer Data Architect, Embarcadero ER/Studio, and ERwin.
• DB2 system, instance, and database security and auditing experience using table definitions, triggers, data replication, and automated monitoring and alerting of security events recorded by the DB2 Audit Facility.
• Extensive experience automating database maintenance and monitoring with shell scripts including automating system event logging, e-mail alerting, and reporting using the DB2 utilities and Command Line Processor (CLP) with the Windows Shell.
• Database migration experience from DB2 on mainframe platforms to DB2 for Linux with the Confidential DB2 Migration Toolkit.
• Confidential Problem management, and resolution (PMR) experience with DB2 diagnostic log facility, administration notification log, trace facilities, db2 inspect, DB2 database analysis reporting tool (db2dart) and the Confidential DB2 Lab.

TECHNICAL SKILLS

• Linux
• Unix
• Windows
• LUW
• AIX
• DB2 9.5/9.7 6A EE/EEE ESE
• TSM
• Data Warehouse Manager
• Informix
• CA7 Scheduler
• BMC Patrol
• Toad
• Tivoli Workload Scheduler
• Windows XP
• Windows 7
• Business Objects.

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

SME DBA

Responsibilities:

• Supported DB2 Systems running DB2 v9.7 FP 5 till FP 11 in various environment, including DR and HACMP cluster environment.
• Successfully migrated 11k client’s customers in subjective waves.
• Worked closely with LoB, App and Vendor teams in order to understand and support migration testing
• WROTE and moved various SCRIPTS to monitor the entire process and generate alerts and alarms for specific issues and errors in OCM & OTM Environment.
• Performed REDIRECTED RESTORE to transfer data from PROD to various lower environments.
• Responsible for OBJECT MANAGEMENT, BACKUP, RECOVERY, SECURITY, PERFORMANCE TUNING, TROUBLESHOOTING, and UPGRADES.
• Collaborated with developers to devise DDL, in addition to contribution to code walk-through to analyze SQL code efficiency.
• Supported the PERFORMANCE TESTING TEAM and Environment.
• Resolved several performance issues with suggesting efficient SQLs.
• Installed DB2 binaries, configured instances and databases, database maintenance, recovery, high availability, and security for OTM 5.1 build.
• Worked with technical vendor in installing vendor proprietary tool for OTM 5.1 DB2 Database.
• Migrated DEVELOPMENT, TEST, and QA environments from DB2 UDB v9.7 FP 5 to FP 8 on AIX / Unix Platform.
• Performed Database maintenance, configuration, recovery, monitoring, failover, and security auditing suggestion of DB2 database servers.
• Helped in documenting all aspects of vendor based application in DB2 Systems.
• Participated in vendor based application and database build.
• Designed and implemented backup architecture viz., backup requirements, backup standards and retentions.
• Provided consulting and analysis to create roadmap and strategy for initial phase of table purge for QA and production Databases.

Environment: AIX, DB2 V9.7 Fp5 & DB2 V9.7 FP8, DB2 Connect, Windows XP, AIX 6.3, JAVA 1.6 64Bit, ARLM, UOB 5.1, Microsoft Lync, Microsoft Outlook.

Confidential

SME DBA / TL

Responsibilities:

• DB2 UDB EE 9.7 6A Database administration and support in LUW
• As SME DBA, Worked on planning, commissioning and overall designing of data structure of Database and its elements per guidelines.
• Worked with different teams on getting data and providing best suitable solution for desired structure of delivery.
• Worked on Confidential ’s internal project of building heterogenic data transfer model eg. CMDB to DB2.
• Migrated data from older db2 version to newer.
• Created new DR environment and performed various stress tests per guidelines.
• Worked on major project called DC2015, under which played a key role in DBA team of preparing 4 types of runbooks for DBA level tasks in Linux, AIX and Solaris.
• Performed REDIRECTED RESTORE solution to transfer full volume data from production to UAT environment to help user debugging data problem.
• Performed migration of databases between heterogeneous platforms (Solaris 10 to AIX 6.1) by working with the AIX administrators to set up the system before the restore the original database on the new hardware. Performed a version upgrade at the same time from V8.2fp18 to V9.7 FP 2.
• Learned and used thefeatures of V9.7.
• Experience in database restores and disaster recovery.
• Worked on 8 different use cases and its test labs for 3 months (18-20 Hrs of day) to choose best methods out for migration.
• Successfully migrated over 150+ servers from one Datacenter to another across the country with and / without outage depending upon requirement.
• Worked on fixing Confidential ’s own delivery tools, by pointing out possible solutions to deliver build and fix of instances on time.
• Setup pioneer path for internal process called “DC2015 Abbreviated process” and guided teammates by giving various presentations on work flow and build of an instance in all environments.
• Provided 24x7 production supports.
• Set record of working on maximum number of SRs (Service Requests) in minimum period of time.

Environment: All three environments (Linux, Unix, Solaris) LUW, AIX 6, DB2 9.5/9.7 6A EE/EEE ESE, BMC Patrol, Tivoli Workload Scheduler, EPV, Windows XP, Windows 7, Linux 6.1 OS, SameTime, Lotus Notes & Travelers.

Confidential, Johns Creek. GA

Database Administrator

Responsibilities:

• DB2 UDB EE 9.7 6A Database administration and support in LUW.
• Created a template starting from DB2 Installation, FixPack (4a) Upgrade, Instance creation, created databases and loaded data from various platforms to it.
• Synchronized LINUX platform database to UNIX databases using DB2MOVE tool and migrated whole database between two heterogenic Platforms.
• Migrated whole offline as well as live snapshot of a database between two different platforms using import and export scripts.
• Gave 24 x 7 supports to production databases.
• Tuned DBM CFG and DB CFG parameters and also the self-tuning memory manager.
• Involved in day to daydatabase administration tasks like running REORG’s, RUNSTATS, IMPORT, EXPORT, EXPLAIN, DB2ADVIS, taking snapshots, running list applications, checking the memory, BACKUPS, RESTORES etc.
• Created instance for iShop environment.
• Extracted DDLs of whole database and created identical database on different platforms for Quality Assurance, Test and Monitoring purposes.
• Granted various permissions to application team on particular objects.
• Setup of two similar databases for toggling between them to enable 24/7 database availability using scripts, one being online at one point and other being offline at same time.
• Understood and DEVELOPED FLOW CHART of DATA for whole DBA team.
• Updated various load processes by removing and solving locking issues.
• Used ‘lock with force’ option of V9.5 in order to solve locking issues of day to day loading activity.
• Used DB2RELOCATEDB to move database to other location.
• Did capacity planning for the existing database when the data was supposed to increase also added new schemas.
• Also used thefeatures in V9.7 such as the SYSIBMADM schema views in the monitoring scripts instead of the snapshot.
• Developed Stored Procedures and fine-tuned them to save time and to improve the performance.
• Created database objects: Tables, Table Spaces, Indexes, Views, and Aliases.
• Monitored various loads, improved total process time.
• Introduced and Implemented Jump-Box concept server and cataloged all the databases on appropriate instances.
• As a member of DBA team, created and maintained databases, table-spaces, tables, views, and indexes.
• Created and Designed Database according to various requirements.
• Interact with business team and development teams for incorporating new functionality.
• Documented plans and procedures in terms of backups, restores and disaster recovery.
• Tuning application queries, Databases and Systems for best performance.
• Tuned SQLs and brought performance time from two hours to twenty eight minutes.
• Monitored operation performance using governor scripts.
• Performed backups and restores on time to time in order to maintain data security.
• Performed dropped table recovery and recovered tables.

Environment: All three environments (Linux, Unix, Windows) LUW, AIX, DB2 9.5/9.7 6A EE/EEE ESE, TSM, Data Warehouse Manager, Informix, CA7 Scheduler, BMC Patrol, Toad, Tivoli Workload Scheduler, Windows XP, Windows 7, Business Objects.