Summary
Overview
Work History
Education
Skills
Timeline
Generic
Osman  Mirza

Osman Mirza

Chicago,IL

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.

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
  • TOAD

Timeline

Oracle DBA

Aztec Technology Solutions Inc
02.2021 - Current

Oracle DBA

Aztec Technology Solutions Inc
10.2019 - 02.2021

Diploma - Business Management

Cambridge College of Learning

Bachelor of Accountancy - Finance

Osmania University
Osman Mirza