Project : Installation, Setup, Maintenance and Upgrade of Server
7.3.3.5 to Oracle 8.0.5, 8i, Oracle Internet Application Server
(Apache), Oracle Enterprise Manager, Space Manager, Enterprise
Recovery Manager, Oracle SQL Backtrack, Oracle Data Warehouse,
CITRIX 1.7 , Questa Shareplex and Schema Manager

Role : SENIOR ORACLE DBA
Hardware : Sun E5000, EMC Drives, AIX

Environment : Windows NT, Sun Solaris 2.6, Veritas, Quick IO, EMC
Drives


Software : Oracle (7.3.4/8.0.x/8i), Pro*C, C, Unix Shell
Scripting, SQL Scripting, Forms (2.3, 4.5), Unix CRON jobs,
Oracle Application Object Library (AOL), BMC patrol monitoring.

:
RESPONSIBILITIES AS ORACLE DBA

§ Installation, Upgrade and Configuration of Oracle (7.1.6,
7.3.4, 8.0.5, 8i).

§ Installing and configuring Recovery Manager.

§ Installation and configuration of IAS 2000, Apache and Oracle
Portal.


§ Using Informatica/ERwin in Data Warehouse
Design/Implementation.

§ USed Quest Shareplex for replicating databases.

§ Extensive Performance Tuning, Memory (SGA) Tuning, Tuning
Concurrent Managers, etc.

§ Managing Veritas Clusters, I2 Implementation.

§ Working with Blobs and Clobs, Materialized views with Query
Rewrite, Bitmapped Indexes, etc

§ Applying Patches both Server side and Client side.
§ Cloning databases.
§ Setting up new environments (Development, Production etc)
§ Upgrading to Oracle Server 7.3.4 and then to 8i.
§ Setting up advanced replication.
§ Installed and configured Oracle Web Server 3.0
§ Taking Hot and Cold Backups, Exports etc.
§ Setting up and Installing Oracle Web Application Server

§ Setting and Installing Oracle Enterprise Manager and Enterprise
Backup Utility.


§ Creating the database, tables, tablespaces, data objects,
setting privileges, indexes, user logins, passwords (security).

§ Data Warehousing, Dataware House

§ 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.
§ Data Modelling, Database Design and Creation

§ Deciding the naming conventions of data file, 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.