SUMMARY

• Having 7 years of experience in Oracle SI, RAC, APPS & Database Machine Administration(DMA).
• Setting up Oracle 11g/12c SI & RAC database & Engineered System environments.
• Involved in 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.
• Administering & Maintaining Oracle Application with AD utilities- adpatch,adadmin, adctrl, adclone, adrelink, autoconfig etc.
• Applied various types of patches using Opatch, Adpatch & Oplan on SI, RAC, Apps R12 & Exadata/ODA/SuperCluster enviroments.
• 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.

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
• 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

PROFESSIONAL EXPERIENCE

Confidential, Washington, DC

Senior 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).
• Database Performance Tuning
• Implemented Index Strategy on AWS Environment
• Tested new environment and worked with Informatica and Business Object teams as required.
• Handling Hypervisor Servers(Dom0) and Virtual Machines.

Environment: Oracle 11g & 12c, EXADATA, Oracle, SQL & PL/SQL,, Shell Scripting, UNIX.

Confidential, Redwood City, CA

Database Consultant

Responsibilities:

• Configuring 11g/12c SI,RAC & Exadata environments.
• Configuring Oracle Exadata Using Oracle OneCommand Utility.
• Configuring Oracle Database and Oracle ASM Instances for Oracle Exadata.
• Checking Exadata Storage Servers, Oracle Database Servers and Verifying the InfiniBand Network
• Installing Oracle Enterprise Manager Grid Control on Oracle Exadata.
• 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, Oracle ApEx, Bigdata & Hadoop, Oracle VirtualBox, Orachk/Exachk, SqlDeveloper, Shell Scripting, UNIX, Windows.

Confidential

Database Consultant

Responsibilities:

• Oracle Clusterware Installations and SI & RAC database Creations.
• 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.
• Having Good Knowledge on Oracle Exadata & Hadoop Bigdata Environments

Environment: Oracle 10g & 11g, Oracle Apps 11i, VMware, Toad, SQL & PL/SQL UNIX, Windows.

Confidential

Database Administrator

Responsibilities:

• Managing day-to-day activities and database maintenance.
• Oracle Databases SI and Cluster Administration.
• 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.
• Resolving Oracle errors and failures, auditing activities, and resource utilization.

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