Oracle DBA Job For 3-8 Year Exp In Avantha Technologies Limited Bengaluru / Bangalore – 1340586

• Installation, configuration and upgrading of Oracle server software and related products
• Good Understanding of RAC (2 nodes or 3 nodes) and its services
• Understanding Active/Passive, Active-Active (ASM and Veritas Cluster)
• Different OS few important commands to check the server load Partitioning (Partition Tables and it’s type understanding Range, Hash etc)
• Indexing (Local and Global Index, its benefits and drawbacks)
• Worked on Heavy databases 100+ TB (Filesystem and ASM)
• Adding Disk in ASM and Adding datafiles in RAC, tempfiles etc.
• Establish and maintain sound backup and recovery policies and procedures (RMAN backup, Level0, level1, level2 & Logical Backup Exports)
• Different backup and recovery scenarios understanding through RMAN
• Restoration backup (point in time recovery, control file restoration, datafile restoration)
• Implement and maintain database security (create and maintain users and roles, assign privileges)
• Perform database tuning and performance monitoring – Plan changing understanding, how to fix plan
• MOS SR raising, TFA generation Logs checking Cluster, ASM, scan listener etc.
• Patch Management (Patching single node and RAC two node, Three nodes)
• Oracle Data Guard understanding, troubleshooting, Archive files restoration, incremental backup restoration to make the DR sync