Oracle DBA

JOB DESCRIPTION

Oracle Database Administrator

Experience: 4 + years

Location: Mumbai

Primary Skills:
• Oracle DBA's Exp., Oracle 10g, 11g, 12c, 1+C versions (18 & 1+ Additional benefits), Oracle 10g, 11g, 12c, 1+C versions (18 & 1+ Additional benefits).
• Installation, configuration and upgrading of Oracle server software and related products (clients, RAC 2 nodes, stand Along).
• Good Understanding of RAC (2 nodes or 3 nodes) and its services.
• Understanding Active/Passive, Active-Active (ASM Cluster).
• OCP 12c/1+C/21C Oracle Certified Professional along with IT

Graduation/Master’s degree

Desired Skills & Responsibilities
• A good knowledge of the physical database design.
• A good understanding of the underlying operating system ( Unix (linux, solaris & AIX)).
• 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, controlfile 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
• Perform application tuning and performance monitoring .
• Work as part of a team and provide 24x7 suppor t when required (Weekend supports, Shifting working)
• MOS SR Creation , TFA/OSW 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