Applied Patches on RAC, Standalone, Standby databases based on the requirements.

Evaluated mix of backup and recovery methods based on organizational needs. Implemented, tested and documented various backup/recovery scenarios for knowledge base.

Experience on working with data guard physical/logical standby databases.

Used Data Pump for export and import. Wrote scripts for Backup of databases, maintenance of archive logs for databases. Streamlined backup procedures and implemented RMAN for backup and disaster recovery.

Database Refreshing / Replication from production to testing using Exp/Imp.

Designed, developed and maintained UNIX shell scripts to collect and monitor database metrics and Statspack snapshots and reports.

Creating roles and granting to users based on their group requirements.

Creating profiles and attaching them with users, performing hot and cold backups.

Restoration and recovery from backup.

Sizing the SGA, sizing the db buffers, shared SQL area, log buffer based on the requirements.

Oracle Export, Import, SQL*Loader and data pump utilities.

Installing &configuring Oracle 10g, 10g RAC,9i on Linux & AIX.

Installation, Configuration, Upgrade, patching of Oracle RDBMS.

SQL issues and Tuning Considerations for Different Applications.

Established and wrote the Performance Tuning guidelines for the Engineering Department to enhance the quality of the product for all current and future code development. This document includes hints for SQL, PL/SQL and JDBC performance tuning, application tuning.

Led the application design team in developing a custom ETL application using built-in Oracle technology (Oracle Replication, Materialized Views, Snapshot's, and PL/SQL) as well as designing the Star Schema used to support the company's Enterprise Business Intelligence system.

Established standards for all Oracle database environments based on Oracle's Optimal Flexible Architecture (OFA). This initiative involved redesigning all new and legacy environments to adhere to these newly established standards.

Established and wrote the Database Administrators Procedures document for the IT department. This document outlines all standards for the DBA Group including installing/upgrading Oracle, creating databases, DBA tools, administration and monitoring, naming standards, coding standards for Java and PL/SQL, policies, practices and procedures.

Redesigned a thorough backup and recovery strategy for all major production systems.

JavaScript Requires
Sorry this site will not function properly without the use of scripts.
The scripts are safe and will not harm your computer in anyway.
Adjust your settings to allow scripts for this site and reload the site.