SUMMARY

• Around 8 years of experience as an Oracle Database Administrator and performed different tasks like database administration, installation, configuration, upgrades, migrating, patches, performance tuning, backup and recovery, cloning, space management, database security etc. in production as well as development databases on different platforms.
• Excelling experience in Installation, Setup and configuration of Oracle 10g, 11g, 12c and 19c in UNIX/LINUX.
• Experience in Installing, configuring and administering Oracle multiple node RAC clustered databases on ASM.
• Experience in Data Migration using Data pump utility.
• Good Knowledge and hands on experience on Oracle Golden Gate installation, configuration, troubleshooting GG issues.
• Proficient in Database administration activities such as user management, space management, monitoring, Creating Database, Managing Oracle Instance and Database security and Materialized Views.
• Experience in UNIX shell programming.
• Hand on experience working on oracle data and key vault, VPD, TDE.
• Hands on experience working on High Availability Environments.
• Goal Oriented, Good Co - ordination and Co-operation wif teh Team and Management. Adept at learning and adaptable to complex work environment

PROFESSIONAL EXPERIENCE

Confidential

Database Administrator

Responsibilities:

• Provided 24X7 support for all teh production and development databases.
• Installed and configured Oracle 12c.
• Upgraded oracle databases from 19c to 12c.
• Other duties include applying oracle database patches, design and creation of databases as per user requirement, creation of database users, monitoring, tuning, troubleshooting, backup and recoveries.
• Completely eliminated space errors by implementing proactive space monitoring and TEMPeffective space allocation.
• Cloned/RefreshedOracle Databases from prod to dev and testing.
• Responsible for optimizing teh queries and application tuning.
• Perform SQL tuning and assist developers wif coding PL/SQL.
• Provided support to Application Database Administrators in designing teh database.
• Installed and Implemented Backup & Recovery procedures.
• Implement Hot, Cold and Logical backup plans.
• Implement "Stored Procedures and Triggers" based on business plans using PL/SQL.
• Automation of data load using Korn shell scripting andSQL*Loader.
• Responsible for setting and managinguser accounts, Granting required privileges to users.
• Defining and Implementation of backup and recovery strategies.
• Perform other regular DBA activities including space management and performance monitoring.
• Loaded data using EXTRACT and REPLICAT process in Oracle Golden Gate tool.
• Setting up Golden Gate replication to heterogeneous environments for OS and Databases.
• Maintained database security by implementing Data vault, oracle Key vault and VPD.
• Involved in process improvement, Oracle Server Installations/Upgrades/Patches, Space Management, Capacity Planning, Backup & Recovery, Disaster Recovery, Database Performance Tuning, Memory Tuning, Application Tuning, Security Administration, Data Warehousing, Data Guard, Oracle Advanced Replication, Real Application Clusters, Oracle Standby Servers.

Confidential, Irvine, CA

Database Administrator

Responsibilities:

• Upgrading oracle two node RAC and standalone databases from 8i to 12.2.
• Upgrading and migrating oracle 8i and 9i standalone databases to 12.2 through INPLACE and oracle transportable table spaces.
• Upgraded oracle databases of sizes 5TB to 40 TB through storage/disk swing approach.
• Converted raw data files to cooked data files and upgraded to 12.2.
• Upgraded databases of version 8.1.7.4, 9.2.0.4/9.2.0.8 , 10G and 11g to 12.2 through multiple approaches like INPLACE upgrade through DBUA and manual scripts, oracle transportable table spaces and storage swing.
• Worked on Oracle TRANSPORATBLE TABLESPACE for migration databases.
• Configured and troubleshooting of oracle ACL in oracle 11g and 12.2 databases.
• Resolved issues related to oracle XML database components.
• Performed Database refreshes using hot backup mode and RMAN backups.
• Worked wif oracle support in resolving teh block header corruption during teh database upgrade.
• Creating new RMAN 12c catalog databases, registering teh databases and creating teh RMAN backup scripts.
• Migrating teh 10G and 11G RMAN catalog databases and upgrading teh RMAN catalogs.
• Created and resolved teh issues related to database links from lower versions to oracle 12c.
• Restore and recovering teh databases from RMAN backups.
• Managed teh Very Large table spaces and tables in 50 TB size of Database.
• Identified bugs and applied required patches like CPU, PSU Patches as per teh oracle recommendations.
• Performed daily database administration tasks: User management, Space monitoring, Performance monitoring, Alert Log monitoring and backup monitoring.
• Configured Oracle grid control to manage teh entire database in single centralized location.
• Proactive monitoring, identifying areas that need to be improved in teh application and database using AWR, ADDM and OEM Grid Control.
• Creating table spaces, tables, and users for custom applications.
• Automation of Startup Shutdown on all Production and Development Database.
• Database backup & Recovery wif export and import for non-archive and archive database wif RMAN commands
• Was involved in developing and testing a disaster recovery (DR) plan.
• Creating Tables, indexes, & triggers to assist developers.
• Interfacing wif Oracle Corporation for technical support.
• Scripts for Analyzing of Tables and Rebuilding of Indexes, analyzing alert log errors and database related errors.
• Maintained all documents of Oracle database operations. Prepared documentation of database backup and recovery standards.
• Performing all daily Maintenance tasks. Interacting wif Oracle Customer service as and when required.
• 24 X 7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database Issues.

Confidential, Monroe, MI

Database Administrator

Responsibilities:

• Installed and migrated oracle 12c oracle two RAC databases on virtual machine.
• Implementing interval partitioning for SQL query better performance.
• Worked wif oracle purge scrip and costume partition drop script to contain teh growth of oracle middleware database/schema.
• Migrated oracle OTM databases from 11g on windows to 12c Linux wif oracle data pump.
• Implemented oracle GOLDEN GATE 12c unidirectional replication.
• Worked wif middleware team in created a disaster recovery strategy for middleware SOA INFRA schema.
• Worked wif development team in loading and unloading teh XML data.
• Worked on online REDEFENITION for partitioning tables and also for reorganizing large tables.
• Monitoring Standby Database whether all teh logs transferred to Standby site and applied properly.
• Implemented oracle backup and recovery strategy using RMAN.
• Performed database and tablespace RMAN point-in-time recovery.
• Created stand by database and implemented DATAGUARD wif asynchronous.
• Created custom scripts for databases refresh from production to non-prod databases.
• Worked on OEM extended metrics to monitor teh FRA space and performed teh correction action upon alert warning.
• Implementation of RAC, ASM, DATAPUMP, FLASH BACK Recovery
• Worked on oracle database auto shutdown and start for OS patching.
• Upgraded oracle 12c OEM to 13c OEM.
• Replication and Extracting data and applying on production using Golden Gate.
• Worked on performance and sql tuning using explain plan and SQLT.
• Wrote custom shell scripts to drop partitions, monitor teh alert log, cleaning teh log files, backup and database reports and FRA space and tablespace monitoring.
• Applied oracle interim, quarterly PSU and CPU patches.
• Migrated upgraded oracle 11g databases to oracle 12c container databases.
• Managed oracle database for size around 4TB.
• Involved in database cloning, tuning, patching and monitoring.
• Maintained all documents of Oracle database operations. Prepared documentation of database backup and recovery standards.
• Performing all daily Maintenance tasks. Interacting wif Oracle Customer service as and when required.
• 24 X 7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database Issues.

Confidential, Albany NY

Oracle Database Administrator

Responsibilities:

• Implementation of High Availability solutions wif Oracle 12c,11g RAC,10g RAC, StandbyDatabase(Active Data Guard), Replication.
• Implemented Data Pump, Export and Import on day to day basis as per development and test servers.
• Wrote shell scripts for automation of tasks and used shell scripts wif crontab for job scheduling
• Performs ongoing database performance tuning, including review & tune complex SQL statements
• Run AWR and stats pack reports to identify sql wif large buffer gets and physical reads per execution.
• Created Physical Standby database usingOracleData Guard at local and remote sites and performed managed recovery of Physical Standby Database and monitored Standby Database.
• Monitored DR (Data Guard) implementations regarding connectivity issues and "log shipping" to failover site.
• Troubleshooting teh blog and log datatype along wif XML data for better performance.
• Implemented multiplexing control files and redo log file.
• Identifying and removing Fragmentation, row migration/chaining ofdatabaseobjects
• IdentifySQLexecution plan changes and performance regressions through SQL Performance Analyzer wif RAT.
• Capture, analyze and replay database transactions by using RAT.
• Experience in upgrading 11g OEM to OEM 12c Cloud Control wif a Two system approach method having zero downtime
• Installed, Configured Oracle 12c Golden gate on Oracle 12c Database.
• Extensively worked on Golden gate. Configured cascading and bi-directional setups to accommodate teh business requirements.
• Performed conversion of Single Node Instance to Multi Node RAC wif ASM and adding instance to existing RAC.
• Applied patches and Migrated Databases and maintain an updated platform matrix and Cloned/Refreshed Databases from Production Database using RMAN and Hot Backups.
• Resolved Oracle errors and bugs by working wif Oracle Support.
• Providing production support for 24X7 database availability forOracleDatabase.