SUMMARY:

• Over 10 years of experience as an IT professional in Oracle Database Administration, installation, patches, upgrades, migrations, configuration, database security, capacity planning, space management, backup and recovery, cloning, troubleshooting and documentation.
• Excellent experience in Oracle database administration on Oracle 11g/10g/9i RAC and standalone databases in different environments LINUX, RHEL,OEL, WINDOWS
• Strong Experience in
• Installation, Configuration, Maintenance, Performance Tuning, Backup & Recovery, Cloning of Oracle and SQL Server.
• Experience in Re - Organization of database using export/import and Data Pump.
• Experience in implementing and using Oracle Streams for Replication.
• Experience with Disaster Recovery, Data Guard, RMAN, Real Application Cluster (RAC), OLTP and Data warehousing environments.
• Enforcing Database security by creating and assigning Roles, Profiles and Privileges to various Users (Schemas) on different Objects.
• Implemented Oracle Enterprise Manager (OEM), Automatic Storage Management (ASM) & Automatic Database Diagnostic Monitor (ADDM).
• Excellent Knowledge on Golden Gate Installation and Migration.
• 3 years of experience in Goldengate Technology for Replication. Also experienced in upgrading Goldengate software from 10.2.X version to 11.2.X.
• Extensive experience with RMAN backup, hot backup and cold backup. Performed full backups and incremental backups. Backup and Recovery strategy using hot backup, user managed and RMAN.
• Experience in developing Shell Scripts to manage Oracle databases daily backups and monitoring jobs.
• Migrating and upgrading the databases to higher versions.
• Expertise in maintaining Database Security using auditing.
• Expertise in loading data from flat files using external tables, SQL*Loader.
• Managed streams for data replication, data protection.
• Worked as a team member to provide 24x7 on-call production support

TECHNICAL SKILLS:

Databases: Oracle 9i, 10g, 11g, 12c, MS SQL Server 2000.

Middleware: Oracle Application Server 10g

Hardware & OS: Linux, UNIX, Solaris 9, 10, Windows 2000/2003.

Programming: Basic Shell Scripts.

NetWare: TCP/IP, FTP, Telnet, Netscape, and Internet

Tools & Utilities: RMAN, Data Pump, Dataguard, OEM, Grid Control. Oracle Export/Import, SQL Navigator

Oracle Tools: SQL*LOADER, Oracle SQL Navigator, TOAD

ERP Modules: Oracle Applications R12/11

Others: VMware, Net Backup, Toad

PROFESSIONAL EXPERIENCE:

Confidential, IL.

Oracle DBA

Responsibilities:

• Worked as a Core DBA/ Exadata DBA at Confidential as migration specialist on Oracle 12cR1, 11gR2, Exadata X2, X3 & X6,, OEM 13c, RAC, Data Guard, Linux.
• Working on Exadata X2, X3 and X6 machines which included Half Rack and Full Rack
• Migrating 50+ databases from Exadata X2 and X3 machines to Exadata x6 machines
• Managing database on 12c RAC and 11g R2 RAC
• Created OEDA requirement document for Oracle to setup the new Exadata X6 machines
• Worked with network and linux teams to configure the network on the Exadata x6 machines so Oracle ACS can install Grid infrastructure 12cR2 and Databases 11g R2 and 12cR1
• Configured and modified Exadata x6 machines as per Confidential requirement and specifications after Oracle handed over the standard Exadata machines.
• Installation of OJVM patch on 11gR2 databases on Exadata X2 and X3 environments before migrating it to Exadata X6 machines to match with Bundle patch version.
• Worked with Storage team in configuring Netbackup and Datadomain on Exadata X6 machines.
• Migrated using Datapump Export/Import for small databases and non-critical databases and used DataGuard to Migrate huge and critical databases with 99% uptime.
• Setup DataGuard between multiple datacenters for 12 production databases.
• Planed and documented all migration steps and coordinated with different teams during the deployments.
• Integration of Exadata monitoring into our existing IT monitoring framework. Provide and implement performance and tuning recommendations of all components in the Exadata machines.
• Develop and record certified processes/procedures for all potential IT downstream support group to maintain and upgrade the Exadata servers.
• Migrating databases to Oracle Exadata Database Machine for different clients.
• Analyzing database performance and tuning database on Oracle Exadata using Real Application Testing (RAT) .
• Implemented Best Practices for migration E-Business Suite and regular databases to Oracle Exadata.
• Installing, configuring and maintaining Enterprise Manager Cloud Control to monitor and manage Exadata and regular databases.
• Zero Downtime Migration to Oracle Exadata with Oracle Dataguard and Oracle GoldenGate.
• Participated in analysis and designing of Oracle Exadata Server for infrastructure and related projects. Assisted in integration of Exadata applications into current IT actionable events and solutions.
• Tested Switchover and failover between data centers before migration of production databases using Dataguard
• Efficient in using Dataguard Broker for all DataGuard tasks.
• Migrated multiple databases upto 10TB of size with minimal to no downtime using dataguard.
• Configured databases with 2 node and 4 node RAC clusters
• Migrated databases for applications like Peoplesoft, Automic UC4, GitHUB, Stibo STEP, Atlassian Jira, Arlassian Confluence, BuildForge, DataStage, Oracle WebCenter Sites and Confidential website.
• Software and firmware maintenance of the Exadata storage servers in the Database machine including routine health check, patching and upgrades according to the suggestions from Oracle support department.
• Integration of Exadata monitoring into our existing IT monitoring framework. Provide and implement performance and tuning recommendations of all components in the Exadata machines.
• Working on Installation of Oracle Enterprise Manager Cloud Control 13c.
• Worked with linux team to setup VM’s for Oracle Management Repository database server and Oracle Management Service (OMS) web-based application server.
• Working on setting up agents on Exadata x6 machines for monitoring.
• Setup and configure RMAN jobs for daily full backups, incremental backups and archive log backups and are scheduled using Cron.
• Setup scripts to monitor dataguard health on all datacenter apart from OEM monitoring.
• Monitoring for 24x7 Production environment, resolution of severe performance and user access issues
• Worked with tuning tools like DBArtisian, TOAD and Solarwinds Database Performance Analyzer.
• Worked on building and rolling out new 12c databases for TEST/DEV/QA/PROD environments.
• Experience in setting up Oracle Data Guard and administering Oracle Data Guard using Data Guard broker. Also Troubleshoot and resolved log gap in Data Guard Configuration.
• Strong oracle Rman backup and recovery skills. Ability to restore and recover databases, tablespaces quickly up to a point in time.
• Proficient in performance tuning using Explain Plan, AWR, ADDM, Performance Tuning of the database (Memory Tuning, I/O Tuning).
• Proficient in Performing backup and recovery using Oracle 11g's user managed backup, using RMAN (cold backup/hot backup procedures).
• Extensively using DATAPUMP and Export/Import utilities for logical backups and moving data between oracle databases for updates in development database.

Environment: RAC Oracle 11gR2, 12C ASM, Red Hat Linux 4.x/5.x, MySQL, OEM, SQL*Loader, RMAN, ASM, Data guard, Toad.

Confidential, IL.

Oracle DBA with RAC & Golden Gate

Responsibilities:

• Administering 24x7 Real Application Cluster (RAC) databases running on Cluster File system. Worked with senior DBA’s for preparing cluster, configuring and Installation of Clusterware and Oracle RAC on Red Hat Linux. Startup and Shutdown of Individual instances on RAC database using Enterprise Manager.
• Installation, Cloning, Configuration, Deploying and Administration of Oracle 11gR2 RAC.
• Migrated oracle 11gR2 databases to 12c from windows to Linux.
• Installed RAC on Oracle 11gR2 and worked on ASM feature of Oracle.
• Created and maintained immediate failover and identified vulnerabilities up to the minute data to minimize the recovery time mission systems using oracle GOLDEN GATE (Testing Purpose).
• Setup RAC to RAC Data guard with real time applies for DR purposes and offloading reports onto read-only standby.
• Periodically cloned databases from production to the Dev environment using RMAN duplicate DB.
• Identify poorly performing sql’s using Oracle 12c sql monitoring feature and run sql tuning advisor to analyze advisory suggestions.
• Used Oracle 11g Sql plan stability feature to stabilize execution plans of poorly performing sql queries on OLTP systems.
• Work with application developers and business groups to partition large transactional table’s in-order to facilitate max availability, manageability and performance.
• Implemented and tuned RMAN backups using incremental backups (Oracle block change tracking) thus reducing the back foot print on daily backups.
• Worked closely with the network team to migrate both public and private networks on the Production RAC clusters in a rolling fashion with minimal to no downtime and identify and monitor vulnerabilities
• Applied standby first patch apply Oracle PSU patches on Oracle RAC clusters (GRID & DB) with 2 node RAC standby.
• Worked in 24 X 7 running databases and support environment
• Performed RAC all nodepatching and Rollingpatching.
• Migrated oracle 9.2.0.8 databases to 11.2.0.4 from windows to Linux
• Ggs Heterogeneous replication usingGoldenGate( Oracle 11.2.0.3 to SQL Server)
• GoldenGatetroubleshooting using Log miner
• Migrated Database between servers using Data pump Export/Import

Environment: Oracle 11gR2,, 12C, Red hat Linux 6.X, Oracle 11gRAC, Toad, SQL-navigator, Goldengate, SQL*Loader, ASM, and Data guard

Confidential, IL.

Oracle Database Administrator

Responsibilities:

• Involved in Installation of Oracle 11g database in ASM (Linux).
• Created users & privileges with appropriate roles and levels of security
• Involved in migration of the database from Non ASM to ASM using Data pump utility
• Maintaining the Cold and Hot backups of the databases
• Performing Day to Day activities such as checking alert logs and scheduled tasks
• Created and managed table spaces monitored the data files space, resizing and adding new data files etc
• Exporting & importing data into the databases, using Oracle utilities such as exp/ imp, and Data pump
• Monitoring and performing daily incremental backups, weekly backups using Rman utility.
• Involved in recovering of the data block using Rman utility and complex backup and recovery issues
• Interaction with client/users on various issues
• Database Restore using RMAN, Cold Backup and Import
• GG Replication administration:
• GG installation
• Configuration, Monitoring and Troubleshooting
• Setup Golden Gate Database User with necessary privileges
• Collecting performance statistics using Stats pack/AWR (Automatic Workload Repository) and analyzing by ADDM (Automatic Database Diagnostic Monitor)
• Rebuilding indexes or analyzing the index as per the fragmentation level and minimize the performance issues.
• Refresh/Cloning of Database from production environment to test environment and application of patches.
• Monitoring the CPU usage, IO statistics, and CPU time to identify any OS level Performance killers
• Experienced of managing and administering 24 X 7 running databases and support
• Identified vulnerabilities and applied bug patches according to the Oracle Critical Patch alerts.
• Configured the automated alerts for the production servers, which alerts DBA with the alert log errors and proactively space related errors.
• Identified and trouble shot everyday issues like locking and scripts execution.
• Working with the application support people to resolve database related issues and running the scripts for the application support people.
• Creating Users and Database links, snap shots on production and development servers.
• Checking CRON jobs and restarting the failed jobs.
• Implemented automated backup strategy using the UNIX shell script and CRON Utility.
• Used SQL*Loader to load data from flat files to Oracle database.
• Created database links for data transfer to support distributed transactions

Environment: Oracle 10g/11g, ASM, Red Hat Linux 4.x/5.x, Windows 2003, OEM, SQL*Loader, Grid Control, RMAN, ASM, Data guard, Data pump, GoldenGate 11g

Confidential

Oracle DBA

• Installed, configured and maintained Oracle Databases.
• Performed 24/7 production support on rotational basis
• Installation, Configuration, Deployment and Administration of Oracle 10g and structures.
• Managing, troubleshooting and resolving oracle database, RAC and applications issues.
• Refresh/Cloning of Database for development and testing purpose.
• Involved in Upgrade/Migration of the oracle databases from Oracle 9i to Oracle 10g.
• Plan Golden Gate setup, Installation, configure to achieve Unidirectional replication
• Test initial Data Load option of GoldenGate during environment build
• Prepare GoldenGate parameter files for Extraction and Replication
• Created scripts to query performance views in an effort to reduce parse times and tune memory structures such as the database buffer cache, shared pool, library cache and PGA for a shared server configuration·
• RAC Patching using Opatch tools - CPUs and PSUs patchingPro-active monitoring and performance tuning databases including partitioning and creating materialized views as well as working with Development teams to develop and tune SQL queries and stored procedures.
• Standby Database (Data Guard) setup and configuration.
• Working alongside programmers and contributing to the development process; Enabling and analyzing Trace files.
• Performing monitoring and performance tuning
• Defining and Setting backup and recovery procedures. Configuration of backup that Includes table/index/etc. maintenance in QA and production
• Support for test and/or development environments and tuning the database using Statspack and custom scripts.
• Responsible for continuous database monitoring, identifying vulnerabilities and reorganization for ensuring performance.
• Modified tablespaces, tables, views, triggers, stored procedures as well as configuration and storage allocation to improve performance.
• Scheduled jobs using Cron Job.
• Tuning SGA, I/O Tuning, Identifying contention, waits and tuning.
• Experienced in Tuning SQL statements using Explain Plan and using ADDM
• Writing Shell Scripts for managing day-to-day activities and automation of backup.
• Backup of Database (Making Backup Schedules depending upon Business Strategy: Daily Backup, weekly Backup etc).
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).

Environment: RHEL 6, Oracle 11g, Golden-gate 11g.

Confidential

Oracle DBA

• Installed, configured and maintained Oracle Databases.
• Performed 24/7 production support on rotational basis
• Installation, Configuration, Deployment and Administration of Oracle 10g and structures.
• Managing, troubleshooting and resolving oracle database, RAC and applications issues.
• Refresh/Cloning of Database for development and testing purpose.
• Involved in Upgrade/Migration of the oracle databases from Oracle 9i to Oracle 10g.
• Created scripts to query performance views in an effort to reduce parse times and tune memory structures such as the database buffercache, shared pool, library cache and PGA for a shared server configuration·
• RAC Patching using Opatch tools - CPUs and PSUs patchingPro-active monitoring and performance tuning databases including partitioning and creating materialized views as well as working with Development teams to develop and tune SQL queries and stored procedures.
• Standby Database (Data Guard) setup and configuration.
• Working alongside programmers and contributing to the development process; Enabling and analyzing Trace files.
• Performing monitoring and performance tuning
• Defining and Setting backup and recovery procedures. Configuration of backup.
• Includes table/index/etc. maintenance in QA and production and Support for test and/or development environments.
• Tuning the database using Statspack and custom scripts.
• Responsible for continuous database monitoring and reorganization for ensuring performance.
• Modified tablespaces, tables, views, triggers, stored procedures as well as configuration and storage allocation to improve performance.
• Scheduled jobs using Cron Job.
• Tuning SGA, I/O Tuning, Identifying contention, waits and tuning.
• Writing Shell Scripts for managing day-to-day activities and automation of backup.
• Backup of Database (Making Backup Schedules depending upon Business Strategy: Daily Backup,weekly Backup etc).
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally,Recovering data files, Recovering from Block Corruption).
• Installation and configuration of Oracle Client software and Tools.
• Analyzed the user requirements and Designed partitioned tables for improving performance of Data marts.
• Performed partition maintenance and automated the process of creating new partitions as and when required.Automated the process of analyzing tables every night.

Environment: Oracle 10g (RAC), OEM, RMAN, Exp/Imp, ASM, SQL*Loader, Data Guard

Confidential

Oracle Database Administrator

• Installation and Maintaining of Oracle (10g and 11g).
• Involved in designing of disaster recovery using Data Guard, High Availability using RAC
• Responsible for administration and supporting Oracle 9i, 10g databases.
• Schemas refresh using Export/Import. Creating the database, table spaces, tables, indexes, settings privileges and user logins.
• Taking Backups on scheduled time and monitoring scheduled Backups through RMAN.
• Cloning databases using scripts as well as RMAN.
• Responsible for creating the databases used for the users over the entire state.
• Periodically refreshing the SIT/UAT databases from Production database.
• Utilized Oracle Streams to capture, propagate, and apply the transfer of data, transactions, and events within managed databases.
• Performed database tuning using Explain Plan, TOAD, and Enterprise Manager.
• Establish standby/cloned databases via Data Guard for Database Disaster Recovery. Created, procured, and maintained various database-related documents such as manuals and spreadsheets
• Involved in Data Migration / Conversion Process and experienced with Data guard Implementation.
• Implemented oracle high availability solution using oracle 10g Physical Standby.
• Importing data from flat files into database using SQL loader and External Tables.
• Experienced in Volume management, Disk Management using volume manager.
• Written shell scripts to automate the tasks.
• Mapping of old data fields to new model data fields for data migration.
• Tuning Oracle databases and tuning applications (SQL), for tuning SQL working closely with development Team. Daily Health Check Up of the Database using STATSPACK, AWR, ADDM.
• Rebuilding of Indexes for better performance, maintenance of Oracle Database.

Environment: RHEL 5, Oracle 10g, 10gRAC, TOAD 9.6.