SUMMARY

• An astute Oracle DBA with 8 plus years IT experience in Oracle products both production and development environments.
• I have participated in a wide array of activities in support of multi - tier production and development environments which include the installation and configuration of Oracle RDBMS versions 9i, 10g, 11g on UNIX/Linux/Windows platforms, database administration, production support, installation, configuration, upgrades, patches, database security, troubleshooting database design, UNIX shell scripting, Backups and Recoveries, Data pump, Data Replication, Performance Tuning and OEM.
• Hands on experience on Oracle (9i/10g/11gR1/11gR2), installed and configured on different platforms like Windows, Linux, RHEL, Oracle Solaris, HP-UX., IBM-AIX
• Worked on databases sizes ranging from 500GB to 8TB.
• Worked on Different operating systems for OLTP & OLAP environment on Very Large Databases (VLDB).
• Experience in configuring high availability systems like Real Application Clusters (RAC).
• Experience in installation of Oracle RAC with ASM and manage RAC instance using Crsctl and Svrctl utility.
• Involved in migrating production databases single instance to RAC environment.
• Planned and Implemented Disaster Recovery (DR) and HA using RAC, Data Guard.
• Experience in configuring, managing and monitoring both Physical standby and Logical standby database using Data Guard and Have hands on experience on Active Data guard.
• Having good experience in migrating databases with zero downtime across the cross platforms.
• Having good experience in Installation of 12C Grid Control on OEL 6.3 and experience in monitoring and managing of Oracle instances using Enterprise Manager Grid Control (OEM grid) 10g /11g.
• Developed database monitoring/health check alert scripts for database uptime/downtime status, and sizing issues using grid control (OEM).
• Experience in installation and configuration of Oracle Golden gate (GG) (both unidirectional and bidirectional).
• Generate and interpret Automatic Workload Repository (AWR), Active Session History (ASH), and Automatic Database Diagnostic Monitor (ADDM) reports using OEM.
• Configured Targets and used OEM to do the daily tasks regarding the performance, maintenance.
• Experience in implementing and planning backup and recovery strategies using Recovery Manager (RMAN). Performed block recovery, data files and databases using RMAN.
• Created clone databases for development and test environments using RMAN and User managed cloning and Implementation of Flashback Technology.
• Installed patches using Opatch utility and upgraded databases from 9i/10g to 11gr2 and expertise in applying Oracle PSU and CPU patches.
• Implemented data transfer using Transportable Table Spaces (TTS), Data Pumps and Export/Import utilities.
• Enforced Security administration, system monitoring by adding and removing users, configuring quotas, auditing, and analyzing security problems.
• Utilized SQL* Loader to migrate or load data to Oracle.
• Experience in using SQL, PL/ SQL procedures, functions, triggers and packages.
• Experience in SQL tuning using Explain Plans and Hints, Performance Tuning for better performance and Monitoring and optimizing the performance of the database through database tuning - Tuning applications, Tuning Instance, and Tuning Disk Usage.
• Worked on different types of storage structures (SAN/NAS).
• Good knowledge on Oracle support process for technical requests using Metal link and other support features.
• Good written and verbal communication skills, self-motivated team player and good analytical thinking.
• 24*7 on-call production database support and maintained remotely.

TECHNICAL SKILLS

RDBMS: Oracle 11gRAC/10gRAC/10g/9i.

Operating Systems: Red Hat Linux RHEL 4.x, 5.x 6.x, Sun Solaris 5.8/5.9/5.10 and Windows 2000/2003, HP -UNIX 5.9, AIX 5.1/5.2/5.3

Languages: SQL, PL/SQL, C++, C, UNIX Shell Scripting, XML.

Web Tools: HTML

Tools: /Utilities: Oracle Enterprise Manager (OEM) Grid Control, Toad, RAC, SQL Navigator, SQL*Loader, AWR, Patch Management, SSIS,, Data pump, Data Guard, Remote desktop Server, WebEx and Net Meeting, JDBC, MS Office.

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM

PROFESSIONAL EXPERIENCE

Confidential, MD

Oracle DBA

Responsibilities:

• 24 X 7 Production database administration, support and monitoring to ensure Proactive problem recognition and resolution of database issues.
• Involved with installation and maintenance of ORACLE RAC 3 nodes and adding a node to this cluster database for high availability on Linux.
• Installation, Configuration and Maintenance of RAC, Standby database.
• Installed 12C GRID CONTROL and registered databases in GRID control.
• Knowledge in handling and Oracle Enterprise Manager (OEM) on daily basis observing the performance of the production database using OEM.
• Duplication of Databases from Production RAC to test RAC using RMAN active cloning.
• Involved in migrating non-RAC databases to RAC environment on ASM.
• Converted single instance database to RAC Database using R-CONFIG.
• Configured and installed 15 standalone DR servers on ASM.
• Implementation and configuration of Oracle golden gate.
• Worked on databases sizes 8TB and involved in scheduling backups.
• Applied patches to Oracle Databases using Opatch utility and upgraded databases manually.
• Involved in migrating HP-Unix databases from 9i, 10g, and 11gR1 to 11gR2 Linux.
• Implemented Disaster recovery for production databases using Data guard.
• Have hands on experience in creating physical standby databases, and involved in converting physical to snapshot standby.
• Implemented 11g new features for building Active Data-guard.
• Configured Data guard-broker and involved in registering of databases in Data guard broker using utility DGMGRL.
• Extensively used data-pump at schema level and Database level for moving data from Solaris to Linux during migration
• Performed database refresh from production to test environment in both RAC and NON RAC environment using RMAN.
• Installed and Implemented Backup & Recovery procedures using RMAN.
• Performed Block Recovery, data file recovery using RMAN.
• Configured RMAN retention policy, archive log deletion policy for Production databases.
• Maintained catalog server and registered databases in catalog server.
• Performed Database refresh using RMAN active cloning and data-pump.
• Responsible for setting and managing user accounts, Granting required privileges to users.
• Oracle Database monitoring, troubleshoot and resolve the issues.
• Extensive Performance Tuning, Memory (SGA) Tuning, Net backup,RAID, RAW Devices.
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, recovering from Block Corruption).
• Taking periodic Backup of the Database and the software using RMAN and supporting VERITAS - Netback up Team.
• Involved in SQL tuning by generating explain plan, ADDM, AWR and TKPROF.
• Familiar with ORA-600 error. Involved with this ERROR.
• Involved in Performance tuning which includes creating indexes, analyze, explain plan, optimizer hints.

Environment: ORACLE 10g/11g, Oracle 10g/11g RAC, ASM, Oracle Solaris 10, Linux 5.x,6.x, Toad, SQL, PL/SQL, Toad, Data-Pump, OEM, RMAN, XML, Shell Scripting.

Confidential, CO

Oracle DBA

Responsibilities:

• Installed and maintained 3 Node 11g RAC and created database for production, development and test environment on Hp-Unix platform.
• 24 x 7 production support group member supported by our team.
• Perform Backup and Recovery of Primary and Standby Databases using RMAN and external backup using Net-backup.
• Involved in migrating single instance databases to RAC databases.
• Applying upgrade patches, maintenance and interim patches on all the databases.
• Troubleshooting and Investigation of application Bugs, Oracle Bugs and Job failures. upgraded Databases from 10.2.0.4 and to 11.2.0.1
• Worked on ASM environment performed various tasks like creating disk group using ASMCA, adding a disk to disk group, making disk online/offline in disk group.
• Implemented data-guard for databases and maintained Data guard DR server and have good experienced in Trouble shooting issues in Data-guard Environment.
• Configured physical standby databases and converted snapshot standby database.
• Converting data files across different platform using RMAN convert, Transportable Tablespaces (TTS), Export/Import and Data-pump (expdp/impdp).
• Migrating from Oracle 10.2.0.4 on Solaris databases to Oracle 11.2.0.1 on Linux.
• Manage and maintain database and user security using OEM Grid Control.
• Documented backup and recovery plans and tuning procedures.
• Efficient in using the Oracle Tools like OEM, SQL* Plus, SQL* Loader, TKPROF, LOGMINER, STATSPACK, SQL*Net, IMPORT/EXPORT, and RMAN.
• Supported development by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools Explain Plan, SQL Trace, TKPROF, TOAD and Oracle Enterprise Manager (OEM).
• Involved in writing for shell scripts for monitoring health checks and also for taking RMAN backups and Developed Scripts for transferring data from production server to testing/development servers. Writing backend procedures, functions, packages and triggers using PL/SQL.
• Checking of Alert log and Trace files to monitor the database on a daily basis. Also wrote monitoring scripts to check reports for space, Max. Extents, coalescing which are kept in CRONJOB

Environment: Oracle 10g/11g, Oracle 10g RAC, ASM, HP-UX 11, RHEL 5.8, Data Warehouse, OEM, SQL*Loader, Grid Control, RMAN, ASM, Data guard, TOAD, Data pump.

Confidential, NY

Oracle DBA

Responsibilities:

• Involved in Real Application Cluster (RAC) administration including 10g Database cloning, tuning, patching and monitoring concurrent manager processing etc.
• Wrote several shell scripts for checking oracle errors in alert file and database backup log files.
• Cloning of application from production environment to test environment and application of patches.
• Performing Backup/Recovery of all the Oracle databases using Recovery Manager (RMAN), also setup Recovery Manager Catalog for the same and hot and cold backups.
• Creating table spaces, sizing the system table space, allocating default table spaces for users.
• Creating users with restricted access, with default and temporary table spaces.
• Creating different kinds of partitions on tables and indexes.
• Creating roles and granting to users based on their group requirements.
• Creating profiles and attaching them with users, performing.
• Sizing the SGA, sizing the database 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 & RHEL.
• SQL issues and Tuning Considerations for Different Applications.
• 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.
• Estimate growth of database size by detail analysis of the company's future policies and generating reports for the management to act in advance.
• Clear documentation was prepared on all the processes like program specification, bugs fixing logs & change requests for future reference.
• Expertise in PL/SQL, SQL and UNIX Scripting (Used to write UNIX Scripts & implemented by Using CRONJOB for Day - to - Day activities.)
• Wrote PL/SQL Scripts, Packages and views to extract load and create data files using DTS and SQL server integration services (SSIS) in the SQL server 2000 and 2005.

Environment: ORACLE 11g, SQL, PL/SQL, Import/Export, RHEL, Windows NT.

Confidential - NY

Oracle DBA

Responsibilities:

• Managing daily operations for over 20 servers, including the Oracle System, using physical data guard and Delivered technical presentations on Oracle database operation.
• Designing and Implementing Database security using Oracle roles and privileges.
• Creating and managing stored procedures and triggers, distributing data, database replication, server tuning, and automation of administrative tasks
• Preparing a plan, policy and testing for the Upgrade of Oracle from 9i to 10g.
• Used RMAN for Backup, recovery and security.
• Supporting all aspects of production, QA, and development Databases (versions 9i and 10g) on Solaris and Linux
• Working in/with Development and Production in resolving SQL issues.
• Generated scripts for daily maintenance activity like analyzing the tables/indexes, and monitoring their growth rate and Coding stored procedures, Packages and functions and well tuning the SQL in the application.
• Strong and extensive use of DDL and DML tools/ Maintained database schemas and dictionaries and Involved in PL/SQL Coding, Scripting & Training Developers
• Installing, creating, configuring, tuning, and supporting Oracle Databases for several Enterprise java based E-commerce and portal applications
• Written PL/SQL programs functions, procedures, packages and triggers.
• Implementing Database object changes that were tested in testing environments
• Performing capacity planning and sizing of Databases based on inputs from business.

Environment: Oracle 9i/10g, SQL*Plus, PL/SQL, Solaris, Red Hat Linux AS 2.1/3.0, and Windows 2000.