UHHS(University Hospitals Health Systems), Cleveland, OH, USA Sept 2001 - Present
Senior Oracle Application DBA / Financial, CRM, HRMS-Payroll, Self Service.

Project: Installation, Setup, Maintenance and Upgrade of Oracle Applications 10.7, 11.0.3, 11i - 11.5.3, 11.5.5, 11.5.8 Server 7.3.3.5 to Oracle 8.0.5, 8i, 9i Oracle Internet Application Server (Apache/9iASx), Oracle Enterprise Manager, Space Manager, CITRIX, Questa Shareplex and Schema Manager, Veritas Clusters Failover, Quick IO, 9iRAC, Oracle SQL Backtrack, RMAN, Oracle Data Warehouse, Net Backup, Legato, EMC TimeFinder/SRDF, Raid, Raw Devices, DSS
Hardware: Sun E5000, HP9000, EMC Drives
OS: Sun Solaris 8, HP-UX 11.0, Windows NT/2000
Environment: Windows NT/2000, Sun Solaris 2.8, HP-UX 11.0, Veritas, Quick IO, Citrix, Linux.
Software: Oracle (7.3.4/8.0.x/8i/9i), Pro*C, C, Unix Shell Scripting, Perl, SQL Scripting, Forms (2.3, 4.5), Unix CRON jobs, Oracle Application Object Library (AOL), BMC patrol monitoring.
APPS Modules: GL, AR, AP, FA, WIP, ONT (Order management), OE, INV, PO, QP, ASO, PA, CRM (Sales Comp-CN, Mobile Field Service etc), Self Service Applications, iProcurement, iSupport, iPayment, HRMS (Payroll, HR)
DB Size: 2000 GB (2 TB), Users- 1500

Responsibilities:
* Installing, Upgrading, Patching and Managing Oracle Applications 10.7, 11.0.3, 11.5.3, 11.5.5, 11.5.7, 11.5.8.
* Performed Applications System Administration tasks like Registering new forms, reports, Fixing Printer Issues, Setting Profile Options, Creating/Assigning Responsibilities, Creating APPS Users etc.
* Migration of Oracle Applications 11i from Sun Solaris to Linux, SuSE, SLES 7
* Using utilities like adpatch, adadmin, adctrl, adaimgr, licmgr.sh, adrelink.sh, adsplice, adconfig etc.
* Complete cycle of implementing 11i with Multi-Language(MLS) and Multi-Currenty(MRC) with UTF8 Character Set.
* Completed Upgrade from 10.7 to 11i
* Completed upgrade from 11.0.3 to 11i
* Completed upgrade from 11.5.4 to 11.5.8
* Completed Migration of 11i from AIX IBM machines to Sun Sparc Servers.
* Extensive Performance Tuning of Concurrent Managers, Web Server and Jinitiator, Defining Work Shifts, etc.
* Registering new forms, reports etc.
* Expertise in Scheduling Control-m for scheduling jobs
* Used Kentana for Patching as well as for Migration of Foundation Objects.
* Installation and configuration of 9iAS Portal and Single Signon, Apache and J2EE Containers(OC4J).
* Net backup, Legato, EMC(Timefinder and SRDF), RAID, RAW Devices
* Cloning 11i databases using adclone, adconfig and Rapid Clone Methods.
* Installation of Oracle 8.0.4, 8i and 9i, Database migrating Oracle 8i to 9i.
* Extensive Performance Tuning (Systems and Query Tuning), Memory (SGA) Tuning, Bitmap indexes, Hash Joins, Tuning Concurrent Managers, etc.
* Storage Management Managing Space, Tablespaces, Segments and Extents, Rollback Segments & Data Dictionary.
* Security User Management, Privileges, Roles, Auditing, Profiling, Authentication.
* Backup & Restore on-line and off-line backup planning, procedure, exp/imp, restores process.
* Used Quest Shareplex for replicating databases.
* Managing Veritas Clusters for HA.
* Standby Server for Oracle 7.x/8i/9i Databases
* Table Partitioning, Creating Index Organized tables, Creating Locally managed Tablespaces.
* Working with Blobs and Clobs, Materialized views with Query Rewrite, Bitmapped Indexes, etc
* Setting up new environments (Development, Production etc)
* Used Oracle Advanced replication feature to set up multi-master replication, dealt with conflict resolution and performance issues.
* Setting up Oracle Parallel server and 9i RAC.
* Installing and Configuring Oracle Enterprise Manager(OEM) as well as RMAN.
* Creating the database, tables, tablespaces, data objects, setting privileges, indexes, user logins, passwords (security).
* Writing Unix Shell scripts for backup and recovery, Import and export procedures etc.
* Setting up ADI and Metaframe Citrix.
* Defragmentation of database using export import.
* Removing row chaining for better performance.
* Used Informatica for ETL(Extraction Transformation and Loading) in a Data Warehousing Environment.
* Used Designer 2000/Erwin for database design.
* Used PL/SQL, SQL Loader as part of ETL process to populate the operational data store
* Data Modeling, Database Design and Creation, Data Warehousing, ODB (Oracle Datawarehouse Builder)

Grainger(Manufacturing & Distribution), CA, USA Jan 1999 - Sep 2001
Senior Oracle Applications DBA, Financials, Manufacturing, CRM
Project: Installation, Setup, Maintenance and Upgrade of Oracle Applications 11i, 10.7, Server 7.3.3.5 to Oracle 8.0.5,8i, Apache, Oracle Enterprise Manager, Space Manager, Recovery Manager (RMAN), Oracle SQL Backtrack, Chain Link Object Migrator (2.0), CITRIX 1.7
Environment: Sun Solaris 2.6, AIX, Windows NT
Software: Oracle (7.3.4/8.0.x/8i), Oracle APPS 11i, 10.7, Pro*C, C, Unix Shell Scripting, SQL Scripting, Forms 6i, Unix CRON jobs, Oracle Application Object Library (AOL), BMC patrol monitoring.
APPS Modules: GL, AR, AP, FA, WIP, OE, INV, PO, QP, ASO, PA, CN, SC
Size of the DB: Up to Size # 900 GB, Users- 780