Oracle Database Administrator @ Cradlepoint

About this opportunity:
With the introduction of 5G and cloud, the role of IT Managed Services has evolved to become an enabler of new revenue opportunities, in addition to delivering efficient cloud and IT operations for service providers on their 5G journey.
Join us to understand how different technologies come together to build a best-in-class solution which has made Ericsson lead the 5G evolution. We will also explain how you can be part of this outstanding culture and advance your career while creating a global impact.
We believe in trust we trust each other to do the right things!
We believe in taking decisions as close to the product and technical expertise as possible.
We believe in creativity trying new things and learning from our mistakes.
We believe in sharing our insights and helping one another to build an even better user plane.

What you will do:

Oracle 12c, 18c, 19c & 21c versions
Performance tuning (Optimizing Queries, Instance Tuning)
Upgrade knowledge on oracle database upgrade from 12c to 19c and 19c to 21c.
Installation, configuration and upgrading of Oracle server software and related products (clients, RAC 2 nodes, stand-alone)
Good Understanding of RAC (2 nodes or 3 nodes) and its services
Understanding Active/Passive, Active-Active (ASM and Veritas Cluster)
A good knowledge of the physical database design
A good understanding of the underlying operating system (Windows, Unix, Linux, Solaris & AIX)
Different OS few important commands to check the server load (top, sar ,vmstat, etc).
Partitioning (Partition Tables and it s type understanding Range, Hash etc) and partition pruning.
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, temp files etc

The skills you bring:

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
Perform application tuning and performance monitoring
Work as part of a team and provide 24x7 support when required (Weekend supports, Shifting working)
Constraints understanding (PK, FK, un etc..)
MOS SR raising , TFA generation Logs checking Cluster, ASM , scan listener etc.
Patch Management (Patching single node and RAC two node, Three nodes)
Hands on experience on Golden Gate

Location - Bangalore/Noida

Experience - 3-12 years