|
MAJOR ASSIGNMENTS
Dec 99 to Present
Client : At&T Broadband , MA, USA
Project : Installation, Setup, Maintenance and Upgrade of Oracle
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 A SENIOR 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.
* Table Partitioning, Creating Index Organized tables, Creating
Locally managed Tablespaces.
* 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.
* Setting up Oracle Parallel server.
* 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 Citrix 1.7
* Defragmentation of database using export import.
* Removing row chaining fot better performance.
* Data Modelling, Database Design and Creation
* 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 .
Jan '98 to Nov '99
Client : MCI, CO, USA
Project : Installation, Setup, Maintenance and Upgrade of Oracle
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), Oracle Applications
Datawarehouse, CITRIX 1.7
Role : SENIOR ORACLE DBA
Hardware : Sun Solaris 2.6, AIX
Environment: Windows NT, Sun Solaris 2.6
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) .
* Extensive Performance Tuning, Memory (SGA) Tuning, Tuning
Concurrent Managers,
etc
* Applying Patches both Server side and Client side.
* Copying databases.
* 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.
* 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
|
