SUMMARY

• Over 8+ years of experience as an Oracle Database Administrator having hands on experience in database administration and performed different tasks like installation, configuration, upgrades, patches, performance tuning, backup and recovery, production support, cloning, space management, database security.
• Experience in Installation, Configuration and Monitoring of Oracle Server on UNIX, Linux, AIX and Windows Environments.
• Experience in Installation of Oracle Real Application Cluster (RAC) with ASM and manage RAC instances using CRSCTL and SRVCTL Utility.
• Experience in monitoring and managing of Oracle instances using Enterprise Manager Grid Control (OEM Grid)
• Configuring and implementing Oracle ASM on UNIX, Linux, and Windows platforms.
• Configure high availability systems like Data Guard and RAC environments.
• Installation, Configuration and Maintenance of Logical/Physical standby databases in Dataguard.
• Experience in Implementing BACKUP and RECOVERY strategies using RMAN.
• Providing DBA support to multiple Cluster, Non Cluster and ASM Database in production, development and Testing Servers in UNIX, AIX & Windows Environments.
• Installation and configuration of Recovery Catalog for multiple Databases.
• Experience in taking logical backup of the database using DATAPUMP (Expdp/Impdp).
• Experience in Oracle Patching for 9i, 10G and 11G.
• Experience in SQL tuning using Explain Plans and Hints.
• Experience in Performance Tuning for better performance.
• Configuring Oracle Golden Gate for replications.
• Configured multiple database instances using a single ASM instance.
• Having Experience in MS SQL Server database Administration..
• Generate and interpret Automatic Workload Repository (AWR), Active Session History (ASH) and Automatic Database Diagnostic Monitor (ADDM) reports.
• Experience in performing database related activities using Oracle Enterprise Manager Grid (OEM Grid).
• Experience in UNIX Bash Shell Scripting.

TECHNICAL SKILLS

Databases: Oracle 11gR2, 10g, 9i, SQL Server 2005 and 2008

Oracle Products: Oracle10g (Grid Control), OEM (Oracle Enterprise Manager), RMAN, SQL*Loader, Import and Export (EXPdp/IMPdp), ASM, TKPROF, SRVCTL, SQL* Loader And SQL * Net.

Operating System: RHEL 4, RHEL 5, OEL 4, WIN NT/2003/2008, Solaris 10HP - UX Itanium, IBM AIX

Languages: SQL, PL/SQL, UNIX Shell Scripting.

Other Tools: TOAD, Putty, SQL Developer, Erwin.

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Oracle DBA

Environment: Oracle 10g, 11g, SQL, Oracle Grid Control, Oracle Enterprise Manager Database Control, TOAD, SQL Developer, SQL*Loader, Red Hat Enterprise Linux, ASM.

Responsibilities:

• Installation, configuration and maintenance of Oracle 10g and 11g database on OEL.
• Involved in construction of DR sites for all the Production databases.
• Involved with installation and maintenance of ORACLE RAC 3 node and adding a node to this cluster database for high availability.
• Upgraded the Oracle 10g database to 11g version and also applied patch set and interim patches whenever required to make the database software up to date.
• Monitoring Day-to-Day Backups, Log’s & recovering them as per the requirement.
• Successfully implemented Backup & Recovery using RMAN, Hot and Cold backups.
• Taking the RMAN incremental and cumulative backups.
• Scheduling the databases backup using Cron tab and VERITAS net backup.
• Extensive experience in RMAN recovery in RAC and stand alone database.
• Created a Clone Database using RMAN on remote Server and used SRVCTL commands for Real Application Cluster (RAC) Databases.
• Implemented Data Guard with maximum availability, protection and performance configurations and worked with Data Guard Fail over and Switch over cases at the times of up gradation and migration.
• Monitoring the Oracle Instances, Users, Tables, Tablespaces, Memory structures, and Rollback segments, Redo logs, Archived Redo logs and Alerts.
• Creation of Users and granting them the required Roles and Privileges accordingly.
• Involvement in space management, rectification of lock problems, managed quotas.
• Configuration of Listener and Net Service names using NETCA.
• Created, monitoring database objects like Tables, Indexes, Views, Users, and DB Links etc.
• Cloned schemas, objects and data on new server using Data pump.
• Responsible for capacity planning, recovery planning and installing patches
• Worked extensively on monitoring 10G grid control database, configuration of error notifications, installing listeners, and adding them to the grid control.
• Conducted time to time analysis and monitoring of the software and hardware requirements and act accordingly.

Confidential, Mt Lauren, NJ

Oracle DBA

Environment: Oracle 10g/11g, Linux, SQL Server 2008, Oracle Enterprise Manager Database Control, RDBMS, TOAD, PL/SQL, Shell Scripting, ASM, Data guard.

Responsibilities:

• Involved in monitoring the Database related activities using Oracle Enterprise Manager 11g Grid Control (OEM Grid) and monitoring the backup jobs scheduled in OEM Grid.
• Performed configuration of Oracle ASM on HP-UX, RHEL.
• Performed Installation, Configuration and Monitoring of Oracle 11gR2, 11gR1, 10g on UNIX, Linux AIX, HP-UX and Windows environments.
• Installed, configured and monitored Oracle RAC11gR2 and 10gwith ASM.
• Configured and implemented Oracle 11gR2 Data Guard for Database disaster recovery.
• Performed oracle Database data refreshes using export/import from production to test Servers.
• Involved in performance tuning by general health checks and maintenance for Database using AWR and ADDM reports by finding wait events.
• Performed logical backup of the database and Schemas using DATAPUMP (Expdp/Impdp) as per the requirement.
• Migration of databases from MS SQL server 2008 and Oracle 11g.
• Involved in implementation and support of 10g and 11g migrations and upgrades from Oracle 9i and 10g databases on HP-UX and Linux.
• Involved in applying CPU and PSU patches for Oracle Server.
• Involved in writing UNIX Shell Scripts for maintains tasks for oracle database.
• Worked on Data modeling Using Oracle SQL Developer Data Modeler.
• Configured and implemented Oracle Golden Gate replication.
• Involved in PL SQL programming and Performance tuning for oracle Database by generating AWR and ADDM reports
• Performed Database activities using Integrated Development tools like SQL Developer and TOAD.

Confidential, Wayzata, MN

Oracle DBA

Environment: Oracle 10.2.0.3/11.1.0.6/.7 , Linux, Solaris 10,Window 2003, Oracle Enterprise Manager Database Control, RDBMS, TOAD, PL/SQL, Shell Scripting, ASM, Data guard.

Responsibilities:

• Configuration and maintenance of a Two node RAC on Oracle 10g.
• Configuration of ASM with normal and external redundancy.
• Responsible for planning, testing and implementing different backup and recovery strategies.
• Responsible for scheduling backups.
• Taking Incremental backup using RMAN.
• Alert monitoring and Ticketing.
• Performing analysis and diagnosis of database performance statistics.
• Tuning performance using Advisors, AWR, ADDM, SQL tuning etc.
• Performing Online and Offline backups with RMAN as well as User managed.
• Installation of Oracle 10g on RHEL 4.
• Used Shell Scripting to backup database.
• Physical and logical data modeling using Erwin tool.
• Responsible for granting required privileges and roles to users.
• Tuning SQL queries when the performance is poor.
• Restoration of purged tables using Flashback.
• Implementation of logical backups using Log Miner.
• Upgrading databases from 10.0.1.0 to 10.0.4.0 using Patch sets.
• Scheduling Oracle Jobs in the database.
• Implemented Point in time recovery using RMAN.
• Responsible for Space management.
• Responsible to provide 24 x 7 database administrative activities over different database servers.

Confidential, Sunrise, FL

Oracle DBA

Environment: Oracle 9i/10g, LINUX, Windows 2003 server, OEM, Shell Scripting, PL/SQL.

Responsibilities:

• Installation and configuration of Oracle software 10g version.
• Created databases, allocated system storage and planned future storage requirements for the database.
• Installed Oracle and related tools, upgraded the database and applied patches as and when required.
• Configured and maintained Standby Databases in OLTP environment to automatically synchronize with production database.
• Configured the Data guard for switchover and failover and thereby providing high availability.
• Coordinated operating system setup/upgrades and infrastructure troubleshooting in partnership with system administrators.
• Implemented Recovery Manager (RMAN) Recovery Catalog performed Complete and Incomplete recovery.
• Performed Hot Backups and maintained database availability to support non-stop Business operations.
• Implemented Cloning to migrate data from PROD to Test and Dev databases.
• Performed Capacity planning and storage management.
• Estimation of database growth and analysis.
• Reorganization of tables and rebuilding of indexes.
• Maintained a disaster recovery site and planned and instituted disaster recovery process.
• Coordination with the team and ORACLE Support for troubleshooting the database issues.
• Developed UNIX Shell scripts to backup and recover the Oracle databases.
• Modified shell scripts for backup and recovery, Imported and exported procedure, implementing transportable table spaces.
• Worked as a team member to provide 24x7 on-call production database support.

Confidential, Richmond, VA

Oracle DBA

Environment: Oracle 9i/10g, Red Hat Linux, SQL, TKPROF, STATSPACK, OEM, PL/SQL.

Responsibilities:

• Performed full and incremental Backup Using RMAN Utility for Production databases.
• Involved in Upgrading the databases using Database Upgrade Assistance (DBUA)
• Performed cloning and refresh of Database from production environment to test environment using RMAN Duplicate database and Data pump import export.
• Handling service requests within Service line agreement.
• Involved in configuration files like Listener.ora, Tnsname.ora for Client - Server environment using network configuration assistant.
• Identified and fixed the logical block corruption using RMAN.
• Performed Data load on different databases from flat file using SQL*Loader.
• Performed Hot backup, cold backup and incremental backup for production database using RMAN.
• Monitored ALERT Log files to keep tracking the Oracle Errors and make necessary actions to rectify them.

Confidential

Oracle DBA/Developer

Environment: Windows 98/NT/2000, Oracle 9i, Toad, Oracle Enterprise

Responsibilities:

• Developed PL/SQL packages, stored procedures, functions, Cursors, Triggers.
• Responsible for installing, upgrading and configuring the Oracle server.
• Creating databases, Objects, Roles and privileges.
• Partitioned large tables to increase the performance.
• Responsible for optimizing the queries and application tuning.
• Implement Hot, Cold and Logical backup plans.
• Enhanced the performance of the company’s Oracle environment by providing advanced performance tuning and coding standards.
• Use TOAD tool to access the database.
• Used PL/SQL developer to create PL/SQL Procedures.
• Testing PL/SQL procedures against the test cases.
• Involved in checking the status of listener and restarting listener.
• Grant and Revoked user privileges and roles as per requirement and killed blocking session.
• Performed auditing on user activities on request and per organization policies.
• Created and managed database objects like table spaces and increase the size of the table space by resizing and adding the data files.