Work Preference
Summary
Overview
Work History
Education
Skills
Languages
Personal Information
Timeline
Generic
Abdulrahman Shaikh
Open To Work
Verified
This profile is verified using an email address.

Abdulrahman Shaikh

Navi Mumbai

Work Preference

Job Search Status

Open to work
Desired start date: Immediately

Desired Job Title

ConsultantOracle DBA (Offshore)Oracle Database Administrator

Salary Range

₹45000/yr - ₹200000/yr

Summary

Dynamic Oracle Database Administrator with over 4.6 years of experience specializing in Oracle RAC Configuration, performance tuning, and high availability solutions. Demonstrated success at Clover Technologies Pvt Ltd. in optimizing database performance and ensuring system stability. Achieved a very good satisfaction rate in resolving database-related tickets while expertly implementing security measures and enhancing overall system efficiency.

Overview

4
4
years of professional experience

Work History

Consultant

Clover Infotech Pvt Ltd (Equitas Small Finance Bank)
10.2022 - Current
  • Successfully installed, configured, and managed Oracle Database 12c/19c RAC across Linux, Solaris, Windows, and AIX servers.
  • Efficiently patched Grid home and Oracle home binaries in both development and production environments using OPatchauto and manual methods to maintain system security and stability.
  • Configured and supervised physical standby databases, successfully performing switchover and failover operations to ensure high availability and data integrity.
  • Converted physical standby databases into snapshot standby databases for testing purposes.
  • Performed incremental recovery of standby databases through services to synchronize them with the production database.
  • Efficiently managed database backups and recovery processes, ensuring data integrity and minimizing downtime.
  • Conducted capacity planning and optimization to achieve efficient resource utilization and prevent system overload.
  • Performed index rebuilds and gathered statistics to ensure tables remained efficient and up-to-date.
  • Automated monitoring jobs using Crontab and Microsoft VBA for Excel, significantly increasing monitoring efficiency.
  • Leveraged AI tools to analyze Explain Plans and JSON-converted AWR reports, pinpointing poorly written SQL and high I/O bottlenecks. Partnered with developers to apply these AI-driven insights, reducing buffer gets and improving query and application performance.
  • Resolved critical RAC issues, including Grid start-up failures, RAC interconnect problems, high I/O on ASM disks, Grid permission issues, block corruption, and unknown data file.
  • Collaborated effectively in troubleshooting database-related issues during incident calls.
  • Contributed to identifying and resolving critical database problems, demonstrating strong problem-solving skills and teamwork.
  • Effectively resolved various database locking/blocking issues to maintain smooth and uninterrupted operations.
  • Utilized Oracle Support to troubleshoot and solve critical database issues.
  • Delivered expert technical support and troubleshooting for database issues, handling problems promptly to maintain high system availability.
  • Partnered with developers, system administrators, and change management teams to transition databases from development through testing to production, transforming business requirements into environment-specific databases.
  • Standardized the placement of database-related files and managed logical and physical backups (full, partial, and structure exports) to enhance data organization and retrieval efficiency.
  • Created comprehensive documentation for the DBA team, streamlining knowledge sharing and reducing onboarding time for new members.
  • Proactively oversaw daily DBA activities, including system monitoring, troubleshooting, and performance tuning, to contribute to overall database stability.
  • Attended bi-weekly and monthly meetings to understand business needs and provide enhancement suggestions.
  • Executed daily database administration tasks on over 120 Oracle 19c production databases and over 100 non production databases, contributing to consistent performance across the IT infrastructure.
  • Compiled and maintained detailed documentation on database configurations and procedures to ensure compliance with company standards.
  • Built Microsoft Excel VBA macros to easily monitor all production and non-production databases.
  • Clover Technologies Pvt Ltd - Navi Mumbai, Maharashtra

Oracle DBA (Offshore)

The Schnell Apps Pvt. Ltd
Thane, Maharashtra
09.2021 - 09.2022
  • Administered and maintained Oracle database environments, ensuring optimal performance and continuous availability for organizational operations.
  • Assisted in user management, including schema creation, profile management, and assigning appropriate access privileges to maintain data security.
  • Monitored database alerts and system logs, performing initial troubleshooting for performance bottlenecks and escalating critical issues when necessary.
  • Executed routine backup procedures and verified backup integrity to safeguard data and ensure disaster recovery readiness.

Education

B.E. - Electrical Engineering

Theem College of Engineering
Boisar
08-2021

Diploma - Mechatronics

Malik Sandal Polytechnic
Vijapura
07-2016

H.S.C/12th - Science

Samadiya Jr. College
Bhiwandi
02-2013

S.S.C/10th -

Samadiya High School
Bhiwandi
03-2011

Skills

  • Oracle RAC Administration
  • Installation and Patching of Databases
  • RMAN Backup and Recovery
  • Database Security Management
  • Grid Infrastructure Management
  • Data Guard and Disaster Recovery
  • Schema Management and Capacity Planning
  • Teamwork and Collaboration
  • Oracle Database 11g
  • Oracle Database 12c
  • Oracle Database 19c
  • Windows 7
  • Windows 8
  • Windows 10
  • Windows Server 2012
  • Windows Server 2016
  • Red Hat Linux
  • Oracle Linux

Languages

English
Hindi
Marathi
Arabic

Personal Information

Date of Birth: 10/12/95

Timeline

Consultant

Clover Infotech Pvt Ltd (Equitas Small Finance Bank)
10.2022 - Current

Oracle DBA (Offshore)

The Schnell Apps Pvt. Ltd
09.2021 - 09.2022

B.E. - Electrical Engineering

Theem College of Engineering

Diploma - Mechatronics

Malik Sandal Polytechnic

H.S.C/12th - Science

Samadiya Jr. College

S.S.C/10th -

Samadiya High School
Abdulrahman Shaikh