Dynamic and results-oriented Oracle Database Administrator with over 4 years of comprehensive experience in managing Oracle databases on Linux, Solaris, and AIX platforms Experience in managing large databases, Backup & Recovery.
Proficient in all aspects of database administration, including installations, configurations, upgrades, and performance tuning.
Skilled in backup and recovery strategies, utilizing RMAN with VERITAS Net Backup for hot/cold backups, cloning, and disaster recovery.
Experienced in implementing backup strategies and Oracle Data Pump utilities to ensure data integrity and availability.
Adept at performance tuning, utilizing tools such as EXPLAIN PLAN, AWR, ADDM, and Oracle 10g OEM grid monitoring to optimize database performance.
Proficient in PL/SQL, UNIX scripting, and Perl scripting to automate tasks and enhance efficiency.
Proven ability in proactive monitoring and identifying areas for improvement using AWR, ADDM, and TOAD. Experienced in configuring and managing OEM 12C for comprehensive database management.
Overview
4
4
years of professional experience
Work History
Oracle DBA
Aztec Technology Solutions Inc
CHICAGO, IL
02.2021 - Current
PROFESSIONAL SUMMARY
Dynamic and results-oriented Oracle Database Administrator with over 4 years of comprehensive experience in managing Oracle databases on Linux, Solaris, and AIX platforms Experience in managing large databases, Backup & Recovery.
Proficient in all aspects of database administration, including installations, configurations, upgrades, and performance tuning.
Skilled in backup and recovery strategies, utilizing RMAN with VERITAS Net Backup for hot/cold backups, cloning, and disaster recovery.
Experienced in implementing backup strategies and Oracle Data Pump utilities to ensure data integrity and availability.
Adept at performance tuning, utilizing tools such as EXPLAIN PLAN, AWR, ADDM, and Oracle 10g OEM grid monitoring to optimize database performance.
Proficient in PL/SQL, UNIX scripting, and Perl scripting to automate tasks and enhance efficiency.
Proven ability in proactive monitoring and identifying areas for improvement using AWR, ADDM, and TOAD. Experienced in configuring and managing OEM 12C for comprehensive database management.
Oracle DBA
Aztec Technology Solutions Inc
Chicago, IL
10.2019 - 02.2021
Experienced Oracle Database Administrator with a focus on Oracle 12c environment, proficient in database creation, performance monitoring, and troubleshooting.
Skilled in working closely with Oracle Support to address critical database issues promptly and effectively.
Capable of managing database refreshes from PROD to DEV environments for seamless application testing and upgrades.
Extensive experience with Data Guard for advanced replication and high availability solutions.
Proficient in database restoration and recovery procedures, ensuring minimal downtime and data loss.
Utilizes Grid Control for monitoring and managing database access and storage utilization.
Expertise in complete and incomplete recovery of production databases using RMAN copy and backup sets.
Experienced in shell scripting for automation of database tasks, including job scripts, startup/shutdown procedures, health checks, and index rebuilding. Proactively monitors database performance, access, and security, ensuring optimal functionality and data protection. Well-versed in providing DBA support in UNIX environments.
Education
Diploma - Business Management
Cambridge College of Learning
United Kingdom
08-2008
Bachelor of Accountancy - Finance
Osmania University
Hyderabad - India
03-1998
Skills
Application Support & Upgrades
ASM (Automatic Storage Management)
AWR, ADDM, Oracle 10g OEM Grid Monitoring
Backup & Recovery Strategies
Disaster Recovery with Standby Database/Data Guard
Data Guard
Disaster Recovery Planning & Testing
Database Security Management
Data Pump
Oracle Database Administration (10g, 11g)
Linux, Solaris, AIX Platforms
Linux Platform
Oracle Data Pump
Oracle RAC (Real Application Clusters)
OEM 12C Configuration & Management
RMAN, VERITAS Net Backup
RMAN Backup & Recovery
PL/SQL, UNIX Scripting, Perl Scripting
Performance Tunning:SQL, SGA, Disk I/O Distribution