Oracle DBA / DMA/OCI
UST Global
مجموع سنوات الخبرة :7 years, 9 أشهر
• 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.
• 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).
• 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.