SUMMARY

• Databases: Oracle Database 10g, 11g, 12c
• Prepare and communicate reports using tools like SQL, Microsoft Outlook, Microsoft Office, etc.
• Real Application Cluster.
• Familiarity with SQL Server.
• Experience in creating single instance oracle database, configuration, and administration.
• Experience in Grid Infrastructure and ASM installation, configuration, and administration.
• Experience in Data Guard installation, configuration, and administration.
• Creation of database Documentation.
• Use database tools such as STATSPACK, EXPLAIN PLAN, SQL TRACE, AWR and ADDM to evaluate database performance, gather statistics, resolve performance related issues, and generate report.
• Experience in backup and recovery, and validated database backups using RMAN utility.
• Capacity Planning.
• Use expdp/impdp tool to perform import and export of data.
• Advanced analytical, problem solving and research skills.
• Ability to handle multiple projects simultaneously while working under pressure.
• Experience in providing 24X7 production and development support for Oracle databases 10g and 11g on a variety of platforms.

TECHNICAL SKILLS

• Oracle Database 10gR1 & R2/11gR1
• Windows 7/2000/2003/2008/2012/ NT/XP
• UNIX
• Linux (Redhat
• Ubuntu
• Centos)
• SQL - Loader
• SQL Developer
• Oracle EM
• Oracle Recovery Manager (RMAN)
• VMware EXSI Hypervisor
• RAC
• ASM
• Data Guard
• SQL*Plus
• SQL
• PL/SQL
• Shell Scripting
• SQL Trace
• Explain Plan
• Statspack
• AWR
• ADDM
• Oracle Data pump (expdp/impdp) iSCSI
• NAS
• Toad
• Spotlight.

PROFESSIONAL EXPERIENCE

Oracle Database Administrator

Confidential, Harrisburg, Pennsylvania

Responsibilities:

• Successfully installation of Oracle Database 12c in a recent project.
• Successfully created 3 nodes RAC database to 3 nodes RAC Physical Standby database for high availability and disaster recovery.
• Upgraded from Oracle 11.2.0.5 to 11.2.0.7 in a recent project.
• Monitored different databases and application servers using Toad and Oracle Enterprise Manager (OEM) 10g Grid Control,
• Performed Database upgrade from Oracle 10g (10.2.0.5) and Oracle 11g (11.2.0.3).
• Performed full & incremental backup (cumulative and differential) using RMAN and implemented recovery strategies.
• Automated the processes like moving files, managing alert log, efficient backup by developing UNIX scripts.
• Installed ASM environment and migrated databases from NON-ASM to ASM.
• Achieved optimized performance for the databases by rebuilding indexes, implementing portioning methodologies (Range partitioning, List partitioning, Hash partitioning, Composite partitioning) on tables and indexes.
• Successfully applied RDBMS patches, security patches for improving the security and functionality of the databases.
• Extensively utilized AWR, ADDM and explain plan for periodic performance tuning.
• Implemented Flashback technology of the Oracle 11g, 10g along with Recycle bin for a faster recovery of the databases and database objects.
• Loaded data from flat files to database using SQL*Loader, External Tables.
• Refreshed/cloned databases using RMAN utility.
• Successfully installed and configured Oracle 11g database.
• Utilized import/export utilities for cloning/migration of small sized databases and Datapump import/export to move data between 10g and 11g environments.
• Provided production support database on 10g and 11g versions with standalone and RAC environment.

Oracle Database Administrator

Confidential, Flemington, New Jersey

Responsibilities:

• Successfully installed/maintained Physical Standby database using Oracle Data Guard for Oracle11.2.0.3 and Oracle 11.2.0.5 RAC databases.
• Migrated databases from oracle 10g to oracle 11g on Linux on development, integration and production environment.
• Implemented switchovers on primary and standby databases as a part of planned maintenance activities.
• Tested and implemented different physical and logical Backup and Recovery methods like point in time, Media recovery, full/partial export/import.
• Performed user management, creation, monitoring and management of database users, altering passwords of users and granting and revoking system/object privileges, roles, auditing user actions in the database.
• Monitored and configured Oracle 10g databases using OEM
• Maintained Oracle 11gR2 Real Application Cluster (RAC) Database for High Availability, Scalability and Performance by determining the best Cluster architecture, choosing the best hardware configuration for Oracle RAC.
• Created and managed user, table spaces, data files and archive log.
• Performance Tuned and optimized SQL Query, SGA, and Disk I/O using Oracle Enterprise Manager and by monitoring the Stats pack report generated from snapshots.
• Applied client patches and other patches as required.
• Troubleshot Database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM). Tuned database for optimum performance.
• Utilized Oracle Public and Private Database Link.
• Managed auditing and security with Oracle databases.

Oracle Database Administrator

Confidential

Responsibilities:

• Install and configure Oracle 8i database.
• Creating users, granting privileges and roles, unlocking and locking accounts.
• Creating table and defining data type as well as space requirement.
• Managed and resolved database design issues during development stage.
• Implemented disaster recovery.
• Perform import and export.
• Handled database server tuning, application tuning, maintaining documentation, capacity planning, and database security.
• Gathering statistics such as execution time, response time, CPU usage, memory usage, etc.
• Support database and application on a daily basis.
• Diagnoses database issues, application issues, and monitoring, and performing regular database health check.