SUMMARY

• An accomplished Professional Oracle Database Administrator with over 6years of experience in Oracle database administration in heterogeneous system environment including Solaris, UNIX, Linux and Windows.
• Excellent experience in Installation and configuration of Oracle 12c,11g, 10g, 9i, in UNIX/LINUX, Sun Solaris and Windows environment.
• Upgraded Databases from to 10g, 10g to 11g and 11g to 12c on various platforms.
• Transparent Data Encryption, Oracle Wallet, Password complexity to ensure Database Security.
• Performance Tuning of the database (Memory Allocation Tuning, I/O Tuning, Tuning Contentions) using oracle 11g tools like AWR, ADDM, Advisories, TKPROF, SQL TRACE, EXPLAIN PLAN for the better performance.
• Implemented user/Application authentication and Database Backup protection using Oracle TDE.
• Experience in taking Full and partial backups, Incremental (both differential and Cumulative) backups using RMAN (Recovery Manager).
• Comfortable in full SDLC including Production, Application and Project Support.
• Established standby/cloned production database via Data Guard for Database Disaster Recovery.
• Experience in maintaining Data Guard for disaster recovery by implementing physical standby database and snapshot standby and worked with Oracle 11g features, 11g Grid Control.
• Monitoring performance using OEM and Customized Scripts.
• Worked on 24/7 environments, responsible for monitoring, upgrading, configuring, managing and troubleshooting over 300 oracle 10g and 11g databases with various sizes.
• Patching/Upgrading databases using DBUA, data pump Export/Import, Transportable Tablespaces and manually using upgrade scripts.

TECHNICAL SKILLS

• DBCA, DBUA, Recovery Manager (RMAN), Oracle Enterprise Manager (OEM), OEM Grid Control, Oracle Data Guard, Oracle Management Service (OMS), Real Application Clusters (RAC), ASM, Data Pump (expdp, impdp),SRVCTL,SQL*Plus
• SQL TRACE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM • WEB TOOLS: HTML, XML

PROFESSIONAL EXPERIENCE

Oracle DBA

Confidential - Richmond, VA

Environment: RHEL 5.X, 6.X; Windows NT 2000/2003; Oracle 10g, 11g, 12c

Responsibilities:

• Primary DBA for 100+ databases of Oracle 10g/11gR2 on Linux REHL, HP-UX. Worked as per ITSM/Remedy Incident ticket/Critical Response Time (CRT) call.
• Data guard - configure primary -standby using duplicate from active database command of 11g. Apply SCN-based Incremental backup to sync standby after loss of Archive logs on primary. Measure data loss based on latency/lag. Cross­platform migration using Data guard.
• RAC installation and administration/Trouble-shooting of 3 Node cluster on Oracle 10g, 11G R2 and 12C. Configuring Grid Infrastructure SCAN Listeners on 11gR2. Migrate OCR files to ASM. Trouble-shoot Resource related issues. Cluster-wide Resource management such as create resource plan, Service configuration, parallel instance group, Application Isolation. Stress testing, benchmarking of clustered database.
• Managed Container and pluggable databases.
• Designed daily, weekly Backup and Recovery procedures for production, non­production databases using RMAN backups taking periodic Complete, cumulative and differential Incremental Backups.
• Intensively used latest 10g/11g Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitoring (ADDM) reports for the health check of the databases, and used the notification tool to send the alerts in OEM Grid Control.
• Data Refresh/Cloning from Production environment to set up QAT/ DEV using RMAN Duplicate
• Implemented Point in time recovery using RMAN.
• Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 12c Grid Control
• Implemented user/Application authentication and Database Backup protection using Oracle TDE.

Oracle DBA

Confidential — Richmond, VA

Environment: RHEL 5.X; Windows NT 2000/2003; Oracle 10g, 11g

Responsibilities:

• Installed, configured, and maintained Oracle 10g and 11 g R2 on Linux and also Upgraded from Oracle 10g to 11g.
• Extensive working knowledge of Oracle Advanced Security in implementation of data in-transit and data at rest encryption for Oracle 11g/12c databases (TDE).
• Collecting performance statistics using Statspack /AWR (Automatic Workload Repository) and analyzing by ADDM (Automatic Database Diagnostic Monitor)
• Refresh/Cloning of Database from production environment to test environment and application of patches.
• Setup data guard, create physical-standby database using hot backup. Troubleshoot errors on standby. Manually register archive logs.
• Setup & test backup on databases. Writing RMAN scripts embedded in shell scripts. Recover full database by applying archive and redo logs. Duplicate database by RMAN on remote host. Optimize backup on RAC.
• Experienced of managing and administering 24 X 7 running databases and support.
• Responsible for Creating Users, Groups, Roles, Profiles and assigning the users to groups and grant necessary privileges to the relevant groups.
• Cloned/Migrated databases using RMAN and traditional Datapump export/import utilities in Oracle 10gR2
• Constantly monitor the performance (V$ dynamic performance views at peak load) of the Databases and viewing Alert log files & Trace files.

Oracle DBA

Confidential — Harrisburg, PA

Environment: SQL server; Oracle 9i, 10g, 11g

Responsibilities:

• Performed Upgrades on databases from Oracle 9i to Oracle 10g.
• Expertise in Performing Tuning Database - Tuning involved I/O, Memory, CPU utilization, SQL Tuning, SGA tuning, Shared Pool tuning, Buffers and Disk I/O tuning using Oracle's regular performance tuning tools like Explain Plan, STATSPACK, SQL1 2Trace, AWR, ADDM, ASH, SQL tuning advisor etc. Done resetting of storage parameters by series of exports and imports of tables, used conventional as well as direct path loads to upload the data into the server using SQL loader.
• Creating the users and assigning them the required privileges.
• Provided 24/7 on-call support as needed