PROFESSIONAL SUMMARY:

• Around 9 + years of experience as Oracle DBA especially in Exadata and Oracle proficient in database administration, production support, installation, configuration, upgrades, migration, performance tuning, backup and recovery, cloning, space management, capacity planning and database security with Oracle (8i, 9i, 10g, 11g, 12c) on Sun Solaris, Red Hat Linux, HP - UX, AIX.
• Planning, designing, developing, deploying and supporting RAC/ASM on MAA environment.
• Experience in Installation and Configuration of Oracle Real Application Clusters (RAC) on 2/4 nodes with Automatic Storage Management (ASM) on AIX and Red hat Enterprise Linux 5.x
• Experience with very large-scale database environment and mission critical OLTP and OLAP systems.
• Experience working on Oracle 12c container and pluggable databases and new features of Oracle 12c multi-tenant databases.
• Good hands-on experience in Exadata database machine Storage cell administration maintenance tasks by using cellcli dcli utilities.
• Good Understanding of Exadata smart storage capabilities, HCC, smart flash cache intelligent caching.
• Applied bundle patch to Oracle Exadata Database machine database, storage cells, INFINIBAND switch patching.
• Knowledge on Configuring Exadata Server metrics, Thresholds and Alerts Good knowledge about Exacheck, ADRCI, Imagehistory OSWATCHER.
• Good Experience in Applying Latest Bundle Patches to Exadata.
• Installed and Configured Physical data guard replication across data centers for Disaster Recovery
• Experience setting up Active Data guard (11g) for reporting and backup recovery.
• Experience in Backup & Recovery, Disaster Recovery options, Oracle Recovery Manager (RMAN).
• Advanced Backup and recovery using Oracle's RMAN software, used offline/online for recovery in a production environment with shell scripting.
• Experience in Managing Security, User groups and Users by using roles, grants, privileges and Profiles.
• Designed and Implemented Oracle Golden Gate solution for multi-site replication.
• Experience in setup of Oracle Grid Control 11g and Oracle Cloud Control 12c for monitoring production/dev/QA databases
• Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
• Provided service focused technical support remote and onsite to achieve effective troubleshooting, resolution of issues, and maximum customer satisfaction.
• Expertise in Installing and configuring ASM and RAC for high availability databases.
• Performed Strategic Planning, Logical and Physical Data Modeling & Application Tuning.
• Experience in Performance Tuning (I/O, Memory & SQL Tuning, Baseline etc.) by using tools/utilities like tkprof, sql PROFILE, A utomated Workload Repository (AWR), and Automatic Database Diagnostics Monitor (ADDM).
• Experience in Hot/Cold Backup and Recovery and Cloning of databases using RMAN.
• Good knowledge of Oracle Architecture, SGA, PGA, LISTENER, TNSNAMES, V$ and DBA Views.
• Performed various database upgrades ranging from oracle 9i to 10g, 9i to 11g and 10g to 11g
• Experience writing/setting up script to clone databases from Production to Test and Development using RMAN.
• Refresh of database from lower environments using export and import Datapump -expdp and impdp.
• Experience in Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, AWR report, 10gOEM Grid Monitoring custom scripts troubleshooting oracle databases using SQL trace utilities.
• Database security using Oracle Security Features (roles, privileges), auditing & Network ACL Config, Transparent data encryption, DBMS CRYPTO, etc.
• Good team player, self-motivated, dedicated in any work environment.
• Experience On-Call 24x7 as production support DBA.

Technical Environment:

Operating Systems: HP-UX 10.x/11.x, Sun Solaris 8/9/10, AIX 5.2/5.3/6.1, Red Hat Linux RHEL 7.3/8/9, SUSE 10.0 and Windows 2008 R2, 2012.

RDBMS: Oracle 8i,9i/10g/11g/12c,Exadata Oracle 10g/11g Real Application Clusters (RAC)

Languages: SQL, MYSQL, PL/SQL, C, C++, XML, Shell Scripting, Perl scripting.

Software/ Application Tools: OEM, DATAGUARD, GoldenGate, Exadata

Recovery Manager (RMAN), Datapump, STATSPACK, AWR, TKPROF, ADDM, ERWIN, ETL, Clusters, EMC Storage, DTS, Developer 2000, SQL Loader, TOAD.: Web Tools/

Reporting Tools: HTML, XML, Discoverer, BI- BO, crystal reports, Tableau.

PROFESSIONAL EXPERIENCE:

Confidential, South Plainfield, NJ

Sr Oracle DBA

Responsibilities:

• Responsible for maintaining & monitoring Critical OLTP application production and test databases (25+) for ICMP& AOW on RAC Real Application Clusters of 3 nodes and 4 nodes.
• Handled RAC 3 node and 4-node Builds, installation, configuration and SCAN listener’s configuration including role based service setup and building Active dataguard for production systems.
• Ongoing proactive database-level performance tuning, with a good working knowledge of Oracle internals.
• Experience Building Oracle Dataguard, Physical Standby and Active dataguard for Disaster recovery and managed through Dataguard broker and also Automating the Data Guard cutover and failback processes.
• Configured GoldenGate 12c RAC for Active-Active Replication between the Datacenter for High Availability.
• Setup configuration of Enterprise Manager OEM 12c for complete control of Exadata environment.
• Exadata Monitoring setup IB switch, Cell server and compute nodes.
• Assisted in management and database administration of Oracle database applications on Exadata platforms.
• Experience setting up backup and recovery policies with RMAN.
• Troubleshooting archive log transport failures for standby database
• Installed and configured GoldenGate in a prod and non-prod env, configured extract, data pump and replicate.
• Played a vital role in streamlining and consolidating all production and non-production databases on AIX, Linux.
• Creation of oracle users, oracle roles, granting privileges and profiles etc.
• Experience with My Oracle Support (MOS)/Metalink for Oracle SR, patch download.
• Deployed scripts for monitoring Goldengate lag and process (Extract, Datapump and replication).
• Resolved replication & lag issues in GoldenGate
• Scheduled backups (like Expdp, RMAN,and Archive log).
• Experience working on STAMP, PeopleSoft & Clarity applications and databases.
• Working with SAN team and raising SAN storage requests to add additional space to ASM disks when needed.
• Worked on OEM 12c Cloud Control, scheduling jobs in Autosys and crontab & deploying OEM agents. Scheduling Backup Jobs and troubleshooting failed jobs through OEM and modifying shell scripts where needed.
• Experience with variety of enterprise scheduling tools like Autosys and BMC Control-M.
• Experience setting for RMAN backups to tapes and disks and maintaining backup and recovery policy to ensure database standards at client is met.
• Performance testing (Stress testing) of third vendor applications for DB parameter settings, capacity planning (Memory, Space, CPU, Baseline) and SQL tuning.
• Responsible for Data refresh operations from prod to other environments using export Datapump and import as per business needs.
• Taken care of major releases in production environment.
• Worked with Oracle Support Team to resolve ORA-00600 and ORA-07445 errors in production databases and other Oracle bugs and applying patches when required.
• Performance Tuning i.e. Tuning RAC, tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms using AWR/ASH reports.
• Perform POC for testing DDL and DML replication across Databases using Goldengate 12c.
• Responsible for performing 24/7 on-call duties and handling critical priority tickets/incidents and resolving them on time. Performance tuning by analyzing SQL Execution plan, backup & recovery (RMAN, if required), managing users & privileges, resource limits etc.

Environment: Oracle 9i, 10g, 11g and 12c, OEM 12c Cloud Control and 13c, PeopleSoft, Stamp, TOAD, RMAN, Data guard, AIX 6.1, RHEL, RAC, ASM, SQL Developer, PL/SQL, Golden Gate, Exadata.

Confidential, Burns Harbor, IN

Sr.Oracle DBA

Responsibilities:

• Supported 250+ databases including RAC Production database, a Data warehouse database and lot of Development and Test databases.
• Installation of oracle software, creation, Upgradation and applying patches on database servers.
• Handling Production, Test and Development environments.
• Participated in analysis and designing of Oracle Exadata Server for infrastructure and related projects.
• Conducted analysis and feasibility studies for development of Oracle Exadata solutions.
• Assisted in integration of Exadata applications into current IT actionable events and solutions.
• Testing of hot backup and cold backups on regular basis.
• Created and maintained different database entities included tablespaces, datafiles, redo log files, renaming/relocating of data files on servers.
• Managing the Users quota over User default tablespaces and temporary tablespaces.
• Logical backups using Export and Import utilities.
• Backing up Control files whenever a change made to database.
• Weekly taking physical backup of whole database.
• Maintaining archived data on appropriate storage devices.
• Implemented hot backups for all the production databases in 24*7.
• Implemented Logical backups for the production as well as test databases.
• Configured and Performing backups and recovery through RMAN utility.
• Database Recovery using backup when required.
• Provided all kinds of DBA support to development teams as well as production support to various applications.
• Cloned the Production Database for testing purpose.
• Maintained multiple databases.

Environment: Oracle 8i, 9i, 10g and 11g Exadata OEM 11g grid control, LINUX, IBM AIX, TOAD,SQL Developer, TKPROF, SQL Tuning, Data Modeling, Builds.

Confidential, Cambridge MA

Sr.Oracle DBA

Responsibilities:

• 10g/11g RAC Database Up-gradations.
• Responsible for RAC 10g/11g database, client installation Software for 9i, 10g and 11g Enterprise Edition.
• RAC Database and SQL tuning
• Database Capacity Planning
• Apply CPU, DST, RDBMS patches to RAC Databases as per the requirement.
• Supporting OS Patching activity for all RAC Servers.
• Create databases for development, testing and production (including RAC databases and NON-RAC databases).
• Perform refreshes from RAC to RAC and non-RAC database to a RAC environment.
• Security Administration including the management of profiles, roles, users and their privileges.
• Configure and manage RMAN backup.
• Clone RAC databases with various strategies like Cold/Hot/Logical Refresh and RMAN Backup.
• Implemented Disaster Recovery Plan.
• Basic Administration of Data guard database.
• Supported SAN Migrations: Moved ASM disk groups from one server to other server.
• Breaking up RAC for few instances.
• Cloning from cluster database to Normal database and Cloning from Normal database to cluster database.
• Used Oracle 12c grid control and installed, upgraded and troubleshoot OEM agents.

Environment: RAC/ASM, Oracle 10g,11g, Oracle Enterprise Manager 10g/12c Grid Control, Putty, RH Linux 5.2/6.2, VERITAS Net Backup, BLIB, BC and RMAN

Confidential

Oracle DBA

Responsibilities:

• Responsible for RAC 10g/11g database, client installation Software for 9i, 10g and 11g Enterprise Edition.
• RAC Database and SQL tuning
• Database Capacity Planning
• 10g/11g RAC Database Up-gradations.
• Apply CPU, DST, RDBMS patches to RAC Databases as per the requirement.
• Supporting OS Patching activity for all RAC Servers.
• Migrate RAC databases across Database servers.
• Create databases for development, testing and production (including RAC databases and NON-RAC databases).
• Perform refreshes from RAC to RAC and non-RAC database to a RAC environment.
• Security Administration including the management of profiles, roles, users and their privileges.
• Configure and manage RMAN backup.
• Clone RAC databases with various strategies like Cold/Hot/Logical Refresh and RMAN Backup.
• Implemented Disaster Recovery Plan.
• Basic Administration of Data guard database.
• RAC Instance migration from one server to other server using Quality Center Tool.
• As part of maintenance activity changed few OCFS2 parameters.
• On RAC systems did CRS upgrade,ASM upgrade, DB Upgrade and OEM Agent Upgrade.
• Supported server upgrades.
• Supported SAN Migrations: Moved ASM disk groups from one server to other server.
• Breaking up RAC for few instances.
• Added new clusters to the existing clusters ( Added 4 nodes to the existing 3 node cluster )
• Cloning from cluster database to Normal database and Cloning from Normal database to cluster database.
• Used Oracle 12c grid control and installed, upgraded and troubleshoot OEM agents.

Environment: RAC/ASM, Oracle 10g,11g, Oracle Enterprise Manager 10g/12c Grid Control, Putty, RH Linux 5.2/6.2, VERITAS Net Backup, BLIB, BC and RMAN

Confidential

Oracle DBA

Responsibilities:

• Responsible for database, client installation Software for 9i & 10g Enterprise Edition.
• Created databases for development, testing and production (including RAC databases and NON-RAC databases).
• Cloned databases with various strategies like Cold/Hot/Logical Refresh and RMAN Backup.
• Implemented Partitioning on OLAP system.
• Object/Schema level re-org whenever the fragmentation is found.
• Implemented Disaster Recovery Plan.
• Added/configured the database for database monitoring in Grid.
• Worked on Restore and Recover of databases.
• Basic Administration of Data guard database.
• Experience in opening, managing, and resolving Oracle Service Requests.
• Developed UNIX shell scripts to carry out routine checks on databases.
• Administrate RAC service with SRVCTL.
• Managed the Cluster Services in case of any abnormal failures.
• Instanced migration from one server to other server using QualityCenter Tool.
• Implemented Critical Patch Updates which Oracle provides for each server.
• Converted table spaces from Non-ASSM to ASSM.
• As part of maintenance activity changed few OCFS2 parameters.
• Cloned RDBMS homes from one server to other server.
• On RAC systems did CRS upgrade,ASM upgrade, DB Upgrade and OEM Agent Upgrade.

Environment: Oracle 9i,10g,11g, Oracle Enterprise Manager 10g Grid Control, TOAD 9.1, SQL*Net8 TKPROF, Putty, Linux 2.6.9, Sun Solaris 5.10, VERITAS Net Backup, BC and RMAN