PROJECT EXPERIENCE
AT&T Communications, Lowell, Massachusetts, USA
June 2000 - Present
Senior Oracle Application DBA / CRM-HRMS DBA.

PROJECT:
Installation, Setup, Maintenance and Upgrade of Oracle Applications 10.7, 11.0.3, 11i - 11.5.3, 11.5.4, 11.5.5, Server 7.3.3.5 to Oracle 8.0.5, 8i, 9i Oracle Internet Application Server (Apache), Oracle Enterprise Manager, Space Manager, CITRIX, Questa Shareplex and Schema Manager, Veritas Clusters Failover, Quick IO, Oracle SQL Backtrack, RMAN, Oracle Data Warehouse

Hardware : Sun E5000, HP9000, EMC Drives

OS : Sun Solaris 2.8, HP-UX 11.0,Windows NT/2000

Environment : Windows NT/2000, Sun Solaris 2.8, HP-UX 11.0, Veritas, Quick IO, 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, 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 iProcurement, iSupport, iPayment, HRMS (Payroll, HR)

DB Size : 2000 GB (2 TB), Users- 1800

Responsibilities:
-Complete cycle of implementing 11i
-Completed Upgrade from 10.7 to 11i
-Completed upgrade from 11.0.3 to 11i
-Installing, Upgrading, Patching and Managing Oracle
Applications 10.7, 11.0.3, 11.5.3, 11.5.4, 11.5.5.
-Installation of IP5 (Internal Requisitions) with 11.0.3
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
-Using utilities like adpatch, adadmin, adctrl, adaimgr,
etc.
-Installation and configuration of IAS 2000, 9iAS,
Apache and Oracle Portal.
-I2 Implementation.
-Applying Patches both Server side and Client side.
-Application Cloning
-Setting up and Installing Oracle Web Application Server
-Installation of Oracle 8.0.4, 8i and 9i, Database
migrating Oracle 8i to 9i.
-Installation and managing Oracle Network products
including Net 8.
-Installing and configuring Recovery Manager.
-Tuning Oracle server along with Operating System to
obtain optimal performance.
-Configuring ORACLE Process, Parameters &
Multithreading.
-Setting up Distributed databases, Multi-site update,
and two-phase commits
-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.
-Tuning performance monitoring and tuning, Optimization,
Parameters, Tuning Issues, Bitmap indexes, Hash Joins.
-Used Quest Shareplex for replicating databases.
-Managing Veritas Clusters
-Involvement in Disaster recovery Level of experience
with parallel servers
-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
-Cloning databases.
-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.
-Installed and configured Oracle Web Server 3.0
-Taking Hot and Cold Backups, Exports etc.
-Setting and Installing Oracle Enterprise Manager and
Enterprise Backup Utility.
-Creating the database, tables, tablespaces, data
objects, setting privileges, indexes, user logins,
passwords (security).
-Deciding the naming conventions of datafile, redo log
files, tablespaces, segments.
-Writing scripts for backup and recovery, Import and
export procedure.
-Unix Shell scripting in csh, ksh for automating
startup/shutdown of databases.
-Database Sizing, Tablespace Management and Rollback
Tablespace Management, Transaction Management, Security
Administration.
-Setting up GLDI and Metaframe Citrix.
-Defragmentation of database using export import.
-Removing row chaining for better performance.
-Using Informatica/ERwin in Data Warehouse
Design/Implementation.
-Applied transformation rules using Informatica.
-Used Designer 2000 for database design.
-Built the ETL stage using Informatica Power Center
-Used various tools in Informatica Designer like Source
analyser, Warehouse architect, Transformation developer.
-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)

General Electric, Erlanger, Kentucky, USA
November 1998 - June 2000
Senior Oracle Applications DBA

PROJECT:
Installation, Setup, Maintenance and Upgrade of Oracle Applications 10.7, Server 7.3.3.5 to Oracle 8.0.5,8i, Oracle Web Server3.0, Oracle Enterprise Manager, Space Manager, Oracle Backup Enterprise Utility, 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 10.7, Pro*C, C, Unix Shell Scripting, 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, OE, INV, PO, QP, ASO, PA, CN, SC

Size of the DB : Up to Size " 900 GB, Users- 780

Responsibilities:
-Complete cycle, including development, testing, training and production,
-Implementation of 11.0.3/10.7 implementation.
-Installation, Upgrade, patching and managing Oracle
Applications 10.7NC & Smart client and 11.0.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