Ayush Kamal

Results-driven Senior Oracle Database Administrator with 5.8+ years of total IT experience across enterprise infrastructure management, database security, and high availability systems. Specialized in Oracle Audit Vault and Database Firewall (AVDF), Oracle Data Vault, advanced performance tuning, and Shell scripting automation. Proven track record in core database administration, patching, backup/recovery, Data Guard DR configurations, and Exadata infrastructure support.

Senior Oracle Database Administrator at DGliger Consulting (2024-06 – Present)

• Implemented and managed Oracle AVDF for continuous audit data collection, firewall policy enforcement, and real-time threat detection; configured Oracle Data Vault realms and command rules to secure critical application schemas and restrict unauthorized DBA access.
• Diagnosed and remediated database performance bottlenecks, long-running queries, and execution plan shifts using AWR, ASH, and OEM diagnostics.
• Executed routine standalone and RAC database patching (opatch / opatchauto), including quarterly RU/PSU updates and critical bug fixes to ensure system security and compliance.
• Authored custom UNIX/Linux Shell scripts to automate daily database health checks, alert generation, tablespace monitoring, and backup cleanup.
• Managed core DBA responsibilities including user/role administration, schema refreshes via Data Pump (EXPDP/IMPDP), tablespace management, and storage allocation.

Oracle Database Administrator at Cognizant (2020-11 – 2024-06)

Client: Loblaw

• Managed Production-DR sync using Data Guard, executing routine switchover/failover activities and resolving sync issues using RMAN incremental backups.
• Coordinated with Oracle Support and Field Engineers for Exadata server patching, hardware maintenance, and Service Request (SR) resolution.
• Managed GoldenGate operations (process control, report file analysis) and table re-instantiation using Data Pump.
• Supported 24/7 production operations, managed change tickets within strict SLAs using ServiceNow, and maintained problem logs for recurring issues.
• Executed database cloning, schema/table level refreshes, and managed RMAN backups across production and test environments.

B. Tech. in Mechanical Engineering – APJ Abdul Kalam Technical University (2014 – 2018)

10+2 – Modern Public School (2013 – 2014)

10 – Modern Public School (2011 – 2012)