SUMMARY

• Over 10 years of IT experience as Database Administrator IBM DB2 UDB with Financial HSBC and Health Care Industry Prime/Syntel/McKesson
• Experience with PeopleSoft Financials/Portal/EPM/ABM/FDW/PJP OLTP, Data Warehouse systems in EEE multi TB environment.
• Experience in designing , creating and Upgrading SAP db2 databases
• Experience with Health Care Applications OLTP systems in EEE.
• Sr. UDB DB2 DBA on AIX at Prime Therapeutics
• Sr. UDB DB2 DBA on AIX/RedHat Linux at HSBC.
• Sr. UDB DB2 DBA on Windows/Ubuntu 6.1 for McKesson/Syntel.
• Analyst DBA for Intronix Systems to build and support CRM and Health Care Management System databases.

UDB DB2 DBA Experience

• Instance and database creation and configuration in non-partitioned EE and partitioned EEE/ESE database server including multiple logical MLP and multiple physical partition MPP configurations.
• Installation, configuration, and upgrade experience on single processor, symmetrical multi-processing SMP , massively parallel processor MPP , with enterprise storage area networks SAN .
• Creating and Converting existing Databases to Automatic Storage Databases
• Designing, Creation and Upgrade of SAP databases
• Performance Tuning of DataStage, BusinessObject queries
• Implemented MDC and Range Partitioned Together on one table and implemented Seperately.
• Setting up of AIX and Linux Environments Single and Multiple LPAR's
• Database migrations from AIX to RedHat Linux EE, EEE and from EE to EEE
• Database, instance monitoring using snapshots, event monitoring DBM, DB, Application, Lock, FCM, Dynamic SQL and Problem determination.
• Good Expertise with DB2MTRK, DB2TOP, DB2PD and review information for problem determination.
• Tier0 SSD-Thin Pooling , Tier1 Fiber Channel , Tier2 SATA , Tier3 Clarion Disk designing for Table space Containers Data, Log, Archive Log, Backup and Archive without contention.
• Database migrations for Tier1 EMC disks to SSD EMC disks.
• Setting up of Tablespace Containers to support Parallel Processing without contention for OLTP Databases and for Data Warehouse DSS Databases
• Requirements gathering, reviewed with Users, Architects and Developers for Capacity Planning
• Participated in Logical Design of DB2 Custom Designed Databases for both Transactional OLTP and Decision Support Systems DSS VLDB Helped in Defining Partitioning Key .
• Experienced in UDB V10.1, UDB V9.7, V9.5, V9.1, V8.2 on LUW Operating Systems.
• Proficient in Database Migrations and Recovery of databases.
• Very good understanding on WLM
• Worked with SYSADMINS to setup of Database cluster Servers and DR servers.
• Actively participated in DATA CENTER Migrations Requirements Gathering, Planning, Setting up of New Data Center and Implementing, Migrating database and application Servers .
• Actively participated in DR tests and Real DR Activates, including DR planning, setup, testing etc.
• Application and Batch Process Tuning Efforts Achieved 40 of Runtime Gains.
• Good understanding and working Experience of Statistical Views
• Setting up of Optim Performance Monitoring OPM for Database monitoring.
• Setting up of Optim6.1 for Database Archiving
• Installation, Setup of DB2 High Performance Unload.
• Writing Shell Scripts for Database maintenance Activities including but not limited to REORG, RUNSTATS, Pruning of Logs
• Database recovery experience with backup, restore, roll-forward, and log archival
• High availability HA experience with VERITAS Clutter Services VCS and HADR.
• SQL Tuning Efforts and DBM , DB CFG Parameters and database performance Tuning.
• Stored procedure, user defined function, and user defined table function experience with DB2 SQL/PL and Java.
• 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.
• Database analysis and design experience Computer Associates ERwin.
• Supporting PeopleSoft Installation/Migrations/Upgrades.
• Worked with People soft Financials/Portal/EPM/ABM UDB DB2 running on AIX/Linux RedHat OS.
• Scheduled the conference calls with the Off-Shore teams and coordinated the smooth transition and take over.
• 24/7 On-Call Support.
• Highly experienced in resolving deadlock and time out issues, which are common with most of the 3-tier vendor product applications which contain lot of Referential Integrity and DB triggers.

AIX/Linux Administrator SAN Experience

• Experienced in designing multiple LPAR's or physical nodes to establish UDB DB2 multi-partitioned database servers, experienced in DB2 Clusters and partitions Physical Nodes Logical Partitions
• Setting up of all filesystems JFS and Large File enabled JFS , home directory of DB2 instance NFS exported , across multiple physical nodes with appropriate naming conventions defined by the Production UNIX Sysadmins.
• Using SMITTY, performed most of the UNIX administrator tasks using root authority
• AIX/Linux RedHat OS Server space management
• Helped SAN Admin in getting a good physical design of the database laid out on a multi partitioned environment with sizing of LUN's, allocation of EMC Storage SSD, Fiber Channel

Application Servers SAP, BusinessObjects, SAS, PeopleSoft Financial/Portal/EPM/ABM/Websphere /FCR/Hyperion/PJP/Optim Archiving Data Masking

• Worked with PeopleSoft/FCR/Hyperion/PJP Admins to Configure Applications with DB2 UDB 8.1, 9.1, 9.5 and 9.7 and setting up of Application Security.
• Migration of PeopleTools suite PS 7.1 to 7.5.1 and from 7.5.1 to 8.1
• Migration of SAP DB2 V9.7 databases to V10.1 fp3a
• Installed and Configured Optim6.1 Application for Data Archive and Data Masking of Production Data.
• Supporting FCR Financial Control Report , PJP Platform Journal Processing application Migrations and Configuration Setup.
• Worked with Application Admins to migrate application codes to perform DB2 database administration tasks.
• Complete Design Physical and Logical of PJP Application, ITM/RRM process Tables, Views , Referential Integrity, Database Triggers Setup.
• Complete Design Physical of GH Application database

Analyst Engineer/Performance Test Engineer

• End to End Batch Process Testing with consideration of Each SQL in Batch Process.
• Proficient in writing Test plans, Test Procedures, Identifying Test Scenarios, Test Conditions, Use Cases and Test cases, Executing Test cases, gathering metrics and creating testing reports.
• Expertise in Product and Integration testing of Healthcare and insurance software.
• Experience in Automation Testing using WinRunner and QTP.
• Dedicated team player who works well with developers and testing peers.
• Self-starter with strong work ethic and excellent time management skills.
• Well acquainted with Defect Tracking Systems Test Director.
• Experience in Test Scenario Matrix Planning and Project Planning

Confidential

UDB DB2 DBA

• Migrating UDB V9.5 to V9.7, V9.7 to 10.1
• As part of Disaster Recovery strategies, implemented HADR on one of the OLTP Production Servers clustered across two IBM p-5 servers.
• Implementing HADR databases with TSA Tivoli System Automation
• Widely using DB2TOP tool to find out bottlenecks, ongoing executing applications, locks, snapshot of applications and queries which are running, bufferpool hit ratios etc.,
• Online data movement for tables by using db2 admin move procedure
• Supporting SAP, SAS, GuidedHealth, Business Object, DataStage Applications/Tools
• Responsible for design, creation and to upgrade SAP databases from 9.7 to 10.1 and used DBA COCKPIT to find out db backup issues and Changing DBM/DB cfg parameters
• Expertise in using DB2PD, DB2TOP, and Widely used SYSIBMADM Views to find Index Usage, Locks, Waiting Locks, Instance, Database configuration checks, Bufferpool hit ratio, Tablespace containers checks, Application info, Active Statements, Dynamic Cache, FCM buffers usage, Reorg Process checks, Utilities checks
• Used DB2PD on table level to find Number of Insert, updates, deletes on table and Index usage for heavy hit Tables and to find out reorg processes stage/status checks
• Widely used db2 admin move procedure as part of online data move activities
• Responsible for Physical database model maintenance on OLTP and Warehouse Databases
• Tuning GuidedHealth Batch Process, Reporting process, Table and Tablespace Design changes, Container modifications and Achived 45 of runtime Savings.
• Table design changes by Implementing MDC and Range Partitions achived 60 performance Gains over the Batch Process
• Implemented Range Partition Tables over Claim Tables
• Done various restore and roll-forward recovery operations from the source to the target databases as and when required.
• Responsible to Identify issues with newly implemented Information MDM process db2 as database
• Performance tuning of dynamic sqls captured from snapshots using tools like db2 explain, db2advis and also created different types of event monitors to monitor databases.
• Everyday Monitoring of GuidedHealth Batch and Reporting process and make sure identity long running queries and tune to meet Batch SLA's .
• Implemented Statistical View solutions for GH Queries and Rebates queries and achieved 70 of runtime savings.
• Client Configuration, instance set up for client connectivity for BOBJ Application as part of setting up DR System for BOBJ Production system.
• Designing, Implementing, Converting and Supporting BPW, PS, PBP Pharmacy Benefit Plan Processes and change of Process to run in Parallel Mode.
• Implemented Adaptive Row Compression on tables whose row count more than a Million and achieved 75 of DISK SPACE savings.
• Did periodic checks of the various database environments in terms of the growth of the data and maintained the threshold limit of 80 across all DMS table spaces.
• Responsible for Implementation of OPTIM 6.1 tool in various servers.
• Discussed, Designed, Documented, Implemented ,and lead the team in project planning, system design, development and testing, security, and documentation on the entire project.
• On-call support for Data warehouse and OLTP databases

Environment: UDB DB2 V9.7/V10.1, AIX5.3/6, Linux 5.6 RedHat , BusinessObjects, Web-Sphere, OPM 4.01/5.1/6, SAP, DataStage, Informatica MDM, Corticon Rule Engine

Confidential

UDB DB2 DBA

• Migrating UDB V8.2 to UDB V9.1 ESE and From V9.1 to V9.7 MPP and SMP .
• Setting up of EEE environment using 4 p-5, p-6, p-7 IBM Servers LPAR's with 17 logical nodes having 10TB data warehouse.
• Setting up of EEE PeopleSoft environment using RedHat Linux LPAR with 4 Logical nodes having 2TB Allocation PeopleSoft Transactional database.
• Designing PeopleSoft and Data Warehouse databases DISKs without Contention Tier0, Tier1, Tier2, Tier3 .
• As part of Disaster Recovery strategies, implemented HADR on one of the OLTP Production Servers clustered across two IBM p-5 servers.
• Table spaces and File system designing for EMC SSD DISKS Think Pooling .
• Creation of VCS Veritas Cluster Services Servers for Production databases.
• Setting up of DR servers and SRDF file systems setup with EMC disks.
• Supporting People Soft Financial Applications, Portal, EPM, ABM Migrations.
• Expertise in using DB2PD, DB2TOP, DB2MTRK to find Locks, Waiting Locks, Instance, Database configuration checks, Bufferpool hit ratio, Tablespace containers checks, Application info, Active Statements, Dynamic Cache, FCM buffers usage, Reorg Process checks, Utilities checks
• Used DB2PD on table level to find Number of Insert, updates, deletes on table and Index usage for heavy hit Tables and to find out reorg processes stage/status checks
• Logical and Physical Designing of New Modules for Data Warehouse databases CoRep, MI modules/functionalities .
• User requirements gathering and reviewing with users, architects and developers for incoming data feeds to Unix systems from Mainframe for the sources like TDA, DDA, Credit Card etc for Capacity Planning for PeopleSoft GL OLTP and FDS DSS databases, and Determined extending the database partitions, adding CPUs, Memory, DISK and Increasing the number of FCM buffers.
• DataCenter Migrations from Amhurst to Buffalo, From Buffalo to Volo and from Volo to Vernon Hills Actively handled real time DR Tests and actual DR situation.
• Tuning People Soft Batch Process, Tablespace Design changes, Container modifications and Achived 45 of runtime Savings.
• ITM/RRM/SQR processes Tunings effort and achieved 60 of runtime Improvements.
• Session databases design, implementation and supporting
• Done various restore and roll-forward recovery operations from the source to the target databases as and when required.
• Implemented MQT's for everyday repeatable queries and MDC's for monthly RSF/JSF Journal Tables balances verification jobs.
• Designed and Implemented Range Partitions Monthly, Daily , and ,as part of automating process, written scripts to Roll-in, Roll-out partitions.
• Performance tuning of dynamic sqls captured from snapshots using tools like db2 explain, db2advis and also created different types of event monitors to monitor databases.
• Everyday Monitoring of People Soft and FTP Batch process and make sure identity long running queries and tune to meet Batch SLA's .
• Extensive use of DB2 HPU to unload data from production then using DB2 Load Utility to load data onto Test Databases. This is to support and prepare test Bed for test Processes in BST/UAT databases.
• Implemented Clustered Index Solution for Heavy Hit Tables to remove ITM/PS LEDGER/PS JRNL LN tables PS batch tables from weekly reorg list .
• Implemented Statistical View solutions for People Soft PS Queries and SQR queries and achieved 70 of runtime savings.
• Client Configuration, instance set up for client connectivity for Cognos Application as part of setting up DR System for Cognos Production system.
• Monitoring databases Memory and CPU utilization on Server, giving suggestion to tune and Prioritize Workload and finding out heavy resource consuming SQL and scheduling change suggestions and implementation to reduce contention with User queries and Batch Process queries ITM/RRM, FIRE and Downstream processes
• Implemented DB2 Governor to force long running SQR/PS Queries and User queries which run more than 30mins or select more than 72000 rows.
• Designing, Implementing, Converting and Supporting ABM, GFDM/CIBM EPM Processes and change of Process to run in Parallel Mode to use multiple PeopleSoft Temp Tables.
• Implemented Row Compression on tables whose row count more than a Million and achieved 62 of DISK SPACE savings.
• Did periodic checks of the various database environments in terms of the growth of the data and maintained the threshold limit of 80 across all DMS table spaces.
• Installation and Configuring Database Achieving Tool OPTIM6.4.0/6.4.1.
• Responsible for Implementation of OPTIM tool in various servers.
• Discussed, Designed, Documented, Implemented ,and lead the team in project planning, system design, development and testing, security, and documentation on the entire project.
• On-call support for Data warehouse and PeopleSoft databases

Environment: UDB DB2 ESE/V8.2,V9.1 DPF EEE , AIX5.3, Linux 5.6 RedHat , VCS, Cognos, Web-Sphere Commerce Suite, Peoplesoft, FCR, PJP, Hyperion, OPTIM6.4.0/6.4.1/OPM 4.01/5.1

Confidential

DB2 UDB DBA

• Stored procedure, user defined function, and user defined table function experience with DB2 SQL/PL and Java.
• Participated in logical data model discussions to decide on the partitioning keys, primary keys and relationships triggers for Out and In Patients and Billing functionality tables.
• Active Member in designing and setting up of Production, Staging and Development Databases.
• Used Erwin to forward engineer and reverse engineer as and when required
• 24 7 on-call rotation carrying pager all the time
• Designed and implemented MQT for the data warehousing environment
• Export/Load data from Production to Non-Production and Staging, and Performance databases to support Test cycles.
• Redirected Restore of Databases to support Test cycles
• Excellent communication, interpersonal, managerial and team skills.
• Instrumental in implementing frequent DDL changes and going thru the complete life cycle development, UAT and Production of the project in adding columns into existing tables, creating new tables, taking care of all the dependant objects in the process.
• Performance tuning of long running queries and monthly, weekly report queries.
• Worked on Hospital Specific Code Migrations, Hospital Specific Enhancements Table changes and Specific Report queries Tuning.
• Implemented range partitioning on the data warehouse environment EDW to improve reports SQL performance across various geographies by 40 .
• Assisted the data modeler during the logical design phase with partitioning strategies, assigning DB2 data types and naming conventions
• Implemented BCU configuration for 10 Data Marts.
• CSR's and DCR workflow process and segregation and identification of Enhancements and Defects based on customer requirements
• Supported and Involved on Cognos Migrations and set up of new cognos content store Hospital by Hospital and Report by Report Migration.
• Complete Physical Design of different functionalities and Rules for Pathways Contract Management Application. Ex: Hourly Billing, Daily Billing, In Patient, Out Patient, Billing by Person, Billing by Child etc.,
• Performed various tests on the database from simple to complex queries and captured performance measures in order to assess Hospital specific queries performance.
• Created users and groups on the management node on the shared home directory and also created sudo access for selected users.
• Installed DB2 clients and Configured the Cogno's content store database and data marts for the appropriate users.
• Statistics collection on OLTP systems, DW staging system
• Monitoring Database using snapshot, Event Monitor's, Dynamic SQL monitoring to find out heavy hit tables based on Hospital and Implemented weekly maintenance of Tables..
• Statistics Collection for Bufferpools read/writes , Lock Monitoring, DBM CFG and DB CFG Snapshot to find out Lock List Memory Usage and SQL Sorts.
• Used DB2EXPLN, DB2EXFMT and DB2 Design Advisor for Long running queries and Index suggestions.
• Written appropriate maintenance shell scripts to maintain the production, QA and Development environments. The scripts include, Weekly Offline Backups to TSM, Nightly Online Backups with rolling 3 days backups on the disk and remaining in TSM with a retention period of 1 month, Runstats, Reorgchks and Reorgs, Archive Logs script- used only when connection between TSM and the Production Server fails.
• LDAP Server load balancing across Windows 2003 clusters to implement failover environment of the UDB DB2 OLTP Production database.
• Scheduling of all the automated jobs to maintain the Windows 2003 DB2 Databases was done using Tivoli Work Load Scheduler and also the scheduler provided by DB2 Control Center.

Environment: UDB DB2 ESE/V8, V9.1 DPF EEE , AIX 5.1/AIX 5.2, Linux 6.1 Ubuntu HACMP, Cognos, Web-Sphere, Java, J2EE, C , TSM, IBM SHARK ESS SAN

Confidential

Software Analyst DBA

• End to End Batch Process testing of CRM and Hospital Applications
• Effectively Managed CRM databases
• Physical Design Enhancements, Implementations of New/Adding CRM functionalities
• Identify long running batch process queries and run explains and find out index solutions with the help of design advisor
• Supported customized user defined queries By re-writing queries
• Supported code migrations from Dev -> Test 1 QA1 -> Test 2 QA2 -> Production
• Installed V8.1 ESE and setting up databases Test1 QA1 , Test2 QA2 with root and instance owner
• Applying Latest Fix Packs for V8.1
• Identifying Test Conditions, Designing Test Cases, Successful Execution of Test Cases
• Good working knowledge of Software Life Cycles, Project Management activities, Problem Solving abilities
• Database server workload identification and schedule changes to support Parallel Processing efforts
• Converted EEE database to EE database by dropping logical partitions and rebalancing data to node0 eliminated node1, node2, node3
• Identified data skewing and suggested Partitioning Key changes to redistribute data evenly across all HASH partitions
• Effective use column group spastics collection to improve query performance by 75
• Good understanding and working experience of Software Enhancements and Defects/Bugs and new releases
• Analyze custom code, involved in code and functionality reviews, walkthroughs and Knowledge sharing sessions
• Collecting end to end process timings and identify failed test cases and tune queries whose response times are not up to the mark
• Supporting data movement activity export, import, load from Prod to QA1 and QA2
• Snapshot collections, event monitor setup, lock monitoring, memory usage monitoring, sort monitoring
• Tuning SORT HEAP, SHEAPTHRES, LOCKLIST, NUM IOCLEANERS, NUM IOSERVERS parameters
• Weekly and monthly table maintenance REORG and RUNSTATS
• Setting up Backup Offline, Online, Online-Incremental Strategy for CRM and Hospital SelectPT databases
• Restoring of database from Prod to QA1 and QA2 for testing efforts
• Test Plan writing, Test Case and Test Conditions designing and running test cases and reporting failed test cases in Test Director
• As a Entry level analyst involved in Re-Testing, Regression Testing, Integration Testing, System Testing, User Accepting Testing, Business Process Testing of SelectPT and CRM applications

Environment: UDB DB2 ESE/V8.1/V8.2, MySQL, Windows 2000 Server, HADR, SQL Server 2000, Cognos, Web-Sphere, Java, C , PHP, TD8, QTP8.1, WR7.1

References: Provided upon Request