Senior Oracle Database Administrator

Join our Team

About this opportunity:

Couchbase Database Administrator. In this pivotal role, you will be responsible for the architecture, deployment, management, and optimization of our critical Couchbase database environments. You will play a key role in ensuring the high availability, performance, and scalability of our data infrastructure, with a particular focus on deployments within Kubernetes.

What you will do:

• Design, deploy, and manage highly available, scalable, and performant Couchbase clusters on Kubernetes clusters/Container platforms in production and non-production environments.
• Perform database installation, configuration, patching, and upgrades.
• Implement and manage robust backup and recovery strategies for Couchbase.
• Monitor Couchbase health, performance, and capacity, proactively identifying and resolving issues.
• Conduct performance tuning, query optimization, and capacity planning for Couchbase.
• Experience with monitoring tools (e. g., Prometheus, Grafana, Splunk) for database metrics.
• Manage user access, security, and data encryption for Couchbase.
• Troubleshoot complex Couchbase-related incidents, performing root cause analysis.
• Lead Life Cycle Management for Couchbase DB product.
• Plan, design, execution, monitoring, and control, drive the closure, articulate project stages, resolve dependencies, etc.

The skills you bring:

• OCP 11g & 12c Oracle Certified Professional along with IT Graduation/Master’s degree.
• Design, deploy, and manage highly available, scalable, and performant Couchbase clusters on Kubernetes clusters/Container platforms in production and non-production environments.
• Oracle 10g, 11g, 12c, 18C, 19C versions (18 & 19 Additional benefits)
• Performance tuning (Optimizing Queries, Instance Tuning)
• Upgrade knowledge on oracle database upgrade from 12c to 19c and 11g to 12c.
• 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 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, topas sar ,vmstat
• 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, 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 support when required (Weekend supports, Shifting working)MOS SR raising , TFA generation Logs checking Cluster, ASM , scan listener etc.
• Patch Management (Patching single node and RAC two node, Three nodes).
• “All academic credentials must be from recognized and accredited institutions and are further subject to verification.”