Oracle DBA

Job Title: Senior Oracle Database Administrator (DBA)

Location: Noida, Gurgaon

Role Overview

We are seeking a highly skilled and experienced Senior Oracle DBA to manage and maintain critical Oracle 12c, 18c, 19c, 21c single instance and RAC databases with Data Guard, hosted on Google Cloud Platform (GCP) and on‑premises environments.

This role will focus on ongoing administration, performance optimization, and troubleshooting The ideal candidate will have deep expertise in Oracle database administration, OS‑level tuning, parameter optimization, security, and backup/recovery in large-scale enterprise production environments, with additional experience in MongoDB.

Experience with Oracle Exadata (on‑prem or cloud) — including architecture understanding, cell/offload features, smart scans, and performance tuning — will be considered a strong plus.

Key Responsibilities

Oracle Database Administration

• Install, configure, and maintain Oracle 12c, 18c, 19c, 21c (single‑instance, RAC, Data Guard) and MongoDB in on‑prem and GCP VM environments.
• Implement and manage Oracle Data Guard for HA/DR (switchovers, failovers, broker configuration).
• Develop and execute backup/recovery strategies (RMAN, MongoDB backups), including DR drills.
• Perform database upgrades, patching, migrations, and security hardening.
• Proactively monitor database health and performance, ensuring minimal downtime.
• Provide ongoing post‑migration administration, tuning, and troubleshooting for Oracle databases on GCP Exadata Cloud Service.

Performance Tuning & Optimization

• Tune Oracle database parameters (SGA/PGA sizing, AMM/ASMM) for optimal performance in GCP environments.
• Analyze AWR reports, identify bottlenecks, and resolve high memory usage issues.
• Optimize SQL queries, indexes, and partitioning for large datasets.
• Apply Linux OS‑level tuning (kernel parameters, HugePages, I/O subsystem, TCP/IP).

Security & Compliance

• Enforce access controls, encryption, and auditing for all databases.
• Ensure compliance with corporate and regulatory requirements.

Automation & Documentation

• Automate routine tasks using Shell, Python, PL/SQL.
• Maintain accurate operational documentation, SOPs, and runbooks.

Qualifications

Education:

• Bachelor’s degree in Computer Science, Information Technology, or related field.

Experience:

• 10-12 years as an Oracle DBA in production environments.
• Deep expertise in Oracle RAC, Data Guard, and performance tuning.
• Experience managing large databases on Google Cloud Platform.
• MongoDB administration (on‑prem and cloud).
• Proven OS‑level tuning skills in Linux.

Experience with Oracle Exadata (on prem or cloud) — including architecture understanding, cell/offload features, smart scans, and performance tuning in Exadata environments will be a plus

Certifications:

• Oracle Certified Professional (OCP) preferred.
• GCP Cloud Architect/Engineer certifications a plus.

Soft Skills:

• Strong problem‑solving skills, cross‑functional collaboration, excellent communication.

Nice-to-Have Skills

• Experience with GoldenGate replication.
• Exposure to AWS or Azure.
• Familiarity with Agile/DevOps and tools such as Ansible, Chef, Puppet.
• Experience with Active Data Guard.
• Understanding of cloud cost optimization strategies.