SUMMARY:

• IT Professional with about 12 years of experience in database development and administration working for Fortune 500 companies. Extensive team leadership experience on corporate wide projects. Excellent communication skills with the ability to act as a bridge between the technical and the non - technical.
• Experienced in Oracle, MySQL, PostgreSQL and Hadoop database/application administration, backup and recovery, schema maintenance, performance tuning, performance monitoring, space management, production support 24x7. Possess excellent interpersonal, communication and technical skills.
• Experienced in Oracle Exadata X4-6 machines through 12cR2, managing, configuration and administration on Oracle Linux.
• Experienced in Oracle Database through 12cR2, installation, configuration and administration on Sun Solaris, Windows, HP UNIX, IBM AIX and Linux Redhat.
• Experienced in Oracle eBusiness Suite 11i through 12i, installation, configuration and administration on Linux Redhat.
• Experienced in installation, configuration and administration of Oracle 12c, 11g, 10g Real Application Cluster (RAC).
• Experienced in Installation and Configuration of Physical Dataguard databases.
• Experienced in Installation and Configuration of Grid Control 12c/11g.
• Experienced in Installation and Configuration of RMAN and Recovery Catalog.
• Experienced in implementation, configuration and administration of Oracle Streams.
• Experienced in Oracle MySQL Database, installation, configuration and administration on Linux Redhat.
• Experienced in PostgreSQL9.6.1 Database, installation, configuration and administration on Linux Redhat.
• Experienced in Cloudera Bigdata Cluster Database, installation, configuration and administration on Linux Redhat.
• Experienced in configuring, managing and monitoring Merging Technology of Golden Gate Replication to Bigdata/Hadoop data Lake.
• Experienced in configuring, managing and monitoring Golden Gate Replication from heterogeneous RDBMS databases like SAP HANA, DB2 on z/OS, Oracle, Bigdata and SQL Server using either OGG binaries or java Adapters.
• Experienced in configuring, managing and monitoring Multi-Directional Golden Gate Replication.
• Extensive experience in leading projects like data replication using Oracle GoldenGate (version 9.5 to 12cR2) installation, configuration, troubleshooting, performance tuning and administration, including Bi-Directional, 3 & 4-Way Multi-master Replication topologies with proper Conflict Handling & Resolution.
• Experience in implementing and supporting Data Warehouse environments, comprising primarily of Oracle databases.
• Experience setting up Hadoop nine node cluster, and writing Python scripts for Map Reduce tasks.
• Experienced in Oracle databases cross-platform migration, upgrading and Maintenance of the Oracle Databases to the latest releases using Oracle Streams/GoldenGate with zero downtime.
• Experienced in Oracle databases cross-platform migration of the Oracle Databases from BIG Endianness to SMALL using RMAN Transportable Tablespaces.
• Experienced in migrating Oracle Single Instance databases running on NFS to Oracle RAC databases running on ASM filesystems using RMAN.
• Experienced in developing and implementing standards, procedures for operation, access, control, backup and recovery policies of database and application servers.
• Experienced in developing scripts (Shell, SQL, and PL/SQL) to monitor databases, disk I/O, processes, memory (paging/swapping), Network and CPU utilization, etc.
• Experienced in manual hot backup.
• Experienced in cloning the database using export/import, transportable tablespaces, cold backup, hot backup and RMAN.
• Experienced in creating, altering and managing primary database storage structure (tablespaces, rollback segments for Oracle) and database objects (tables, views, indexes, stored procedures, etc.) for Oracle.
• Experienced in database performance tuning and optimization by creating views, caching tables and packages, creating indexes, using HINTS, using AWR Report, using ASH Report, using TKPROF, generating EXPLAIN PLAN, etc.
• Experienced in implementing data warehouse using PL/SQL, SQL*Loader, ETL etc.

TECHNICAL SKILLS:

Operating Systems: Sun Solaris through 10, HP-UX 11i, Windows through 7, Linux Redhat through 6, Linux SuSE 10/9, IBM - AIX through 6.x - through

Oracle: 12 yrs through 11gR2

Oracle RAC: Veritas Cluster Server (VCS), IBM HACMP, HP Serviceguard, RedHat GFS, IBM GPFS

Cluster: Service Guard, HACMP, GPFS, OCFS2, ASM, Veritas Cluster, Redhat Cluster, Polyserve, Windows MSCS

Backup: RMAN, Manual Hot and Cold, BCV, Snapshot, SRDF Storage EMC Clariion, Symmetrix, Netapp, Celera, ISCSI, EquaLogic, Sun Storage, Hitachi 3par, HP EVA Data Modeling Erwin, Oracle Designer, Rational UML, Silverrun Virtualization vmware ESX ESXi vSphere hypervisor hpvm PowerVM - Oracle VMware

Performance Tools: BMC Patrol, Quest Embarcadero, Grid Control, Site Scope, Precise, Quest Spotlight, Toad, SQL Navigator Disaster Recovery Golden Gate, Oracle Streams, Data Guard through 12cR2 Application Servers Weblogic 3 yrs, Oracle10g Application Server

Application Portals: Oracle Access Manager, OID, SSO, OIM, SOA, BAM, LDAP, Sun Identity, Microsoft Active Directory

Oracle Ebusiness: 5 yrs through R12.2

Oracle Exadata: 3 yrs Linux and SUN

Peoplesoft: 3 yrs through version 9

Case Tools: Erwin, Oracle Designer, Rational UML, Silverrun

Languages: Shell Scripts (Korn, Bash, C, Bourne and PERL), SQL, PL/SQL, XML

PROFESSIONAL EXPERIENCE:

Lead Project Analyst Engineer

Confidential

Responsibilities:

• Involved in managing Oracle12c and Oracle11g databases on Exadata Engineered Systems by supporting the OLTP/OLAP applications.
• Involved in managing Oracle12c and Oracle11g databases and creating database objects, which include datafiles, transaction log files, filegroups, tables, views and indexes.
• Implemented Oracle12cR2/11gR2 RAC environment with disaster recovery solution of Physical Dataguard on ASM Filesystem.
• Implemented and managed Advanced Partitioning and Advanced Compression in VLDB environment.
• Involved in backup, recovery, restore, and duplicating/cloning databases by using RMAN and manually through Datapump.
• Involved in writing scripts (Shell and PL/SQL) for database maintenance.
• Installing, managing and patching databases running on 12c/11g of different sizes ranging 100GB to 11TB.
• Involved in cross-platform migration and Maintenance of the Oracle/SAP HANA/DB2 LUW and DB2 z/OS Databases to the latest releases using Oracle GoldenGate.
• Involved in writing scripts (Shell and SQL) for Oracle GoldenGate Monitoring.
• Installing, managing and patching Oracle GoldenGate running on 12c (12.1 and 12.2).
• Implemented the Oracle GoldenGate unidirectional replication between two production databases running with Oracle11.2.0.4.x databases on Exadata.
• Implemented the Oracle GoldenGate heterogeneous unidirectional replication between two production databases running on Oracle/SAP HANA/DB2 z/OS/DB2 UDB/SQL Server to Hadoop Cloudera Cluster in HBASE and HDFS.
• Implemented Shell scripts for GoldenGate databases in view to monitor GoldenGate replication environment.
• Worked on implementing Oracle GoldenGate for Auditing some critical data.
• Upgraded Oracle GoldenGate from version 12.1 to 12.2 on multiple hosts.
• Experienced in configuring, managing and monitoring Merging Technology of Golden Gate Replication to Bigdata/Hadoop data Lake.
• Experienced in configuring, managing and monitoring Golden Gate Replication from heterogeneous RDBMS databases like SAP HANA, DB2 on z/OS, Oracle, Bigdata and SQL Server using either OGG binaries or java Adapters.
• Experienced in configuring, managing and monitoring Multi-Directional Golden Gate Replication.
• Extensive experience in leading projects like data replication using Oracle GoldenGate (version 9.5 to 12cR2) installation, configuration, troubleshooting, performance tuning and administration, including Bi-Directional, 3 & 4-Way Multi-master Replication topologies with proper Conflict Handling & Resolution.

Environment: PostgreSQL9.6 - 10.1, Oracle Exadata 11g/12c, SQL, PL/SQL, Oracle Enterprise Manager Grid Control 12c, Oracle GoldenGate 12c, Linux Redhat Server, AIX, z/OS, Shell Scripting, ASM Filesystem, Exadata X4 through X6 Half Rack, Bigdata, etc.

Senior Oracle Database Administrator

Confidential, MA

Responsibilities:

• Involved in creating and managing 300 plus production, testing and development Oracle databases with 14 other DBAs for one group.
• Involved in managing Oracle10g and Oracle11g databases and creating database objects, which include datafiles, transaction log files, filegroups, tables, views, indexes, and stored procedures.
• Involved in migration/upgrading of Oracle10g to Oracle11g database.
• Involved in managing Oracle11g databases on Exadata Engineered Systems by supporting the OLTP/OLAP applications.
• Implemented Oracle11g RAC environment with disaster recovery solution of Physical Dataguard on ASM Filesystem.
• Implemented and managed Advanced Partitioning and Advanced Compression in VLDB environment.
• Involved in backup, recovery, restore, and duplicating/cloning databases by using RMAN and manually through Datapump.
• Involved in writing scripts (Shell and PL/SQL) for database maintenance.
• Installing, managing and patching databases running on 10g/11g of different sizes ranging 100GB to 1TB according to Bank Standards with BBDA.
• Installing Oracle RAC 11.2.0.3.6 databases on Linux Redhat and creating, managing and configuring databases.
• Implemented Shell scripts for monitoring database activities and gathering metrics of the databases running on the exadata storage.
• Optimizing database performance by analyzing database objects, generating statistics, creating indexes, using BASELINE, EXPLAIN PLAN, HINTS, TKPROF and AWR etc.
• Implemented heterogeneous replication solution of unidirectional environment for reporting from Oracle11.2.0.3 to DB2 LUW Databases using Oracle GoldenGate.
• Implemented the Oracle GoldenGate bidirectional replication between two production databases running with Oracle11.2.0.3.x databases on Exadata X5-2.
• Implemented Shell scripts for GoldenGate databases in view to monitor GoldenGate replication environment.
• Involved in cross-platform migration, upgrading and Maintenance of the Oracle Databases to the latest releases using Oracle GoldenGate.
• Migrated production databases running on EMC storages to Exadata storages using GoldenGate with zero downtime.
• Worked on implementing Oracle GoldenGate for Auditing some critical data.
• Upgraded Oracle GoldenGate from version 11 to 12 on multiple hosts.

Environment: Oracle11g / 10g, SQL, PL/SQL, Oracle Enterprise Manager Grid Control 12c, Oracle GoldenGate, Dataguard, Linux Redhat Server, Solaris 10, RMAN, EMC SAN, Shell Scripting, ASM Filesystem, Exadata X4 through X5, etc.

Senior Oracle Apps Database Administrator

Confidential, RI

Responsibilities:

• Involved in creating and managing 700 plus production, testing and development Oracle databases with 23 other DBAs.
• Upgraded Several Oracle Ebusiness 11.5.10.2 to R12.1.1 and then upgraded to R12.1.3. Migrated from existing Solaris to Linux. Migrated application tier to shared application tier. Setup PCP and Oracle 11g RAC. Provided scaling and HA architecture. Setup Physical Data Guard.
• Migrated Oracle Application Server 10g to Oracle Weblogic Server 11g.
• Documented the implementation plan (POC) all along with recommendations after setting up the Oracle GoldenGate.
• Implemented the Oracle GoldenGate between two production databases running e-business suite 11.5.10.2 with Oracle11.2.0.2 databases on Exadata Half Rack.
• Architected the Goldengate based bi-directional solution for Warehouse Management System (WMS) which is the “customized application” along with unidirectional Goldengate solution for Oracle e-business suite 11.5.10.2 database from production server to WMS Database Server for reporting purposes.
• Setup SOA, BPM, SSO with OID, OVD and OAM integration with LDAP and Active Directory. Configured all provisioning and data transfer rules. HA Configuration of SOA and OBIEE. Implement tight Oracle 11g Security.
• Install and Configure VMWARE servers with ESXI, setup HA failover with Clustering solutions. Install RAC 11.2.0.3.x on several VM Servers. Setup backup and monitoring.
• Involved in managing Oracle10g and Oracle11g databases and creating database objects, which include datafiles, transaction log files, filegroups, tables, views, indexes, and stored procedures.
• Involved in migration of SQL Server Databases to Oracle11g databases using Oracle GoldenGate.
• Install and Configure VMWARE servers with ESXI, setup HA failover with Clustering solutions.
• Implemented Oracle10g RAC and Oracle11g RAC environment with disaster recovery solution of Physical Dataguard on ASM Filesystem.
• Implemented and managed Advanced Partitioning and Advanced Compression in VLDB environment.
• Involved in cross-platform migration, upgrading and Maintenance of the Oracle Databases to the latest releases using Oracle GoldenGate.
• Involved in backup, recovery, restore, and duplicating/cloning databases by using RMAN and manually through Datapump.
• Setup Data Guard and Goldengate for high-availability and replication. Architected the Goldengate based HA solution, also installed in configured Active Data Guard in a Stretch Cluster environment using EMC SRDF.
• Involved in writing scripts (Shell and PL/SQL) for database maintenance.
• Installing, managing and patching databases running on 10g/11g of different sizes ranging 100GB to 2TB.
• Installing Oracle database 10g/11g on AIX Servers as well as Linux Redhat and creating, managing and configuring databases.
• Implemented Shell scripts for GoldenGate databases in view to monitor GoldenGate replication environment.
• Worked on implementing Oracle GoldenGate for Auditing some critical data.
• Documented the recommendations after analyzing the Oracle Streams setup.
• Recommended to improve performance by using a JMS technology despite home grown PL/SQL single threaded application.
• De-normalization issue was resolved by overhauling the system thru Java Messaging.
• Optimizing database performance by analyzing database objects, generating statistics, creating indexes, using EXPLAIN PLAN, HINTS, TKPROF and AWR etc.

Environment: Oracle11gR2/10gR2/9iR2, SQL, PL/SQL, Oracle Enterprise Manager Grid Control, RMAN, AIX 6.1 Server, Dataguard, Linux Redhat Server, Oracle GoldenGate 11.2.1.0.1, Shell Scripting, ASM, EMC SAN, Exadata X3-2 Half Rack, etc.