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 with the Team and Management. Adept at learning and adaptable to complex work environment

PROFESSIONAL EXPERIENCE

Confidential

Database Administrator

Responsibilities:

• Provided 24X7 support for all the 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 effective space allocation.
• Cloned/RefreshedOracle Databases from prod to dev and testing.
• Responsible for optimizing the queries and application tuning.
• Perform SQL tuning and assist developers with coding PL/SQL.
• Provided support to Application Database Administrators in designing the 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 with oracle support in resolving the block header corruption during the database upgrade.
• Creating new RMAN 12c catalog databases, registering the databases and creating the RMAN backup scripts.
• Migrating the 10G and 11G RMAN catalog databases and upgrading the RMAN catalogs.
• Created and resolved the issues related to database links from lower versions to oracle 12c.
• Restore and recovering the databases from RMAN backups.
• Managed the Very Large table spaces and tables in 50 TB size of Database.
• Identified bugs and applied required patches like CPU, PSU Patches as per the 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 the entire database in single centralized location.
• Proactive monitoring, identifying areas that need to be improved in the 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 with export and import for non-archive and archive database with RMAN commands
• Was involved in developing and testing a disaster recovery (DR) plan.
• Creating Tables, indexes, & triggers to assist developers.
• Interfacing with 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 with 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 with oracle purge scrip and costume partition drop script to contain the growth of oracle middleware database/schema.
• Migrated oracle OTM databases from 11g on windows to 12c Linux with oracle data pump.
• Implemented oracle GOLDEN GATE 12c unidirectional replication.
• Worked with middleware team in created a disaster recovery strategy for middleware SOA INFRA schema.
• Worked with development team in loading and unloading the XML data.
• Worked on online REDEFENITION for partitioning tables and also for reorganizing large tables.
• Monitoring Standby Database whether all the 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 with asynchronous.
• Created custom scripts for databases refresh from production to non-prod databases.
• Worked on OEM extended metrics to monitor the FRA space and performed the 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 the alert log, cleaning the 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 with 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 with 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 with crontab for job scheduling
• Performs ongoing database performance tuning, including review & tune complex SQL statements
• Run AWR and stats pack reports to identify sql with 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 the blog and log datatype along with 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 with RAT.
• Capture, analyze and replay database transactions by using RAT.
• Experience in upgrading 11g OEM to OEM 12c Cloud Control with 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 the business requirements.
• Performed conversion of Single Node Instance to Multi Node RAC with 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 with Oracle Support.
• Providing production support for 24X7 database availability forOracleDatabase.