SUMMARY:

• 8 years of Oracle DBA experience with Installation, Upgradation, configuration and troubleshooting of Oracle 12C/11G/10G OLTP/OLAP database environments with multi - node RAC, ASM and Non-ASM on UNIX, LINUX, Windows Operating Systems.
• 5+ years of Oracle GoldenGate CDC experience with installation, configuration and troubleshooting of Oracle GoldenGate 11g/12c unidirectional and bidirectional replication in both Oracle and Non- Oracle environments, GoldenGate Downstream capture setup and Performance tuning of GoldenGate processes to achieve zero lag time.
• Hands on experience on using of Oracle GoldenGate Macros, Conflict Detection Resolution (CDR), filtering and transformation parameters, exception handlers and Security.
• Experience with Oracle Data Guard setup, maintenance and troubleshooting for High Availability and Data Replication. 
• Experience in performing Backups/Recovery using RMAN, Datapump and Flashback Technologies.
• Effective troubleshooting of Database Performance and tuning using ASH, AWR, ADDM and OEM.
• Experience in SQL Tuning using tools like Explain Plan, SQL*Trace, TKPROF and OEM.
• Experience in Database capacity planning, security and Storage Management.
• Performed data migration from flat files into an Oracle database using SQL*Loader.
• Experience in performing Cloning and Refresh using RMAN and Datapump.
• Experience in Oracle Advanced Compression techniques.
• Experience in Online/Offline Re-Organization of database objects.
• Experience in Partitioning Tables, Rebuilding of Indexes, Securefiles, DBLINKS, Materialized Views, Store Procedures, Triggers and constraints.
• Demonstrated proficiency in managing Oracle Instance, database storage structure, schema objects, managing tablespaces, Rollback and undo segments, creation of database objects, Data Modeling.
• Experience in defining Users, Roles, Privileges, Auditing to ensure database Security.
• Experience in applying CPU/PSU patches to various versions of databases with minimum downtime.
• Experience in upgrading Oracle Binaries and databases from 10g to 11g/12c and 11g to 12c.
• Experience in setting up of network components like TNS, VIP and SCAN listeners.
• Experience in handling very large databases (VLDB) ranging up to 100TB.
• Proficient in writing SQL, PL/SQL (Stored Procedures, functions, packages and triggers) scripts.
• Experience in Shell Scripting for configuring monitoring alerts and automation.
• Experience in performing Data Migration between Non ASM and ASM databases and also between the databases of different vendors.
• Good understanding with MySQL, Big Data/Hadoop and  NoSQL (MongoDB/Cassandra) concepts.
• Experience in supporting Business Intelligence / Data warehouse environments and troubleshooting issues working closely with ETL developers and BI users.
• Experience with Agile and ITIL Change and Incident management processes and tools.
• Excellent communication skills, with strong troubleshooting, and problem-solving ability.
• Experience on Oracle Support processes for technical requests through Metalink.
• Participated in 24 X 7 on-call rotation, off-hour production problem resolution activities.

TECHNICAL SKILLS:

Databases: Oracle, MongoDB

Tools: OEM, SQL* Loader, RMAN, Oracle Golden Gate, mongodump, mongorestore, mongoexport/import, Robomongo, SQL Developer, TOAD, SQL*Plus, MS Office, Ansible

Operating System: HP-UX, SUSE Linux, Oracle Enterprise Linux(UK), AIX, RedHat, Solaris, Windows

Languages: SQL, PL/SQL, UNIX Shell scripting, HTML

PROFESSIONAL EXPERIENCE:

Oracle DBA

Confidential, Charlotte, NC

• Administration and troubleshooting of Oracle RAC and non-RAC 11g/12c Databases.
• Performed Oracle Schema level and Table level data migrations using Datapump EXPDP/IMPDP.
• Monitoring of tablespaces, memory structures, rollback segments, logs, and alerts.
• Monitor and fully analyze performance issues in production Oracle databases by using OEM, ASH/AWR/ADDM, EXPLAINPLAN and TKPROF tools.
• Managing security compliance failures in DBSmart for Dealer Services group databases and taking action to remediate the failure. 
• Partitioning Tables, Rebuilding of Indexes, Securefiles, DBLINKS, Materialized Views, Store Procedures, Triggers and constraints.
• Configuring and scheduling of RMAN database backup and performed RMAN Duplications.
• Monitored the various database activities such as Backup, Error Logs, Space, Object, Performance, User and Session monitoring to ensure proper Capacity and Availability.
• Involved in User Management and Database Security by granting appropriate Roles, Privileges, and Profiles.
• Configuring Blackout, setting alerts and thresholds for targets in OEM 12c/13c.
• Monitoring the availability of system, listener, database, alter log file, trace file.

Environment: Oracle 11g/12c databases on AIX, Oracle Exadata (DBaaS), OEM 13c, GoldenGate 12c

Oracle DBA & GoldenGate Administrator

Confidential, Charlotte, NC

• Installation, Configuration and Administration of Oracle RAC 10g/11g/12c Databases.
• Installation, Upgradation, Configuration and Troubleshooting GoldenGate 12c software.
• Configured GoldenGate Downstream Mining and replication components for replication.
• Performed Zero Downtime Database Data Center Migration using GoldenGate and DataGuard.
• Performed Oracle Schema level and Table level data migrations using Datapump EXPDP/IMPDP.
• Performed cross platform database migrations using Transportable tablespaces.
• Monitoring of tablespaces, memory structures, rollback segments, logs, and alerts.
• Monitor and fully analyze performance issues in production Oracle databases by using OEM, ASH/AWR/ADDM, EXPLAINPLAN and TKPROF tools.
• Partitioning Tables, Rebuilding of Indexes, Securefiles, DBLINKS, Materialized Views, Store Procedures, Triggers and constraints.
• Configuring and scheduling of RMAN database backup and performed RMAN Duplications.
• Monitored the various database activities such as Backup, Error Logs, Space, Object, Performance, User and Session monitoring to ensure proper Capacity and Availability.
• Involved in User Management and Database Security by granting appropriate Roles, Privileges, and Profiles.
• Monitoring the availability of system, listener, database, alter log file, trace file.

Environment: Oracle 10g/11g/12c databases on SPARC Solaris 10, Oracle Exadata (DBaaS), OEM 13c, GoldenGate 12c

Oracle DBA & GoldenGate Administrator

Confidential, Oaks, PA

• Installation, Configuration and Administration of Oracle RAC 11g/12c Databases on Oracle Enterprise Linux
• Installation, Upgradation, Configuration and Troubleshooting GoldenGate 12c software.
• Configured GoldenGate Downstream Mining and Integrated components for Active-Passive and Active-Active replication.
• Configured GoldenGate High Availability using Oracle DBFS and Active DataGuard.
• Installed and configured GoldenGate JAgent to work with OEM GoldenGate Plugin.
• Performed Schema level and Table level data refreshes from Production to Development environments using Datapump EXPDP/IMPDP.
• Monitored the various database activities such as Backup, Error Logs, Space, Object, Performance, User and Session monitoring to ensure proper Capacity and Availability.
• Involved in User Management and Database Security by granting appropriate Roles, Privileges, and Profiles.
• Monitoring the availability of system, listener, database, alter log file, trace file.

Environment: Oracle 11g/12c databases on OEL (UK), OEM 12c/13c, GoldenGate 12c

Oracle DBA & GoldenGate Administrator

Confidential, Framingham, MA

• Installation, Configuration and Administration of Oracle RAC 11g/12c Databases ranging from 100GB to 100TB on Linux/UNIX/AIX/ Exadata X4 servers.
• Installation, Upgradation, Configuration and Troubleshooting GoldenGate 11g/12c software.
• Configured GoldenGate Classic and Integrated components for Active-Passive and Active-Active replication between heterogeneous environments (DB2 LUW, iSeries/ Teradata/ Oracle/ Microsoft SQL Server/ Hadoop/ MongoDB) and maintain data synchronization.
• Developed and configured GoldenGate macros for data conflict resolution, filtering and transformation, exception handlers.
• Configured GoldenGate High Availability on VERITAS Clustering Service and developed scripts for GoldenGate Failover.
• Monitoring and Performance tuning of GoldenGate sessions at OS level, Database level and GGSCI level and investigate replication failures using ggserr.log, report files and LogDump utility.
• Performed Zero Downtime migrations from Non Exadata machines to Exadata machines using Oracle Golden Gate and Dataguard.
• Developed Shell scripts, SQL & PL/SQL scripts for monitoring GoldenGate processes and their stats running on 60+ servers from one single database repository providing table level granularity with end-to-end replication map and thus maintain history of all GoldenGate processes for later analysis.
• Performed Oracle Schema level and Table level data migrations using Datapump EXPDP/IMPDP.
• Configuring and scheduling of Oracle database backup using RMAN. 
• Performed data loads from flat files into an Oracle database using SQL*Loader.
• Partitioned tables Maintenance, adding new partitions, exchanging one-year-old partitions then archiving of the exchanged partitions, dropping or truncating of old portions. 
• Monitoring of tablespaces, memory structures, rollback segments, logs, and alerts.
• Monitor and fully analyze performance issues in production Oracle databases by using OEM, ASH/AWR/ADDM, EXPLAINPLAN and TKPROF tools.
• Partitioning Tables, Rebuilding of Indexes, Securefiles, DBLINKS, Materialized Views, Store Procedures, Triggers and constraints.
• Involved in Cassandra Multi Data Center Implementation.
• Involved in Data Migration from RDBMS to Cassandra using Sqoop.
• Performed Mongo CRUD operations like Update, Insert and Delete data in MongoDB. 
• Experience in MongoDB Monitoring Service (MMS) for backup and Monitoring.
• Migrated large amount of data between mongo clusters using mongodump, mongorestore, mongoexport and mongoimport. 
• User Management like creation of users, defining Profiles, Roles and Privileges.
• Worked with Informatica team for performing GoldenGate Initial loads.
• Developed UNIX shell scripts for Monitoring and Automation.

Environment: Oracle 10g/11g/12c databases on HP-UX/RedHat/AIX/Exadata, OEM 12c, GoldenGate 12c, MongoDB (3.0, 3.2), Robomongo

Oracle DBA & GoldenGate Administrator

Confidential, Warren, MI

• Administration and supporting of Oracle RAC 11g/12c Databases ranging from 100GB to 60TB.
• Installation, upgradation, configuration and troubleshooting GoldenGate 11G/12C software.
• Configured GoldenGate components for unidirectional and bidirectional replications and maintain data synchronization.
• Monitoring and Performance tuning of GoldenGate sessions at Database level and GGSCI level and investigate replication failures using LogDump utility.
• Performed Zero Downtime Database Data Center Migration using GoldenGate and Datagaurd.
• Performed data migration from MySQL to Oracle using GoldenGate.
• Performed database upgradation from Oracle 11.2.0.4 to 12.1.0.2.
• Performed Schema level and Table level data refreshes from Production to Development environments using Datapump EXPDP/IMPDP.
• Performed Logical and Physical structural changes to table online using DBMS REDEFINITION.
• Configured and scheduled RMAN backups to EMC DataDomain.
• Performed RMAN Duplications.
• Masking of sensitive PII data using Oracle Data Masking Pack.
• Create Wallet and Implemented Oracle TDE to encrypt tablespace thus safeguarding data
• Proactively performed tuning and health monitoring for the databases.
• Troubleshoot database performance issues using ASH, AWR, ADDM and OEM.
• Carried out Performance optimization and Query tuning using Explain Plan and Tkprof.
• Monitoring of tablespaces, memory structures, rollback segments, logs, and alerts.
• Storage management - adding storage to ASM diskgroups and reclaiming unused space to ASM
• User Management like creation of users, defining Profiles, Roles and Privileges.
• Hands on Experience working with Database Resource Management and capacity planning.
• Developed UNIX shell scripts for Monitoring and Automation.
• Supporting Monthly/Quarterly release cycles.
• Work with Oracle Support on SR’s to resolve issues.
• Production support and providing 24x7 on-call support.

Environment: Oracle 10g/11g/12c databases on HP-UX/SUSE/OEL (UK), OEM 11g/12c, GoldenGate 11g/12c, MySQL 5.6.

Oracle Database Administrator

Confidential, Monroe, LA

• Installed and configured 11g databases on RAC and Non-RAC environments.
• Setup maintenance of Data Guard for disaster Recovery and reporting purpose with various modes.
• Planned, Installed and Configured Golden Gate setup to achieve unidirectional replication.  
• Performed, developed and maintained database backup and recovery using RMAN.
• Refreshing/Cloning databases for the testing/developing purpose.
• Replicated data between two databases using materialized view and DB link.
• Performed logical backup of database, schemas, tables using Expdp/Impdp.
• Performed Database and SQL tuning by using various Tools like STATSPACK, EXPLAIN PLAN for Query Optimization and SQL tuning advisor, Database Health Monitor, ADR and Creating tables with Virtual Columns, DDL Lock Timeout, Invisible Indexes and knowledge of Database Resident Connection Pooling.
• Monthly, Weekly and daily report generation using AWR and ADDM.
• Reorganizing and Rebuilding of the Tables/Indexes.
• Performed Cross-platform Migration using transportable tablespaces and RMAN. 
• Applying one-off patches/CPU/PSU Patches.
• Upgrading Databases (10.2.0.1/10.2.0.4 to 10.2.0.5/11.1/11.2 ).
• Monitored the various database activities such as Backup, Error Logs, Space, Object, Performance, User and Session monitoring to ensure proper Capacity and Availability.
• Involved in User Management and Database Security by granting appropriate Roles, Privileges, and Profiles.
• Day to day monitoring like availability of system, listener, database, alter log file, trace file.
• Configured Auditing to audit information about database activity.
• Support users for bugs/issues in Oracle Database.
• Production support and providing 24/7 on-call support.

Environment: Oracle 10g/11g databases on RHEL 5.5, OEM 11g and GoldenGate 11g

Oracle Database Administrator

Confidential

• Installing and maintaining of Oracle 9i, 10g, 11g database according to security baseline.
• Participated in developing Database Design Standards and database object naming conventions.
• Creation and Implementation of RMAN Catalog databases and registering target databases with the Catalog and implemented database Backup and Recovery strategies using RMAN.
• Performed maintenance tasks on existing test and development environments that included modifying database sizes and migrating changes through various environments.
• Database maintaining including Backups, Recovery, Imports, Exports.
• Utilized Oracle Enterprise Manager (OEM) to manage users, privileges, profiles, schemas.
• Involved in Performance Planning and Tuning, using baselines and proactive monitoring, bottleneck elimination and the wait event interface to identify issues.
• Analyzed tables and re-built indexes regularly and Reports, Statspack, AWR, Explain Plans, ADDM and monitor the database performance on daily basis.  
• Utilized SQL*loader and data pump import to load data into tables and Oracle Flashback Data Archives.
• Support users for bugs/issues in Oracle Database.
• Production support and providing 24x7 on-call support.

Environment:  Red Hat Linux, Oracle 9i/10g/11g, RAC, SQL*Plus, OEM, TOAD, RMAN, TKPROF, SQL Trace, STATSPACK, ADR, AWR, ADDM, Data Guard