Senior SME supporting global enterprise customers across OCI, Exadata, RAC/ASM, and cloud data platforms. Provides deep technical troubleshooting, architecture guidance, and performance optimization for mission critical workloads in financial, insurance, retail, and telecom sectors.

• Improved Exadata performance for a global bank by 60% by resolving a critical storage cell bottleneck.

• Reduced OCI Data Flow job failures by 40% through optimized Spark configurations, partitioning, and shuffle tuning.

• Automated diagnostic collection using Python + OCI CLI, reducing RCA time by 25%.

• Improved customer DR readiness by designing Data Guard failover playbooks, reducing RTO from 45 minutes to under 10 minutes.

• Enabled secure data ingestion for regulated clients by implementing KMS/Vault encryption and IAM hardening.

• Reduced recurring incidents by 30% through proactive monitoring and pattern based RCA.

• Supported customers using OCI Data Flow, Data Integration, Streaming, Object Storage, ADW/ATP, GoldenGate, and Analytics Cloud.

• Designed secure, scalable cloud architectures aligned with financial sector governance.

• Optimized Spark jobs for large scale ETL workloads, improving performance and reducing cost.

Exadata & Database Engineering

• Troubleshot complex issues across Exadata (ExaCS/ExaCC), RAC, ASM, Clusterware, Grid Infrastructure.

• Performed deep performance diagnostics using AWR, ADDM, SQL Trace, and TKPROF.

• Tuned SQL queries, optimized execution plans, and resolved high load incidents.

Security & Compliance

• Implemented IAM, RBAC, TLS/SSL, network encryption, KMS/Vault key rotation.

• Strengthened customer security posture through identity hardening and encryption enforcement.

• Automated diagnostics using Python, Spark, and OCI CLI.

• Reproduced customer issues in lab environments to accelerate RCA and reduce downtime.

• Developed scripts to streamline operational workflows and reduce manual effort.

• Led migration of 30+ production databases to Oracle 19c RAC, improving scalability by 40% and strengthening security controls.

• Designed and implemented secure database architectures, ensuring compliance with enterprise security standards and GDPR.

• Automated monitoring and alerting using Python and Shell scripting, reducing manual effort by 50% and improving response time by 35%.

• Implemented RBAC, auditing, and patching strategies, reducing security vulnerabilities by 30%.

• Managed Data Guard environments, achieving 99.99% availability and near-zero data loss.

• Performed advanced performance tuning, improving query performance by up to 60%.

• Built RMAN backup frameworks for 30+ databases, ensuring 100% recoverability and SLA compliance.

• Led incident management and RCA, reducing recurring issues by 25%.

• Supported MongoDB and PostgreSQL, implementing secure configurations and access control mechanisms.

• Mentored team members and improved operational efficiency by 20%.

Apple has many missions critical applications hosted on various enterprise production databases. Provided support for iTunes, Mobile Me ,New Castle,iCloud and iPhone databases.

Database support:

• Finance

• Content

• Finance Shared

• Partition

Main databases on Mme & New Castle

• Idp2

• Partition databases

Total Production databases for iTunes,Mme=310.

Overview of the processes used including Problem Management and change management process and impact assessment.

Used following tools for the internal management.

• Espresso as a ticketing system,

• Mail for setting up mailbox.

• Open Directory for directory services

• Launchpad for logging to Production host

• iChat as chat communication and group chat.

• iCal for scheduling meetings.

• ISCONFLUENCE for internal documentation.

Activities:

DF Check - File System

Table space space addition

Push tickets (Change / Release Management)

DB refresh - ITMS

System Appreciation Document

DB upgrade - Delayed

Scheduling Export backup for non production systems & Fixing

HTML DB

MYSQL Operation Document

Espresso Ticketing Tool

Scheduling TOP SQL Report [DBAMAINT_USER} & Fixing Issues

Monitor Active sessions

Session Waits

High load average.

Database lock-waiting sessions

Application Deadlocks

Top SQL reports (Analyzing TOP SQL report)

Database Standby Build [HA & Delayed]

Database Creation

Scheduing CRONTAB.