SUMMARY

• To offer my years of experiences in the field of Information Technology in a creative and collaborative environment where my analytical and technical skills will contribute to the overall goal of the organization.
• 18+ years of experience in Oracle DBA and have been involved in Installation, Configuration, Upgrades, Patching, Backup and Recovery, Migration, Memory and Space Management, Cloning, Replication, Reporting, Performance Tuning, RMAN, RAC, Data Guard, OEM Grid Control.
• Expertise in Oracle 11g, ASM, RAC, OEM, Data Guard, RMAN and Shell Script
• Configured and maintained replication using Oracle Golden Gate.
• Experience in Backup & Recovery techniques of databases running in ARCHIVELOG MODE using RMAN.
• Having good knowledge on EXADATA and Involved in moving databases in EXADATA to RAC environment.
• Experience in Data Migration using Data pump utility, Non RAC to RAC and Non ASM to ASM.
• Implemented Oracle Transparent Data Encryption to encrypt tables and tablespaces that contains PII,PCI and SOX data.
• Implemented Oracle Audit Vault 11G
• Managed Oracle security (using virtual private databases and role - based security).
• Implemented virtual private database/application context code.
• Database Refresh from Production to Development and from Development to Test environments.
• Worked with various application teams in developing, testing and deploying codes across all life cycles of the application phase.
• Experience in Space Management by Monitoring and Managing Tablespaces.
• Experience in Implementing, configuring, trouble shooting, switchover, failover of Physical Standby Data Guard on 10g and 11g.
• Experience in Administering Oracle Database using Oracle Enterprise Manager, Toad, and PL/SQL Developer.
• Provided hands-on support and implementation of Installation / Configuration / Performance Tuning / Trouble shooting Oracle Golden Gate (OGG) in Oracle to Oracle homogeneous environments.
• Monitoring Alert log for any errors and issues.
• Resolved Replication related errors Such as ORA -1403, 0001, and several other errors regarding golden gate replication during and after code deployment activity.
• Good understanding of no-SQL database, Cassandra and Hadoop.
• Communicated and interfaced with Oracle support via Metal-link to troubleshoot day-to-day database issues.
• Worked with various application teams in developing, testing and deploying codes across all life cycles of the application phase.
• Hands on experience in Oracle 10g/11g RAC implementation & administration (Oracle Cluster-ware setup and configuration, RAC Installation using ASM, Grid Installation.), Patching, RAC Backup, adding a node to existing cluster database for High Availability and Recovery.
• Hands on experience working on High Availability Environments.
• 24 X 7 Production Database on Call Support.
• Experience working with data warehousing (OLAP) applications, transactional database (OLTP) development, installing, configuring, administering, managing oracle databases, implementing solutions like High Availability (HA), Disaster & Recovery, Cloning, and Database Security.
• Mentored other DBA in various Oracle and non-Oracle related tasks.

TECHNICAL SKILLS

• Oracle 8i/9i/10g/11g/12c Oracle Database Administration
• Performance Tuning & Capacity Monitoring
• Data Security, Backup & Recovery
• Configured and maintained replication using Oracle Goldengate
• Exadata
• Data Center Migration
• Data Guard
• VLDB
• Solaris
• Linux
• Windows
• Storage
• Data Profiling, querying and reporting on multiple RDBMS
• Oracle RAC (Real Application Cluster) setup and tuning
• Using shell scripting and RMAN
• Import/Export
• Installation and configuration in AWS Cloud
• Oracle database partitioning, patching, and cloning
• Hadoop
• AWS
• Google Cloud
• Microsoft Azure Cloud
• Team Lead
• SalesForce Admin/dev

PROFESSIONAL EXPERIENCE

Confidential, Las Vegas, NV

Snr. Oracle Golden Gate / Database admin.

Environment: Oracle, MS SQL Server, Confidential DB2 RAC, Data Guard, Grid Control, Golden Gate, EMC, HP-3Par, Linux Advanced Server, RHEL, Windows, ASM.

Responsibilities:

• Architected a big data application replication solution with a factory approach using Mongo API,KafkaSpark and Scala.
• Designed the use of Azure EventHubs, CosmoDB, ADLS, Hadood, Azure DataLake as targets for the data sourced from Golden Gate passed through Kafka, Mongo DB API, Hadoop API.
• Installation, Configuration and Migrated multi- Terabyte Database from existing to a new Data Center.
• Managed Oracle security (using virtual private databases and role-based security).
• Implemented virtual private database/application context code.
• Monitoring and Performance tuning of Goldengate sessions at Database level and GGSCI level and investigate replication failures using, report files and LogDump utility.

Confidential, Atlanta, GA

Snr. Oracle Database admin.

Environment: Oracle 11g/12C, TOAD, Oracle Enterprise Manager (OEM), RMAN, RAC, Data Guard, Grid Control, Golden Gate, EMC, HP-3Par, Linux Advanced Server, RHEL, Windows, ASM.

Responsibilities:

• Installation, Configuration and Migrated multi- Terabyte Database from existing to a new Data Center.
• Installation, upgradation, configuration and troubleshooting Oracle Goldengate 11G/12C software.
• Implemented Oracle Transparent Data Encryption to encrypt tables and tablespaces that contains PII,PCI and SOX data.
• Managed Oracle security (using virtual private databases and role-based security).
• Implemented virtual private database/application context code.
• Monitoring and Performance tuning of Goldengate sessions at Database level and GGSCI level and investigate replication failures using, report files and LogDump utility.
• Performed Zero Downtime migrations from Non Exadata machines to Exadata machines using Oracle Golden Gate and Dataguard/Rman Duplicate.
• Installed configuring Real Application Clusters (RAC) on Oracle11g /12c Automatic Storage Management (ASM).
• Setup and maintenance of DATA GUARD on 11g,12C for Disaster Recovery and reporting purpose with various modes.
• Performed Data Center Migration involving multi-Terabytes Oracle databases.
• Implemented Oracle Transparent Data Encryption to encrypt tables and tablespaces that contains PII,PCI and SOX data.
• Managed Oracle security (using virtual private databases and role-based security).
• Implemented virtual private database/application context code.
• Monitoring and Performance tuning of Goldengate sessions at Database level and GGSCI level and investigate replication failures using, report files and LogDump utility.
• Performed Zero Downtime migrations from Non Exadata machines to Exadata machines using Oracle Golden Gate and Dataguard/Rman Duplicate.
• Involved in the project of implementing and configuring Real Application Clusters (RAC) on Oracle11g Automatic Storage Management (ASM).
• Setup and maintenance of DATA GUARD on 11g,12C for Disaster Recovery and reporting purpose with various modes.
• Database Cloning for Logical and Physical Standby server.
• Maintained and monitored RMAN backup, restore, and recover as needed.
• Created database links to retrieve data from multiple Databases source to ODS.
• Monitored Schema level performance issues and performed the tasks like analyzing tables, rebuilding

Snr. Database Administrator

Confidential, Detroit, MI

Environment: Oracle 10g/11g,12c TOAD, SQL Plus, Oracle Enterprise Manager (OEM), RMAN, Oracle and Linux.

Responsibilities:

• Creating and maintaining databases, creating table spaces, tables, indexes, data files etc.
• Installed configured Oracle Enterprise Manager (OEM) / Grid Control for monitoring and administrative tasks purposes.
• Installed, Setup and configure Goldengate Bi-directional, Broadcast, and Unidirectional replication.
• Implemented Oracle Transparent Data Encryption to encrypt tables and tablespaces that contains PII,PCI and SOX data.
• Managed Oracle security (using virtual private databases and role-based security).
• Implemented virtual private database/application context code.
• Created and implemented replication between 2 databases running on Unix RAC for multiple schemas and validated replication for insert, updates functionality between both source and destination databases.
• Handled several Onstar Global and minor releases from 4.3 - 6.2 Database and Goldengate replication design changes from ODS and application perspective.
• Installed, configured, loaded and implemented of Oracle Spatial Database changes using various ESRI files from different vendors (i.e. NavTeq,TomTom,Nokia, etc).
• Installation and configuration of Oracle 10g / 11gR2/12c Real Application Clusters (RAC)
• Great Understanding of how the complex Banner environment works together.
• Backup plan designing and implementation using cold/hot backups, Flash copy, Volume copy and RMAN backup technology.
• Perform capacity planning required to create and maintain database environments.
• Helping the development team and data warehousing team.
• Monitored table space size, resizing table space, relocating data files for better disk I/O.
• Creating users, allocation to appropriate table space quotas with necessary privileges and roles for all databases.
• Configuring TNSNAMES.ORA and LISTENER.ORA for SQL*NET connectivity.
• Monitoring table space size, resizing table space, relocating data files for better disk I/O.
• Designed Backup Strategies and Disaster recovery plans depending upon the criticality of the Databases.
• Performed large data loads through SQL*Loader
• Managing archive logs, DB-links, partitions.
• Create Indexes by analyzing and rebuilding of Indexes for better performance.
• Managed database users and security for the SQL Server database.
• Fine-tuned and maintained large production SQL Server databases, as well as monitored overall database activities using Profiler
• Monitoring of SQL Server databases, working to maximize availability and tune data performance as needed.
• Experience in Implementing, configuring, trouble shooting, switchover, failover of Physical Standby Data Guard on 10g and 11g.
• Experience in Administering Oracle Database using Oracle Enterprise Manager, Toad, and PL/SQL Developer.
• Provided hands-on support and implementation of Installation / Configuration / Performance Tuning / Trouble shooting Oracle Golden Gate (OGG) in Oracle to Oracle homogeneous environments.
• Monitoring Alert log for any errors and issues.
• Resolved Replication related errors Such as ORA -1403, 0001, and several other errors regarding golden gate replication during and after code deployment activity.
• Worked with various application teams in developing, testing and deploying codes across all life cycles of the application phase.

Lead Oracle DBA

Confidential

Environment: Oracle 10g/11g, Oracle Enterprise Manager (OEM), OEM 10g/11g Grid Control, RMAN, Veritas NetBackup, RAC, ASM, DataGuard, AIX 5.x/6.1, Linux RHE, TOAD, Shell Scripting, PL/SQL

Responsibilities:

• Managed and led DBA team in the complete SDLC, Database design, System analysis, design and development to production phase.
• Successfully implemented physical standby database using Oracle Data Guard feature for High availability configuration.
• Setup and configure RMAN Backup using Varitas - NetBackup for all Backups.
• Provided daily database administration support such as monitoring space utilization, backup, and export /import of schema objects.
• Installed, configured and implemented Oracle Enterprise manager Grid Control.
• Engaged in database and Disaster Recovery capacity planning and implemented Disaster recovery exercise.
• Supported, maintained and troubleshooting Oracle Goldengate for data replication and high availability databases.
• Debugging Goldengate replication issues such as abend of replicat,extract, and pump processes.
• Implemented Oracle Transparent Data Encryption to encrypt tables and tablespaces that contains PII,PCI and SOX data.
• Managed Oracle security (using virtual private databases and role-based security).
• Implemented virtual private database/application context code.
• Performed performance tuning using SQLT tool to migrate SQL profile between databases to impact and reduce query runtime.
• Installed and configured Multiple Oracle 11g databases.
• Responsibilities included applying CPU/PSU patches, maintaining and troubleshooting database issues.
• Installed and configured Oracle Audit Vault server / database for a two (2) node RAC with a standalone audit vault server.
• Installed and configured Audit Vault Agent on a two (2) node RAC.
• Configured and integrated DB and OS collectors with the Audit Vault server/database
• Performed Trouble shooting of ora errors and performance tunning of oracle instances and databases.

Snr. Oracle DBA

Confidential

Environment: Oracle 9i/10g/11g, Oracle Enterprise Manager (OEM), OEM 10g/11g Grid Control, RMAN, SQL BACKTRACK, Veritas NetBackup RAC, ASM, DataGuard, AIX 5.x/6.1, Linux RHE, TOAD, Shell Scripting, PL/SQL

Responsibilities:

• Involved in the complete SDLC, Database design, System analysis, design and development.
• Cloned databases using RMAN and manual copy.
• Performed disaster recovery using Oracle Recovery Manager.
• Setup and configure RMAN Backup using Varitas - NetBackup for all Backups.
• Supported, maintained and troubleshooting Oracle Golden Gate for data replication and high availability databases.
• Performed backup and recovery using BMC SQL BACKTRACK.
• Engaged in database capacity planning for a new application deployment.
• Installation and configuration of Oracle 9i/10g/11g Real Application Clusters (RAC).
• Performed backups and tested crash recoveries using conventional cold, hot and RMAN backups.
• Experience in Supporting Bi-directional Goldengate replication between databases.
• Setup and configure goldengate Manager Processes, Extract Processes, and Replicat Processes for a Unidirectional replication.
• Responsibilities included installing, upgrading, migrating and applying patches to Oracle databases.
• Managed 4 node Oracle 10g Real Application Clusters (RAC) databases with ASM Storage.
• Responsible for creating standard database creation scripts, installation, upgrades, patches, contacting Oracle collaborative support for critical issues.
• Performed numerous Oracle database migration from RDBMS 10g through 11g using various Oracle migration methods such as EXPDP/IMPDP, Transportable Tablespace .
• Performed cross-Platform Migration of oracle databases.
• Supported Quest SharePlex for data replication and for high availability stand-by databases.
• Ability to manage high availability solution centers using Oracle Real Application Clusters (RAC) with several nodes.
• Proactive monitoring, identifying areas that need to be improved in the application and database using Statspack, AWR, ADDM, and 10g OEM Grid Monitoring.
• Performed daily service management activities related to change, incident and problem management, as well as coordinate and/or participate in team and customer meetings.
• Analyzed and tuned Oracle database / instances using EXPLAIN PLAN, AWR Reports, Advanced Database Diagnostic Monitor (ADDM), StatsPak, SQL*TRACE and TKPROF.