Oracle DBA at Aeris

Gurugram, haryana, India -

Full Time

Start Date

Immediate

Expiry Date

15 May, 26

Salary

0.0

Posted On

14 Feb, 26

Experience

10 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Oracle Dba, Oracle 12c, Oracle 18c, Oracle 19c, Oracle 21c, Rac, Data Guard, Gcp, Performance Tuning, Troubleshooting, Rman, Mongodb, Exadata, Linux, Python, Shell

Industry

Software Development

Description

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.

Responsibilities

The role involves installing, configuring, and maintaining critical Oracle 12c through 21c databases, including RAC and Data Guard configurations, across on-premises and Google Cloud Platform environments. Key duties include ongoing administration, performance optimization through parameter and OS-level tuning, security enforcement, and managing backup/recovery strategies.