SUMMARY:

Oracle certified consultant with over 7 years of experience as an Oracle Database Administrator. Extensively worked on Installing, configuring and managing Oracle 11gR2, 10g, 9i & 8i Database on Linux, UNIX and Windows environments. Experienced in configuring and managing Oracle Real Application Cluster (RAC), Data Guard and Golden Gate for Oracle High Availability.Extensively worked on SQL Server 2005/2008 administration. Experienced in cloning Oracle database from production to development and QA Servers. Experienced in monitoring the Database using OEM Grid Control. Expertise in Upgrading Oracle Database and applying Oracle PSU and CPU Patches. Experienced in implementing Backup and Restore strategies for Oracle Database using RMAN and Data pump (Expdp/Impdp). Proficient in Oracle Performance tuning Using AWR, ASH, ADDM reports, SQL trace and TKprof.Expert in monitoring Oracle database using tools like Toad, SQL Developer. Proficient in writing UNIX shell scripting using BASH interpreter for Database activities.

TECHNICAL SKILLS:

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

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, Denver, CO

Environment: Oracle 11g RAC, Data Guard, HP-UX, RHEL Server 5.3,AIX, Windows 2003 Server, OEM Grid Control 11g,ASM, AWR/ADDM, Shell Scripting, RMAN, TOAD, Oracle SQL Developer.

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 RAC 10gR2 and 11gR2 with 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.
• 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.
• Involved in Performance tuning for oracle Database by generate and interpret AWR and ADDM reports, performed SQL Tuning by gather Auto trace information for oracle session using SQL Trace and interpret Trace file using TKProf utility.
• Provided technical support to Data warehouse and ETL teams by refreshing schemas and refreshing database on regular basis and performed SQL Tuning.
• Participated in rotational on-call support for production databases.
• Performed Database activities using Integrated Development tools like SQL Developer and TOAD.

Confidential, Franklin, TN

Environment: Oracle 11g RAC, Golden Gate, HP-UX, RHEL 5, Windows 2003 Server, OEM Grid Control 11g,ASM, MS SQL Server2000/2005, AWR/ADDM, Shell Scripting, RMAN, Performance Tuning, TOAD

Responsibilities:

• Involved in Implementation and support for Oracle 11g RAC instances in Enterprise Linux Environment.
• Monitored all the jobs which is scheduled on the Oracle Enterprise Manager Gridenvironment and Restarted the Failed database Agents in OEM Grid Environment.
• Installed and Configured MS SQL SERVER 2000/2005/2008 , responsible for taking MS SQL server database Backup and Recovery using LiteSpeed.
• Proficient in refreshing the materialized views using DBMS MVIEW package.
• Involved backup and restore strategies for Oracle Database using RMAN Utility.
• Performed logical backup of the schemas using Datapump (EXPdp, IMPdp) as per requirement.
• Provided support for Oracle Enterprise Manager Grid Control and Agents.
• Involved in monitoring and managing of Oracle instances using Enterprise Manager Grid Control (OEM Grid) and attending the alerts from OMS service.
• Generated and interpreted Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) reports for optimization of oracle Database.
• Raised SR’s and worked with Oracle support resolving bugs & issues.
• Provided the status of the Long running Query to the end users and killed unwanted user sessions per requests.
• Involved in migration of Oracle Database.
• Created Users and implemented Security administration by creating roles, views and granted the necessary system and object privileges for users.
• Handled and performed client requests and internal Service Request for Incident Management (IR), Problem Management and Change Management (RFC).
• Worked on improving performance of SQL statements by gathering table level, schema level, system level and Database level statistics.
• Performed Oracle flashback recovery, flashback query and flashback tables.
• Involved in creation of materialized views from different data sources and refreshed the materialized view using DBMS MVIEW package.

Confidential, Louisville, KY

Environment: Oracle 11g RAC, Data Guard HP-UX, RHEL 5, OEM 11g, ASM, Server2000/2005, AWR/ADDM, Shell Scripting, RMAN, Performance Tuning, TOAD

Responsibilities:

• Installed and Configured Oracle 11g, 10g servers on HP-UX, RHEL 5 and Windows for Large Multi-Terabyte Databases (VLDB).
• Configured and implemented Oracle ASM on UNIX, Linux, and Windows platforms and maintained ASM instances and ASM disk Groups.
• Monitored the production Database growth and increased the table space size by resizing and adding data files.
• Created and Configured Oracle Recovery Catalog for RMAN for production databases.
• Performed CPU and PSU Patching and Upgrade for Oracle Database.
• Implemented flashback technology to restore deleted Database tables.
• Configured Oracle Data Guard by the log shipping process between primary and standby for High Availability.
• Performed Oracle cloning and Refresh Database from Production to Test servers using RMAN utility.
• Performed SQL Tuning by generating EXPLAIN plan, creating indexes, using HINTS and interpret trace files Using TKprof utility.
• Involved in Oracle database performance tuning and troubleshooting using AWR, ADDM reports.
• Monitored the OMS (oracle management server) Alerts from Oracle Enterprise manager Grid control.

Confidential, Tampa, FL

Environment: Oracle 11g RAC, Data Guard HP-UX, RHEL 5, Windows 2003 Server, OEM Grid Control 11g,ASM, MS SQL Server2000/2005, AWR/ADDM, Shell Scripting, RMAN, Performance Tuning, TOAD

Responsibilities:

• Performed general health checks and maintenance for database using AWR and ADDM.
• Implemented and Performed Flashback recovery for flashback tables and flashback query.
• Performed Weekly Data Refresh from Production to Development and Test environments using Database Cloning and Datapump Import and Export utility.
• Provided On call support for production databases on rotational basis.
• Created database links to refresh the database schemas from remote databases.
• Performed Backup and Recovery strategies of large databases.
• Involved in Dropping the partition table after its logical backup is completed based on retention policy of the table.
• Configured Recovery Catalog for multiple Databases.
• Involved in creating and refresh the materialized views.
• Involved in loading data from flat files into the database tables using SQL Loader.
• Configured standby database for database disaster recovery.
• Created Service Request for production issues, Interacted and Worked with Oracle Support.

Confidential, Cleveland, Ohio

Environment: Oracle 11g, HP-UX, RHEL 5, Windows 2003 Server, OEM Grid Control, ASM, MS SQL Server2000/2005, AWR/ADDM, Shell Scripting, RMAN.

Responsibilities:

• Installed, configured and monitored Oracle 10g on HP-UX, Linux, and Windows.
• Involved in monitoring database in Oracle Enterprise manager grid control.
• Performed general health checks and maintenance for database using AWR and ADDM reports.
• Involved in Tuning the SQL statements using Auto trace and TKprof.
• Created and managed partition tables, indexes and rebuilt partition table index for improving performance.
• Implemented Backup and recovery strategies for production Databases.
• Managed Table spaces in the production Databases and added space when needed.
• Performed logical backup using Datapump import and export utility and refresh development database schemas from production database.
• Performed database and system level space management and monitoring.
• Created and managed both system level and object level roles and privileges for various users.
• Managed Database Locks and blocking sessions using OEM and dynamic performance views.

Confidential

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

Environment: Oracle 9i, 10g, RHEL 4, windows 2003,RMAN.

Responsibilities:

• Created and Managed users, roles, schemas, tables, views, indexes and rebuilding Indexes and granted privileges
• Configured Recovery Manager (RMAN) and Performed HOT and COLD Backups for production databases using RMAN.
• Involved in taking logical backup using Data pump Expdp and Impdp Utility.
• Involved in checking the status of listener and restarting listener.
• Revoked unwanted 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.
• Conducted daily routine checks on alert logs and trace files for database errors and taken necessary actions to resolve the issue.