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
• Database migrating from Oracle 8I to DB2 UDB 6.1 for BEA WebLogic
• 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 .
• 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 WebLogic)
• 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 Snapview,MirrorView/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.

Oracle DBA

• Setup one-way , bi-directional Oracle streams setup from Oracle , non Oracle databases
• Creation of database under Oracle 8.0.5/8i for Development and Production environments
• Laying out logical and physical designs, mirroring of redo logs and rollback segments.
• Creation of table spaces meant for storing data and index segments.
• Laying out strategies for the physical distribution of the control files, redo log files and data files related to the database across the disk volumes.
• Database designing, Creating instance ,Creating Database.
• Configuring Database Manager & Database
• Creating backup & recovery strategies, Implementing Incremental & delta backup, Database disaster recovery
• Configured, implemented 10g RAC with ASM disk on Linux servers EMC /IBM.
• Performed several RDBMS upgrades from 8i to 9i, 8i to 10g, 9i to 10g and 7.x to 8i on Multi platform.
• Expert in 10G Oracle RDBMS installation on Linux platforms (32 and 64 bit), upgrade, configuration, backup, recovery, archiving & purging activities. Used stats pack report to tune materialized views by creating materialized view logs to enable fast refreshes on master tables.
• Created physical standby database from hot backup of primary database.
• Created scripts to query performance views in an effort to reduce parse times and tune memory structures such as the database buffer cache, shared pool, library cache and PGA for a shared server configuration. Created logical standby database from hot backup of primary database. Resolved gaps between primary and standby databases (Gap Resolution).
• Designed, documented, implemented, and maintained all disaster recovery procedures . Setup physical standby on a 9i database to protect mission critical from any failures, errors or corruptions. Configured a cold-failover for 9i and 10G database using Sun clusters 3.1
• 10g RAC switchover and failover configuration, implantation, and testing. Installed Oracle 10g RAC on Linux platform using ASM for a storage manager.
• IBM Tivoli Storage Management configuration, setup & admin ( for Backup/recovery)
• AIX/Solaris SysAdmin work
• Hardware/software requirements estimation for client , based on their application or environment . which hardware , server best for client.
• DR (Disaster Recovery) recovery strategies design & implementation for either Oracle10g ( RAC/ASM/Data Guard) . Logical to Physical by using VMware and IBM TSM with Zero Down time & Desktop and Server Virtualization.

SQL Server DBA

• In-depth experience in database architecture, design and development, administration and maintenance of SQL Server 2008/2005/2000 /7.0 large scale databases.
• Experience in building enterprise cubes for data mining, developing Data warehouse solution using SQL Server Analysis Services 2005, SSRS,SSAS 2000.
• Highly experienced in database server performance tuning and optimization and troubleshooting and performance tuning for Complex SQL queries
• Highly experienced in distributed systems and high availability data server,data modeling, SQL and stored procedure development. DTS (2000), SSIS OLAP and replication design and implementation, build and support.
• Microsoft Certified Professional in SQL Server Design and Implementation
• Excellent Interpersonal, Management and Communication skills with ability to deliver quality results with minimum supervision
• Manage over 50 SQL Server instances for a Fortune 150 corporate IT environment.
• Monitoring of databases, working to maximize availability and tune data performance as needed. Ensure that adequate backup procedures exist for all critical SQL Server instances.
• Apply latest OS and SQL Server service packs and hot-fixes to ensure maximum security. Worked on building the first data warehousing system utilizing SQL Server 2005. Designed and configured a SQL Server 2005 cluster system.
• Upgraded number of production servers from SQL Server 2000 to SQL Server 2005. Developed and implemented Disaster Recovery (DR) on production SQL Server 2000 clusters. Environment: Windows Server 2000/2003, SQL Server 2000/2005.
• Scheduled maintenance tasks to monitor overall database performance, as well as design stored procedures and views that generate report files to be distributed on daily basis to clients. Redesigned entire IT infrastructure, streamlining business processes.

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 Analyser
• 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.

PeopleSoft Admin

• PeopleSoft8.x installation, Upgrade from 8.x to 9
• PeopleSoft CRM, Student Admin ( Campus Solutions ),HCM, Financial upgrade from V8.8 to V9.0 , V8.21 to 9.0
• PeopleSoft People tool upgrade from 8.43 to 8.49.03.
• Setup one-way , bi-directional Oracle streams setup from Oracle , non Oracle databases.
• Configuring Application Server, Web Server, Process Schedulers, application performance tuning
• Migration/version control PeopleSoft Internal & external object migration using Quest STAT
• Maintaining application & database integrity, applying patches, Controlling application user security.
• Migration from SQL Server 2005/DB2 UDB V8 on Windows/AIX to Oracle10 Linux/Windows.
• PeopleSoft Server Administration - Expertise in installation, configuration, maintaining and troubleshooting PeopleSoft process schedulers, application Servers, setup and management of the Database and PeopleSoft Internet Architecture PIA environment and related processing objects.
• Created multiple Tuxedo and Bea WebLogic/ IBM WebSphere PIA Server domains on separate host systems to access one database, an effective strategy for performance and tuning.
• Upgraded the PeopleSoft Tools and Applications (HRMS and Financials) using Upgrade Assistant and Change Assistant.
• Strong knowledge of PeopleSoft messaging and Integration broker.
• Applied Patches/Fixes/Updates/Tax Updates from the PeopleSoft Customer Connection to the PeopleSoft databases on timely basis.

WORK EXPERIENCE

Did DB2 upgrade from DB2 V8.2.7 to V9.5 on AIX 5.3.006 for client Amway located at Grand Rapid,MI. This project I did part time remote from Nov to Dec'09

Confidential, New Haven,CT July'09 to Till date
Sr. DB2 on Linux/Windows/Z/OS and SQL Server DBA

DB2 DBA Windows/Linux

Upgrade DB2 from V8.2 to 9.5 on Linux
Install DB2 V9.5 on windows

Automate REORG and RUNSTATS with out using DB parameters AUTO_REORG/RUNSTATS
Create stored procedure REORGCHK_TB_STATS,REORGCHK_IX_STATS procedure , populating reorg required table into create tables and setup cron job to run every weekend.

Build scripts and Setup monitoring jobs for Top 10 SQL, Tablespaces space usage , LOCKS, Database ,bufferpool activity.

Database cloning environment to environment
Implementing Incremental, Delta backup

Moving storage from external standalone desks to SAN DS8100 storage for DB2 Windows, Linux

Maintaining and supporting Database and system
Performance tuning SQL , database, instance level.

Install DB2 Connect Enterprise Server Edition V9 on Linux , configure connect between Z/OS to DB2 on Linux

SQL Server DBA

Install SQL Server 2008,
Upgrade SQL Server from 2000 to 2005 by using SQL Server Upgrade Assistant(SSUA)
Database Maintenance of SQL Server 2000/2005 on Windows 2003
Involved set configure managing SSRS and SSAS .
Created groups, roles, users and assigning access privileges to users.
Coordinated with back-end programmers in writing stored procedures, implemented referential integrity by using triggers, performance and tuning.
Scheduled the backups for Databases and Transaction log. Performed restoration operations Suggested backup strategies.
Managing the SQL Servers in Clustered Environment.
Recovered the database during the event of crash on several occasions. The Recovery was done to Point-in-time and incomplete stage.
Extraction, transformation and Loading of Data using DTS Packages.
Exported and imported data from text files and Excel to SQL Server database using BULK insert and BCP utility.
Performing query plans and making sure each and every query is using appropriate indexes.
Checked Performance Tuning, Indexing, Query Optimization.
Implemented, deployed and maintained Log Shipping.
Performed DBCC utilities and fixed data corruption in application databases.
Provided on - call 24/7 provide support.

DB2 DBA Z/OS
Migrated DB2 from V7 to V9.

DB2 Sub-Systems.Responsible for assisting Application Teams in writing efficient SQL, DB2 Performance monitoring and problem resolution using TMON\'s Monitor for DB2 z/OS Query Monitor tool.Responsibilities included implementing Database Change requests from the Application Team and applying those in a timely manner.

Software used to implement Database Changes was primarily BMC\'s Change Manager Tools.
Carried a pager on a rotating basis to support DB2 issues encountered by application teams.
Created & executed JCL for IBM\'s Check, Load, Image Copy, REORG, REBUILD, Quiesce etc. utilities.

Performance tuning instance, database Omegamon ,, SQL tuning using BMC Apptune .

Setup Federated environment from DB2 Z/OS and SQL Server to DB2 UDB on Linux using Web Sphere Information Integrator .

Environment :
DB2 V8/9 on Windows 2003, Linux Red hat V5 ES, SQL Server 2000/2005/2008 on Windows 2003/2008 , DB2 Z/OS V7/8/9 on Z/OS V 1.8 on IBM X series , P5 series Server , IBM DS8100 storage, DB2 Connect Enterprise Edition V8/9. Web Sphere Information Integrator

Confidential, Chicago ,IL July'08 to June'09
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.