SUMMARY:

• Experienced, passionate and motivated Database Administrator with 5 years of extensive experience in Oracle Database administration. Responsible for the implementation, design, and optimization of various database environments ranging from small business databases to large enterprise databases. Experience involves Installation, Configuration, Performance Tuning, Patch Installation, Upgrades, Backup and Recovery, Cloning, Migration, Replication, RAC, Data Guard, Golden Gate, monitoring and optimization of Oracle databases. Great team player, quick learner and excellent motivator that has been very instrumental in vital DBA team collaborations, and has also excelled working alone in various environments.
• Experience in Installation, Configuration of Oracle Standby/Data Guard.
• Installed and Configured Golden Gate setup to achieve unidirectional replication.
• Performed database backup and recovery using RMAN .
• Experience in installation and support OEM Grid control 10G/11G/12c.
• Experience in Backup & Recovery using Data Pump, Hot, Cold, Logical and RMAN
• Experience in maintaining Database Security using auditing.
• Experience in performance monitoring, tuning and troubleshooting.
• Experience in applying security patches ( Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU) using runInstaller and opatch .
• Knowledge of RAC databases.
• Experience in Data Migrations.
• Involved in Configuration of Manager, Replicate and Extract processes and implemented unidirectional, bidirectional replication using Oracle 11g Golden Gate on Linux platform .

PROFESSIONAL EXPERIENCE:

Confidential - Indianapolis, IN

Oracle Database Administrator

• Providing database administrative support and 24x7 on call support for production, development oracle 12c/11g databases on Red Hat Linux 5.0 and oracle enterprise Linux 5.5
• Involved in Isntallation and configuration of Golden Gate 11G/12C software.
• Involved in Configuration of Golden Gate components for unidirectional and bidirectional replications.
• Managing database security.
• Creating and assigning appropriate roles and privileges to users depending on the user activity.
• Installed and configured Oracle (10g&11g R2) databases on Linux 5, HP-Unix 11.X.
• Upgraded Oracle database from 10.2.0.3 to 11.2.0.2 .
• Applied Critical Patch Updates and Patch Set Update (CPU/PSU) on various platforms using Universal Installer and OPatch Utility.
• Have touch-point calls with offshore team and make sure all issues happen in off business hours are addressed with sense of urgency.
• Successfully upgraded the databases from 11g to non CDB 12c .
• Created Oracle Wallets and implemented Tablespace level TDE security.
• Managed Database Maintenance Activities to achieve optimum database uptime.
• Configuration of Listener and Tnsnames.
• Doing the regular activities like monitoring the alert logs, redo log status, listener. Log and checking the space for normal segments, rollback segments and tablespaces.
• Monitored and optimized database performance using Oracle Enterprise Manager (OEM) 11g Grid control.
• Performed database backups with RMAN incremental and cumulative backups by registering 10g/11g databases in recovery catalog.
• Performed database tuning using Explain plan, Stats Pack, TKPROF, SQL tuning advisor, SQL access advisor, SQL planned management tools and AWR (automatic workload repository), ADDM (automatic database diagnostic monitor) and ASH reports and performed database tuning based on the recommendations suggested by ADDM reports.
• Performed other Oracle DBA responsibilities performance tuning, monitoring tablespaces, monitoring users, etc .

Confidential - Deerfield, IL

Oracle Database Administrator

• Successfully installed and configured Oracle 12.1.0.2, Oracle databases on Linux platforms.
• Used TOAD for database management.
• Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 13c cloud Control.
• Performed SQL tuning, and monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM) and Active Session History (ASH).
• Installing, configuring and maintaining Enterprise Manager Cloud Control to monitor and manage databases.
• Developed RMAN Cold Backup Script to take backups automatically every week for about 45 databases vary in size from 200GB to 2TB and automated the process through crontab.
• Involved in Configuration of Data Guard to ensure high availability, data protection and disaster recovery for enterprise data.
• Experienced in cloning the databases using HOT and COLD backups.
• Database monitoring/maintenance using OEM (Oracle Enterprise Manager).
• Documented the Standard Processes for peers to follow.
• Involved in Installation and Configuration of a 2-node oracle 11G RAC Databases.
• Performed full & incremental backup (cumulative and differential) using RMAN and implemented recovery strategies.
• Involved in converting a single instance database to Oracle 11g, 10g RAC databases.
• Refreshed/cloned databases using RMAN utility.