Darsan Devarajan

Senior System Executive (Oracle DBA)

• Job Details:Administered 50+ Oracle databases (500 GB–3 TB) across production, dev, and test environments supporting ~1,000 users with 99.99% uptime. Led quarterly patching cycles for Oracle 11g/12c/19c clusters and standalone systems with zero unplanned outages and full rollback plans. Migrated 10+ critical production databases using RMAN and GoldenGate with minimal downtime and 100% data integrity. Enhanced SQL performance for high-load systems by up to 40% using AWR, ADDM, and SQL tuning advisory reports. Configured and monitored GoldenGate replications, resolving lag and sync issues within SLA to ensure real-time replication. Configured and resolved 25+ Data Guard incidents, reducing average redo lag recovery time to under 10 minutes. Partnered with infrastructure and application teams on capacity planning and DR testing. Engaged with Oracle support for diagnosis and resolution of critical production issues and ORA errors and ensuring service continuity. Managed user administration and tablespace operations, including creating and dropping database users, assigning roles and privileges, auditing user activity, and managing object creation (tables, indexes, etc.). Performed core DBA tasks such as capacity planning, tablespace expansion, index management, creation of database links, disk space monitoring, and secure file transfers using SFTP.