Change Leader Hiring for Oracle Database Administrator (SME) at Mumbai, Maharashtra Full Time

Full Job Description
JOB DESCRIPTION

Oracle Database Administrator [SME]

Experience: 10+ years

Location: Mumbai (Goregaon, Airoli)

Primary Skills:
Oracle DBA’s Exp., Oracle 10g, 11g, 12c, 19C versions (18 & 19 Additional benefits), Oracle 10g, 11g, 12c, 19C versions (18 & 19 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/19C/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 24×7 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.