Jan '02 till Date
Client: Jeppesen Sanderson, Inc., Englewood, CO, USA 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, 11.5.7, 11.5.8, 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, 9iAS(Single Signon)

Hardware: Sun E5000, HP9000, EMC Drives

OS: Sun Solaris 2.8, HP-UX 11.0, Linux, 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, Kintana , Constellar

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)

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.5, 11.5.8
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, admerge, adconfig, adclone, licmgr.sh, adsplice, etc.
Installation and configuration of IAS 2000, 9iAS, Apache and Oracle Portal.
Installation of Oracle 8.0.x, 8i and 9i, Database migrating Oracle 8i to 9i.
Installation and managing Oracle Network products including Net 8.
Installing and configuring Recovery Manager.
I2 Implementation.
Applying Patches both Server side and Client side.
Application Cloning
Setting up and Installing Oracle Web Application Server
Tuning Oracle server along with Operating System to obtain optimal performance.
Configuring ORACLE Process, Parameters & Multithreading.
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, 9i RAC.
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, perl, awk
Setting and Installing Oracle Enterprise Manager(OEM).
Setting up ADI and Metaframe Citrix.
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)
Defragmentation of database using export import.
Removing row chaining for better performance.