Experience Details

Samtrans,NJ, USA
Senior Oracle APPS/CRM DBA
Jun 2002 - Present
Project: Installation, Setup, Maintenance and Upgrade of Oracle Applications 10.7,11.0.3 to 11.5.8 MRC, MLS(UTF8), Server 7.3.3.5 to Oracle 8.0.5, 8i, 9i(9.2) Oracle Internet Application Server (Apache) 9iAS, Oracle Enterprise Manager, Space Manager, Oracle SQL Backtrack, RMAN, Oracle Data Warehouse, CITRIX, Questa Shareplex and Schema Manager, Veritas Clusters Failover, Quick IO, 9i RAC, Database High Availability Clustering, Net Backup, Legato, EMC, Raid, Raw Devices, DSS, Business Objects, Toad, TKPROF, Stats Pack, LOGMNR, Spotlight on Oracle, Sql Navigator, SQL Expert, Veritas Netbackup, etc.
Hardware: Sun E5000, HP9000, EMC Drives
OS: Sun Solaris 2.8, HP-UX 11.0, Linux, Windows NT/2000
Environment: Windows NT, Sun Solaris 2.8, HP-UX 11.0, Veritas, Quick IO, Linux, Citrix
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, BMC patrol monitoring.
APPS Modules: GL, AR, AP, FA, WIP, ONT (Order management), OE, INV, PO, QP, ASO, PA, CRM (Sales Incentive Compensation, Mobile Field Service, iSupport, iPayment, Install Base, Service Contracts), Self Service Applications, iProcurement, HRMS (Payroll, HR)

RESPONSIBILITIES
* Complete cycle of implementing 11i with Multi-Language(MLS) and Multi-Currency(MRC)
* 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 servers to Sun Sparc servers
* Installing, Upgrading, Patching and Managing Oracle Applications 10.7, 11.0.3, 11.5.8(11i) Tuning Concurrent Managers, Defining Work Shifts, etc.
* 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.
* Installation, Upgrade and Configuration of Oracle (7.1.6, 7.3.4, 8.0.5, 8i, 9i).
* Used Kentana for Patching as well as for Migration of Foundation Objects.
* Scheduled jobs using cron, control-m/Data Stage.
* Installing and configuring Recovery Manager.
* Installation and configuration of 9iAS Portal and Single Signon, Apache and J2EE Containers(OC4J).
* Net backup, Legato, EMC(Timefinder and SRDF), RAID, RAW Devices
* Used Informatica for ETL(Extraction Transformation and Loading) in a Data Warehousing Environment.
* Used Designer 2000/Erwin for database design.
* USed Quest Shareplex for replicating databases.
* Extensive Performance Tuning (Systems and Query Tuning), Memory (SGA) Tuning, Bitmap indexes, Hash Joins, Tuning Concurrent Managers, etc.
* Managing Veritas Clusters for HA.
* Table Partitioning, Creating Index Organized tables, Creating Locally managed Tablespaces.
* Working with Blobs and Clobs, Materialized views with Query Rewrite, Bitmapped Indexes, etc
* Cloning 11i databases using adclone, adconfig and Rapid Clone Methods.
* Upgrading to Oracle Server 7.3.4 and then to 8i and 9i.
* 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.
* Taking Hot and Cold Backups, Exports etc.
* Installing and Configuring Oracle Enterprise Manager(OEM) as well as RMAN.
* Expertise with Installation and Configuration of EDW(Enterprise Data Warehouse).
* Creating the database, tables, tablespaces, data objects, setting privileges, indexes, user logins, passwords (security).
* Database Sizing, Tablespace Management and Rollback Tablespace Management, Transaction Management, Security Administration.
* Setting up ADI and Metaframe Citrix.
* Defragmentation of database using export import.
* Removing row chaining for better performance.
* Data Modelling, Database Design and Creation following OFA, Data Warehousing, OWB (Oracle Warehouse Builder)
* Writing scripts for backup and recovery, Import and export procedure.
* Unix Shell scripting in csh, ksh for automating tasks like startup/shutdown of databases.

AT&T Broadband, North Reading, MA, USA
Senior Oracle APPS DBA
Mar 1999 - Jun 2002
Project: Installation, Setup, Maintenance and Upgrade of Oracle Applications 10.7 ,11i(11.5.3), Server 7.3.3.5 to Oracle 8.0.5,8i, Oracle Web Server3.0, Oracle Enterprise Manager, Space Manager, Oracle SQL Backtrack, Chain Link Object Migrator (2.0), CITRIX
OS: Sun Solaris 2.6, AIX 4.3, Windows NT
Environment: Windows NT, Sun Solaris 2.6, AIX/6000 Server
Software: Oracle (7.3.4/8.0.x/8i), Oracle APPS 10.7, Pro*C, C, Unix Shell
Scripting, SQL Scripting, Forms (4.5, 6i), Unix CRON jobs, BMC patrol monitoring.
APPS Modules: GL, AR, AP, FA, WIP, OE, ONT, INV, PO, QP, ASO, PA, Sales Incentive Compensation, CRM(Service Contracts, iSupport, Install Base), iProcurement.

RESPONSIBILITIES
* Complete cycle, including development, testing, training and production,
Implementation of 11.5.3/10.7 implementation.
* Installation, Upgrade, patching and managing Oracle Applications 10.7 & Smart client and 11I(11.5.3)
* Tuning Concurrent Managers, Defining Work Shifts, etc.
* Installation, Upgrade and Configuration of Oracle (7.1.6, 7.3.4, 8.0.5, 8i).
* Extensive Performance Tuning, Memory (SGA) Tuning, Tuning Concurrent Managers, etc
* Performed Applications System Administration Responsibilities.
* Applying Patches both Server side and Client side.
* Using utilities like adpatch, adadmin, adctrl, adaimgr, licmgr.sh, adrelink.sh, adsplice, adconfig etc.
* Used Designer 2000 for database design
* Cloning databases and APPS 10.7, 11i.
* Setting up new environments (Development, Testing, Conference Room Pilot, Production etc)
* Upgrading to Oracle Server 7.3.4 and then to 8i.
* Setting up advanced replication.
* Setting up Oracle Parallel server.
* Taking Hot and Cold Backups, Exports etc.
* Setting and Installing Oracle Enterprise Manager(OEM) and RMAN.