PROFILE:

An Accomplished Oracle DBA with SIX years of diligent experience in Oracle Database Administration in large - scale production environments across multiple platforms. Ability to provide expert-level technical support in all aspects of database administration including Installation and Configuration, Database Security, Golden Gate for Replication, Cloning memory management, performance monitoring and tuning, RAC, Data Guard, Backup & Recovery, Upgrades and Patching, OEM Grid control, Migration, Data Modeling, oracle Stream Linux and Windows OS.

SUMMARY:

• Proficient experience as an IT professional along with extensive experience as an Oracle Analyst.
• Expert in Oracle 13c,12c, 11g R1, 11g R2.
• Experienced in Oracle installations, upgrades, migration, configuring logical/physical architecture, SQL Tuning, database access and Security and auditing.
• Performing Fault Injection Test Case for verifying High availability at each layer of RAC and stack like port failover, instance failover, ASM failover and nodes failover.
• Installation Configuration and Administration of Oracle 13c,12c RAC, 11g RAC and oracle 10g RAC database with Flex Cluster and Flex ASM.
• High ability to analyze and understand the AWR reports and can fine-tune the databases for maximum performance.
• Performed database administration, production support, installation, configuration, upgrades, patches, migration, backup and recovery, performance tuning, and cloning on the above said versions.
• Implement RMAN backup (full, incremental and cumulative) hot/cold backup and recovery, cloning database-using RMAN.
• Strong experience in migrating database from Non-ASM to ASM and Non-RAC to RAC.
• Administered Oracle ASM disk groups (mirroring, compatibility) with Oracle ASM Configuration Assistant (ASMCA).
• Skilled in developing RMAN scripts for database back up including hot and cold backup options for both RAC and standalone instances.
• Performed backups and crash recoveries using conventional hot/cold backups and RMAN
• Performance Tuning of the database through Database Tuning, SQL Tuning utilities like STATPACK, EXPLAIN PLAN, AWR, ADDM, ASH and Tuning of SGA, distribution of disk I/O, Sizing of tables and indexes and dell Fluid Cache/Fusion IO - Tuning Applications, Tuning Instance, and Tuning Disk Usage to improve database performance
• Implemented Data guard in the production environment.
• Excellent experience in various migration techniques like export/import, Data pump, backup restore, cloning, and data guard.
• Proficient in setting up Standby Database supported by ORACLE DATAGUARD for disaster recovery purpose.
• UNIX Systems Administration - Database and application integration efforts. Heavy UNIX shell scripting, CRON jobs.
• SQL PLUS trained
• Knowledge of Installation and configuration of SQL clustered environment with availability groups.
• Installed and configured a SQL 2008 clustered test environment.
• Can configure, support replication and log shipping.
• Ability to document processes for installations, clustering, availability group setup, and patching.
• DB2 trained.
• AWS savvy
• Proficient in complete, incomplete recovery of the database, Point in Time Recovery (PITR).
• Delivered SQL and Database performance tuning services via V$/GV$ views, Explain Plan, AWR (Stats pack) reports, ADDM, SQL Tuning Advisor, SQL Access, Oracle Enterprise Manager (OEM), Grid control.

PROFESSIONAL EXPERIENCE:

Confidential, FLORIDA

Oracle DBA

Responsibilities:

• Applied upgrade patches, maintenance and interim (Opatch) patches on all the databases.
• Refreshing Dev and Test instances with data from Production on a regular basis.
• Migration of database from one server to another server.
• Implemented ASM on RAC and stand-alone databases. Managing disks and disk groups with ASM.
• Done migration of non ASM database to ASM database.
• Used RMAN Duplicate and HOT/COLD backups to migrate the data from 11.1.0.7 to 11.2.0.3.
• Created a standby database by using RMAN Duplicate in order to reduce the down time for the PROD database during the migration process.
• Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups (with Export/Import Data pump utilities).
• Creating & Managing Database Structures, Storage Allocations, Table/Index segments, Rollback segments, Constraints, Database Access, Roles and Privileges.
• Follow up on SRs for different issues (SCAN behavior, Node eviction, Failover etc. )
• Experience in managing alerts, objects, schemas etc
• Performed SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM) and Active Session History (ASH).
• Implemented scripts to monitor and get information on free space, alert log errors provided maintenance of user accounts, privileges, profiles and roles.
• Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).
• Extensive knowledge of SNOW(ServiceNow).
• Database refreshes using expdp, impdp, RMAN Duplicate and cloning.

Environment: Oracle RMAN, Oracle 13c, IBM, AIX, Linux, RAC, ASM, RMAN, AWR, ADDM, SQL* Plus, SQL*Loader, OEM, AIX, AWS, SAP.

Confidential, TORRANCE, CA

Oracle DBA

Responsibilities:

• Involved in Installing, Configuring and Administration of Oracle 10g/11g /12C RAC on ASM.
• Upgraded databases from 11.1.0.7, 11.2.0.2 11.2.03 to 12C
• CRS upgrades from 11.2.0.2 to 11.2.0.3.
• Worked on 2 node and 4 node RAC databases from 200GB - 16TB
• Installed 10g /11g binaries on HP-UX and Linux servers and configured new production databases for the same.
• Installation of agent 11g and OEM Grid control 11g.
• Proficient in writing UNIX Shell scripts to automate business process and daily backups.
• Involved in capacity and resource planning.
• Experience using 11g and 12c Golden Gate, Director, including upgrading, setup and support in QA and production ODS.
• Ensured that ODS was always in sync with sources by using custom scripts, EM12c monitoring, and Golden gate director notifications.
• Performed SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM) and Active Session History (ASH).
• Responsible for setup and implementation of 2 Node RAC on Linux in 10g and 11g R2.
• Responsible for configuring data guard physical and standby database setup for high availability and handling synchronization issues between primary and standby.
• Worked closely with the Oracle developers for the better performance in Applications in writing the Packages, Triggers and Indexes on the tables.
• Used Secure SCP & FTP extensively for the File transfers from machines to remote server.
• Cloning & duplicating databases using scripts as well as RMAN for test and developments instances.
• SQL tuning and Database performance tuning done based on reports generated by SQL Trace, TKPROF, STATSPACK, Explain Plan, AWR , ADDM and monitor the database performance on daily basis.
• Oracle, Oracle E-Business Suite (EBS), Linux RedHat, and AWS (or Vsphere, Hyper-V, Azure)

Environment: Oracle RMAN, Oracle 11g (11.2.0.2), DBMS STATS, Data pump, SQL TRACE, EXPLAIN PLAN

Confidential, Phoenix, AZ

Oracle Database Administrator

Responsibilities:

• Successfully installed and configured Oracle 12C, 11.1.0.7, Oracle 10.2.0.5 databases on AIX platforms.
• Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 10g Grid Control.
• Loading data from flat files to database using SQL*Loader, External Tables.
• Automated the processes like moving files, managing alert log, efficient backup by developing UNIX scripts.
• Extensively used AWR, ADDM and explain plan for periodic performance tuning.
• Implementing Data pump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance.
• Used import/export utilities for cloning/migration of small sized databases and Data pump import/export to move data between 10g/11g environments.
• Databases migrated to RAC for improved resiliency and performance.
• Security User Management, Privileges, Role, Auditing, Profiling, Authentication.
• Knowledge in Golden Gate installation & Configuration setups in both windows/Linux environments.
• Performed Database upgrade from Oracle 9i (9.2.0.7) to Oracle 10g (10.2.0.5) and to Oracle 11g (11.1.0.7) RAC database.
• Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.
• Involved in the installation, configuration and extended support to Oracle 11g, 10g two Node RAC (Real Application Cluster) with ASM file system on AIX platform.
• Installed ASM environment and migrated databases from NON-ASM to ASM.
• Used TOAD for database management.
• Performed SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM) and Active Session History (ASH).
• Worked closely with the Oracle developers for the better performance in Applications in writing the Packages, Triggers and Indexes on the tables.
• Used RMAN Duplicate and HOT/COLD backups to migrate the data from 11.1.0.7 to 1/ 1.2.0.3. Oracle, Oracle E-Business Suite (EBS), Linux RedHat, and AWS (or Vsphere, Hyper-V, Azure)

Environment: Oracle 11.1.0.7, 10.2.0.5, IBM AIX V6.1, Linux, RAC, ASM, RMAN, AWR, ADDM, SQL* Plus, SQL*Loader, OEM, TOAD 10.0.