PROFESSIONAL EXPERIENCE:

Confidential

Consultant - DBA Analyst / Admin

Environment: Single partition and shared disk ( Pure Scale ) environment to support Confidential Insurance ( JPOD, Curion and Broker Dealer) applications. Infrastructure spread across multiple RDBMS ( DB2 V9.5/9.7/9.8,Oracle, My SQL and Open source database Postgres 9 ) in composition with Unix,Linux and Windows platforms ( AIX 5.3/6 and Redhat 6 Enterprise Edition ), Mercury and Quest/DB2 Artesian are used as Problem/Change and Incident Management and DB Admin and performance monitoring tool. ER Studio for Data Modeling and Congos for Reporting.

Responsibilities:

• Analysis,research,design and write specification for maintenance and enhancement of databases.
• Data modeling for logical and physical database design, Installation and configuration of databases.
• Security / Disk space layout planning, Creation of databases.
• Performance monitoring, tuning, troubleshooting, reorganization and security implementation.
• Database capacity planning and design reviews.
• Co - operate with and provide technical support to Project teams, Strategic Business Partners and Associates.
• Maintain production database, design new structures / procedure / views / function for development of data migration from production to reports.
• Analyze logs and system messages.
• Migrate changes to system test and production environments.
• Database creation ( DDL); Archive/Purge data.
• Develops data design solutions based on Client/ Strategic Busniness partners needs.
• Refresh database structure and data to prep test environments.
• Documentation of key procedures.
• Prepare LINUX and UNIX scripts.
• Test database patches and upgrades; backups and recovery.
• Respond to automated alerts and requests from other items.

Confidential - Bloomington (IL)

Solution Provider - (Database/Data Analyst / Database Warehouse Professional )

Environment: Multi partition shared environment spread across 96 nodes, 60 TB plus in database size, Source-Legacy ( HP-Mainframes ), Target - DB2 UDB/LUW v9.5/v9.7 FP 5 on AIX 5.3 and SuSE 10, IBM HPU, IBM Data Propagator ( Replication ), Informatica V8, ER Studio Data Architech 8.5, IBM Optim, Quest.

Responsibilities:

• Capacity planning and storage forecasting for the production database.
• Define logical and physical model and maintain them in sync across the enterprise.
• Understand logical model and its relationship and analyses the data for business intelligence.
• Developed automated shell script for range partitioning, roll in and roll out data techniques.
• Set up scripts for Database maintenance activities like Runstats, Reorg etc.
• Creation of Materialized query tables.
• Created Databases for Development, Testing & Evaluation for Production.
• Creation and implementation of triggers and stored procedures.
• Tuned complex and long running SQL's.
• Creating explain tables and running the visual explain utility on sql statements.
• Recommend indexes for queries that run long and tune SQL queries using Explain.
• Worked closely with reporting team to validate reports and data accuracy.
• Database monitoring and tuning through snapshot and event monitors.
• Worked on database design and implementing appropriate changes to the physical database (indexes, database and server configurations, etc.)

Confidential, Dublin (Ohio)

Senior Consultant - UDB DB2 DBA

Environment: SAP-Frontend with DB2 UDB/LUW v8 and v9.5 FP4, v9.7 on AIX 6x and SuSE 10with IBM HADR Cluster.

Responsibilities:

• Contractor hired for Medical Business Transformation Project, Work with build team to gather the requirement and build the upcoming servers based on the requirement.
• Test and confirm the backup and restore strategy and define the standard process.
• Flash copy and Recover copy test to clone the existing database from production to staging environment.
• Setup of jobs for regular backups other maintenance activities.
• Verify Flash copy and recovery copy on media server.
• Routine DBA Administration.
• Applying security to database objects and users.

Confidential

Team Lead / Senior Database Administrator (UDB DB2 and ORACLE )

Environment: UDB DB2 V8/9.5 FP4 on AIX 5.3 (With HADR/DPF), Oracle 10G, MQ Replication,VCS Cluster and ER Data Architect Studio.

Responsibilities:

• Senior DBA responsible to manage daily Database Administration and maintenance for 200 UDB BD2 instances.
• Trouble shooting.
• Maintain physical and logical data model.
• Interact with business analyst, gather requirement and identity needed data to full business requirement in term by generating reports.
• UDB DB2 instance upgrades ( Regular/Alternate Fixpacks )
• Space Management.
• Instance and Database Migration ( UDB DB2 V8 to V9)
• Change Management
• Ensuring daily maintenance checks like runstats, reorgs, bufferpools, table-space space etc.
• Setup of Database Partitioning(DPF) on warehouse databases.
• Designing and implementing the database for DPF.
• Worked on disaster recovery plan and setups.
• Monitoring performance statistics and ensuring good performance.
• Database health monitoring.
• Database space monitoring, database trouble-shooting.

Confidential

Senior Database Administrator

Environment: DB2 UDB/LUW v8, FP9 and FP14, V9( DPF )on AIX, Linux and Windows. Oracle 10G on HPUX with Emc2 Storage.

Responsibilities:

• Responsible to evaluate SFUA high end features ( Database Mirroring/Snapshot and cloning) using veritas File system and Volume Manager features and certified them as a UDB DB2 expert.
• Certify high end features, by establishing lab setup for UDB DB2 (EE/EEE) and Oracle
• Check out for database cloning and snapshot feature, with the IBM provided workload.
• Test extensive limits for Database as well as SFUA features.
• Trouble shooting the database issues.
• Business partner support.

Confidential

Database Administrator

Environment: DB2 UDB/LUW v8 FP14 on AIX, Linux, Sun-Solaris and Windows on AMD

Responsibilities:

• Production Database Support, DB2 UDB V8 FP14, System Verification Testing; It is the testing of DB2 Product v8 FP14 for its capabilities and its behaviors with introduced new features, like peer-window in HADR.
• Installing the new release/Fix-packs by pulling the new builds, setting up the environment DPF/HADR, Creating the instance and Database which spans on all nodes. Populating the database.
• Running the workloads, Testing for the Database Administration Capabilities and
• Features, like crash recovery.
• Analyze the diagnostic log records for any problems and troubleshooting. Try to find the bugs in yet to release product. Report to DB2 Software Lab, Toronto.
• Observe takeover/failover by secondary server from Primary. Observe Behaviors of primary and standby servers.
• Analyze and research for new features of Takeover behaviors between Primary and Secondary Servers with different parameters sync, async and nearsync modes.
• Impact analysis about the implementation on various Administration modules of the DB2 product.
• Database Support: Ensured the 24/7 support by Managing the Time Schedules and Task distribution for Team Members. Handling the database growth, Health monitoring, Security checking, Backups etc. Used scripts to schedule and run jobs.
• Performance tuning of DB2 production databases. Tuning SQLs for better performance, I/O and Memory Tuning, Registry Tuning, Runstats, Reorgs.

Confidential

Database Administrator/Database Developer/Data Analyst

Environment: DB2 UDB/LUW v7/8 on Linux and Windows, SQL Server, SQL Replication, Quest Central and ERWin.

Responsibilities:

• AsDB2 UDB v8.2 Database Administrator, responsible for building Databases, Installing Application Server, WebServer and integrating the entire setup.
• Maintain Logical and Physical data model.
• Provides inputs to business owners and partners.
• Develops data design solutions and verifies they effectively meet business partner needs.
• Verifying the database users and object security.
• Documents the process flow and design pattern to propagate the changes.
• Providing 24/7 DBA support for troubleshooting though tickets. Monitoring. Troubleshooting Tablespace problems.
• Analyzing Buffer pool and other memory requirements for better performance.
• Regularly taking Backups and running Reorgs and updating statistics.
• Importing data. Migrating to new releases. Applying Patches.
• Maintain SQL Replication setup .
• Development of database; Creating Database objects, Stored procedures and User Defined Functions.
• SQl Tuning, Creating Indexes.