Job
Description
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 stechnical competence deeply. What you will do: Performance tuning (Optimizing Queries, Instance Tuning) 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) 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) The skills you bring: Oracle 12c, 18c, 19c & 21c versions 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 2nodes, 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) Worked on Heavy databases 100+ TB (Filesystem and ASM) Hands on experience on Golden Gate
