16 Aug
|
Aeris Communications
|
Noida
16 Aug
Aeris Communications
Noida
Job Title: Senior Oracle Database Administrator
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 solid 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.
📌 Oracle DBA (Noida)
🏢 Aeris Communications
📍 Noida