SUMMARY:

• Database Administrator with more than 5 years of experience in high volume and high availability environments. Expertise in both production and development settings. Great problem solving skills. Proficient in backup and recovery, performance tuning and data migration. Good in documentation and communication, sound interpersonal and leadership skills. Sharp problem solving abilities and goal - oriented attitude.
• Authorized to work in the US for any employer

TECHNICAL SKILLS:

Operating Systems: Red Hat Linux RHEL 5.x and WindowsXP

RDBMS: Oracle 10g/11g

Languages: SQL, PL/SQL, UNIX Shell Scripting, Ksh, bash and Perl Scripting

Tools: DBCA, DBUA, Recovery Manager (RMAN), OEM Grid Control, Oracle Data Guard, Oracle Management Service (OMS), Agents, Real Application Clusters (RAC), ASM, SqlDeveloper, TOAD, Exp/Imp, DataPump (expdp/impdp),SRVCTL,SQL*Plus, Recovery catalog,Autosys, Crontab

Tuning Tools: SQL TRACE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDMetc

PROFESSIONAL EXPERIENCE:

Confidential, Salt Lake City, UT

Oracle Database Administrator

Responsibilities:

• Involved with OLTP relational databases system analysis, design, implementation and management.
• Upgrade/Migration of Databases from Oracle 9i to 10g, Cross platform migration from different platforms.
• Working as GCP and Non GCP ADBA Consultant managing 100+multiple oracle database environments on Production UAT, Test, DEV database and golden gate.
• Setup and configured replication using GoldenGate and Data Guard in physical and logical mode.
• Plan for new Servers/RAC Databases to host databases that are as big as 3 Terabytes in size.
• Responsible for setting up Oracle Golden Gate to help in propagating information between databases.
• Implementation of Oracle Golden Gate from Oracle 10g database to 11g database
• Responsible for installing and configuring Golden Gate for Oracle using 11g R2.
• Usage of Partitions to improve the query performance and manageability.
• Created users, granted roles and privilege management. Maintained user accounts and privileges to maintain application security.
• SME on partitioning Advanced Compression and other core DBA functions.
• Cloning databases using scripts as well as RMAN. Installation, setup and configuration of Data guard.
• Analysis on SQL and Services with high CPU, Memory usage, AWR analysis, ADDM (Automatic Database diagnostic Monitor report), Active Session History (ASH).
• Monitoring production database and provide detailed analysis on Long running, Resource consuming SQLs, Wait events, Locks and Alert log file.
• Providing suggestion and workaround to Tune the Bad Performing SQL by giving Index and Stats fixwith the help of Execution plan and Predications
• Monitoring and working in Oracle Golden Gate support activities like new configuration, deployment on existing configuration and Release activities.
• Managing Golden Gate abended, stopped process, errors, alerts and lag alert using golden gate director.
• Provide assistance and technical support to all database end-users and addressing all OEM, BMC PE Alerts for Sev2, Sev3, and Sev4 etc.
• Database schemaMigration activities using oracle golden gate, data pump (Expdp/Impdp).
• Database housekeeping activities that can reclaim space at both OS & DB Level.
• Responsible for performance tuning the applications by capturing and tuning database performance metrics, System metrics and resolving issues like deadlocks, Locking, slow performing queries using SQL Advisor, Baselinesand other tools (SQLT).
• Installation, configuration, maintenance and tuning of Oracle RDBMS 10g -12c in Production, QA, and Test environments as well as 10g Forms and Reports and 10g-11g Application Suite.
• Oracle Database Upgrades 10g to 11g, 11g and 11gr2 to 12c.
• Migrating and consolidation of 11g databases into 12c in both QA and Production environments.
• Installation and consolidation of 12c multitenant database's in QA and Test environments. Container and Pluggable database administration and cloning.
• Troubleshooting Space Management & User accounts and privilege issues while coordinating with Unix and application teams.
• Performed proactive database maintenance procedures to ensure optimal performance and uptime and implemented shell scripts for automation of day to day activities.
• Identify Top SQL that are consuming heavy resources and provide support to the development team in identifying SQL queries that are consuming high resources and interact with the development team to see if these queries can be fine-tuned further.
• Regular Security Patching and Critical patch Updates (CPU) and Patch set updates (PSU) on Oracle databases and interim patches for various bug fixes on database products.
• Production support for Oracle database 10g/11g RAC.
• Monitoring space, wait events, locks and long operations running on the database
• Monitoring the session waits for the database performance and resolving the performance issues.
• Monitoring the database for growth and added space to the table spaces as per demand.
• Generating AWR/statspack reports on regular basis to identify the database performance at peak load.
• Tuning the SQL statement by analyzing the explain plan and ADDM reports
• Implemented scripts to monitor and get information on free space, alert log errors Provided maintenance of user accounts, privileges, profiles and roles.
• 1 Year experience using 11g and 12c GoldenGate, Director, including upgrading, setup and support in QA and production ODS.
• Ensured that ODS was always in sync with sources by using custom scripts, EM12c monitoring, and Goldengatedirector notifications.
• Upgrades, patching, and off-hours maintenance and change control execution in production 24/7 environments and hosting facilities using Remote desktop connection or Putty in conjunction with RSA -VPN.
• Applied quarterly PSU Patches Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN) and Network attached storage (NAS).
• Documented the Standard Processes for peers to follow.
• Applying upgrade patch, maintenance and interim (opatch) patches on all the databases.
• Refreshing Dev and Test instances with data from Production on a regular basis.
• Developed PL/SQL packages, DML, DDL, Oracle tables, Stored Procedures, functions, cursors, triggers and UNIX shell scripts.
• Knowledge in Oracle Data warehouse DBA skills relating to administration and management of VLDB environments, Oracle OLTP.
• Used Data Pump for export and import. Wrote scripts for Backup of databases, maintenance of archive logs for databases. Streamlined backup procedures and implemented RMAN for backup and disaster recovery.
• Database Refreshing / Replication from production to testing using Exp/Imp.
• Created logical and physical design installed and upgraded databases.
• Experience in writing UNIX/SHELL scripts for providing the reports.
• Installed and configured Oracle 11g database on a test server using Oracle standard procedures and OFA, for performance testing and future 10g production implementation.

Environment: Oracle 10g/11g RAC/9i, VMS, Sun Solaris, Windows Server 2003, Red Hat Linux, TOAD, RMAN, SQL server, OEM.

Oracle Database Administrator

Responsibilities:

• Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 10gGrid Control.
• Loading data from flat files to database using SQL*Loader, External Tables.
• Extensively used AWR, ADDM and explain plan for periodic performance tuning.
• Implementing Datapump, conventionalexport/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance.
• Used import/export utilities for cloning/migration of small sized databasesandDatapump import/export to move data between and 10g/11g environments.
• Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN.
• Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).
• Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN) and Network attached storage (NAS).
• Documented the Standard Processes for peers to follow.
• Applying upgrade patch, maintenance and interim (opatch) patches on all the databases.
• Implemented Flashback technology of the Oracle 11g, 10g along with Recyclebin for a faster recovery of the databases and database objects.
• Performed Database upgrade from Oracle 9i (9.2.0.7) to Oracle 10g (10.2.0.5) and to Oracle 11g (11.1.0.7) RAC database.
• Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.
• Achieved optimized performance for the databases by rebuilding indexes, on tables and indexes.
• Automated the processes like moving files, managing alert log, efficient backup by developing UNIX scripts.
• Implemented data guard for the critical production databases and tested switchover and failover. Logical standby databases for the real time DML apply in the remote databases. Disaster recovery plan for the production to standby database to check the data consistency.
• Maintain databases build database backup and recovery routines (RMAN), monitor database activities and conducting performance monitoring. Clone Development, test and UAT databases using RMAN.
• Handling multi-terabyte databases and the capacity planning for the data and application growth and recommend partitioning strategies for very large tables.
• Successfully implemented physical standby database using Oracle Data guard and Active Data guard feature for High availability configuration in RAC environment.
• Performed full & incremental backup (cumulative and differential) using RMAN and implemented recovery strategies.
• Refreshed/cloned databases using RMAN utility.
• Involved in the installation, configuration and extended support to Oracle 11g, 10g two Node RAC (Real Application Cluster) with ASM file system on AIX platform.
• Involved in converting a single instance database to Oracle 11g, 10g RAC databases.
• Installed ASM environment and migrated databases from NON-ASM to ASM.
• Used TOAD for database management.
• Made optimal use of Oracle Support in resolving the SRs.
• 24 X 7 Production & Development database support and administration.

Environment: Oracle 11.1.0.7, 10.2.0.5, IBM AIX V6.1, Suse Linux, RAC, ASM, RMAN, AWR, ADDM, SQL* Plus, SQL*Loader, OEM, TOAD 10.0.