About this opportunity:
We are now looking for a Oracle DBA professional.
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.
We truly believe in happiness; we enjoy and feel passionate about what we do and value each other s technical competence deeply.
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.
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