SUMMARY:

Over 18 plus years of IT experience working for global organizations focusing on Oracle Database Management and Administration with experience in the Health Care, Financials, Telecommunication, Consumer Electronics, and Government  as Database Manager / Lead / Senior Oracle DBA.

• Designed and planned infrastructure setup for many complex database environments across multiple industries
• Managed several DBA teams, both onsite and offshore
• “Capability Lead” for Oracle technologies @ Confidential Technology Solutions, Singapore
• Led Confidential ’s Centre of Excellence for Database Technologies and conducted several knowledge transfer sessions for cutting edge technologies like Oracle GoldenGate, Oracle Exadata (Oracle Engineered System)

EXPERTISE AREA:

• Data migrations, database upgrades and consolidation, backup and recovery, Oracle installation, configuration, patching and database tuning
• Expert on very large databases and Enterprise Manager Grid/Cloud Control
• High availability (RAC) Real Application Clusters & Oracle Active Data Guard
• Advanced Replication: Materialized view replication, Oracle streams, Golden Gate and Oracle AQ
• Database security: Oracle Advanced encryptions, Advanced Compression, Oracle Vault, Oracle Fine Grained Auditing (FGA) and data masking
• Extensively used Real Application Testing (RAT)to ensure the performance during database migrations (SQL performance Analyzer& Database Replay)
• Extensive troubleshooting and tuning skills and analyzing the diagnostic reports AWR, ADDM, ASH and STATPACK
• Oracle Exadata implementation expert configuration from X2 to X5 systems
• Tuning and implemented best practices for Exadata Flash Cache, Smart Scans and Cell offloading
• Troubleshooting and tuning Exadata Cell server performance
• Worked with the vendors and partial Implementation of Exadata Hybrid Columnar Compression
• Integration of Exadata with grid and cloud control for centralized monitoring
• Configured ODI & Oracle GoldenGate from / to Exadata - Hadoop HDFS and NoSQL databases

PROFESSIONAL EXPERIENCE:

Confidential

Senior Oracle DBA / DB lead performance tuning / Big Data Design Manager

Responsibilities:

• Led the database performance tuning team and resolved memory leakage issues through OS kernel tuning, Completed database optimizer tuning and implemented plan stability.
• Led the server migration and database upgrade team. Mission critical trade port databases (Oracle version11.2.0.1) was upgraded to Oracle 11.2.0.4 and migrated to RHEL server without any downtime.
• Proof of Concept - Oracle Exadata for 4 node RAC clusters ( Half RACK - Exadata) and data integration to BigData (Hortonworks)

Environment: IBM AIX 5.3, RHEL 7.3 Oracle 11.2.0.1, Oracle 11.2.0.4, Oracle GoldenGate 12.2.0.1

Confidential

Senior Oracle DBA

• Designed Zero downtime DB upgrade using Oracle Streams (Schema Replication)
• Designed and implemented for Oracle DB migration to SAP HANA system using SAP BODS extractors - SAP HANA Studio
• Designed replacing existing Data Refresh from disparate system DB2 by IBM Q Rep by Oracle interface with Oracle External Tables and Oracle Loader

Environment: Oracle 9i, Oracle Streams, Oracle 11.2.0.4, IBM AIX & SAP HANA

Confidential

Oracle DB global Expert

• Led business proposal for CRM - Siebel database tuning, archiving & purging strategy for ultra large tables by using Oracle GoldenGate,
• Exadata X4 patching, UAT and post production support support
• Created proposal to move Siebel CRM 3 node RAC DB to Exadata machine (Business Development, Proof of Concept (PoC)
• Created proposal to implement columnar compression for SAPPROD database in Exadata machine for effective use of storage

Environment: Oracle Enterprise Linux, Oracle Exadata X2-2, X4-8 Siebel CRM RAC DBs, Oracle 11.2.0.4

Confidential

Root cause analysis

• Led multiple database teams ( Confidential DBA team and infra structure team), Rimini Street, USA (Oracle Service provider), Comptel DBA team, Enkitec team ( Confidential, Australia) and EMC storage team to resolve database corruption issue
• Fixed data propagation issues from SAPROD Exadata machine to Comptel DB.

Confidential

Senior Oracle DBA

• Led Proof of Concept (PoC) to replace existing software (Change Data Capture by IBM) by using the Oracle Streams Replication from 5 sources running in multiple versions of Oracle multi node RAC database
• Designed and implemented migration of Oracle 11i apps to Exadata machine - using DBFS
• Designed , configured and implemented to move Oracle EBS to Exadata Machines X4

Environment: Solaris, HP-UX, Windows Servers, Oracle Exadata X4-8 , Oracle apps 11i , Oracle 11.2.0.4 , IBM (Change data Capture), ASM, Grid, Oracle RAC DB

Confidential

Senior Oracle DBA

• Designed, executed, and implemented Oracle TimesTen in memory database upgrade
• Moved databases running in individual physical servers to Oracle Virtual Machines
• Business Development - created proposal to migrate oracle databases running various versions of Oracle from 7.3 to 11gR2 to Exadata Machine X4. Based on the complexity and size, provided various methodologies to reduce the downtime. (exp/imp, expdp/impdp, CTAS, DBFS, XTTS (cross platform transportable tablespaces and transportable databases, Incremental RMAN backup)
• Supported full cycle of Data consolidation from Oracle databases from various versions to Exadata , provide post production support which includes patching and performance tuning

Environment: Oracle Exadata x4-2, Multiple versions of Oracle in multiple OS, Oracle TimesTen -in-memory database & VMware

Confidential

Senior Oracle DBA

• Moved database from Oracle Virtual Machines to physical servers for all production databases 11gR2 OEL.
• PoC on Oracle BigData Appliance and Cloudera Hadoop using commodity hardware and software

Environment: Oracle Enterprise Linux, Oracle Virtual Machine , Oracle ASM,RAC, Oracle 11.2.0.3, Oracle BigData Appliance , Cloudera Hadoop eco system

Confidential

• Led DBA team to create capacity planning, creating and communicating service delivery procedures and run-books, managing SLAs and deadlines, Oracle vendor escalation, Veritas cluster design
• Developments & New proposals (Design / Lead and implement)
• Created zero downtime upgrades proposal for production databases from 10gR2 HP-Itanium 5 node RAC clusters to 11gR2 to RHEL 3 node RAC clusters (from multimode RAC to multimode RAC) using Oracle GoldenGate (14 production databases with varied size from 2TB to 14TB).
• Effective usage of Oracle Real Application Testing (RAT) to ensure the performance before and after migration by RAT. Extensively tested the actual workload with RAT and ensured the explain plans are the same before and after migration.
• The workload simulation done by Database replay (RAT) since the load testing are more accurate than other traditional simulators which gain confidence for clients for our migration approach.
• Designed excellent fallback plans for all the production databases using reverse swing from migrated higher versions to the earlier versions of production databases using Oracle Goldengate.
• Offload work from 5 node production RAC databases (HP- Itanium 10gR2) to another multimode RAC databases (RHEL 11gR2) for selected tables sizes ranges with 4TB - 6TB size using Oracle GoldenGate live sync.
• Created Business proposal for JARVIS - Oracle Big Data Appliance (Infrastructure design included Cloudera HDFS, Oracle Data Integrator ODI, Oracle GoldenGate, Oracle Loader, Oracle Discoverer & Oracle Exadata X2-8)

Environment: Oracle 10.2.0.5, Oracle 11.2.0.4, HP-Itanium, RHEL 5.7 & 6.3, Oracle GoldenGate 11g , Veritas Clusters , Oracle ASM , GRID ,RAC, ACFS, Oracle Exadata X2-8 , Hitachi Shadow Image