SUMMARY

• 10 years of experience in Oracle SI, RAC, GoldenGate, EBS Databases, Exadata Database Machine Administration(DMA) & AWS Redshift/Dynamo/RDS Admin.
• 2+ Years of experience in AWS Databases (Redshift/Dynamo/RDS) Admin/Developer.
• Responsible for EDW migration from Oracle to Redshift cluster.
• Redshift Database Cluster Design and Administration.
• Managing Redshift Database Access Control and IAM roles.
• Managing and using AWS Cloud Services like SCT, DMS, Data Pipeline & Cloudwatch.
• Loading and Unloading data using services like Copy, Data Migration Services etc.
• Senior Oracle DBA with more than 8 years of IT experience in various products on multiple platforms.
• Replatformed Data Warehouse data from Oracle Database to AWS Redshift database.
• 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,GoldenGate, Apps R12 & Exadata/ODA/SuperCluster environments.
• Handled Database migrations, Replatformings from On - premises Exadata to AWS EC2.
• Implemented and migrated Oracle RAC on SuperCluster & Exadata Systems.
• Managing and Monitoring Exadata Storage Server Administration.
• Creation and Administration of High Availability Services.
• 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 the Hadoop cluster.
• Involved in R12 Oracle Apps implementation lifecycle 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 Monitoring database environments.
• Expertise in Oracle Exadata specified features such as Smart Scan, HCC, Smart Flash Cache, etc.
• Utilized GoldenGate for data replication and synchronization.
• Experience in Security Management and Database Auditing.
• 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 24x7 support and On-Call rotation when needed for very large databases.

TECHNICAL SKILLS

• Oracle 9i10g 11g & 12c
• Oracle Exadata & SuperCluster
• Oracle RAC & ASM
• Oracle Grid (OEM) & Guardium
• Oracle GoldenGate & Streams
• Performance Tuning
• TOAD
• SQL Developer
• Oracle Data Guard (DG)
• Oracle VirtualBox & VMWare
• MongoDB
• Dynamo DB
• 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
• AWS Redshift
• Amazon EC2/RDS

PROFESSIONAL EXPERIENCE

Confidential, Washington DC

Senior Database Consultant

Responsibilities:

• Managing day-to-day activities and Database Production Support.
• Responsible for large database Migration for cross-platform.
• Responsible for EDW migration from Oracle to Redshift cluster.
• Redshift Database Cluster Design and Administration.
• Managing Redshift database Access Control and IAM roles.
• Managing and using AWS Cloud Services like DMS, Data Pipeline & Cloudwatch.
• Extensively worked on Oracle GoldenGate installation, configuration, troubleshooting GG issues.
• Goldengate patching, upgrade, and solutions for compressed and encrypted tables.
• Performing data architect/design role and responsible for project delivery in a timely manner.
• Performed Database migration using various methods.
• Performed Installing Bundle patches on RDBMS & Grid Infrastructure.
• Responsible for Installation, patching, and support for Linux system while Coordinating and working with Oracle support service on ASR requests
• Responsible for Capacity planning and managing infrastructure and ASM storage migration.
• Worked on NetBackup to configure/setup backups and RAC Database migration across operation system.
• Responsible for tuning for I/O Contention, Memory contention, Row Migration, Block Contentions, etc.
• Export and Import of database objects to copy from one database to another database and convention oracle export, import for oracle 11g/12C RAC and standalone databases.
• Managing Oracle 12c EDW environment on AWS Cloud.
• Resolving Oracle errors and failures, auditing activities, and resource utilization.
• Created and managed High Availability 11g/12C RAC Linux clusters utilizing Data Guard in compliance with Oracle's Maximum Availability Architecture (MAA).
• Upgraded Oracle databases from 11g to 12c.
• Implemented OEM Cloud Control 12c Agent installations, plug-ins installations and adding targets to OEM.
• Performance tuning through Application or SQL tuning, Memory tuning, I/O tuning.
• Performance Monitoring & Tunings Cluster nodes.
• Database performance tuning (Instance & SQL Tuning).
• 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, AWS Cloud, Goldengate, AWS Redshift/RDS, Dynamo, Copy, AWS DMS, AWS SCT Guardium Tool, ETL, SAP BI, SQL & PL/SQL, Shell Scripting, UNIX & Performance tuning

Confidential

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 performance tuning (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 (Exadata,ODA & SuperCluster)

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 tablespace, 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 software, 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 the 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 the 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 GOLDEN GATE.
• Configured Exadata X2-2, X2-8 and have a good knowledge of smart flash cache, storage index, storage management, and migration.
• Troubleshoot 2node and 4node RAC and implemented 11g New ASM features.
• Setup physical standby database using Data guard and implemented new 11g features such as Active Dataguard and Snapshot standby database.
• Implemented switching primary database to standby and standby to primary during regular maintenance 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 in 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 tablespaces 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 an on-call pager.
• Resolving Oracle errors and failures, auditing activities, and resource utilization.
• Having Good Knowledge of 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.
• Performed cloning and refresh of Database from the production environment to a test environment using RMAN Duplicate database and Data pump export/import.
• Upgraded databases using Database Upgrade Assistance (DBUA).
• Involved in the optimization of various SQL and PL/SQL using EXPLAIN PLAN and TKPROF.
• Developed UNIX shell scripts to perform the above tasks efficiently.
• Convert non-ASM instance to ASM instance using RMAN
• Administer ASM instance by using SQL plus and ASMCMD command line
• 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.
• 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.
• Various sysadmin functions like administer concurrent managers, defining users, request sets and submitting requests.
• Run diagnostics and troubleshoot bottlenecks. Support existing applications and excellent troubleshooting skills.
• Resolving Oracle errors and failures, auditing activities, and resource utilization.
• Provided 24 x 7 database administrative activities.
• Having Good Knowledge of 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.