Sr. Oracle DBA Resume

Title
Sr. Oracle DBA

Primary Skills
Around 8 years of IT experience as Senior Oracle Database Administration Ver 7.x/8.0/8i/9i/10G on a variety of platforms

Location
US-CA-Mission Viejo

Posted
Apr-06-07


OBJECTIVE: To work as a Senior Oracle DBA-will relocate at my expense to any US location.
Education: MS Information Technology, Masters in Computer Application.
Certification: Oracle 8.0/8i/9i.

Experience Summary:
* Around 8 years of IT experience as Senior Oracle Database Administration Ver 7.x/8.0/8i/9i/10G on a variety of UNIX (Solaris, HP-UX, AIX), Windows NT 4.0/2000/2003 with Oracle (7.x, 8.0.5, 8i, 9i, 10g), Stored Procedures, DB Triggers, Developer 2000, Forms (4.5 & 6i/9i) and Reports (2.5 & 6i/9i) Net 8, Sql*Plus, Pro*C etc.
* Expert in packages like Oracle Enterprise Manager, Oracle Datawarehouse Builder (ODB), Quick IO, Veritas Clusters, RAID, RMAN, Quest Shareplex, EMC DM, 9iAS & 10gAS Portal and Single Signon, Web Logic, Schema Manager, BMC Patrol, SQL Backtrack, Smart DB, Apache, HTML, XML, JAVA, J2EE(OC4J), OLTP, Control-M, Entity/Relation Data Modeling using ER-Win, Informatica ETL, and Discoverer 3.x, 4i and 10g. Experience in Administration of Oracle Database, Oracle Application, Data Warehouse, ETL Technology, Reporting tools, Data Modeling and Data Architecture, Transparent Application Failover (TAF).
* Global implementations support with Multi-Language (MLS) as well as Multi-Currency (MRC).
* Currently managing 50 databases, biggest database around 2000GB in size supporting both production developments on Unix as well as on Windows NT/2000/2003.
* Skilled in Oracle Server Installations / Upgrades, Space Management, Oracle Applications System Administration, Oracle Workflow, Oracle Internet Directory(OID), Oracle Web Application Server, Oracle Parallel Server & 9i RAC/10g RAC (Grid), Developing client-server systems with Oracle Developer Suite, Oracle Data Guard, Backup & Recovery, Conversion, Process improvement, normalization/de-normalization, Replication, Capacity Planning, Disaster Recovery, Database Performance Tuning, Memory Tuning, Application Tuning, Patching, Security Administration, Data Architecting, Oracle Advanced Replication, Oracle Replication Manager, Data Warehousing, Space Manager, SQL Server, Oracle Standby Server, Multithread Servers, Distributed Databases for Oracle 7.x/8i/9i/10G Databases, index and cluster partitioning.

TECHNICAL SKILLS
Database: Oracle 10g/9i/8i, MS Access and MS SQL Server.
Database Tools: OEM, BMC Patrol, SQL Backtrack, RMAN, Shareplex, DBARTISAN Smart DB, Space Manager, Discoverer 4i, 10g, EDW, Data Guard, Control-M, ERWIN, ADI 7.0, 7.2, Web ADI 8.3.1, Oracle Warehouse Builder (OWB), SQL Trace, TKPROF, Kentana, Netbackup, Legato, EMC DM/TimeFinder & SRDF for BCV, 9i RAC, 10g RAC
Operating System: Windows 95/NT, Windows 2000/2003, HP-UX, Sun Solaris, AIX, Quick IO, Veritas Clusters
Hardware: HP9000, Compaq, EMC, Sun Sparc E5000, RS6000
CASE Tools: Designer 2000
Languages: Cron Processes, Unix Shell Scripting, SQL*Plus, PL/SQL, C, Pro*C, csh, ksh, Html, JAVA
OLAP Tools Cognos Tools (Impromptu, PowerPlay, PowerPlay Powermart, Excel Transformer, Informatica)
GUI: Developer 2000, Developer 6i (Forms 6i, 9i, Reports 6i, 9i)
Web Tools: HTML, XML, JAVA, Apache, 9iAS, 10gAS, Web Logic

Experience Details

Shell Oil Corporation
Los Angeles, CA / Houston, TX
SENIOR ORACLE DBA
January 2006 - Present

PROJECT: Installation, Upgrade, Setup and Maintenance of Server 7.3.3.5 to Oracle 8.0.5, 8i, 9i and 10g Oracle Internet Application Server (Apache), 9i RAC/ 10g RAC, Oracle Internet Directory(OID), Oracle Data Warehouse, Oracle Data Guard, Oracle Warehouse Builder, Space Manager, Oracle SQL Backtrack, Oracle Enterprise Manager, EDW, EMC TimeFinder/SRDF, Raid, Raw Devices, DSS, Veritas Clusters Failover, Quick IO, CITRIX, Quest Shareplex, Schema Manager, RMAN, Net Backup, Legato,
OS: Windows NT, 2000, 2003, AIX 5.1, HP-UX 11.0, Sun Solaris 2.8, Veritas, Quick IO
Hardware: HP9000, Linux RedHat, EMC Drives, RS6000, Sun E5000.
Software: Oracle (8.0.x/8i/9i/10g), Forms 6i/9i, Unix Shell Scripting, Unix CRON jobs, BMC patrol monitoring, Pro*C, C, SQL scripting, Oracle Application Object Library (AOL), SQL Server
Environment: Sun Solaris 2.8, HP-UX 11.0, OLTP, Windows NT/2000/2003, Veritas, Quick IO, Citrix, Linux.
RESPONSIBILITIES AS ORACLE DBA
* Installation, Upgrade and Configuration of Oracle (8i, 9i, 10g)
* Database migrating Oracle 8i to 9i/10g.
* Upgrading the Oracle Server to 8i and 9i and 10g
* Oracle9i ETL supplies robust ETL infrastructure right in the database
* Installation and configuration of 9iAS and 10gAS Portal and Single Signon, Apache and J2EE Containers(OC4J).
* Storage Management Managing Space, Tablespaces, Segments and Extents, Rollback Segments & Data Dictionary.
* Played the key DBA role in conversion of data from legacy systems to Oracle database on E10K Sun box.
* Supported and trouble shooted Applications running on Web Logic, OLTP.
* Net backup, Legato, EMC (Timefinder and SRDF), RAID, RAW Devices
* Used Transparent Application Failover (TAF) to configure type and method of failover for each Oracle Net client.
* Synchronized Transparent Application Failover (TAF) with Oracle 10g RAC.
* Worked on IMS DB on IMS Mainframe.
* Installing and configuring Recovery Manager.
* Completed Migration of Oracle Databases from AIX IBM machines to Sun Sparc Servers as well as with Linux.
* Expertise in SQL Server 2000.
* Expertise in Scheduling Control-m for scheduling jobs
* Used Quest Shareplex for replicating databases.
* Security User Management, Privileges, Roles, Auditing, Profiling, Authentication.
* Backup & Restore on-line and off-line backup planning, procedure, exp/imp, restores process.
* Managing Veritas Clusters for HA.
* Used Oracle Internet Directory to leverages the scalability, high availability and security features of the Oracle database
* Extensive Performance Tuning, Memory (SGA) Tuning, etc.
* Oracle Warehouse Builder 3i provides functions for designing, deploying, and managing data warehouses
* Setting up Oracle Parallel server and 9i RAC/10g RAC(Grid Control).
* Configured Oracle data Guard and OID(Oracle Internet Directory).
* Complete cycle of implementing Oracle Databases with Multi-Language(MLS) and Multi-Currenty(MRC) with UTF8 Character Set.
* USed Quest Shareplex for replicating databases.
* Using Informatica/ERwin in Data Warehouse Design/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)
* Setting up advanced replication.
* Installed and configured Oracle Web Server 3.0
* Taking Hot and Cold Backups, Exports etc.
* Strong expertise in RMAN.
* 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
* Used Informatica for ETL(Extraction Transformation and Loading) in a Data Warehousing Environment
* Removing row chaining for better performance.
* Data Modelling, Database Design and Creation
* Data Warehousing, ODB (Oracle Datawarehouse Builder)
* Very well experienced in Setting up, Configuring, Installing, Development etc. for Oracle Portals.
* Managing Veritas Clusters, I2 Implementation.
* Table Partitioning, Creating Index Organized tables, Creating Locally managed Tablespaces.
* Database Sizing, Tablespace Management and Rollback Tablespace Management, Transaction Management, Security Administration.
* Setting up GLDI and Metaframe Citrix.
* Defragmentation of database using export import
* 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

Cummins Engines International Limited
(Columbus, Indiana and Orange, California)
SENIOR ORACLE DBA
Sept 2004 - Dec 2005

PROJECT: Installation, Upgrade, Setup and Maintenance of Server 7.3.3.5 to Oracle 8.0.5, 8i, 9i and 10g Oracle Internet Application Server (Apache), 9i RAC/ 10g RAC, Oracle Internet Directory(OID), Oracle Data Warehouse, Oracle Data Guard, Oracle Warehouse Builder, Space Manager, Oracle SQL Backtrack, Oracle Enterprise Manager, EDW, EMC TimeFinder/SRDF, Raid, Raw Devices, DSS, Veritas Clusters Failover, Quick IO, CITRIX, Quest Shareplex, Schema Manager, RMAN, Net Backup, Legato,
OS: Windows NT, 2000,2003, AIX 5.1, HP-UX 11.0, Sun Solaris 2.8, Veritas, Quick IO
Hardware: HP9000, Linux RedHat, EMC Drives, RS6000, Sun E5000.
Software: Oracle (8.0.x/8i/9i/10g), Forms 6i/9i, Unix Shell Scripting, Unix CRON jobs, BMC patrol monitoring, Pro*C, C, SQL scripting, Oracle Application Object Library (AOL), SQL Server
Environment: Sun Solaris 2.8, HP-UX 11.0, Windows NT/2000/2003, Veritas, Quick IO, Citrix, Linux.
RESPONSIBILITIES AS ORACLE DBA
* Setting up new environments (Development, Production etc)
* Upgrading to Oracle Server 7.3.4 and then to 8i.
* Used Oracle Advanced replication feature to set up multi-master replication, dealt with conflict resolution and performance issues.
* Setting up Oracle Parallel server and supporting the parallel server environment in production.
* 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
* 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
* Installing and configuring Recovery Manager.
* Completed Migration of Oracle Databases from AIX IBM machines to Sun Sparc Servers as well as with Linux.
* Strong expertise in RMAN.
* Expertise in SQL Server 2000.
* Expertise in Scheduling Control-m for scheduling jobs
* Used Quest Shareplex for replicating databases.
* Security User Management, Privileges, Roles, Auditing, Profiling, Authentication.
* Backup & Restore on-line and off-line backup planning, procedure, exp/imp, restores process.
* Managing Veritas Clusters for HA.
* Installation, Upgrade and Configuration of Oracle (8i, 9i, 10g)
* Database migrating Oracle 8i to 9i/10g.
* Upgrading the Oracle Server to 8i and 9i and 10g
* Oracle9i ETL supplies robust ETL infrastructure right in the database
* Installation and configuration of 9iAS and 10gAS Portal and Single Signon, Apache and J2EE Containers(OC4J).
* Storage Management Managing Space, Tablespaces, Segments and Extents, Rollback Segments & Data Dictionary.
* Played the key DBA role in conversion of data from legacy systems to Oracle database on E10K Sun box.
* Supported and trouble shooted Applications running on Web Logic.
* Net backup, Legato, EMC(Timefinder and SRDF), RAID, RAW Devices
* Worked on IMS DB on IMS Mainframe.
* Used Oracle Internet Directory to leverages the scalability, high availability and security features of the Oracle database
* Extensive Performance Tuning, Memory (SGA) Tuning, etc.
* Oracle Warehouse Builder 3i provides functions for designing, deploying, and managing data warehouses
* Setting up Oracle Parallel server and 9i RAC/10g RAC(Grid Control).
* Configured Oracle data Guard and OID(Oracle Internet Directory).
* Complete cycle of implementing Oracle Databases with Multi-Language(MLS) and Multi-Currenty(MRC) with UTF8 Character Set.
* USed Quest Shareplex for replicating databases.
* Using Informatica/ERwin in Data Warehouse Design/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)
* 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
* Used Informatica for ETL(Extraction Transformation and Loading) in a Data Warehousing Environment
* Removing row chaining for better performance.
* Data Modelling, Database Design and Creation
* Data Warehousing, ODB (Oracle Datawarehouse Builder)
* Very well experienced in Setting up, Configuring, Installing, Development etc. for Oracle Portals.
* Managing Veritas Clusters, I2 Implementation.
* Table Partitioning, Creating Index Organized tables, Creating Locally managed Tablespaces.
* Database Sizing, Tablespace Management and Rollback Tablespace Management, Transaction Management, Security Administration.
* Setting up GLDI and Metaframe Citrix.
* Defragmentation of database using export import
* 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

Washington Mutual, Irvine, CA
SENIOR ORACLE DBA
Jun 2003 - Aug 2004

Project: Installation, Upgrade Setup and Maintenance of Oracle Server 7.3.3.5 to Oracle 8.0.5, 8i, 9i, (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
Hardware: Sun E5000, HP9000, EMC Drives
OS: Sun Solaris 2.8, HP-UX 11.0
Software: Oracle (7.3.4/8.0.x/8i/9i), Pro*C, C, Unix Shell Scripting, Perl, SQL Scripting, Forms (2.3, 4.5, 6i), Unix CRON jobs, Oracle Application Object Library (AOL), BMC patrol monitoring.
Environment: Windows NT, Sun Solaris 2.8, HP-UX 11.0, Veritas, Quick IO

RESPONSIBILITIES
* Installation, Upgrade and Configuration of Oracle (8i, 9i) .
* Installing and configuring Recovery Manager (RMAN).
* Installation and configuration of Oracle Web Application Server, Apache and Oracle Portal.
* Oracle Portal Development and Production Support
* Using Informatica/ERwin in Data Warehouse Design/Implementation.
* Data Architecting- Design and entity relation.
* Extensive involvment in Data Modeling and Design using Erwin
* Worked in the capacity of a senior Oracle Data Architect.
* Performed the duties of a Unix Sysadmin on Sun Solaris 2.8, HP-UX 11 with Veritas file system.
* Used Crystal Reports.
* Mentored developers and did quality assurance.
* Applied transformation rules using Informatica.
* 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
* Used Quest Shareplex for replicating databases.
* Extensive Performance Tuning, Memory (SGA) Tuning, 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.
* 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

MCI, Colorado Springs, CO
SENIOR ORACLE DBA
April 2002 to May 2003

Project: Installation, Upgrade Setup and Maintenance 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), CITRIX 1.7
OS: Sun Solaris 2.6, AIX, Windows NT
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.
Environment: Windows NT, Sun Solaris 2.6, AIX/6000 Server
RESPONSIBILITIES
* Installation, Upgrade and Configuration of Oracle (7.1.6, 7.3.4, 8.0.5, 8i) .
* Extensive Performance Tuning, Memory (SGA) Tuning, etc
* Applying Patches both Server side and Client side.
* Copying/cloning 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 Architecting- Design and entity relation.
* Data Warehousing
* 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.

Hutchison Essar Telecom Ltd, New Delhi, India
SENIOR ORACLE DBA
June 2001 to March 2002

Project: Installation, Setup, Maintenance and Upgrade of Oracle Server 7.1.6 to Oracle 8.0.5, 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
Hardware: Sun Solaris 2.6, HP
Environment: Windows NT, HP-UX 11.0, Sun Solaris
Software: Oracle (7.3.4/8.0.x), 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
* Installation, Upgrade and Configuration of Oracle (7.1.6, 7.3.4, 8.0.5, 8i) .
* Extensive Performance Tuning, Memory (SGA) Tuning, etc
* Applying Patches both Server side and Client side.
* Copying databases.
* Setting up new environments (Development, Testing, Conference Room Pilot, Production etc)
* CDR Administration - To ensure all the CDRs are inserted and updated regularly and on-time in the system.
* 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
* 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 for 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.

Quark Systems Pvt. Ltd, India
ORACLE DBA
June 2001 to March 2002
(Freelance Project Work done remotely)

Project: Installation, Setup, Maintenance and Upgrade of Oracle Server 7.1.6 to Oracle 8.0.5, 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
Hardware: Sun Solaris 2.6, HP
Environment: Windows NT, Compaq ProLiant, HP-UX 11.0, Sun Solaris
Software: Oracle (7.3.4/8.0.x), 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
* Installation, Upgrade and Configuration of Oracle (7.1.6, 7.3.4, 8.0.5, 8i) .
* Extensive Performance Tuning, Memory (SGA) Tuning, 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

Nestle India Limited, New Delhi, India
ORACLE DBA
May 1999 to May 2001

Environment: HP-9000, Compaq ProLiant, FORMS4.5, ORACLE7.0, ksh, csh, Pro*C, Forms 2.3
Responsibilities
* Developed E-R and data flow diagrams,
* Performed Data Modeling and architected the data warehouse.
* Developed several stored procedures.
* Creation of database, tables, users, roles in Oracle7.0.
* Development of reports in Pro*C and ReportWriter 2.0 Security administration i.e. managing privileges and roles
* Backups and Recovery i.e. exports/imports, hot archieve log backups, cold offline backups, etc
* Performance tuning which includes creating indexes, analyze, explain plan, optimizer hints
* Space Management which includes table space creation, adding new datafiles,
* Creating rollback segments, etc. Shell Scripting in csh and ksh

Certifications
See above


You must be logged in and have a current resume access subscription. Login or Register »

Resumes in Mission Viejo, CA | Resumes in California

View other Sr. Oracle DBA resumes, Database Administrator resumes