Certified Oralce10G , DB2 UDB V8 DBA & AIX System Admin.

SUMMARY:
More than 20 years of experience in Software Analysis, design, development, testing and implementation. Specializing in developing Application Software using IBM Mainframes, RDBMS and Client /Server environment. For more than 14 years, I am being involved in managing the database administration including SQL Server 200/2005/2006,Oracle7/8/8i/9i/10g,11g, DB2 UDB 6/7./8.X/9 & DB2 on RDBMS's on HP UNIX, Sun Solaris, and AIX & OS/390. Experienced in Infrastructure Deployment Installation, Configuration and Administration of ERP Applications such as PeopleSoft 8.3 HRMS 8.8, FIN8.1x/8.44, and PeopleSoft 8.1 x Supply Chain Management, EPM, Portal, Student Admin 8.21, and CRM 8.8/9.0 with Oracle 9i/10g/11g, DB2 UDB /DB2 V6/7/8 on OS/390 as backend in multi platform environments.

SKILLS:

Hardware

RS/6000 SP & Pseries, E Series, Power 5 Servers, SUNW sparc,,ESS-800, DS4800,DS6800,DS8000,Ultra-Enterprise ,HP Tru64, EMC CLARiion CX series. Dell 1650,6650, Dell PowerEdge 1950,2900, Blade Servers HS20-21

Operating Systems

Windows NT/2000,2003,MVS, Z/OS ,AS/400, HP/UX 10.0, Sun Solaris 8/9/10, AIX 4.3/5.3, Linux 4

RDBMS

Oracle 7/8/8i/9i/10g/11g, DB2 UDB V6.1/7.x/8.x/9 & DB2 V4,5,6,7,8 OS/390/Z/OS,SQLServer2000/2005/2008, Informix, SYBASE

ERP

PeopleSoft 8.14 (Supply Chain Management), PeopleSoft8.3, HRMS 8.8/8.9,Student Admin 8.42,9.0, EMP ,Portal 8.4,9.0, CRM PeopleSoft design tools, PSADMIN, Data mover, query, upgrade Assistant, Seibel V7.x,SAP V 3/4.6, DBACockpit,SAP DB2Admin, BRBACKUP, BRARCHIVE, BRRESTORE, BRRECOVER, BRSPACE, BRCONNECT, and BRTOOLS Utilities, Lawson HCM

Clustering Tools

IBM HACMP 5.1, TSA , Xkoto GridScaleServer, EMC, Veritas Clustering ,Flash Copy, Peer to Peer remote Copy(PPRC), Oracle RAC ( Real Application Cluster),DataGaurd,ASM , Quest SharePlex for Oracle, DataGuard

Disaster Recovery

VMWare Tools, IBM Tivoli Storage Management(TSM), Flash Copy, Peer to Peer Remote Copy(PPRC)/, EMC SnapView,MirrorView, Sun\'s StorageTek Virtual Storage Manager (VSM). Veritas

WebServes

IBM Web Sphere , BEA WebLogic,IIS, iPlanet, Oracle 10G application Server

Connectivity Tool

IBM DB2 Connect, Relational Connect, Oracle Gateway

Replication Tool

Data Propagator,DB2 Replication Center (SQL Replicatins,Q Replications), WebSphere ( information integrator) , Oracle Streams

DBA Tools for Oracle

Platinum DBvision, Tsreog, BMC Patrol, SQL Backtrac, Oracle, Enterprise Manager, RMAN, Import, Export, Oracle Data Guard, Flash Back, Automate Storage Management(ASM), Grid Control, DBCA,DBUA ,SQL*Loader, SQL*DBA, Replication Manager, Quest Database Admin Tools, Oracle Ware House Builder

DB2 OS/390 tools

Platinum Database Analyzer, Plan Analyzer, Subsystem Analyzer, SQL Easy, RC/Migrator, RC/Security, Log Analyzer, CA Unicenter, CA7

DB2 UDB tools

BMC Patrol for DB2 UDB, IBM Relational Connect, DB2 Connect, Data Propagator, Quest Central for DB2 UDB/, BMC Web DBA,
DGI SQL Guy, Wise Guy, MQ Series

Data Warehousing

Oracle Discoverer, Oracle Express, IBM Data Warehouse Center, IBM Ware House Manager, MicroStrategy

Design

Designer 2000, Erwin, ER - Studio

Front End

Developer 2000 - Forms 4.5, Reports 2.5, Graphics 2.5, Power builder 5.0

Languages

COBOL, C, Pro*C, JCL, Perl

Involved in the following Database/Application Administration Activities

DB2 DBA (Linux ,Windows ,Unix)

• Upgrade DB2 from V7 to V8 , to V9.5,9.7
• Database migrating from Oracle 8I to DB2 UDB 6.1 for BEA Web Logic
• More than 60 DB2 UDB Database upgraded/Migrated from V7 to V8 to V9
• Good experience in migrating databases from SYBASE, SQL Server to DB2 UDB.
• Upgrade more then 5 Oracle instances from V9i to 10g using DBUA
• Migrating database from one environment to another environment by using Redirect Restore process.
• Setup Federated environment from Oracle, SQL Server and DB2 Z/OS to DB2 on Linux/Unix environments , using Web sphere information integrator , creating Wrapper Server , user mapping and nicknames.
• Performance tuning for PeopleSoft, application (SQL) by using Quest Central & db2 index adviser (DB2ADVIS), database manager & Database parameters by using Snap motor, event monitor & Control center .
• Setup DB2 Work Load Manager for allocation resource , monitoring and managing workload of system , also DB2 Work Load Manger interact with AIX Work Load Manager.
• Automating all database utilities, RUNSTATS, REORGCHK, REORG, QUIESCE, DB2RBIND
• Install and configure DB2 Connect Gateway ( DB2 Connect Enterprise Edition) from Z/OS to DB2 LUW and DB2 on AS/400 and PeopleSoft application.
• Preparing DBA standards for DB2 UDB & Implementing for all the environments (DMO, DEV, SYS, QA1, QA2) for all software (PeopleSoft, Siebel, BEA Web Logic)
• Good exposure in migrating from DB2 to Oracle or Oracle to DB2, Migrated around 100 database from Oracl8i to DB2 UDB V7/8/9 on Solaris & AIX environments.
• Very much comfortable to designing distributed database, setting Database replication on UDB DB2 EEE/DPF .
• Configuring database partition, setting High Availability Cluster Multi-processing (HACMP)/HADR (High Availability Deserter Recovery) for Unix AIX for DB2 UDB.
• DR (Disaster Recovery) recovery strategies design & implementation for DB2 UDB ( HACMP,HADR, For IBM/EMC Snap view, Mirror View/ VERITAS Flash Copy, Peer to Peer Remote Copy (PPRC), setup Physical to Logical , Logical to Physical by using VMware and IBM TSM with Zero Down time.

DB2 DBA on Z/OS

• Experience with maintaining and troubleshooting an enterprise DB2 database on z/OS Using CA tools Database Analyzer, Plan Analyzer, Subsystem Analyzer,.
• Expert with DB2 backup, recovery, high availability and disaster recovery techniques for DB2 z/OS
• Experience with maintaining and troubleshooting an enterprise DB2 database on z/OS
• Expert with DB2 backup, recovery, high availability and disaster recovery techniques for DB2 z/OS using CBD Super Utilities
• Upgrade DB2 Z/OS from 8 to 9 Sysplex Data Sharing environment
• DB2 Utility jobs: data restore, REORG, Loads, Unloads, DSN1Copy utility, RUNSTATS, Image Copy, Quiesce, Table Conversion.
• SQL performance tuning using BMC AppTune , CA SQL Analyzer
• Use SQL to insert and modify DB2 table data in test and production environments.
• Creating and maintaining stored procedures.
• Provide database administration activities and application lifecycle support for multiple projects in mainframe midrange environments.
• Daily monitor DASD allocation growth. Resize VSAM datasets. Order DASD disk packs to accommodate the estimated DASD allocation for new database objects.
• Provide bi-annual projected DASD allocation growth for existing databases.
• Manage data replication via IBM's Data Propagator.

WORK EXPERIENCE

Part Time Projects

Confidential, Tallahassee, FL ( this is on going based on client budget and when needed )
Apply all Oracle critical patches CPU ( critical Patch Update) , Install and configure Oracle Configuration Manager (OCM) in connect and disconnect mode , Install and configure GRID Control Agent for all DB servers , Installed Oracle Wallet Manager and setup Transparent Data Encryption OTDE) for sensitive data .
Initially setup was Oracle RAC with 4 nodes on Red Hat Linux , for client environment they don't want RAC , help them to convert from RAC to stand alone.

Next stage , setup Oracle Data Guard for failover.
Oracle upgrade from Oracle10gR2 to 11gR2

Amway ,Grand Rapid ,MI
Did DB2 upgrade from DB2 V8.2.7 to V9.5 on AIX 5.3.006. This project I did part time remote from Nov to Dec'09.
Install and configure Oracle Transparent Gateway from Oracle on Linux to DB2 on AIX..

Confidential, Overland Park,KS Jan'11 - till date.
PeopleSoft SysAdmin/Architect on DB2 UDB V9.7.

PeopleSoft FCM 9.1 , tools 8.51 on DB2 LUW 9.7 Windows 2008 R2 Install stabilization and citification environment.

Sizing and estimate resource ( CPU , Memory and Disk space ) for DEV , TST environments and build from SYS on IBM x series Servers with VMware ESX 4.1 DB , Batch server on one virtual servers , Web and Application Server another virtual server.

Build PRD environment with 2 cluster 2 web servers , 2 application Servers and Database with HADR.

Design Backup and recovery strategy and implementation.

Automated Database monitoring ( resource usage CPU, memory, I/O activity) , and maintenance ( REORG, RUNSTATS ).

Performance tuning Instance , Database ,bufferpool and Tablespace , Top expensive SQL statements finding and tuning.

Supporting whole environment. Including Storage, System , Application and Database.

Apply PeopleSoft application and tools patches , TAX update .
Migrate PeopleSoft external and internal objects.

Environment cloning from environment to environment.

Maintenance and monitoring with performance Monitor.

Environment :
PsoftSoft FCM 9.1 , tools 9.51 on DB2 V9.7 on Windows 2008 R2, Weblogic 10.3
IBM x series Serves DS3400 storage , VMware ESX4.1

Confidential, Jacksonville,FL Feb'10 to Dec'10
Sr. DB2 UDB DBA

DB2 upgrade from DB2 V7.2 to V8 , V8 to V9.7 Development, QA and Production , setup HADR production on windows environment.

Design and implement backup recovery strategy .

Performance tuning Instance ,Database , Bufferpool , tablespaces and SQL tuning.

Automated Database monitoring and maintenance and knowledge sharing with in house IT team.

WebLogic upgrade from V8 to V10

Environment :-
DB2 UDB V7.2/V8/V9.7 , Windows 2003 , WebLogic V8/V10.
On IBM E series server and storage DS3700

Confidential, Atlanta,GA March'08 to Jan'10
Sr. PeopleSoft DB2 DBA

Supporting PeopleSoft HRMS and EPM on DB2 UDB on AIX .

Apply DB2 patches
People tools upgrade from 8.46 to 8.49
DB2 Upgrade from DB2 V8 to V9.5, 32 bits to 64 bits around 60 instances .
Setup DR/failover environment using IBM Flash Copy on SVC and HACMP XD for DB2 instance for PeopleSoft HRMS , SCM ,Student Admin applications. .
Design best backup and recovery strategy using TSM .
Auto mated Database cloning environment to environment.

DB2 Upgrade from V7 , 32 bits to V9 64 bits on PoepleSoft Student Admin .
PeopleSoft Student Admin upgrade from V8.21 to 9.0 , PeopleTools from 8.46 to 8.49
Performance tuning

Environment :PeopleSoft Student Admin, SCM and HRMS , PeopleTools 8.46/8.49 8.21/9.0 , Web Sphere 6.0,DB2 ESE V7/8/9 on AIX 5.4 , TSM 5.4 , IBM storage DS 4700/4800 with SVC ,on P5 servers and P6 Servers , DB2 Connect Gateway.

Confidential, GainesVIlle,FL June'07 to Feb'08
System Architect/Sr. PeopleSoft DB2 DBA

DB2 UDB on AIX
Build scripts and Setup monitoring jobs for Top 10 SQL, Tablespaces space usage , LOCKS, Database ,bufferpool activity.
Performance tuning SQL , database, instance level.

Database cloning by using EMC SAN utilities SnapClone, SnapCopy , DB2 utilities DB2relocatedb, re-direct restore process.

Right now backup windows is 2 -3 hours , that effecting PeopleSoft Financial and HRMS batch processing and online processing .

By get ting familiar with EMC storage technology like SnapView , SnapView software leverages the power of EMC CLARiiON networked storage systems to create local point-in-time copies of data that can be used for testing, backup, and recovery operations. And SnapView now features consistent split capabilities—to ensure data coherency for all your local replication needs. With the flexibility to create pointer-based, space saving snapshots and highly functional, full-volume clones, you\'re able to meet a mix of service levels with minimal operational impact.

Setup Q-Replication for PeopleSoft applications HRMS ,Financial to EPM on way . EPM to Portal 2 ways .
Also setup SQL Replication from all PeopleSoft environment ( HRMS,Financial,EPM,Portal)

Take EMC SnapShot ( same as IBM FlashCopy) of file system of production LUNs mount it in stand by server, take as regular TSM backup.

Implementation of Zero down ( less than minute ) time backup plan using EMC SnapView and SnapClone for DB2 , we use same for data clone and or replications , by using DB2INIDB DB2 utility as snapshot ( for cloning , ) mirror ( backup) .

Production database cloning into Reporting database using EMC SNAP View every night , taking snap from production file system into Reporting server , roll forward into point in time.

DB2 UDB Upgrade from V8 to V9 on AIX.

Applying DB2 fix pack for Database and application ,batch servers, and also setup Cognos , Composite Information Server, informatica .

System monitoring , performance tuning for AIX , Linux.

Install DB2 Connect on AIX and configure connectivity from Z/OS to DB2 on AIX

DB2 Z/OS DBA

• Provide database administration activities and application lifecycle support for multiple projects in DB2 mainframe environments.
• DB2 Utility jobs: data restore, REORG, Loads, Unloads, DSN1Copy utility, RUNSTATS, Image Copy, Quiesce, Table Conversion.
• SQL performance tuning.
• Used SQL to insert and modify DB2 table data in test and production environments.
• Daily monitor DASD allocation growth. Resize VSAM datasets. Order DASD disk packs to accommodate the estimated DASD allocation for new database objects.
• Provide bi-annual projected DASD allocation growth for existing databases.
• Manage data replication via IBM's Data Propagator.
• Served as project lead, managing projects from initial kick-off stage including test and production installations in a tri-annual release environment.
• Design, implement, and maintain complex database systems, activities including data modeling, system access, storage allocations, validity checks, security, performance tuning, data migrations, data replication, disaster recovery planning/support and procedure/process documentation.
• Lead tri-annual enterprise-wide project-driven software releases, including testing, production implementation executed by applications development and DBA teams.
• Have good exposer of DB2 V89 features , worked upgrade plan from Db2 V8 to V9.

Environment :PeopleSoft Financial,HRMS,EPM 8.8/9.0 people tool 8.46/8.48 ,WebLogic version 8/9,Oracle 10g Application Server, Informatica,Cognos , Composite Information Server ,tuxedo 8.1, DB2 UDB ESE/DWE version 8.2/9.1, DB2 Connect V8/9, DB2 Z/OS 8.1 1.8, ,Oracle10g release 2.03, Oracle Gateways,SQL Server 2000/2005 on Win 2003, Red Hat Linux AES version 4,IBM BladeServer HS20-21,DS4800,DS8000,EMC CLARiiON CX300/700 3-40 ,SnapView,SnapMirror,SnapCLone,SnapCopy , IBM P650 ,P630 servers,

Confidential, Lake Mary,FL Jan'07 to May
PeopleSoft Oracle/DB2 DBA

Install People Tools, configure Appserv, Process Scheduler , WebServer using IBM Web Sphere, Oracle 10g Application Server, Upgrading People soft CRM from version 8.8 to 9.0 . People tools upgrade from 8.46 to 8.48 migrating PeopleSoft CRM from DB2 V8.2 on Windows to Oracle 10g release 2 on Red Hat Linux AES version 4. I create my won scripts to create tablespaces,schema, load data from DB2 to Oracle ,by using DB2 Stored procedures, SQL, Oracle SQL*LOADER.
setup Data Guard , RAC for new PeopleSoft application, RMAN scripts for Backup , monitor , export , database cloning by manually , RMAN.

PeopleSoft application, Appengn,SQR,COBOL process , Database, Instance, SQL performance tuning for Oracle 10g release 2 ( 10.2.03).

Maintaining existing PeopleSoft CRM 8.8 on DB2 UDB V8.2.2 Windows 2003 server.DB2 PeopleSoft database replicate from AS/400 by using Vision Solution software Symbiator. Scheduling backup , database maintain utilities , moving data to and from AS/400 to and from DB2 UDB by using AS/400 extract utility and DB2 Load utility , schedule job by using Microsoft job scheduler. Every day will take online backup of production , re-fresh standby/reporting database by using production online backup , roll forward logs , Database cloning for DB2 environment by using re-direct restore process, purging data.

Setup Composite Information Server part of setting multi environment access.

Install SQL Server 2005, configuration , setup DTS from AS/400 to SQL Server, Migrate from MS access to SQL Server 2005

Install DB2 connect on Windows and configure connectivity from DB2 on AS/400 to DB2 on windows.

Environment :PeopleSoft CRM version 8.8/9.0 people tool 8.46/8.48 ,Web Sphere version 5.x/6, Oracle 10g Application Server,tuxedo 8.1, DB2 UDB version 8.2 , DB2 Connect Enterprise , Oracle10g release 2.3, SQL Server 2005, DB2 V5.1 on AS/400 ,AS/400,Windows 2003 , Red Hat Linux AES version 4,Dell 1650,6650, PowerEdge 1950,2900, Composite Information.

Confidential, Tallahassee ,FL Jan'04 to Nov'06
PoepleSoft DB2 UDB DBA

Involved in DB2 UDB ESE binary installation , database file system designing , estimating size. Instance , database creation , database cloning using re-directory restore , db2relocatedb , export, load utilizes /methods based on user requirement.

Splitting tables to different tablespaces , based on table accessing activity, to avoid time out, lock contention.

Designing backup & recovery strategy for development & Production databases, setup cron jobs for Backup, database maintenance utilities .

Upgrading instance & databases from DB2 UDB V7 to V8.

Configuring database partition, setting High Availability Cluster Multi-processing (HACMP)/HADR (High Availability Deserter Recovery) for Unix AIX V5.x for DB2 UDB V8.x

Implemented IBM FLASH Copy backup strategy for Production DB2 UDB ,Oracle database backup.

Take FlashCopy of Production file system , mounted in reporting server , take backup from reporting database.

Supporting ware House environment .

Setup and maintained Q-replication for PeopleSoft application on DB2/AIX

Working with developers to tune SQL by giving advise to the development team , changing SQL effective way, adding indexes , to speed up the processes.

Environment : RS 6000 ESS 800,DS8000 ,pSeries 690, 650,630s, AIX 5.2/5.3 ,DB2 on OS/390,WIN Tivoli storage Manager, HACMP, IBM FlashCopy, Peer-toPeer Remote Copy ,DB2 UDB V7/8.2.x, Oracle 9i/10g,SQLServer2000/05 PeopleSoft Student Admin V8.21 , Financial 8.43 , HRMS 8.9 ,Portal 8.44 , EPM , CRM, Seibel V7.X, Appdesigner,Data Mover , upgrade assistant , WebLogic V5/6/7/8.

Confidential, Louisville ,KY Sept'03 to Dec

Configuring process scheduler for Z/OS in USS environment , defining report distribution node .

DB2 Connect Gateway install , configuring connectivity between database on Z/OS to Application server , Web Server & client application through DB2 Connect .

Performance tuning at Z/OS system level , sub-system level ZPARMS, calculating lock list size , number of group bufferpools, bufferpools . , splitting highly accessed tables in its own tablepaces to avoid lock contention & improve performance.

Working with developers to tune SQL by giving advise to developers , changing SQL effective way, adding indexes , to speed up the processes.
Analyzing over all system , giving recommendation & helping SysAdmins , DBAs .

Environment :PeopleSoft Financail 8.43, DB2 7/8 ,WebLogic V7, Z/OS V1.4, AIX V5.2 pSeries 630 & 560 servers, Windows NT, DB2 V7 on Z/OS V1.4, DB2 connect Gate way V8.

Confidential, Irving ,TX Jun'03 to Sept
Sun Solaris V8 , WebLogic 6 & 7 , Iplanet Admin, Oracle 8i/9i & DB2 UDB V8 DBA

WebLogic install, web servers configuration , setup web load balancer , iPlanet install & configuration. Creation of system V package for software install & uninstall.
Building Solaris servers for new application , attaching disks, file system creation , space allocation.
Setting up Verities failover for DB servers.
Installing Oracle software , creation instances & DB objects & Maintaining existing Oracle Databases.DB2 UDB V8 install, instance , database design & creation , to migrate database from Oracle8i into DB2 UDB V8.
Working with developers to tune SQL by giving advise to developers , changing SQL effective way, adding indexes , to speed up the processes.

Extract tablespace size, schema DDL , data from Oracle DB , convert into DB2 UDB format, load data into DB2 UDB. Also migration application code from Oracle to DB2 UDB. Mirated 6 databases from Oracle8i to DB2 UDB V8.

Configuring Veritas for Solaris , Linux , NT for file system Backup & recovery
For DB2 , Oracle, Backup , recovery , disaster recovery plan .

Trained Development team in DB2 UDB .

Environment: Sun Solaris V8 , WebLogic V6 & 7 , iPlanet , Oracle8i/9i , DB2 UDB V8.

Confidential, San Antonia, TX Oct'02 to May'03
DB2 UDB DBA & Data Warehouse Architect

Designing Data Ware house environment by using DB2 Ware House Manager on DB2 UDB 7.2 EE AIX 5.x on PSeries Server. Refreshing data from flat files to target database by using stored procedures in Data Warehouse Center , creating user process & designing process module in Warehouse Center, Automated data population from source to target

Developed stored procedures refreshing data from flat files to target databases in Data Warehouse Center. Created and designed process modules to automate data population. Designed backup and recovery processes using Harbor DB2 Agent, Data Archiving. Designed ETL processes and stored procedures using Data Warehouse Center. Defined and created target and source databases. Created data models and database schemas using IBM EZMart.

Environment: DB2 UDB 7.2 on AIX 5.x, DB2 Data Warehouse Manager, IBM EZMart, Warehouse Center, Harbor DB2 Agent for backup

Confidential, Charlotte, NC June'02 to Sept
PeopleSoft 8.3 HRMS installation & configuration on DB2 OS/390

Proposing infrastructure & Estimating hardware requirements & sizing for client based on their requirements.

Creating three sub systems on OS/390 for Development, testing & for Production, installing DB2 connect Gateway (DB2 connect Enterprise Edition) on AIX on RS6000 Server & PeopleSoft Application Server on same box. Installing DB2 connect Personal edition at client workstation, configuring database connectivity from client to OS/390 database through DB2 Connect Gateway. Installing & configuring web server, File Server, NT Report server on Windows 2000 load Balancing Cluster. Configuring process scheduler on AIX with TUXEDO & Batch Server on OS/390. Installing & configuring Micro FOCUS COBOL & SQR on OS/390.

Creating databases for DMO, SYS & populating data through Data mover, running Updating People Tool scripts, creating indexes, views, temp tables & running RUNSTATS. Creating & scheduling database maintenance, backup & recovery jobs.

Environment: DB2 7.1 on OS/390, PeopleSoft HRMS 8.3, People Tools 8.118, AIX 4.3 on RS/6000, DB2 Connect Enterprise Edition 7.2 PK 7, DB2 Connect personal edition 7.2, Web Server IIS, Bea WebLogic, Win2k Load Balancing Cluster, TUXEDO

Confidential, Garner, KS, USA Jan'01 to March'02

DB2 UDB EE DBA on PeopleSoft8 Primary, DB2 UDB DBA EE for CRM Seibel & WebLogic as secondary

DB2 UBD EEE for Data warehouse Project

Nature of Duties:
PeopleSoft Production Database size 6 TB.

DB2 UDB for PeopleSoft (supply Chain Management)

Being in charge for primary & secondary in managing huge database applications, involved in Creating instance, configuring Database Manager & Database, Database design & Creation, Configuring database client and server by using CCA utility, setting cron jobs for REORG, REORGCHK, RUNSTATS and Rebind IBM database utilities, implementing Cold, hot backup, incremental, delta back for all the database in all environments. Mirroring primary database by using BVC of EMC's, replicating primary database to stand by database/reporting database by using db2relocatedb utility. Applying patch for DB2 UDB (Fix pack 1, 2, 3, 4) Applying patches at PeopleSoft side, PeopleSoft tools up gradation, migrating external & internal objects to development an environment for system integration testing, system integration testing environment to QA1 & QA2 environments, from QA2 to Production. Supporting more than 45 databases (total size more than 20 TB), creating standards for database & implementing in all environments.

Tuning Database Manager, Instance, Database Monitoring, Lock contention, I/O contains, tablespaces, bufferpools, and tables by using spotlights of Quest Central, Event Monitor, Snapshot Monitor & Control for DB2. SQL tuning by using EXPLAIN, Quest Central, DB2ADVIS. Configuring IBM relational connect to access Oracle database from DB2 UDB.

PeopleSoft App Amin Activities:
PeopleSoft & TUXEDO Installation, configuration on Sun Solaris with DB2 UDB, PeopleSoft upgrade tools 8.0, 8.1, 8.2, 8.16, Configuring Process Scheduler & App Server on Solaris & NT using PSADMIN, Applications Server monitoring & Tuning by using PSADMIN, TUXEDO, configuring Web Server & Web Client.

Applying Patches, fixes & migrating Internal & external object from environment to environment (DEV to QA1, QA1 to PROD). Maintaining Data integrity & application integrity, by using SYSADUIT and DDADUIT.
User security management & generating compare report for different instance /environments.

PeopleSoft database migrations by using redirect restore process for whole database, Migrating partial database by using IMPORT, EXPORT & LOAD (IBM utilities) Data Mover (PeopleSoft utility), Security Management, creating database objects by using PeopleSoft designer tools in DB2 Database.Process, Scheduler, App Server monitoring/tuning, troubleshooting support & user support.

DB2 UDB 6.1 for CRM Seibel 2000 on sun Solaris:
Estimating disk layout for database, designing, configuring & creating instance & database. Configuring clients, setting cron jobs for backup (physical & logical), REORG, RUNSTATS, Pronelogs, taking backup of whole database DDL by using DB2Look utility. Migrating full database from development to system integration, system integration to QA1, from QA1 to production by using re-direct restore process, migrating partial database by using export, import & load utilities. Database monitoring & Tuning Database monitoring by using IBM utilities snapshot monitor, event monitor and control center for sort overflow, lock contention, buffer pool hit ratio, memory usage & table space usage .By using 3rd party tool, Quest Central for DB2 monitoring disk space & table space exception & table space growth, log space, agent & sub agent process details, tuning Database Manage (DBM) & DataBase (DB) configuration parameters. Monitoring running process, find highly expensive SQL statement & tuning those SQL statements by using index advisor(db2advis) & explain IBM utilities.
And trouble shooting & user supporting

WebLogic on DB2 UDB 6.1
Designing Database, configuring O/S, DBM, DB & client, creating database, configuring JDBC listener, migrating database from Oracle8I to DB2 UDB 6.1. In DB2 UDB database migration from environment to environment by using re-direct restore process, EXPORT, IMPORT & LOAD, Database monitoring by using IBM native utilities & Quest Central for DB2 tools, Performance tuning at instance, database level by using IBM control center & Quest Central. SQL tuning by using IBM utilities Index advisor, explain & Quest Central. Troubleshooting & user supporting.

Supporting SQL Server databases on Windows NT

Supporting Data Warehousing project on DB2 UDB EEE
Accessing legacy data through middle ware MQ Series & setting warehouse environment to DB2 UDB EEE by using DataPropagator, ETL & DB2 Warehouse Manager

Configuring IBM TSM for Solaris , Linux , NT for file system Backup & recovery
For DB2, Oracle, Backup, recovery, disaster recovery plan.

Environment: DB2 UDB 7.1/7.2(EE/EEE) on Sun Solaris, IBM AIX, PeopleSoft 8.1X, IBM utilities, Control Center, DB2ADVIS, RUNSTATS, REORG, REORGCHK, QUIESCE, DB2RBIND, DB2LOOK, DB2MOVE, DB2 Connect, IBM Relational Connect, DB2 Propagator, DB2 Warehouse Manager, MQ Series & other IBM native utilities. PeopleSoft 8.x Supply Chain Management, PeopleSoft tools, designer, query, data mover, psadmin, sysaduit, DD audit, TUXEDO & WebLogic, CRM Seibel 2000 3rd party tools Quest Central, BMC Patrol, WEB DBA, SQL Guy & Wise Guy.

Confidential, Fort Wayne, IN Jul'00 - Dec
DB2 UDB DBA

Nature of duties:
Involved in providing 24/7 Production supporting database administration. Monitoring & performance tuning for production databases.

Data Modeling, configuring DB2 Connect to access DB2 OS/390 databases from DB2 UDB on AIX, configuring Data Warehousing (ODS) environment from Oracle database to DB2 UDB on AIX by using Data Joiner, replicating database from DB2 OS/390 to DB2 UDB by using Data Propagator through MQ Series. Data extract, transport & load (ETL).

Migrating subsystem and database objects from environment to environment by using RC/Migrator
My major responsibilities include creating database, data migration, maintaining databases, creating database, SQL standards & implementing in all db2 environments implementing, automate REORGCHK, REORG, RUNSTATS utilities, create hot & cold backup & recovery strategy & implementing stored procedures using procedure builder & Database triggers, etc.

Environment: DB2 UDB 6.1(EEE) on Aix, Perl, DataPropagator, MQ Series, Db2 Connect, IBM utilities, Relational Connect, Control Center, DB2ADVIS, RUNSTATS, REORG, REORGCHK, QUESE, DB2RBIND, DB2LOOK, DB2MOVE other IBM native utilities, ETL.

Confidential, Lakeland, FL Aug '99 - Jun '00
Production supporting DBA for DB2 UDB & Oracle

24/7 Production support & administration, for DB2 UDB & Oracle databases.

Environment: DB2 UDB EEE on AIX, IBM tools & DBArtisan, Erwin, Data propagator Oracle8 on HP-Unix, Oracle Enterprise Manager, BMC Patrol, Perl, Oracle Recovery manager, TKPROF, UTLBSTAT/UTLESTAT, Net8, Oracle Replication Manager.

Confidential, Fort Wayne, IN Dec 98 - Jul 99
DB2 OS/390 DBA

Production Support involved following activities:
Migrating from testing environment to Production environment and database alterations using Platinum RC/Migrator. Database monitoring, building and scheduling appropriate actions, such as invoking Commands and utilities, when certain thresholds are met, by using Platinum database Analyzer & Trouble shooting.
Y2K Testing Support:
Set up testing environment for three subsystems TSTA, TSTB, TSTC, Creating 6 sets of 19 databases (i.e. 114 databases) for each subsystem for different testing criteria. Creating plans and packages for all databases of each subsystem using Platinum Plan Analyzer. Security management for all databases of TSTA, TSTB, TSTC subsystems using Platinum RC/Security. Capturing data from production databases using unload utility accordingly user request. And loading into different subsystem and database depends on user request. Loading and unloading for different project cycles & troubleshooting.

Environment: DB2 4/5.2 on MVS/ESA, COBOL, JCL, VSAM, File-Aid, QMF, Database analyzer,
Plan analyzer and Subsystem Analyzer, RC/Migrator, RC/Security, Log Analyzer

Confidential, Kansas City, Dec 97 - Dec 98
DB2 OS/390 DBA

Nature of Duties:
DB2 Database performance tuning
SQL Tuning (Application Tuning)
Structure Tuning (Memory Management & Space Management)
Instance Tuning (System, resources tuning)
Optimizing resource and scheduling efficiencies and improving the performance of dividend, posting, and statement process. Purge process of tables and Database reorganization, buffer pooling. Maintenance & tuning of Database, Table partition, buffer pooling, table purging, optimizing Database (using Platinum Technology Products), Plan & Package managing using Platinum Plan Analyzer Database monitoring and tuning using Platinum Database Analyzer.

Maintenance & Performance Tuning DBA

Environment: DB2 4/5 on MVS/ESA, COBOL, JCL, File-Aid, QMF, Database analyzer, Plan analyzer and Subsystem Analyzer, SQL Easy.

Gujarat Lyka Organic Ltd., Bombay, India Nov 93 - Oct 97

Oracle DBA

Nature of duties:
Involved in following DBA activities:
Physical and Logical Data Modeling using Designer/2000, Allocating system storage and Planning future storage requirements for the database system, Creating Database and Data dictionary, creating primary database storage structure (Table spaces, Rollback Segments, Temporary Segments), and creating database objects, loading data from FoxPro to Oracle using SQL* Loader and Probabilistic, collecting database statistics and performance tuning using Analyze, Explain Plan, TKPROF, UTLBSTAT/UTLESTAT, tablespace reorganization using Platinum Tsreorg, setup database cold backup and hot backup, handling Instance recovery, Media Recovery and Point-in-time recovery, Archiving redo logs to offline devices, Database and user security Management, loading data from FoxPro to Oracle using SQL* Loader and probabilistic, trouble shooting & user support.

Environment: Oracle 7.3, SQL*Loader's*Net,SQL, PL/SQL, PRO*C, Designer/2000, Developer 2000, HP- UNIX, Platinum TSreorg, PKPROF

Confidential, Bombay, IndiaApril 93 - Nov 93

System Analyst

Nature of duties:
System analysis design, dividing system into different modules and assigning
Modules to Team players, testing and implementation.

Environment: Oracle 7, PL/SQL 2.3, SQL*Plus 3.2, Developer 2000 on Windows95.

Confidential, Bombay, IndiaAug 92 - April 93
Programmer Analyst

Nature of duties:

System analyzing and designing, Data Modeling & testing and implementation

Environment: Oracle 7, SQL*Plus, PL/SQL 2.3, Developer/2000, Designer/2000,
Developer 2000, on Windows NT

Syspro Consultancy, Bombay, India Mar 92 - Aug 92

Programmer

Nature of duties:

Coding, testing and implementation.

Environment: Oracle 7.0, Forms 3.0, PRO*C on UNIX

Education: B.Sc 1989 from Venkateswara University, Tirupati AP, India
PGDCA from Nagarjuna University, Nagarjuna Nagar AP, India