محمد عاشق, Oracle DBA / DMA/OCI

محمد عاشق

Oracle DBA / DMA/OCI

UST Global

البلد
الهند - تشيناي
التعليم
ماجستير, Computer Applications
الخبرات
7 years, 9 أشهر

مشاركة سيرتي الذاتية

حظر المستخدم


الخبرة العملية

مجموع سنوات الخبرة :7 years, 9 أشهر

Oracle DBA / DMA/OCI في UST Global
  • الهند
  • أشغل هذه الوظيفة منذ يوليو 2022
Oracle Exadata DMA في Capgemini
  • الهند - تشيناي
  • مارس 2021 إلى يونيو 2022

• Exadata X4, x5, X7 and X8 QFSDP Full stack Patching (cell, compute and IB swicthes).
• Proactive Pre-planning of patching by raising Pre-emptive SR with Oracle and checking any roadblocks to proceed with patching by uploading Exachk reports, ILOM Snapshots etc.,
• Running patchmgr prerequisites to make sure the successful patch application prior to the patching.
• Taking care of patch failures and reiterating them for doing successful patch apply.
• Analysis of patchmgr.trc for step by step DB node update and Linux upgrade process.
• ILOM console monitoring for server reboots
• Checking ASR rules for assets for ASR creation on ILOM and test rules verification.
• Follow up with SR sev-1 for patching or on call activities.
• Handling All kinds of Hardware replacements example HBA, DIMM, MB, HDD, Flash disk, Battery replacement etc..
• Indepth Analysis of Exawatcher, Sundiag, TFA reports for server reboot RCA along with Oracle support.
• Generation of Normal ILOM snapshots, sundiag, exawatcher, TFA for issue time and upload to SR.

Oracle DBA في Mphasis
  • الهند - تشيناي
  • فبراير 2018 إلى مارس 2021

• Configure Maintaining Exadata Cell disk/Grid Disks.
• QFSDP Full Stack patching of Compute Nodes, Cell Nodes and IB switches.
• Configuring IORM/DBRM and Implementing Oracle Exadata best Practices.
• Monitoring the Infiniband Switches/ports, HCA ports on DB/CELL nodes
• Table space management and user creation.
• Monitor regular activities like Alert Logs, Trace files, RMAN Backups and Database, Tablespace Size.
• Experience in backup and recovery strategies through physical and logical backups.
• Responsible for monitoring and optimizing the performance of Queries, assisting developers in optimizing their queries, etc.
• Creation of Standby databases (Oracle Data guard) and monitoring the log shipping and log Sync with the production Database.
• Creation of Logical Standby databases for report Purposes.
• Performed Query tuning, Instance/Memory tuning by using various performance tools Explain Plan, Stats pack, Etc
• Experience in providing Security User Management, Privileges, Roles, Quotas, Auditing, Profiling, Authentication.
• Strong experience in Database Sizing, Table space Management and Security Administration in Oracle
• Analysis of the top resource consuming queries using AWR Reports and optimizing the same.
• Scheduling and monitoring of jobs processes, memory space and alert log files.
• Strong knowledge in ADDM, ASM, RMAN.
• Strong knowledge in Flashback Technology & Automatic Workload Repository (AWR).

Oracle DBA في SharpGaze
  • الهند - تشيناي
  • سبتمبر 2016 إلى يناير 2018

• Running cluster verification utility as one of precheck before installation and taking care of failures.
• Installing GI Infrastructure, ASM on legacy Redhat systems by following company standards.
• Configuring RMAN incremental level 0 and 1 backups enabling block change tracking methods.
• Target addition in OEM 13c cloud.
• Switchover and Switchback activities for DR test scenarios as per Apps requirement.
• Taking care of DG sync process.
• Converting the physical standby to snapshot standby database for testing purposes as requested.
• Database Administration and Maintenance such as space allocation, managing tablespaces, index, tables, user privileges and roles.

الخلفية التعليمية

ماجستير, Computer Applications
  • في Bishop Heber College
  • مايو 2015

Specialties & Skills

اللغات

التاميلية
اللغة الأم

الهوايات

  • Sports
    I have played State level Football in school and college.