OVJECTIVE:

• Highly energetic with Over 10 years of hands - on experience as an Oracle Database Administrator
• I have worked on Oracle 12c, 11g, and 10g versions involving database administration, production support, installation, configuration, upgrades, patches, migration, backup and recovery, performance tuning, cloning, space management and security.

PROFESSIONAL SUMMARY:

• Providing supports on production/non production database environment.
• Hands on experience on Oracle installed and configured Oracle databases on different platforms like Windows, UNIX (RHEL 4/5, OEL 5/ 6, Solaris 10, HP-UX)
• Hands on experience on Oracle EBS 12R
• Worked on Different operating systems for OLTP & OLAP environment Experience in configuring high availability systems like Real Application Cluster. 24*7 on-call production database support and maintained remotely and worked on databases.
• Having good experience in 12c database administration, installed 12c database and configured 12C Grid Control.
• Having experience in monitoring and managing of Oracle instances using Enterprise Manager Grid Control (OEM grid).
• Expertise in migrating production databases single instance to RAC environment.
• Planned and Implemented Disaster Recovery (DR) and HA using RAC, Data Guard.
• Experience in configuring, managing and monitoring both Physical standby and Logical standby database Using Data Guard and have hands on experience on Active Data-guard.
• Installed, Configured and replicated databases using Oracle Golden Gate.
• Having good experience in migrating databases with zero downtime.
• Generate and interpret Automatic Workload Repository (AWR), Active Session History (ASH), and Automatic Database Diagnostic Monitor (ADDM) reports Configured Targets and used OEM to do the daily tasks regarding the performance, maintenance.
• Experience in implementing and planning backup and recovery strategies using Recovery Manager (RMAN).
• Performed block recovery, data files and databases using RMAN.
• Created clone databases for development and test environments using RMAN and User managed cloning and Implementation of Flashback Technology.
• Installed patches using Opatch utility.
• Experience on Remedy ticketing system.
• Experience on Oracle monitoring tools including Oracle Application Server monitoring and Oracle Linux monitoring using NMON and TOP commands.
• Implemented data transfer using Transportable Table Spaces (TTS), Data Pumps and Export/Import utilities.
• Enforced Security administration, system monitoring by adding and removing users, configuring quotas, auditing, and analyzing security problems.
• Experience in SQL tuning using Explain Plans and Hints, Performance Tuning for better performance and Monitoring and optimizing the performance of the database through database tuning - Tuning applications, Tuning Instance, and Tuning Disk Usage.
• Performed various Transparent Data Encryption Operations and having good knowledge in Transparent Data Encryption Key Architecture. Work closely with AWS RDS, Aurora and Redshift teams to help ensure the success of project consulting engagements with customer and migration to a multitenancy model.
• Good knowledge on Oracle support process for technical requests using Metal link and other support features.
• Good written and verbal communication skills, self-motivated team player and good analytical thinking.

PROFESSIONAL EXPERIENCES:

Sr. Oracle DBA

Confidential, Los Angeles, CA

Responsibilities:

• Maintained 3 Node Oracle RAC 11gR2 on HP-UX 11.31 using ASM as storage.
• Upgrade of database from 11.2.0.2 to 11.2.0.4 using Transient Logical Standby and minimum downtime.
• Installation RAC on Oracle SuperClusters with Exadata Storage.
• Migration of 12C and 11g Oracle database to Exadata.
• Experience in database management and performance tuning on Exadata.
• Migration of 11gR2 database (HP-UX itanium) to 12c (Solaris) on Oracle SuperCluster.
• Implementing High Availability Oracle GoldenGate (OGG) from front-end OLTP environments to back-end Data Warehouse (ODS) systems on Oracle 11gR2 RAC environments.
• Experience in Remedy ticketing system.
• Troubleshooting typical OGG technical problems such as unique key violation / long transaction abending by using GGSCI / Logdump / discard file analysis etc.
• Performance Tuning OGG in high data volume environments. Installing and configuring OGG heterogeneous environments (from Oracle to MS SQL Server).
• Configured and maintained Data Guard 11GR2.
• Created 12c container and pluggable databases
• Ongoing performance tuning and monitoring of database using tools like Explain plan, TKPROF,
• STATSPACK, AWR, ADDM Reports, OUTLINES, SQL PROFILE, SQL BASELINES, OS utilities like sar, iostat, vmstat, top, ps, find, glance etc.
• Working experience in Oracle EBS 12R.
• Working experience with CHEF development kit.
• Designed architecture for ASM diskgroup for failure scenarios.
• Developed automation utilities for DBA Usage.
• Wrote many automation UNIX shell scripts for database refresh, monitoring, consolidated report, reconfigure data guard, switchover/switchback of database etc
• Designed and Configured Database Service architecture, TNS entries, connection settings etc
• Monitoring and optimizing the performance of the database through Database Tuning, Application Tuning and Tuning Disk Usage.
• Designed RMAN backups to be executed from Standby databases.
• Working with Oracle Support for bug fixing/confirmation through Metalink/SR’s
• Implement and maintain database security using password profiles
• Documentation of Projects
• Collaborate with hadoop admin team to maintain a hadoop cluster, configure hadoop group mapping for LDAP/AD using SSSD.
• Hand on experience on SQL server 2012 and 2014.

Environment: Oracle 10gR2/11gR2/12c, Oracle 3 node RAC, ASM, Data Guard, Golden Gate, BCV, Oracle APEX, Enterprise Manager Grid Control, RMAN, SQL, PL/SQL, Toad, UNIX Shell Scripts, SQL server 2012, 2014, HP-UX etc.

Sr. Oracle DBA

Confidential, Kingsport, TN

Responsibilities:

• Performance tuning at database and sql query level.
• Testing and certify prod changes in all the lower envs.
• Currently working on a big database split where client need to separate out data for two different countries by creating new db and keeping it in sync via dataguard configuration
• Acting as L3 level of dba support.
• Worked on many performance issues like sudden sql plan change due to different reasons like Bad
• Histograms, Bind variables, functional indexes etc.
• Support migration of data from stand alone db to one centeral db.
• Proactive monitoring of production databases to find out potential issues that can cause high severity issues and outages.
• Support in new db designs and structures and fixing the design issues.
• Performed COB test twice a year as per client requirement.
• Support, Maintenance, Installed and configured 2 node server side load balancing Oracle RAC 10g, 11g databases on Linux with ASM and Data Guard.
• Work directly with development and testing teams to perform load tests before every release.
• Production support database on 9i, 10g and 11g versions with standalone and RAC environment.
• Creation and configuration of Oracle database of various sizes 200GB, 400 GB, 2TB and 6TB in Dev, test, Prod Model and Production environments.
• Upgraded databases from 9i to 10g, 11g and 10g to different 10g versions.
• Migrated databases from oracle 10g on Solaris 10 to oracle 11g on Linux on development, integration and production environment
• Migration of databases using various ways like building a COB and import/export.
• Implemented Golden gate to replicate data and keeping databases in sync until the time of cutover.
• Implemented classic Golden gate replication as well as integrated replication.
• Work directly with SAP/application teams to better understand application database relationship.
• Used golden gate to migrate very large database (15TB).
• Schedule jobs in crontab including RMAN backup and other memory maintenance, security jobs.
• Tested and Implemented different physical and logical Backup and Recovery methods like point in time, Media recovery, Full/partial export/import.
• Perform 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.
• Creating and Managing stored procedures and triggers, distributed data, server tuning, automation of administrative tasks, database.
• Worked on Auditing and security with Oracle databases.
• Working knowledge of DATAWAREHOUSING tools like ETL Abinitio.
• Created standby database and worked with data guard to provide high availability.
• Monitor and Configured Oracle 10g databases using OEM.
• Worked with Flash Recovery Area.
• 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 taken at the peak business hours.
• Experience on Remedy ticketing system.
• Worked on Clone the databases.
• Worked on oracle Public and Private Database Link.
• Applied PSU patching for db and Grid infrastructure as required.

Environment: Oracle 10G, Oracle 11G, Solaris 10, RMAN, SQL, PL-SQL.

Oracle DBA/Developer

Confidential, Oklahoma City

Responsibilities:

• Configure. Implement & Deploy Oracle 10g (9.2.0.8) & Oracle 11g (10.2.0.4), single instances on SunOS 5.9 using files systems for storage & VERITAS Clustering for high availability using IBM's HACMP.
• Create oracle databases (single instance) on configured servers using both the DBCA & Database creation scripts including database architecture and table design.
• Develop PL/SQL package.
• Design and Implement Database procedures and complex queries to retrieve data for different needs of the organization.
• Write and code logical and physical database descriptions and specify identifiers of database to management system or direct others in coding descriptions.
• Monitor database systems and provide technical support for database system issues and application performance enhancement/improvement using both Oracle 11g Grid Control & SQL*Plus, as well as UNIX shell scripts.
• Worked closely with Application Developers to design/create new Oracle databases/create new schemas/database objects, as well as making database changes from DEV to PROD, via TST following requests/demands from the development team.
• Backup/Recovery of Oracle 10g/11g databases using Oracle RMAN.

Environment: Oracle 10.2.0.1, Oracle 10g (9.2.0.8), RMAN, Data Pump, SQL TRACE, TKPROF, EXPLAIN PLAN.