Arun Madanu

Oracle SQL Developer and Database Administrator with 7+ years of experience in Oracle database development, performance tuning, and database administration. Strong expertise in writing complex SQL queries, developing PL/SQL packages, procedures, and triggers, and optimizing database performance. Experienced in Oracle 11g, 12c, and 19c environments with hands-on experience in RMAN backup and recovery, Data Guard, RAC, and database upgrades.

SQL Developer & Oracle DBA at N2FORCE Technologies (2020-07 – 2026-01)

Environment: Oracle 12c, 19c, Linux

• Improved query performance by 40% by optimizing SQL queries and indexing strategies.
• Reduced database downtime by implementing automated RMAN backup strategies.
• Successfully upgraded production databases from Oracle Database 12c to Oracle Database 19c with minimal downtime.
• Supported high-availability environment using Oracle Data Guard standby databases.
• Developed and maintained complex SQL queries, PL/SQL stored procedures, functions, packages, and triggers to support enterprise applications.
• Optimized SQL queries using execution plans and optimizer hints to improve database performance.
• Designed and implemented database objects including tables, views, indexes, and materialized views.
• Performed database performance monitoring and troubleshooting using AWR and ADDM reports.
• Implemented RMAN backup and recovery strategies for production and non-production environments.
• Managed Oracle RAC environments and monitored database instances using SRVCTL and CRSCTL utilities.
• Created and maintained physical standby databases using Oracle Data Guard.
• Managed database users, roles, privileges, and profiles to maintain security and access control.
• Performed database upgrades from Oracle 12c to 19c.
• Collaborated with application teams for database deployments, troubleshooting, and performance improvements.
• Automated database maintenance tasks using SQL scripts and Linux cron jobs.

Database Administrator at IT Ridge Technologies (2019-02 – 2020-06)

Client: Economical Insurance, Canada Environment: Oracle 11g, 12c, 19c | OEL | RHEL | AIX

• Managed database storage structures including tablespaces, datafiles, and redo log files.
• Implemented RMAN backup strategies and performed database recovery when required.
• Created clone databases for testing environments using RMAN.
• Monitored and maintained Data Guard physical standby databases.
• Gathered database statistics using DBMS_STATS to improve query performance.
• Performed logical backups using Oracle Data Pump utilities.
• Monitored database alerts and resolved database-related issues.
• Managed database users, privileges, roles, and profiles.
• Applied database patches and performed database version upgrades.
• Performed database monitoring and administration using srvctl and crsctl utilities.

Bachelor of Science – Osmania University, Hyderabad (2015)