SUMMARY

• 7+ years of Oracle DBA experience with Installation, Upgradation, configuration and troubleshooting of Oracle 12C/11G/10G OLTP/OLAP database environments on UNIX, LINUX, Windows and Oracle Exadata servers.
• 4+ years of Oracle GoldenGate experience with Installation, configuration and troubleshooting of Oracle GoldenGate 11g/12c replication setup across heterogeneous database servers and ensure data synchronization.
• Experience in Performance tuning of Oracle GoldenGate Processes to achieve zero lag times.
• Hands on experience on using of macros, conflict resolution, filtering and transformation, exception handlers and Security.
• Experience with Oracle Data Guard setup, maintenance and troubleshooting for High Availability.
• Experience in performing Backups/Recovery using RMAN, Datapump and Flashback Technologies.
• Experience in SQL Tuning using tools like Explain Plan, SQL*Trace, TKPROF and OEM.
• Effective troubleshooting of Database Performance and tuning using ASH, AWR, ADDM.
• Experience in Database capacity planning, monitoring object growth and Storage Management.
• Performed data migration from flat files into anOracledatabase 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 working with database security tools TDE, DB Vault / VPD.
• Experience in applying CPU/PSU patches to various versions of databases with minimum downtime.
• Experience in upgradingOracleBinaries and databases from 10g to 11g and 11g to 12c.
• 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 inShell 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.
• Experience inMongoDB (3.0, 3.2) installation, configuration and administration.
• Good understanding with MySQL, Big Data/Hadoop andNoSQL (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 onOracleSupport processes for technical requests through Metalink.
• Participated in 24 X 7 on-call rotation, off-hour production problem resolution activities.

PROFESSIONAL EXPERIENCE

Oracle DBA & GoldenGate Administrator

Confidential, Oaks, PA

Responsibilities:

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

Oracle DBA & GoldenGate Administrator

Confidential, Framingham, MA

Responsibilities:

• 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) andmaintain 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 NonExadatamachines toExadatamachines 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 anOracledatabase 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 productionOracledatabases by using OEM, ASH/AWR/ADDM, EXPLAINPLAN and TKPROF tools.
• Partitioning Tables, Rebuilding of Indexes, Securefiles, DBLINKS, Materialized Views, Store Procedures, Triggers and constraints.
• Installation ofMongoDBon physical machines and Configuring MongoDB High Availability (Replication) clusters with collection sharding.
• Performed Mongo CRUD operations like Update, Insert and Delete data inMongoDB.
• Experience in MongoDBMonitoring 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 11g/12c, GoldenGate 12c, MongoDB (3.0, 3.2), Robomongo

Oracle DBA & GoldenGate Administrator

Confidential, Warren, MI

Responsibilities:

• 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 andmaintain 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, Woburn, MA

Responsibilities:

• 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 GoldenGatesetup 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 database 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-platformMigrationusing 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

Responsibilities:

• 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