SUMMARY

• 7+ years of experience in Oracle database Administration.
• Experience in Installation, Configuration and Monitoring of Oracle Server on UNIX, Linux and Windows Environments.
• Experience in Work with Oracle 11g, 10g and 9i.
• Experience in Installation of Oracle Real Application Cluster (RAC) with ASM and manage RAC instances using CRSCTL and SRVCTL Utility on HP - UX.
• 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.
• Configured Oracle Data Guard by the log shipping process between primary and standby.
• 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 & 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 Database Patching for 9i, 10G and 11g.
• Experience in SQL tuning using Explain Plans and Hints.
• Experience in Tuning the Oracle Database for better performance.
• Configured multiple database instances using a single ASM instance.
• Having Experience in MS SQL Server database Administration.
• Generate and interpret Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) reports.
• Experience in performing database related activities using Oracle Enterprise Manager Grid (OEM Grid).
• Experience in Unix Shell Scripting
• On-Call 24x7 DBA support for production databases.

TECHNICAL SKILLS

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

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

Operating System: RHEL 4, RHEL 5, OEL 4, WIN NT/2003, Solaris 10, Windows XP

Professional, Windows 2003 Professional.:

Languages: SQL, PL/SQL, UNIX Shell Scripting

Other Tools: TOAD, Putty.

PROFESSIONAL EXPERIENCE

Confidential, Denver, CO

Oracle Database Administrator

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

Responsibilities:

• Installing, Configuring, Monitoring, and Troubleshooting Oracle RAC 11.1.0.6.0 databases on ASM instance.
• Administration of RAC instances using CRSCTL and SRVCTL Utility.
• Re scheduling Failed jobs on Oracle 11g Grid and find the resign for the failure.
• Monitor the OMS (oracle management server) Alerts.
• Taking the logical backup of the partition tables by using Expdp (datapump) utility on the basis of retention policy of the tables.
• Drop the partition table after when its logical backup is completed, based on retention policy of the table.
• Setup standby database via Data Guard for database disaster recovery.
• Create the partition tables based on requirement.
• Rebuild partition table index for better performance.
• Managing Tablespaces in the production databases and adding space when needed.
• Export and Import theschema.
• Granting roles and privileges to end users according to the Incident Request.
• Configuring, monitoring and managing entire oracle database instances with OEM grid control.
• Creating the Roles and assigning Privileges.
• Tuning SQL Query using HINTS, EXPLAIN PLAN.
• Monitoring ALERT Log files to keep tracking the Oracle Errors and make necessary actions to rectify them.
• Restarting the Failed database Agents in OEM Grid Environment.
• Administration of ASM instances and ASM disk Groups.
• Installation and configuration of Recovery Catalog for RMAN Backup.
• Managing Database Locks and blocking sessions.

Confidential, Franklin, TN

Oracle Database Administrator

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:

• Implementation and support for Oracle 11g RAC instances in Enterprise Linux Environment.
• Handled and performed clients and internal Service Request for Incident Management (IR), Problem Management and Change Management (RFC).
• Data refresh from Production to Test and Development environments using RMAN duplicate database.
• Responsible for taking MS SQL server database Backup and Recovery using LiteSpeed.
• Creating and Configuring Catalog database
• Installed and Configured MS SQL SERVER 2000.
• Taking logical Backup of the schemas (EXPDp, IMPDp) as per requirement.
• Hands on experience in setting up Oracle Enterprise Manager grid control to manage the databases through a centralized control and installing OEM agents on the required hosts
• Maintaining the Oracle 10g grid, attending the alerts from OMS service.
• Taking the backup of oracle databases
• Monitor all the jobs which is scheduled on the Oracle Gridenvironment.
• User creation and implemented Security administration by creating roles, views and granting the necessary system and object privileges for users.
• Report with the status of the Long running Query to the end user and kill unwanted user session on request.
• Create partition Table as per database requirement.

Confidential, Louisville, KY

Oracle Database Administrator

Environment: Oracle 11g, 10g, Oracle RAC, ASM, OEM, UNIX, Linux, windows

Responsibilities:

• Created database links to access data from remote databases
• Monitoring Multiple Instances by using OEM (Oracle Enterprise Manager) Grid Control
• Performed Weekly Data Refresh from Production to Development and Test environments using Database Cloning.
• Backup of Oracle cluster Registry (OCR) and Voting Disk (VD).
• Setup standby database for database disaster recovery.
• Collecting database performance information from Dynamic Performance Views.
• Responsible for network configuration and involved in a Client - Server environment using TNS, LISTNER, Net Configuration Assistant and other configuration files.
• Interacted and Worked with Oracle Support (SR) whenever we faced production issues
• Identified and fixed the logical block corruption using RMAN.
• Handling service requests within SLA
• Refresh/Cloning of Database from production environment to test environment using RMAN Duplicate database.
• Finding Tables which are fragmented & reorganization Creating indexes for avoiding full table scans.
• Involved in logical (EXPdp, IMPdp) backup.
• Monitoring RMAN Backup job in Oracle Enterprise Manager Grid control
• Taking Logical INCREMENTAL, CUMULATIVE and FULL Backups by using RMAN.
• Finding long running requests and sessions terminate them if needed.
• Creating and maintaining Backup Scripts.
• Worked on SR’s and have experience in collaborating with Oracle support for bugs & issues.
• Experience in Performance tuning using various aspects of the database utilities like Explain Plan, and Stats pack/AWR/ADDM.

Confidential, Tampa, FL

Oracle Database Administrator

Environment: Oracle 10g, 9i, RHEL 5.4, Sun Solaris, Windows, Linux, UNIX, SUN Solaris, SQLPL/SQL, TOAD, OEM, RMAN, RAC, Shell Script.

Responsibilities:

• Installation, Maintenance and administration of Oracle 10g on UNIX, Linux, Windows.
• Responsible for Data load on different databases using SQL*Loader.
• Monitoring the Database growth and increase the tablespace size in Production database.
• Monitor the Backup jobs scheduled in OEM Grid.
• Involved in Backup and Recovery using RMAN.
• Monitoring ALERT logs and TRACE files.
• In order to protect data in the Production Database, implemented Standby Database and Synchronization of Standby Database with the primary database
• Administration of RAC instances using CRSCTL and SRVCTL utility.
• Daily incremental backup and weekly full backup of databases using RMAN utility.
• Designed Backup and Recovery strategies using RMAN both on standalone and cluster environments.
• Setup of Jobs using the OEM Grid and Re-run the Failed backup job.
• Used EXPLAIN PLAN for query tuning, analyze the plan and recommended useful oracle hints which have improved the performance of the SQL queries.
• Responsible for production, UAT and DEV database maintenance which includes the DB growth projections and optimal/robust DB configurations.
• Creating databases with ASM
• Rebuilding indexes which are fragmented.
• Monitoring the database daily activities through the Grid.
• Experience in Real Application Cluster (RAC) Setup & Administration.

Confidential, Cleveland, Ohio

Oracle Database Administrator

Environment: Oracle 9i, 10g, Oracle RAC, ASM, OEM, UNIX, Linux, windows

Responsibilities:

• Installation and configuration of Oracle Server 11g RAC with ASM.
• Scheduling Backup using Oracle Enterprise Manager Grid control.
• Generating AWR reports and ADDM reports
• Identified the long running transaction through V$session longops.
• Managing TableSpaces and increase the size of the data files whenever needed in the production database.
• Setup of Cold Backup of test/development databases through RMAN for weekly maintenance.
• Scheduled and monitored OEM job scripts for exports, hot backup, analyze schema.
• Taking Logical Backup as per requirements using Data pump Export and Import (IMPdp/EXPdp) utilities.
• Implementation of Oracle Backup and Recovery strategies using RMAN.
• Involved in configuring and maintaining Real Application Clusters (RAC) on 2 nodes for high scalability and availability.
• Interpreting & Finding problems from AWR, ASH & ADDM reports when database is performing poor.
• Setup of Jobs using the Oracle Enterprise Manager (OEM) database control.
• Collecting database performance information from Dynamic Performance Views.
• Creating and rebuilding the indexes to rectify segment fragmentation.
• Experience in working with large database environments.
• Performed database and system level space management and monitoring.
• Experience in Performance Tuning (SQL tuning), ASM, AWR and flashback.

Confidential

Oracle Database Administrator

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

Responsibilities:

• PL/SQL programming, writing Packages, Procedures, Functions and Triggers.
• Loading data into database tables using SQL *Loader.
• Conducted daily routine checks on alert logs and trace files.
• Used SQL loader to load data from CSV files into Oracle tables.
• Experience in Flashback recovery
• Monthly refresh of the development and test environment
• Installation of Oracle 11g, 10g, 9i server on UNIX, Linux, and Windows Operating System.
• DB Installation, configuration and upgrading of Oracle software.
• File System Maintenance
• Providing Technical Support to Developers.
• Multiplex and maintenance of control files, redo log files and data files.
• Implemented flashback technology to restore deleted tables.
• Configuration of Automatic Storage Management (ASM) on Unix, Linux and windows OS.
• Experience on RAC installation and configuring a 2 node cluster.
• Troubleshooting database issues like long running sessions, locks along with backup and recovery.
• Experience in Upgrading the databases using Database Upgrade Assistance (DBUA)

Confidential

Oracle Database Administrator.

Environment: Oracle 9i, 10g, Oracle RAC, ASM, OEM, UNIX, Linux, windows

Responsibilities:

• Multiplexing of control files and redo-logs for disaster recovery scenario.
• Provided On call and L1/L2 support in the database area for development, test and production databases.
• Implemented Materialized views, database links.
• Check Alert Log errors and make necessary actions to rectify them.
• Rebuilding INDEXES, ANALYZING and COMPUTING STATISCS.
• Installing and Configuring Oracle Enterprise Editions 8i/9i/10g/11g on UNIX, Linux and Windows Operating Systems.
• Created and managed both system level and object level roles and privileges for various users.
• Performed day-to-day activities such as creating users, roles, schemas, tables, views, indexes and rebuilding Indexes and running scripts given by the clients.
• Creating and managing database objects like tablespaces, tables, indexes, views, synonyms, materialized views
• Configuring Recovery Manager (RMAN).
• Performing HOT and COLD Backups and logical Backup using Expdb and Impdb.
• Monitoring ALERT logs and TRACE files
• Created and configured database manually & using Oracle Database Configuration Assistant.
• Conducted daily routine checks on alert logs and trace files.
• Auditing against requirements for the User activities.
• Creating & Managing users, roles, granting privileges and Managing Indexes
• Monitoring Database alert log for database errors.
• Killing sessions and revoking user privileges and roles as per requirement.
• Installing clients and making SQL * Net connectivity for Production.
• Taking full and incremental Backup Using RMAN Utility
• Space management, adding space to Tablespace as per requirement