PROFESSIONAL SUMMARY:

• Over 10+ years of experience of Oracle Database Administrator including 10g, 11g and 12c.
• Managed databases on Linux, Solaris, Windows, AIX and HPUX.
• Build Disaster Recovery sites using Oracle Data Guard.
• Installed and configured databases using silent install, OMF and via scripts.
• Has extensive knowledge in dynamic views and dictionary tables.
• Applied CPU and PSU patches.
• Experience with database backup, restore, and disaster recovery procedures such as creating catalog database, Virtual Private Catalog, Hot Backup, RMAN (9i/10g, 11g) full & incremental backup, 10g Data pump (expdp, impdp).
• Installed GoldenGate 11gR2/12c software in Test and production (RAC DB) environment.
• Extensive hands - on experience working in UNIX (Linux, CentOS, Red Hat, HP-Unix, IBM-AIX) environment and with UNIX Shell Scripting.
• Experience in Administration activities such Installation, Configuration, Client/server connectivity, Creating and Managing Repositories, Users, User Groups, Folders, User Roles, Profiles and Privileges.
• Worked on Database monitoring / performance / diagnostics via dictionary views and cloud control.
• Extensive experience in OS space and tablespace management.
• Worked on database security and Fine Grain Auditing.
• Extensive work on shell scripting and documentation.
• Excellent Experience as Production DBA with 24X7 supports.
• Extensive experience in backup and restores using RMAN
• Managed databases on Exadata and GoldenGate.
• Managed Oracle Databases on Amazon Web Services.
• Migrated Oracle Database to AWS
• Good experience in upgrading 10g & 11g R2 database to 12c Pluggable database using Oracle DBUA and/or expdp/impdp method.
• Extensive experience in ASM Storage management such as create ASM disk groupsfrom SAN disks, add/remove ASM disks to existing ASM disk group, drop disk group.
• RAC experience includes working experience in - planning, designing, developing, deploying, maintenance and supporting RAC on RHEL and Oracle Linux.
• Planning and scheduling Backups, Database Recovery, taking Logical Backups (withExport/Import).
• Maintain Oracle fail over databases (Physical and Logical standby databases- Data Guard)
• Worked on Oracle Flashback / Flash Recovery Area (FRA)
• Proficient in Oracle RDBMS - including SQL, PL/SQL and all areas of database Administration.
• Experience monitoring Oracle RDBMS availability, database exports, Data Pump,tablespace, and extents fragmentation.
• Worked on Automated Storage Management (ASM) for 10g/11g databases.
• Worked on much performance tuning including SQL tuning and instance tuning.
• Experience in setting up Grid Control and 12c Cloud Control.
• Experience in Setting up Materialize View Server.
• Worked on Table space/Extent/Segment Management
• Setup Oracle Enterprise Manager (OEM) and worked on 12c cloud control.
• Provided On-call support on 24/7 basis.
• Have written shell scripts to automate database management tasks.
• Pose strong administrative skills in RHEL.
• Worked on Migration & Upgrade project
• Excellent interpersonal and communication skills, technically competent and result-oriented with problem solving skills and ability to work independently.

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Oracle Cloud DBA

Responsibilities:

• Installed and configured 12c multitenant databases on Red Hat Enterprise Linux.
• Implemented and Worked on 13c oracle enterprise manager High Availability Architecture for monitoring Time critical oracle database (11g/12c).
• Configured Data Guard (physical standby) for Enterprise Manager Repository Database for High Availability Architecture.
• Installed Oracle GoldenGate and setup Uni-directional replication.
• Migrated Oracle Non-RAC databases to Oracle RAC databases.
• Migrated Oracle database from file system to ASM.
• Define database backup/restore procedures using RMAN and TSM. Manage database backups and perform recovery. Participate in DR exercise twice a year to validate recovery procedures.
• Experienced in managing space issues in the Database Level for table space and Regular file system cleanup at UNIX level.
• Experienced in Installing OEM agent and hooking up to the grid and Used OEM grid for monitoring the Listeners present in the oracle environment.
• Installed ASM environment and migrated databases from NON-ASM to ASM.
• Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 12cGrid Control.
• Implemented backup/recover strategies using RMAN and Export/Import utilities and wrote Shell Scripting for managing day-to-day activities and automation of backup.
• Conducted analysis and feasibility studies for development of Oracle Exadata solutions.
• Designed and implemented Active/Passive model for Oracle Enterprise Manager High Availability Architecture with minimum down time.
• Upgraded Databases from 12.1.0.2 to 12.2.0.1 in production, test and development environments.
• Developed functions, procedures and packages as re-usable application programs that translated complex business logic using PL/SQL and SQL to transform data between source staging area to target staging area. Extensively used PL/SQL tables, cursors and exception handling.
• Created database objects like Tables, Sequence, Synonyms, Views, and Materialized Views.
• Involved in developing interactive forms and customization of screens using OracleForms.
• Diagnosed and reduced Enterprise manager startup time from 15mins to 5mins.
• Migrated 12.1 Enterprise Manager Repository database from a non-container database (non CDB) to a 12.2 pluggable database (PDB) and worked on TCP Invited node setting for restriction connections.
• Experienced in Oracle Enterprise Manager 13c monitoring enhancements like creating metric extensions, monitoring templates, monitoring oracle database from OEM and Deploying management Agents on to Target servers.
• Upgraded Enterprise manager 13.1 to 13.2 in production, Test and Development environments.
• Experience in applying patches for both oracle databases and critical Enterprise Manager components like OMS system, Plugins and Agent system patches and Agent plugin patches.
• Experience in refreshing of databases using Datapump utilities expdp/impdp.
• Created oracle wallets and imported Third party user and root s into the oracle wallet.
• Created and troubleshooted TCPS and TCP with ASO listeners with Third party s usingoracle wallets related to enterprise manager connectivity.
• Performed Management Agent upgrades from 13.1 to 13.2
• Relocation of Enterprise Manager Agents Targets in a clustered environment.
• Experience in offline patching of databases and the management agent using offline catalogwhen OEM is not connected to oracle support.
• Performed PSU verifications and created custom database related jobs from oracle enterprise manager.
• Experience in using OEM components like Performance home page, Top activity, ASH report, AWR reporting and SQL worksheet for proactive monitoring of oracle databases.
• Configured database using RMAN utility for level 0 and level 1 cumulative backups.
• Deployed and secured Oracle Management Agents on target servers for host level and database monitoring.
• Created custom script for retrieving all the list of incidents from Enterprise Manager Repository Database.
• Cloned databases using RMAN Utility.
• Performed remote clone of oracle multitenant databases using Database link.
• Implemented backup/recover strategies using RMAN and Export/Import utilities and wrote Shell Scripting, cronjob entries for managing day-to-day activities and automation of backup.
• Excellent Knowledge on Data Guard Broker configured TCPS listeners using oracle wallets forData Guard connectivity

Confidential, Little Rock, AR

Oracle DBA

Responsibilities:

• Worked closely with developers during release and used oracle advanced features to achieve minimum downtime.
• Good experience in Performance tuning of large databases.
• Data Guard administration and maintenance.
• Successfully implemented Backup & Recovery using RMAN, Hot and Cold backups.
• Taking the RMAN incremental and cumulative backups.
• Scheduling the databases backup using crontab and VERITAS net backup.
• Perform Logical backup using full/partial export/import and data pump.
• Creation of Users and granting them the required Roles and Privileges accordingly.
• Involvement in space management, managed quotas.
• Configuration of Listener and Net Service names using NETCA and NETMGR.
• Cloned schemas, objects and data on new server using Data pump.
• Managing databases on multiple servers.
• Installed Oracle DB 12c RDBMS, RAC on ASM, Applying Oracle patch updates, Implementing and Manage Data Guard, Replication, Backup and Recovery support and performance tuning.
• Handling the code deployments developed by Developers on Dev, Test and Production.
• Managing users, profiles, roles and table space according to the requirement.
• Created shell script to automate jobs.
• Database user backup using Export /Import Utility. And database backup using data pump.
• Production refresh to PRR environment and conversion environment when required.
• Done partitions on tables and indexes to get better performance on large tables.
• Monitoring Backup report, Database sync report (Verifying Production & Standby Database Synchronization), AWR report and wait events reports using OEM and Custom scripts.
• Configured OEM for the performance monitoring and database administration.
• Monitored indexes and analyzed their status for performance tuning and query optimization
• Used SQL Trace, TKPROF, STATSPACK, PerfStat, Explain Plan, AWR and ADDM for database performance monitoring and tuning. Ensure availability of databases and all related services such as RAC, ASM, Oracle streams and Data Guard.
• Involvedin Implementation of Oracle Grid Control12C - Installation and Configuration of 3 OMSs for Software Load balancer and 3 node RAC OEM Repository.
• Installation of various plugins supporting Golden Gate, Exadata Machine and Agents
• Configure and support Exa-data and clustered Linux servers (RHEL and OEL) to host Oracle 11g and 12cRAC technology stack supporting both OLTP and DSS (data mart/data warehouse) databases.
• Responsible for 24x7 on-call support.
• Done Installation and configuration of Golden Gate on 12c database for the replication.
• Resolving the conflicts between the target and source database and Implemented Bi-Directional replication in golden gate.
• Upgrading GoldenGate from 11g to 12c and Expertise on Oracle Golden Gate and be able to configure Golden Gate.
• Implemented Data Guard - creating 2 Standby Databases on production environment.
• Migration of 2-4 TB Databaselevel from non -Exadata to Exadata environment.
• Weekly data refreshes using data pump and RMAN from Production to UAT / BUAT.
• Fine tune PL/SQL procedures and SQL queries.
• Data loaded from legacy systems using PL/SQL and SQL *Loader.
• Used Toad for creating PL/SQL (trigger, sequence, stored procedure)
• Used UTI FILE PACKAGES for writing DBMS OUTPUT messages to file.
• Created Packages, Procedures, Functions, Triggers, Cursors using PL/SQL in UNIX and Windows environment.
• Experienced in switching primary database to standby and standby to primary during regular maintenances of catalog databases and DR databases.
• Performance tuning of queries consuming Excessive Resources or slow running queries by Providing Required Hints to the Query.
• Responsible to tune ETL procedures and schemas to optimize load and query Performance andWell Experienced in taking Cold Backup for a very Huge 64-Tb Database.
• Experienced in managing Daily Online backups (Level-0 and Level-1) and Archive Backups usingRMAN.
• Experienced with troubleshooting the failed backups by working closely with TSM and NetBackup Support.
• Applied Patches to 11g and 12g and used datapatch to upgrade 12c databases
• Kept team members and management updated on major issues so they have a clear picture of situation.

Confidential, Overland Park, KS

Oracle Cloud DBA

Responsibilities:

• Involved in configuring Exadata X5-2, X5-8 and having hands on the smart flash cache, storage index, storage management and migration.
• Worked on ExadataDatabaseMachine X2-2 Half Rack, X3-2..
• Extensive experience in RMAN recovery in RAC and standalone database.
• Successfully Migrated Non RAC single instance to Real Application Cluster (RAC) database instances.
• Delivered to other DBAs in Oracle RAC, Backup/Recovery, Oracle GoldenGate, Performance Tuning and general database administration tasks.
• Performed Tuning, coding and Monitoring for OracleReal Application Clusters (RAC) nodes, Production Standalone Servers via Toad.
• Performance tuning and optimized the knowledge modules to improve the functionality of the process and worked on Cluster ware troubleshooting, CRS-ERRORS, CRS-4639, CRS-4530 and CRS-4535 and wait events in RAC environment.
• Worked extensively on monitoring 10G/11g/12c grid control database, configuration of error notifications, installing listeners, and adding them to the grid control.
• Installing OracleGoldenGate on RHEL and setup table level replication as well as DDLreplication too.
• Monitoring and Performance tuning of Goldengate sessions at Database level and GGSCI level and investigate replication failures using LogDump utility.
• Troubleshooting GoldenGate issues with error reports and ggserror.log.
• Developed Shellscripts for monitoring Goldengate processes and their stats running on 60+ servers from one single database repository and thus maintain history of all Goldengate processes.
• Implemented DataGuard with maximum availability, protection and performance configurations and worked with Data Guard Fail over and Switch over cases at the times of up gradation and migration.
• Performed Zero Downtime DatabaseData Center Migration using Goldengate and Datagaurd.
• Monitored Dataguard status periodically and Maintained DRserver and troubleshooting issues in Data Guard environment.
• Killed Blocking sessions on oracle databases and monitoring Alert logs and Applying shipped archived logs to standby databases on using MRP process.
• We successfully switched over databases to secondary databases during DR testing using Dataguard broker and Configured Dataguard broker.
• Implemented DRP (Disaster recovery plan) for critical databases using Streams.
• Upgraded the Oracle 10g database to 11g version and applied patch set and interim patches whenever required to make the database software up to date.
• Monitoring Day-to-Day Backups, Log's & recovering them as per the requirement.
• Successfully implemented Backup & Recovery using RMAN, Hot and Cold backups.
• Taking the RMAN incremental and cumulative backups and Scheduling the databases backup using Crontab and VERITAS net backup.
• Created blackouts in OEM to disable alerts from OEM while performing database maintenance activities such as PSU patching.
• Improved the database integrity and increased data accuracy for end-users and management by proficiently using SQL language to troubleshoot, query, insert, update, and delete table data
• Provided Instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical I/O and Memory Usage.
• Always monitoring the Oracle Instances, Users, Tables, Tablespaces, Memory structures, and Rollback segments, Redo logs, Archived Redo logs and Alerts.
• Created, monitoring database objects like Tables, Indexes, Views, Users, and DB Links etc.

Confidential

Oracle Cloud DBA

Responsibilities:

• Migrated oracle databases using oracle11g GOLDENGATE.
• Worked on upgrading of oracle databases from 11g to 12c.
• Installed ORACLE 12c database and Cloudcontrol (12.1.0.3) on Linux64-bit server.
• Implemented OEMCloudControl 12c Agent installations, plug-ins installations and adding targets to OEM.
• Installed and implemented 11gR2 3 node RAC with Data guard (DG) broker.
• Installed and configured of 11gR2 RAC with ASM and RawDevices.
• Configured 11gR2 RAC Data Guard for mission critical production systems andmanaged using Dataguard broker.
• Installed 12C cloud control and Used Oracle Enterprise Manager Grid control 11g for monitoring databases.
• Expertise in Oracle Enterprise Manager Cloud Control 12c/13c.
• Expertise in managing oracle 12c Multitenant databases and good working experience with using advanced features of 12c.
• Experience in using the Oracle Cloud Control (OEM 13c) features like Snap Cloning (using Test Master Snapshot), Orachk Integration.
• Monitoring all the databases using OEM 12c cloud control.
• Worked in troubleshooting 2node and 4node RAC and implemented 11g New ASM features.
• Extensively worked on GoldenGate implementation like installation, configuration GOLDENGATEunidirectional, Bi-directional and broadcast data distribution in classic capture mode on Oracle 11gLINUX.
• Extensively worked in setting up physical standby database using Data guard and implemented new 11g feature such as Active Dataguard and Snapshot standby database.
• Implemented switching primary database to standby and standby to primary during regular maintenances of catalog databases and DR databases.
• Configure OEM12c monitoring with customized templates and email alerts.
• Configured ASM and handled issues and suggested feasible workarounds for ASMMetadatacorruption.
• Applying patch set and interim patches using OPATCH for upgrading the binaries.
• Provided Instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical I/O and Memory Usage.
• SQL query tuning using tools like Explain Plan, SQL*Trace, TKPROF, SQL Tuning Advisory.
• Installed SQLTXPLAIN (SQLT) Tool that helps to diagnose SQL statements performing poorly.
• Used Oracle 11g/12c AWR & ADDM to monitor database activities and performance tuning.
• Performed Range Partitioning as a cause to improve the performance of the database.

Confidential, Louisville, KY

Oracle Cloud DBA

Responsibilities:

• Designed Report output formats, complex filtering and formula calculations, as well as the rendering of multi-band and multi-grouped reports.
• Maintenance included enhancing the existing stored programs, forms and reports with additional procedural and non-procedural programming logic to meet complex user requirements and fixing the bugs on priority basis.
• Installation of Application Instances and configuring them according to the client's requirements
• Configure the following modules: HRMS family, GL, AP, AR, FA, OM, INV, Supplychain & iprocurement.
• Upgrade of Oracle Application from 11.5.10.2 to 12.1.1.
• Troubleshoot various HRMS and Oracle Financial module issues and resolve the issues.
• Involved as a team lead with a team of 13 Oracle Apps dba's.
• Upgrade of Oracle database from 10.2.0.4 to 10.2.0.5 versions.
• Following up with Oracle support on software related issues, create TARs and TAR Tracking
• Cloned the Application Instances as per functional and technical requests using the Autoconfig and build the Context.xml file.
• Registering the Custom Applications, installing the Custom Docs into Oracle Application.
• Registered different types of Printers and customized the Style and Drivers to troubleshoot the printing issues for Oracle Application reports.
• System Administration tasks also includes creating and defining the concurrent programs and executables.
• Applying Patches as per Oracle support to troubleshoot various errors.
• Implementation of High Availability solutions with Oracle 10g RAC, Physical and Logical Standby Databases (Data Guard) and Replication using Oracle Streams.
• Installation, configuration and managing Fusion Middleware components Oracle SOA, HTTP server and web logic.
• Troubleshooting all Oracle Apps Issues like Forms, Apache and CM.
• Run ADADMIN to compile APPS schema, regenerate forms, reports, generate Jar files.
• Supporting the databases for different applications like noetix, fog light.
• Written Shell scripts to move the Tables from one instance to another instance using Import/Export.
• On-call support for Oracle ERP Applications and databases.
• Attended Oracle Conferences and had knowledge about Oracle Future technologies 18c databases.
• Importing data from different varieties of sources like flat file, excel file or Oracle dump file into Oracle database source schema tables using SQL*loader.
• Responsible for creating and maintaining the Table spaces, Users and assigning Roles and Privileges.
• Developed, Tested and Migrated the Oracle PL/SQLscripts to Production.
• Worked on tuning the SQL Queries for better performance and troubleshooting development problems.
• Extensively worked on developing KORN shell scripts for scheduling the jobs using CRONTABand invoking the procedures through shell scripts.
• Involved in implementing bug fixes and enhancements within packages, forms, and reports.
• Responsible for preparing user manuals and quick guides..