SUMMARY

• 8 years of experience as an Oracle DBA (10g,11g&12c).
• 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.
• Experience in advanced recovery methods like PITR and TSPITR.
• Experienced in Configuring and Maintaining Standby databases (Data Guard) in Oracle 11g and 10g.
• 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 11g and 10g Real Application Clusters (RAC) on multiple nodes.
• Experience in Upgrade of Single Instance and RAC databases from Oracle 10g to Oracle 11g 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 Gloden Gate Installation and configuration for replication.
• Implemented Oracle partitioning to improve teh performance.
• Experience in using Oracle Enterprise Manager (OEM 12c) 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.

PROFESSIONAL EXPERIENCE

Confidential, Jacksonville, FL

Oracle DBA

Responsibilities:

• Upgraded Single Instance and RAC databases from 11.2.0.2/11.2.0.4 to 12.1.0.2 manually and also using Database Upgrade Assistant.
• Created Physical Standby Database for teh Dataguard setup manually and also using Oracle Enterprise Manager Cloud Control 12c.
• Performed teh Dataguard Switchover and Failover procedures using OEM 12c and also manually.
• Configured Dataguard Broker for managing teh Dataguard setup.
• Applied latest PSU Patches to teh Oracle Grid Home and Database Home to ensure teh database against teh security vulnerabilities and Oracle bugs.
• Monitored teh Database Performance using OEM Cloud Control 12c and ensured teh Optimum performance of teh databases.
• Cloned teh Oracle databases using Active database duplication feature of RMAN.
• Created users and assigned them appropriate roles to guarantee teh security of teh database.
• Refreshed data from Production to developed environments using datapump expdp and impdp utilities.
• Refreshed 2TB database from Production to QA environment using RMAN.

Confidential, Austin, TX

Oracle DBA

Responsibilities:

• Implemented Dataguard setup wif Physical standby database to ensure High Availability for production databases.
• Applied patches (PSU) to teh Oracle Home and Database on a regular basis to keep them updated wif teh security fixes and priority fixes.
• Refreshed test and development databases wif 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 teh configuration and performance of teh existing databases including data file allocation, index, fragmentation and teh 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.
• Registered newly built databases in OEM 12c and deleted teh targets associated wif 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 wif pluggable databases using Database Configuration Assistant (DBCA).
• Dropped teh obsolete databases using DBCA utility to retrieve space.
• Installed and Configured Gloden 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 wif teh 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, RMAN

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 teh RMAN repository database and configuration of backup policies.
• Created Oracle RAC 11gR2 databases wif ASM Filesystem on Oracle Exadata Servers.
• Installed and Configured Gloden Gate Setup for replication.
• Created Indexes, rebuilt and analyzed indexes to improve teh performance of query.
• Monitored teh database activities by developing shell scripts.
• Worked closely wif 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 teh 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 teh datapump expdp and impdp utilities.
• Identified poorly performing queries using AWR reports, Explain Plans and assisted teh developers in optimizing and tuning teh SQL queries by creating teh 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 teh Oracle Home and Databases to equip them wif teh latest bug fixes and security fixes.
• Developed some Unix Shell scripts to automate database operation and database monitoring.
• Implemented teh changes in teh 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 teh databases on Oracle10g and 11g RAC. Configured storage devices using ASM
• Worked on teh 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 teh 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 teh right teams (such as server administrators or application developers) and took corrective actions to rectify teh 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 teh 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 teh monitoring (shell scripts via cron) of teh 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