PROFESSIONAL SUMMARY:

• 8 years of experience as an Oracle DBA (12c,11g&10g).
• Supported multiple environments on AIX, Linux, and Solaris platforms.
• Experience in taking Hot Backup and Cold Backup as well as immense experience in taking logical backups using oracle utility exp/imp and Data Pump.
• Applied patches (PSU) to Oracle Software on a regular basis to ensure it stays updated and secured.
• Used Oracle backup utility RMAN to implement Oracle backup and disaster recovery.
• Experienced in Configuring and Maintaining Standby databases (Data Guard) in Oracle 11g and 12c.
• Experience in logical and physical design of oracle database.
• Upgraded Oracle Grid Infrastructure and Database from Oracle 11g to Oracle 12c.
• Efficient in SQL query optimization using explain plan and sql profiles.
• Installed and configured Oracle 12c and 11g Real Application Clusters (RAC) on multiple nodes.
• Experience in Upgrade of Oracle databases from Oracle 11g to Oracle 12c using manual method and Database Upgrade Assistant (DBUA).
• Created and managed database object like tables, views, sequences, synonym, index, trigger, user, roles, DB link and Materialize view (M - view).
• Used Automatic workload repository (AWR) to collect statistics and automatic database diagnostic monitor (ADDM) to monitor and analyze statistics and provide advisory services.
• Experience in Golden Gate Installation and configuration for replication.
• Implemented Oracle partitioning to improve the performance.
• Experience in using Oracle Enterprise Manager (OEM 12c and OEM 13c) for monitoring database activities.
• Experience in managing security through grants, roles, privileges and profiles.
• Experience in development of PL/SQL packages, functions, stored procedures and triggers to implement business logics of oracle database.
• Provided 24x7 support for mission critical projects as a production support DBA.

EMPLOYMENT HISTORY:

Confidential, Jacksonville, FL

Oracle DBA

Responsibilities:

• Upgraded Oracle 11gR1 and Oracle 11gR2 databases to Oracle 12c manually and also using Database Upgrade Assistant.
• Created Physical Standby Database for the Dataguard setup manually and also using Oracle Enterprise Manager Cloud Control 12c.
• Performed the Dataguard Switchover and Failover procedures using OEM 12c and also manually.
• Configured Dataguard Broker for managing the Dataguard setup.
• Applied latest PSU Patches to the Oracle Grid Home and Database Home to ensure the database against the security vulnerabilities and Oracle bugs.
• Monitored and Maintained Oracle RAC databases on linux platform.
• Monitored the Database Performance using OEM Cloud Control 12c and ensured the Optimum performance of the databases.
• Installed OEM Cloud control 13c to monitor the database activities.
• Cloned the Oracle databases using Active database duplication feature of RMAN.
• Created users and assigned them appropriate roles to guarantee the security of the database.
• Refreshed data from Production to developed environments using datapump expdp and impdp utilities.
• Performed Disk space recovery and Updated Planner Statistics for tables in PostgreSQL databases.
• Refreshed 2TB database from Production to QA environment using RMAN.

Environment: Oracle 12c, Oracle 11g, RHEL 5.8/6.2/7, Goldengate, OEM Cloud Control 12c

Confidential, Austin, TX

Oracle DBA

Responsibilities:

• Implemented Dataguard setup with Physical standby database to ensure High Availability for production databases.
• Applied patches (PSU) to the Oracle Home and Database on a regular basis to keep them updated with the security fixes and priority fixes.
• Refreshed test and development databases with production data using RMAN duplicate database feature.
• Upgraded Oracle Grid Infrastructure and Database from Oracle 11.2.0.3 to 12.1.0.2
• Checked the configuration and performance of the existing databases including data file allocation, index, fragmentation and the impact on system performance. Analyzed potential problems (response delay, locking, server down time etc) and avoided it.
• Modified and established backup and recovery strategies and procedures using RMAN.
• Created MongoDB databases in test environments and managed it through user and role creation.
• Registered newly built databases in OEM 12c and deleted the targets associated with obsolete databases from OEM 12c.
• Upgraded Single Instance and RAC databases from 10.2.0.4 to 11.2.0.3 manually.
• Configured full backup of production, test and development databases using RMAN.
• Created Oracle 12c 12.1.0.1 Container database with pluggable databases using Database Configuration Assistant (DBCA).
• Dropped the obsolete databases using DBCA utility to retrieve space.
• Installed and Configured Golden Gate Setup for replication.
• Resolved Database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM).
• Designed and developed database tables along with the necessary constraints to enforce business rules.
• Involved in Schema management through creating various objects like tables, views, indexes, maintaining integrity through constraints.

Environment: Oracle 11g, Oracle 10g, RHEL 5.8/6.2, Oracle RAC, OEM Cloud Control 12c

Confidential, Irving, TX

Oracle DBA

Responsibilities:

• Installed and configured Oracle 10g/11g Databases on AIX and Linux Operating systems on Development, UAT and Production Systems.
• Designed and Implemented database security using Oracle roles and privileges.
• Maintenance of the RMAN repository database and configuration of backup policies.
• Created Oracle RAC 11gR2 databases with ASM Filesystem on Oracle Exadata Servers.
• Installed and Configured Golden Gate Setup for replication.
• Created Indexes, rebuilt and analyzed indexes to improve the performance of query.
• Monitored the database activities by developing shell scripts.
• Worked closely with developers to develop, maintain and evaluate PL/SQL codes and troubleshooting other issues.
• Upgraded Single instance and RAC databases from Oracle 10.2.0.4 to 11.2.0.2.
• Converted the single instance standby database to RAC using Oracle Enterprise Manager (OEM) 12c.
• Setup, Configured Oracle Data Guard using physical standby database and performed switchover/failover.
• Patched Oracle databases using OPatch utility and applied one-off patches to fix specific bugs as needed.
• Used OEM 12c to monitor Database health, query execution plans, bottlenecks and session information.
• Monitored scheduled jobs for backups, gathering statistics, checking data guard status and disk space utilization report.
• Used Oracle Database Upgrade Assistant (DBUA) for Upgradation and Migration of oracle database to higher version.
• Generated triggers for data integrity and created views to resolve complex queries.
• Performed Database Cloning to create Test and Development environments from Production.
• Imported and exported files, databases, schemas and tables using the datapump expdp and impdp utilities.
• Identified poorly performing queries using AWR reports, Explain Plans and assisted the developers in optimizing and tuning the SQL queries by creating the SQL profiles.

Environment: Oracle 11g, Oracle 10g, RHEL, SUN Solaris 2.7, Oracle RAC, OEM 12c, RMAN, SQL developer.

Confidential, Irving, TX

Oracle DBA

Responsibilities:

• Involved in designing and implementing Oracle backup and recovery methods using RMAN.
• Successfully implemented physical standby database using Oracle Data Guard feature for High availability configuration.
• Extensively used OPatch utility to Patch the Oracle Home and Databases to equip them with the latest bug fixes and security fixes.
• Developed some Unix Shell scripts to automate database operation and database monitoring.
• Implemented the changes in the database design and modified stored procedures in PL/SQL as per business requirement.
• Successfully Implemented key RMAN 10g features such as block change tracking, use of flashback recovery area and taking incremental backups to meet backup and recovery goals.
• Managed the databases on Oracle10g and 11g RAC. Configured storage devices using ASM
• Worked on the advanced features of Oracle 10g such as Automatic Shared Memory Management (ASMM) and Automatic Segment Space Management (ASSM).
• Developed scripts for refresh of databases in stage and development environments using datapump utilities and RMAN Duplicate database feature.
• Generated DDL statements for creation of new database objects like tables, views, sequences, synonyms, indexes and created triggers, packages, procedures, functions and granted privileges.
• Implemented and monitored all databases using Oracle Enterprise Manager (OEM) for maximum uptime and optimal performance.
• Used Oracle 10g Enterprise Manager db console tools such as ADDM, AWR for diagnosing & monitoring performance related problems.
• Provided support to Application Database Administrators in designing the database.
• Used Shell Scripts to automate database operation and schedule batch jobs using Crontab.
• Applied security patches on staging and production databases

Environment: Oracle 11g, Oracle10g, AIX, RHEL, Solaris, ASM, OEM Grid Control 11g, TOAD

Confidential, Irving, TX

Oracle DBA/Developer

Responsibilities:

• Identified bottlenecks that could potentially cause performance issues, involved the right teams (such as server administrators or application developers) and took corrective actions to rectify the issues.
• Installed and Implemented High Availability database solutions using Physical standby setup of Oracle Data Guard.
• Troubleshoot Database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM) and Tuned the database for optimum performance.
• Managed Schemas through creation of various objects like tables, views, indexes and maintenance of data integrity through constraints.
• Monitored all databases status including CPU, memory and query execution plans using OEM 10g.
• Developed PL/SQL packages, functions, stored procedures and triggers to implement business logics of oracle database.
• Automated the monitoring (shell scripts via cron) of the Oracle databases on Linux.
• Implemented database backups and developed disaster recovery strategies using RMAN.

Environment: Oracle 10g, SUN OS 5.8/5.9, Red Hat Enterprise Linux 4.5, Dataguard, Automatic Workload Repository, RMAN