Summary
Overview
Work History
Education
Skills
Websites
Accomplishments
Languages
Timeline
Generic
Mohammed Umar Hussain Shaik

Mohammed Umar Hussain Shaik

Nellore

Summary

Oracle Database Administrator (DBA) with over 4+ years of experience managing and optimizing large-scale Oracle databases. Proven expertise in database design, implementation, and troubleshooting. Skilled in Backup and Recovery, Data Guard, and other key Oracle technologies. Committed to ensuring optimal database performance, data integrity, and disaster recovery.

Overview

5
5
years of professional experience

Work History

Oracle Database Administrator (DBA)

TCS
Chennai
08.2020 - Current
  • Oracle Database Administrator (DBA) with over 4+ years of experience managing and optimizing large-scale Oracle databases.
  • Proven expertise in database design, implementation, and troubleshooting.
  • Skilled in Backup and Recovery, Data Guard, and other key Oracle technologies.
  • Committed to ensuring optimal database performance, data integrity, and disaster recovery.
  • Managed and optimized Oracle databases with over 20TB of data, ensuring optimal performance and data integrity.
  • Monitored database health metrics using Oracle Enterprise Manager Cloud Control.
  • Monitored database activity, identified performance bottlenecks, and implemented optimizations to improve efficiency.
  • Developed and executed backup and recovery strategies to ensure data protection and minimize downtime.
  • Schema/table refresh activities using data pump utility.
  • Automated database administration tasks using Oracle Enterprise Manager and custom scripts, improving efficiency.
  • Utilized AWR/ADDM/SQLT for analyzing Locks and Deadlocks in DB to optimize SQL queries and improve performance.
  • Troubleshooted and resolved complex performance issues, reducing query response times significantly.
  • Migrated and upgraded Oracle databases to newer versions, ensuring seamless transition and data compatibility.
  • Designed and implemented Oracle database schemas for new applications, ensuring data integrity and optimized performance.
  • Creating and Managing User Permissions, Logins, and Configuring Security Per Organizational Standards.
  • Provided technical support to database users and developers, resolving issues and providing guidance.
  • Administered database security, including user management, access control, and auditing.
  • Automated database patching and updates using the Ansible platform.
  • Working on cross-platform migration using transportable tablespace and export/import.
  • Setting up the Physical Standby databases and administration monitoring db sync, log shipping, and gap.
  • Expertise in analyzing Index Usage, Fragmentation Reorganizing/Rebuild Indexes, and Update Statistics for Better Performance.
  • Stay up-to-date with the latest Oracle technologies and industry best practices through training and certifications.

Education

B.Tech - Computer Science And Engineering

Sree Vidyanikethan Engineering College
Tirupati, Andhra Pradesh

Intermediate - MPC

Hyderabad Institute Of Excellence
Vikarabad, Telangana

Primary Education -

Narayana Residential School
Nellore, Andhra Pradesh

Skills

  • Installation & Configuration of Oracle databases
  • RMAN Backup & Recovery
  • EXPDP/IMPDP
  • Oracle ASM management
  • Data guard implementation
  • Patch management
  • Database upgrade
  • Oracle Enterprise Manager
  • Database troubleshooting
  • Performance tuning
  • Oracle RAC configuration
  • Database migration

Accomplishments

  • Received the highest rating and recognition for exceptional work and dedication within the company
  • Service and Commitment Award
  • Best Team Award

Languages

  • English
  • Urdu
  • Hindi
  • Telugu

Timeline

Oracle Database Administrator (DBA)

TCS
08.2020 - Current

B.Tech - Computer Science And Engineering

Sree Vidyanikethan Engineering College

Intermediate - MPC

Hyderabad Institute Of Excellence

Primary Education -

Narayana Residential School
Mohammed Umar Hussain Shaik