Senior Oracle Database Administrator

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.

Responsibilities

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.

Requirements

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 versions; 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.

Nice to have

Oracle 18C; Oracle 19C