Job Search Status
Open to workDesired start date: Immediately
Open To Work
Verified
This profile is verified using an email address.
Abdulrahman Shaikh
Navi Mumbai
Work Preference
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
Boisar08-2021
Diploma - Mechatronics
Malik Sandal Polytechnic
Vijapura07-2016
H.S.C/12th - Science
Samadiya Jr. College
Bhiwandi02-2013
S.S.C/10th -
Samadiya High School
Bhiwandi03-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