SUMMARY

• Having 10+ years of experience in Oracle SI, RAC, EBS Databases & Exadata Database Machine Administration(DMA).
• Setting up Oracle 11g/12c SI & RAC database & Exadata Engineered System environments.
• Involved in Database Architect, Data Analysis, Data modeling and Database Designing.
• Installation, configuration and managing of Big Data and Hadoop Cluster.
• Upgrading SI, RAC, Apps R12 & Exadata/ODA/SuperCluster enviroments.
• Handled Database migrations, Replatformings from On - primises Exadata to AWS EC2.
• Implemented and migrated Oracle RAC on SuperCluster & Exadata Systems.
• Manageing and Monitoring Exadata Storage Server Administration.
• Creation and Administration of High Availability Services.
• Database performance analysis and tuning.
• Creation and Administration of Physical, Snapshot & Logical Standby Databases.
• Performed number of dev, test cloning from PROD databases.
• Install & Configure Oracle GoldenGate as per the requirement.
• Planning and managing hardware and software required for Hadoop cluster.
• Experience in importing and exporting the data using Sqoop.
• Involved in R12 Oracle Apps implementation life cycle with Oracle Database 11g.
• Various sysadmin functions like administer concurrent managers, defining users, request sets and submitting requests.
• Administered all databases in the areas of maintenance, tuning, performance, and troubleshooting.
• Performed Performance tuning through Application or SQL tuning, Memory tuning, I/O tuning.
• Performance Monitoring & Tunings Cluster nodes.
• Performed troubleshooting activities on Oracle SI, RAC, Apps & Exadata envs.
• Oracle EM Grid & Agent configurations and Montioring database environments.
• Resolved Node Evictions on Oracle Cluster environments.
• Handling Hypervisor Servers(Dom0) and Virtual Machines
• Prepared standard documentation for patching, Cloning, Upgradation process.
• Space Management and Disk Performance Monitoring.
• Knowledge in Predictive Index Reorganization utilizing Index Advisory and Reducing LIOs.
• Application Code Reviews in PL/SQL, Performance Testing using Oracle Database Replay .
• Experience and extensive knowledge in Database Fine-tuning and Optimization on Oracle 12C/11G/10G/9I, Oracle Apps 11i & R12, Oracle Exadata & SuperCluster.
• Experience and extensive knowledge in Cloud & Virtual Platforms.
• Very flexible and can work independently as well as in a team environment.
• Experience with Various ticketing tools for resolving the tickets.
• UNIX shell scripting
• Provided 24 x 7 database administrative activities
• Provided 24x7 support and On-Call rotation when needed for very large databases.

TECHNICAL SKILLS

• Oracle 9i 10g 11g & 12c
• Oracle Exadata & SuperCluster
• Oracle RAC & ASM
• Oracle Grid (OEM) & Agents
• Oracle GoldenGate & Streams
• Performance Tuning
• TOAD
• SQL Developer
• Oracle Data Guard (DG)
• Oracle VirtualBox & VMWare
• MongoDB
• Oracle Apps 11i & 12R
• SQL
• PL/SQL & HiveQL
• Oracle Application Express
• Linux
• AIX
• Solaris & HPUX
• Oracle RMAN & BMC SqlBacktrack
• Puppet
• Chef & Nagios
• Shell Scripting
• ORAchk/Exachk & TFACollector
• Hadoop & Eco Systems
• Core Java
• Amazon EC2 & RDS
• Microsoft SQL Server

PROFESSIONAL EXPERIENCE

Confidential, Washington DC

Sr. Oracle Database Consultant

Responsibilities:

• Managing day-to-day activities and Exadata V1 databases maintenance
• Handling System outage or Failed disk replacements or any failures on Oracle Exadata V1.
• Suspect and handling network issues on Oracle Exadata.
• Backup of Database and Database Server on Oracle Exadata.
• Installation and configuration of 12c EDW development environment on AWS Cloud.
• Involved Data Analysis, Data modeling and Database Designing.
• Resolving Oracle errors and failures, auditing activities, and resource utilization.
• Building EDW & Application Repository Databases.
• Replatformed EDW data from EXADATA to AWS cloud.
• Created and managed High Availability 11g/12C RAC Linux clusters utilizing Data Guard in compliance with Oracle's Maximum Availability Architecture (MAA).
• Migrated databases to Oracle Exadata Database Machine for different clients
• Upgraded Oracle databases from 11g to 12c.
• Implemented OEM Cloud Control 12c Agent installations, plug-ins installations and adding targets to OEM.
• Monitored all the databases using OEM 12c cloud control.
• Database PerformanceTuning (Instance & SQL Tuning).
• Performance tuning through Application or SQL tuning, Memory tuning, I/O tuning.
• Performance Monitoring & Tunings Cluster nodes.
• Implemented Index Strategy on AWS Environment
• Tested new environment and worked with Informatica and Business Object teams as required.
• Capacity planning for the projects owned in the environment.

Environment: Oracle 11g & 12c, Exadata, AWS, ETL, SAP BI, SQL & PL/SQL,Shell Scripting, UNIX & Performance tuning.

Confidential, Redwood City, CA

Database Machine Administrator

Responsibilities:

• Installed, configured and maintainedOracle 12c/11g RAC Databases on various Exadata Systems.
• Configured and Managed Cell Storage and Database administration of Oracle database applications on various Exadata Systems.
• Configured 11g/12c SI,RAC & Exadata environments.
• Configured Oracle Exadata Using Oracle OneCommand Utility.
• Configured Oracle Database and Oracle ASM Instances for Oracle Exadata.
• Managing Exadata Storage Servers, Oracle Database Servers and Verifying the InfiniBand Network
• Installing Oracle Enterprise Manager Grid Control on Oracle Exadata.
• Deployed the 12c agents on the target servers and add the target Configuration Items to monitor.
• Plug-in installations on the target servers to extend the functionality of OEM
• Configured Oracle Advanced Security to implement Transparent Data Encryption at table space, table and column levels. Also configured Redaction using OEM's Policy expression builder.
• Setup physical standby’s (DATAGUARD) for several Databases (via OEM as well).
• Researched, implemented, tested and configured various performance tuning methodologies including
• OLTP compression
• HCC (Hybrid columnar compression for EXADATA)
• Exadata Scan query specific - Compress for query high/low
• Storage Savings specific - Compress for Archive high/low
• Implemented DBFS on EXADATA and Troubleshooting Exadata smart scan/offloading issues.
• Monitored the Infiniband Switches/ports, HCA ports on DB/CELL nodes and IB topology
• Migrated databases to Exadata Setting and Monitoring Exadata using OEM12c
• Maintained and troubleshot Exadata Cell/Storage and DB/Compute node performance issues.
• Implemented Goldengate Unidirectional/Bidirectional replication on RAC using ACFS file system..
• Configured Data guard broker between the primary and standby databases, perform Switchover/Failover and monitor the Dataguard status
• Applying Patches or upgrades of Exadata softwares, Oracle Database & Grid.
• Suspect and handling network issues on Oracle Exadata.
• Backup of Database and Database Server on Oracle Exadata.
• Handling System outage or Failed disk replacements or any failures on Oracle Exadata.
• Upgrade the databases from 9i, 10g to 11g & 12c and regularly applying patches using Opatch.
• Have fine-tuned numerous SQL statements for batch operations, which reduced processing time from several hours to few minutes.
• Install, configure and support uni-directional and bi-directional Oracle-to-Oracle replicated environments utilizing Golden Gate.
• Created and managed High Availability 11g/12C RAC Linux clusters utilizing Data Guard in compliance with Oracle's Maximum Availability Architecture (MAA).
• Manage Oracle database configurations utilizing Golden Gate and Data Guard to ensure maximum availability and data protection.
• Upgrade the databases from 9i to 10g and 10g to 11g & 12c and regularly applying critical patch updates using Opatch.
• Perform in-place rolling upgrades of RAC instance.
• Manage and support multiple oracle nodes version 10g/11g/12c RAC with ASM
• Having experience in building Oracle Best Practice & Analyzing tools (ORAchk/EXAchk, Collection Manager & TFA Collector).
• Installation, configuration and managing of Big Data and underlying infrastructure of Hadoop Cluster.
• Planning and managing hardware and software required for Hadoop cluster.
• Experience in importing and exporting the data using Sqoop from HDFS to Relational Database systems/mainframe and vice-versa.
• Developed PIG Scripts to parse and analyze logs (Application logs and message logs) to capture Errors, Warnings & other events that may cause suspension or halt the automated jobs.
• Collaborating with application teams to install operating system and Hadoop updates, patches, version upgrades when required.
• Configuring Oracle 11g & 12c RAC environments on Virtual Platforms.
• Manage multiple oracle databases using enterprise manager 12c.
• Handling Hypervisor Servers(Dom0) and Virtual Machines.

Environment: Oracle 11g & 12c, EXADATA/SuperCluster, ODA, Performance tuning, Oracle ApEx, Bigdata & Hadoop, Oracle VirtualBox, Orachk/Exachk, SqlDeveloper, Shell Scripting, UNIX, Windows.

Confidential, Richmond, VA

Sr. Oracle Database Consultant

Responsibilities:

• Oracle Clusterware Installations and SI & RAC database Creations.
• Extensively worked on GoldenGate implementation like installation, configuration GOLDENGATE unidirectional, Bi-directional and broadcast data distribution in classic capture mode on Oracle 11g LINUX.
• Migrated Oracle databases using Oracle 11g GOLDENGATE.
• Configured Exadata X2-2, X2-8 and have a good knowledge on smart flash cache, storage index, storage management and migration.
• Troubleshot 2node and 4node RAC and implemented 11g New ASM features.
• Setup physical standby database using Data guard and implemented new 11g feature such as Active Dataguard and Snapshot standby database.
• Implemented switching primary database to standby and standby to primary during regular maintenances of catalog databases and DR databases.
• Configured OEM 12c monitoring with customized templates and email alerts.
• Configured ASM and handled issues and suggested feasible workarounds for ASM Metadata corruption.
• Extensively worked with ASMCMD for managing ASM.
• Performed DR drill activity.
• Applied patch set and interim patches using OPATCH for upgrading the binaries.
• Provided Instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical I/O and Memory Usage.
• SQL query tuning using tools like Explain Plan, SQL*Trace, TKPROF, SQL Tuning Advisory.
• Installed SQLTXPLAIN (SQLT) Tool that helps to diagnose SQL statements performing poorly.
• Used Oracle AWR & ADDM to monitor database activities and performance tuning.
• Performed Range Partitioning as a cause to improve the performance of the database.
• Proactive performance monitoring, and capacity planning for future database and server growth using OEM.
• Setup physical standby’s (DATAGUARD) for several Databases.
• Applied necessary Patches during installation and also in up-gradation of databases on Oracle 11g database versions.
• Extensive Experience with Change Control Management for all database changes.
• Performed Cross platform migration using transportable table spaces and RMAN.
• Data Refresh from Production to Development and Test environments using Data Pump export/import
• Involvement in space management, rectification of lock problems, user management.
• Supported Application developers with various performance, connectivity and security related issues on various projects.
• Scheduled Jobs and Backups using 12c OEM and CRONTAB.
• Handled backups and recovery using RMAN shell Scripts.
• Involved in 24×7 Production Support with on-call pager.
• Resolving Oracle errors and failures, auditing activities, and resource utilization.
• Having Good Knowledge on Oracle Exadata & Hadoop Bigdata Environments

Environment: Oracle 10g, 11gr2, HP-UX, REDHAT LINUX, SUN SOLARIS, IBM AIX, OEL 5.8, OEM12c, RAC, Golden Gate, Oracle Exadata, Oracle Fail Safe, RMAN, EXPDP/IMPDP, Partitioning, ASM, DBFS, Data guard including DGMGRL, Performance tuning, OPATCH Utility, TOAD, DB, SQL Developer, Shell Scripting.

Confidential

Sr. Database Administrator

Responsibilities:

• Oracle Clusterware Installations and SI & RAC database Creations.
• Supported different Oracle 10g and Oracle 9i Databases of Production, Testing, Staging and Training.
• Installed and configured 8 Node RAC on 10gR2.
• Installed standalone servers on ASM and migrated databases to ASM environment.
• Configured Oracle Data guard on 10G for Oracle Disaster recovery. Worked on both Physical standby and Logical standby databases and resolved issues in DR environment.
• Converted Physical standby to Snapshot standby for testing purposes.
• Achieved High Availability, Data Protection and Maximum performance by maintaining both physical and logical standby databases.
• Implemented Oracle database backup & recovery solutions using RMAN and export/import.
• Restored and Recovered databases at the times of occurrence of critical failures.
• Performed cloning and refresh of Database from production environment to test environment using RMAN Duplicate database and Data pump import export.
• Upgraded databases using Database Upgrade Assistance (DBUA).
• Involved in the optimization of various SQL and PL/SQL using EXPLAIN PLAN and TKPROF.
• Optimized SQL statements using Indexes and Hints.
• Managed table spaces, user profiles, indexes, storage parameter’s.
• Developed UNIX shell scripts to perform the above tasks efficiently.
• Upgrading Clusterware & SI/RAC databases.
• Convert non-ASM instance to ASM instance using RMAN
• Administer ASM instance by using SQL plus and ASMCMD command line
• Manage and support multiple oracle nodes version 10g/11g RAC with ASM
• Analyzed past reports to identify harmful trends such as row chaining, fragmentation. Reviewed Changes in segment growth to check harmful growth periodically. Troubleshoot database problems using the trace files.
• Manage backup of cluster ware files by using OCRCONFIG utility
• Provide guidance to the development team to write tuned SQL statements and to tune ad hoc SQL's to run at optimum Performance.
• Worked on Partitioning, Materialized views to improve performance.
• Logical Backup of Databases using EXP/IMP Utility EXPDP&IMPDP and perform schema refresh
• Installation and maintenance of Oracle 10g & 11g data guard for Physical standby databases
• Perform Periodic Maintenance of Databases with Database online Reorganization.
• Involved in Oracle Apps 11i implementation life cycle with Oracle Database 10g.
• Administering & Maintaining Oracle Application with AD utilities- adpatch,adadmin, adctrl, adclone, adrelink, autoconfig etc.
• Various sysadmin functions like administer concurrent managers, defining users, request sets and submitting requests.
• Run diagnostics and troubleshoot bottlenecks. Support existing applications and excellent trouble shooting skills.
• Resolving Oracle errors and failures, auditing activities, and resource utilization.
• Provided 24 x 7 database administrative activities.
• Having Good Knowledge on Oracle Exadata & Hadoop Bigdata Environments

Environment: Oracle 9i, 10g & 11g, Oracle Apps 11i, VMware, Toad, Partitioning, ASM, DBFS, Data guard including DGMGRL, Performance tuning, OPATCH Utility, TOAD, DB, SQL Developer, Shell Scripting.

Confidential

Database Administrator

Responsibilities:

• Managing day-to-day activities and database maintenance.
• Database creation as per requirements.
• Scheduling Full and Differential Backups for the user and system databases.
• Creation of additional tablespaces and adding data files to tablespaces.
• Monitoring the scheduled backups, and refiring the backups in case of failures.
• Creation and maintenance of the users along with security roles and privileges.
• Taking Online, Offline and RMAN Backups.
• Database monitoring and Administration activities.
• Performed number of dev,test cloning from Prod databases.
• Installation and maintenance of Oracle 10g & 11g data guard for Physical standby databases
• Logical Backup of Databases using EXP/IMP Utility EXPDP&IMPDP and perform schema refresh.
• Created and modified PL/SQL objects like Packages, Stored Procedures and Triggers.
• Configured RMAN backups and resolving issues arising out of those.
• Rebuilt indexes for better performance of Oracle database.
• Oracle SQL*LOADER, Oracle Export/Import Tools and utilities.
• Responsible for Data load on different databases using SQL*Loader.
• Resolving Oracle errors and failures, auditing activities, and resource utilization.

Environment: Oracle 9i & 10g, SQLDeveloper,Toad, SQL & PL/SQL UNIX, Windows.