SUMMARY

. Over * years of IT experience in Analysis, Design, Development and

Database administration of DB2 UDB (EE/EEE ESE/DWE) on AIX, Unix,

Linux and Windows platforms, DB2 on Z/OS platform.

. An IBM Certified DB2 UDB DBA, with extensive experience on physical

and logical design,

monitoring and maintenance, query analysis, optimization, backup and

recovery, replication, migration with OLAP, OLTP databases.

. Expertise in Installing, Configuring, Upgrading and Maintaining DB2 on

AIX, Linux, HP UNIX and Windows platforms.

. Expertise in database Backup, Recovery, Monitoring, Performance,

Security and Tuning.

. Extensive experience in performing REORGCHK, REORG and RUNSTATS on

tables and indexes.

. Extensive experience in building, supporting and maintaining large

data warehouse, performance tuning and optimization of queries.

. Extensive experience in designing logical and physical data model,

forward engineering the data model into DDL Scripts using ERWIN and

TOAD data modelers.

. Extensive hands on experience in DB2 Stored Procedures, ISPF, CLIST,

COBOL, CICS, JCL, Rexx, Unix Shell scripting, awk, Perl, MQ Series,

QUEST tools, Omegamon, DBArtisan, and DB2 Connect.

. Good Experience in setting up Federated Data Warehouse Environments.

. Implementing disaster recovery plans using HADR.

. Designed and Implemented database with partitioning feature (EEE &

DPF).

. Used DB2 utilities like Snapshots, Event Monitors, db2pd, db2dart,

db2top, db2adivs, db2batch, db2exfmt for performance tuning and

monitoring.

. Migrated databases using db2look, db2move, IMPORT, LOAD and EXPORT.

. On-site and Off-shore coordination experience

. UNIX Systems Admin Knowledge on any type UNIX platform (AIX, HP-UNIX).

. Excellent troubleshooting, problem analysis and corrective actions

skills.

. Enthusiastic self-starter and team player with excellent communication

and organizational skills.

. Good Leadership skills.

. Varied Experience in functional study and figuring out business logic

technically which involves good amount of feasibility study of the

client requirements with immense patience. Having ability to

prioritize workloads and meet deadlines within time frame.

EDUCATION:

Bachelor of Engineering, SVU College of Engineering, India

CERTIFICATION:

IBM Certified Database Associate (DB2 UDB V8 Family)

. IBM Certified Database Administrator (DB2 UDB V9 Family)

. IBM Certified Advanced Database Administrator (DB2 UDB V9 Family)

TECHNICAL EXPERIENCE:

Operating System : AIX 6.1/5.3/5.1, MVS OS - 390, UNIX,

Solaris 5.8, Linux,

Windows

NT/XP/2000/2003.

Software/Databases : DB2 UDB V9.5/9.1, DB2 UDB V8.2, DB2

UDB V7.X (EEE), DB2 8.0 on

OS/390, MS-Access,

SQL Server, Oracle 9i/10G, Tivoli Storage

Manager, MQ V5.3,

DB2 Warehouse Manager V8.1 FP3, DB2

Information Integrator V8.1

FP3, Query Patroller, Visual Studio, IIS,

IBM Informix, DB2 Connect,

Performance Expert, Quest Central, Quest

Spotlight, Quest Optimizer,

Informatica, DB2 Performance Expert, Data

Propagator, DB2 Replication

Center (DB2RC), ODBC, DB2 Workload

Manager, IBM Rational

Clearcase, IBM Rational Architect

Data Modeling Tools : Erwin, TOAD

Programming Languages : COBOL, JCL, CICS, Rexx, SQL, PL/SQL, AWK, KORN

Shell, Bash, PERL,

Python, Java, Visual

Basic 6.0

Mainframe Tools : Info X, Insync, File-Aid, Abend-Aid, Strobe,

Omegamon, Changeman,

Endeavor, Platinum

Implementation Tools : PVCS/Dimensions, ISIM (Change

Management)

Web server : IBM Websphere, Apache TOMCAT

Web Technologies : ASP, Java Script, VB Script, HTML, XML

DBA Tasks Performed:

. REORGCHK, REORG and RUNSTATS on needed tables and indexes.

. Performing Database Backup and Recovery.

. Database monitoring and query tuning experience using DB2's Snapshot

Monitor, Event Monitor, Visual Explain and Design Advisor performance

tools.

. Designed and Developed scripts in bash, korn shell, AWK and PERL to

automate the daily processes.

. Analyze performance of system screens and batch jobs and recommend

enhancements.

. Review SQL for standards compliancy and performance.

. Recommend physical data model changes to improve application performance.

. Database design using UML and ER-Diagrams, used Erwin and Qdesigner

. Designed and Implemented database with partitioning feature (EEE & DPF).

. Created MDC's, MQT's on database for optimum performance.

. Performing regular schema changes on Test/QA databases used Data factory.

. Maintained log files using User Exit and Performed regular archiving of

logs to storage devices.

. Migrated databases using Db2look, Db2move and Redirected restores.

. Extensive experience in using tools like IMPORT, LOAD and EXPORT.

. Maintained databases that uses TSM, Veritas, and SAN for storage of data.

. Designed, Developed and Maintained replicated servers.

TECHNICAL EXPERIENCE:

Blue Cross blue shield - Chicago, IL Jan 2010 - Current

Position: Database Administrator

Technologies: AIX 5.3 / 6.1, HP Unix, Windows 2003/2000/NT, DB2 UDB V 9.5

DWE with Database Partitioning Feature, DB2 V9.7 Infosphere warehouse, IBM

Balanced Configuration Unit (BCU), IBM Framework Manager, Optim

Development Studio, Optim Performance Manager, IBM Report Studio 8.3, Ab

initio 2.15, IBM Datastage, DB2 Pure XML,, Design advisor, Data Factory,

TOAD Suite, TOAD Data Modeler, Quest Central, Quest Spotlight, DB2 Connect,

IBM Rational Clear Case, Clear Quest, SAP, DB2 Workload Manager, IBM

Rational Architect / Infosphere Data Architect, DBArtisan, DB2 Performance

Expert, Korn Shell scripting, TSM 5.2.3, Awk, AS/400, Symbiator, Segue

Tool, DELL C300 SAN Storage system, SQL 2000/2005

. Designed logical and physical databases and database objects for DB2

UDB on Development, Test and Production environments.

. Performance Tuning - Analyzed the db layer during the load/stress test

and identified tuning opportunities in the database.

. Created tables for implementing Business Intelligence solutions using

Cognos.

. Designed multiple Fact and Dimension table logical and physical models

for Cognos Reporting requirements.

. Created Range Partitioned Tables (Table Partitioning) and specified

range values while creating tables in production environment.

. Worked closely with the Design of Database to utilize the Row

Compression and built row compression for the Tables during Migration

and before deployment.

. Weekend/Nightly DBA support to the developers during region rollout.

. Effectively planned and performed LOAD, IMPORT and EXPORT.

. Created multiple Instances, databases and database objects like Data

Partition Groups, Bufferpools, Tablespaces, Tables, Indexes, Stored

Procedures and Triggers etc. in both partitioned and non partitioned

Database Servers.

. Tuned Long running Cognos SQL's.

. Redistributed Data Partition Groups when data is unevenly distributed

among Data partitions.

. Created Multi Dimensional Cluster (MDC) and MQT tables for optimal

usage of the SQLs.

. Supported ETL team, during load issues and for general testing of

Abinitio load process.

. Created, maintained, and monitored onsite archive, recovery and data

retention strategy for all databases servers.

. Create, maintain, and monitor backup jobs; Ensure backup jobs are able

to support of documented SLAs. Maintain archival strategy, logging

strategy for point in time recovery.

. Hands on experience in using V9 STMM, Deep Compression and Automatic

Maintenance features.

. Apply Fixpacks, monitor IBM maintenance releases and communicate them

to business.

. Used utility tools like DB2look and db2move to extract and load

databases across platforms.

. Identified bottlenecks by monitoring CPU, Disk I/O, Memory and Paging

space utilization using vmstat, ps, nmon, topas and iostat.

. Performed proactive monitoring on DMS tablespaces, bufferpools, locks

and sql statements.

. Helped developers tune SQL queries for better application performance.

. Periodic snapshots on a daily basis and archiving them for maintaining

repository kind of environment

. Troubleshooting load issues related to COPY YES, COPY NO and

NONRECOVERABLE options in the HADR scenario.

. Verified explain plans using db2exfmt and db2expln utilities on SQL

statements

. Troubleshooting HADR disconnection issues and configuration issues.

. Setting up event monitors in dead lock scenarios during the initial

phase of the implementation of the database

. Solved performance issues by using SNAPSHOT information, Explain tools

and db2advis.

. Assisted in the development and testing of the Disaster Recovery Plan.

State of Maryland/DHR - Hanover, MD

May 2007 - Dec 2009

Position: Database Administrator

Technologies: AIX 5.3, IBM Z/OS, Red Hat Linux 2.6, DB2 UDB ESE V9.1 V9.5,

DB2 V8 on Z/OS, Windows 2000/2003, Oracle 10g, SQL Server 2005, IBM

Webshpere 6.1,Java Script, J2EE, Quest Central, Quest Spotlight, Quest

Optimizer, Erwin Data Modeler, DB Artisan, DB2 Connect, Performance Expert,

Query Patroller, Omegamon, Platinum, Korn shell, PERL, AWK, Python, MS

Office, IBM Data stage, Business Objects XI-R3

. Develop data architectures and database management policies and

standards.

. Serve as a high-level resource on database management issues, and

participate in the planning, design, and usage of data resources.

. Implementing and documenting db2 best practices across the enterprise.

. Performed technical evaluations of new releases and developed

migration strategies and schedules.

. Forward engineer the Erwin data model into a DDL structured word

document and edited the DDL script to include the self-designed

tablespace names and index tablespace names, indexes, triggers and

stored procedures and implemented into the Dev, QA and Production

environment

. Interacted with Websphere Administrators and Customers to create

custom Webshpere tables.

. Performed maintenance, performance monitoring, tuning and capacity

planning for mission critical applications in Websphere (JAVA)

environment.

. Provided guidelines to developers to write SQL in DB2 UDB.

. Set up federated database connections to transfer data as per

application team's requirements

. Planed and implemented high availability systems (HADR) across the

enterprise.

. Created MQT's (materialized query tables) on database for optimum

performance.

. Upgraded Db2 (Client and server) from Version 8 to 9.

. Installed and administered DB2 Connect to catalog databases on

mainframe through gateway server

. Installed DB2 9.5 in a silent install mode where input is passed to

the installer through response file.

. Created Korn shell scripts for daily and weekly maintenance activities

of the Database like REORGS, RUNSTATS, BACKUP, DB HEALTHCHECK,

REORGCHK, Online Backup and Offline Backups, Archiving Log files to

disk(in case TSM connectivity is lost), db2diag.log archiving, DB2

Object backups using db2look.

. Was involved in the HACMP testing.

. Dealt with TEMPSPACE, LOGBUFFER, Transaction Logs, DBHEAP, SORTHEAP,

Bufferpools, util_heap_sz, related issues while bettering the

performance of the load process.

. Used db2pd and snapshot to monitor the activities of the database and

the sql.

. Used NMON to monitor the usage on the CPU's and the activities running

on it

. Worked with the developers in creating triggers in development to

prevent some changes in the rows being replicated, eventually

implementing it on production.

. Develop, deploy DBCR (Database Change Requests) based on functional

team requirements.

. Carry out impact analysis for any database architecture changes.

. Carryout system builds in accordance to the SLA guidelines.

. Carryout performance tuning activities.

. Carryout on demand build requests in collaboration with the functional

leads and the Shared Services Lead.

. Configure the hardware and software to create the new development

environments.

. Coordinate with IBM to log support cases.

. Troubleshoot complex technical and logical issues.

Zurich Financial SERVICES - Baltimore, MD Mar 05 - Apr 07

Position: Database Administrator

Technologies: RS 6000, IBM p630/670/690, AIX 5.1, Sun OS 5.8, Windows

2003/2000/NT, DB2 UDB V8.2 / 9.1 EEE 7.2,, SAP R/3, IBM Websphere, BW,

AS/400, Design advisor, Data Factory, Erwin Data Modeler, Quest Central,

Quest Spotlight, DB2 Connect, DBArtisan, TDP Domino, TDP SQL, TSM 5.2.3,

Awk, AS/400, Symbiator, Segue Tool, DELL C300 SAN Storage system, SQL

2000/2005

Responsibilities

. Created the Logical and Physical Data models for the project using

Erwin Data Modeler.

. Performed database backups and recovery.

. Managed the users and their security privileges.

. Was involved in implementing and tweaking the Seibel applications on

the AIX systems.

. Work with business to gather data integration requirements and define

system architecture.

. Developed processes, scripts, procedures and mappings for extracting,

loading and transformation data from source systems.

. Upgraded the database from V 8.1 FixPack 3,8 to V 8.1 FixPack 12 or V

8.2.5

. Created DB2 Instances on different environments.

. Set the DB and DBM configuration parameters in such a way that they

suit the environment.

. Written Korn shell scripts for daily and weekly maintenance activities

of the DB like REORGS, RUNSTATS, and BACKUP etc.

. Opened PMR's with IBM to resolve memory issues and user-id lock issue.

. Worked with the AIX team to change some parameters at the OS level so

that they suit the database.

. Worked on table design in Partitioned databases. Worked on creating

clustered indexes for enhanced query performance.

. Monitored and administered DB2 on multi host DPF environment.

. Ran DB2Expln on SQL's and Procedures that are causing delays and

deadlocks on applications.

. Troubleshooting issues relating to DB2 instance memory, shared memory

etc.

. Used the Database tool Quest Central to look into the schemas, tables,

tablespaces etc.

. Used db2pd and snapshot to monitor the activities of the database and

the sql.

. Used NMON to monitor the usage on the CPU's and the activities running

on it.

. Was involved in Creating, maintaining, administering DB2 UDB databases

for implementation teams.

. Responsible for Day-to-Day Administration of Database Servers,

Application Server

. Extracted the Database DDL's using DB2LOOK and Quest Central to

migrate the database.

. Made a copy of the Production Database for test by migrating from

Production to Development

. Performed Redirected Restore of database from one environment to

another.

. Tuned the database as per the need of the SIEBEL application.

. Helped the applications team to catalog the database on a cluster

environment.

. Applied updates and fixes Database.

. Defined and documented installation process and scripts for database

for product implementation.

SAFECO Insurance, Seattle, WA

Jun 2003 - Feb 2005

Position: Database Administrator

Technologies: IBM Z/OS, DB2 V7.X/8 on ZOS, DB2 UDB 8.2 on Linux, Erwin

Data Modeler, DB2 Connect, DB2 Stored Procedures, Spufi, File Aid,

Omegamon, Strobe, PVCS Dimensions, ISPF, CLIST, COBOL, JCL, CICS.

Responsibilities

. Created the database design for the project.

. Created the Logical and Physical Data models for the project using

Erwin Data Modeler.

. Performed database backups and recovery.

. Managed the users and their security privileges.

. Created database objects such as databases, Table spaces, Tables,

Indexes, Views,

Constraints, Triggers, Stored Procedures.

. Monitored DB2 statistics for necessary reorgs, checks and Runstats.

. Performed subsystem parameter changes (DSNZPARM) to support

application requirements and performance objectives.

. Extracted the Database DDL's using DB2LOOK to migrate the database.

. Performed Maintenance activities like image copy, Reorganization, Run

stats, Recovery, Rebuild, Repair, Load and Unload of database objects.

. Create project plan and co-ordinate project work between local team

and offshore team.

. Provide onsite support for all database administration work that has

been handed over to offshore team.

. Involved in database performance tuning.

. Capacity planning and monitoring the growth of databases.

. Involved in upgrading DB2 from Version 7 to 8.

. Replicated and refreshed the development databases with Production

data.

. 24x7 support for Production database issues.

. Performed application tuning of the application using tools like

Platinum, Omegamon, and Strobe.

. Provided technical assistance to developers in relation to SQL coding.

. Involved in the development and maintenance of procedures, processes,

and standards for documentation.

. Interacted with Application developers and architects with regards to

any issues.

Prudential Financial, USA

Jul 2002 - May 2003

Position: Programmer Analyst

Technologies: IBM Z/OS, DB2 V7.X, ISPF, CLIST, COBOL, JCL, DB2, CICS, Rexx,

SAS, Omegamon, Changeman, Platinum, DAP 10.3, INFOPAC, STROBE, ENDEVOR,

TMON, OBJECT REXX, ABEND-AID, FILE-AID, XML, SOAP, SPUFI, TSO, Xpediter

Responsibilities:

. Understand business requirements and convert this to system and

software requirements.

. Create Ad-hoc outputs and reports based on the requirement using

COBOL, DAP.

. Involved in integration testing and regression testing.

. Providing QA/UA support and support to release management.

. Interact with multiple supporting groups to identify a solution for

the problem at hand.

. Changes to the distribution tables in INFOPAC to route the outputs to

various destinations

. Developed the program specifications and unit test plans.

. Code & unit test the Mainframe Programs using CICS, COBOL, DB2, JCL

and execute System tests, User Acceptance Tests.

. Tracking and reporting defects which facilitates workflow, issues and

helped resolving technical issues with developers.

. Implement the components into production environment and provide

production support till it's turned over to common application support

group.

. Post Implementation support.

Contact this candidate