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:

• Performing database administration and configuration management functions to include the following duties:
• Worked onOracle11g/10gRACand NON-RACdatabases.
• Performed installation of clusterware software across various nodes inRACenvironment.
• Migrated oracle 11gR2 databases to 12c from windows to Linux.
• Created number of databases in bothRAC& NON-RACenvironments, registered the database and database instances with SRVCTL (server control utility) inRACenvironment.
• Maintaining data in ASM instance, andRACenvironments
• Performed Patching, restoration onRACinstance and OS level cluster databases.
• Performed CRS and RDBMS home installationsRACsystems.
• Perform Daily Health Check review of database instances through Grid to ensure all database instances running, Listener are up, backups are successful, redo logs are in sync.
• Resolution of invalid objects after migration, deployment and refresh of database.
• Regular Monitoring Alert log Files and trace files on Day to Day Basis.
• Perform Roll Forward of standby database to sync with primary database.
• Migrated Non ASM databases to ASM. Cloned the production database to test databases using RMAN cloning methods.
• 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.
• Creating and rebuilding indexes as necessary.
• Built databases for development and testing purposes
• Maintained databases for each environmentand created database objects
• Altered database structures and schemas as needed
• Write SQL scripts to create tables, indexes synonyms, views and other objects
• Installed, configured, deployed and maintained all database servers, working with network and system
• Monitoring Tablespaces and Data files utilization, Redo logs, Control files and archive logs.
• Identified, developed, implemented, monitored and improved processes and procedures to increase overall efficiencies within the teams.
• Excellent interpersonal skills, team player, aggressive, hardworking and result oriented.
• Experience in on-call support and 24x7 DBA for production environment.

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

Confidential, Chicago, 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
• Knowledge of the OracleGoldenGateinstallation, configuration, troubleshooting GG issues

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

Responsibilities:

• 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

Responsibilities:

• 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

Responsibilities:

• 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 training databases used for training 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.

Confidential

Oracle Database Administrator

Responsibilities:

• Provided support for Oracle 10g/9i on Linux in a 24x7 production environment..
• Utilized RMAN for backup and Recovery strategy and even performed cloning of database.
• Monitored and supported geographically distributed databases in close association with senior DBAs, system and Network administrators.
• Conformed to business rules.
• Performed regular backups and recovery.
• Setup and managed Oracle Streams replication environment.
• Performed data backups using RMAN on disks as well as on tapes.
• Upgraded databases from 9i to 10g and applied the required patches.
• Participated in consultation with the Application development teams and provided DBA support to the developers.
• Evaluated, recommended and installed various software’s on a regular basis.
• Upgraded and applied patches.
• Wrote UNIX scripts to automate periodic tasks.
• Participated in cloning, creating and maintaining schemas, and performance tuning and monitoring.
• Performed other core database administration activities.

Environment: ORACLE 9i/10g, RHEL 5, windows 2003/2000, TOAD 7.5