TECHNO FUNCTIONAL CONSULTANT L2(CONTRACT)

Location: Bengaluru / Pune / Coimbatore (Work from Office)

Job Summary

Oracle Exadata DMA (L3) responsible for managing and supporting enterprise-scale Oracle Exadata platforms, ensuring high availability, performance, security, and compliance. The role focuses on full-stack Exadata administration, including patching, upgrades, monitoring, backup and recovery, and disaster recovery operations. The DBA proactively troubleshoots complex production issues, performs performance optimization, and supports RAC, Multitenant, and Data Guard environments. Works closely with cross-functional teams to maintain stable, secure, and resilient database platforms aligned with business SLAs.

Key Responsibilities

• Extensive experience in end-to-end administration of Oracle Exadata systems (X5–X9), ensuring high availability, performance, scalability, and lifecycle management for mission-critical enterprise workloads.

• Proven expertise in planning, reviewing, and executing full-stack Exadata patching across all components, including YUM, Grid Infrastructure, Oracle Database, Storage Cells, and InfiniBand switches.

• Strong hands-on experience with Exadata ExaCheck installation, upgrades, and analysis, proactively identifying system health issues and implementing corrective actions.

• Deep expertise in security vulnerability assessment and remediation across Exadata environments, covering compute nodes, Grid Infrastructure, databases, storage cells, and InfiniBand switches.

• Expert-level skills in Exadata Machine Administration and Oracle Database Administration, including upgrades, migrations, configuration management, and lifecycle operations.

• Extensive hands-on experience with Exadata management and diagnostic tools such as DCLI, CellCLI, ILOM, and Oracle Enterprise Manager (OEM) for monitoring, troubleshooting, and performance optimization.

• Proven expertise in planning, evaluating, and applying Oracle 11g, 12c, and 19c Exadata patches across database servers, storage servers, and InfiniBand switches.

• Strong experience with Oracle Multitenant architecture, including PDB refreshes, resolving PDB violations, cross-container PDB migrations in RAC environments, and CDB/PDB backup, restore, and recovery.

• Advanced expertise in Oracle backup and recovery solutions, leveraging RMAN, Flashback technologies, FRA management, and advanced recovery strategies.

• Expert in Point-in-Time Recovery (PITR) scenarios, including database PITR, TSPITR, and table-level recovery, ensuring data integrity and business continuity.

• Extensive experience in Oracle Data Guard and Data Guard Broker, performing production switchovers, failovers, and supporting disaster recovery planning to meet audit and compliance requirements.

• Strong skills in diagnosing and resolving invalid Oracle database components, maintaining system stability and compliance.

• Advanced expertise in database performance tuning and SQL optimization, resolving critical performance issues in high-availability RAC and Exadata production environments.

• Proven experience in table partitioning strategies, including migrating non-partitioned tables to partitioned designs and defining effective maintenance, pruning, and archiving strategies.

• Hands-on experience in Oracle GoldenGate configuration, monitoring, and troubleshooting for real-time data replication.

• Extensive experience in Exadata hardware fault management, including disk, flash card, battery, port, and InfiniBand switch replacements, ensuring minimal downtime and service continuity.

• Strong experience in installing and configuring Oracle 12c/19c RAC and CDB/non-CDB databases, including database cloning and environment standardization.

• Proven ability to upgrade and patch OEM agents and targets, ensuring consistent enterprise-wide monitoring and alerting.

Required Skills and Qualifications

• 8–14+ years of Oracle Database Administration experience, with 5+ years on Oracle Exadata platforms.

• 10+ years of strong experience in Oracle RAC Database Administration, including patching, Multitenant (CDB/PDB), Data Guard, and backup/recovery in high-availability environments.

• Proven ability to troubleshoot complex production issues, perform performance tuning, and manage security, monitoring, disaster recovery, and Exadata patching, with exposure to Oracle GoldenGate and large-scale Multitenant environments.

• Strong experience in Oracle Exadata administration (X5–X9) supporting mission-critical, high-availability environments.

• Hands-on expertise in full-stack Exadata patching and upgrades, including compute nodes, storage cells, Grid Infrastructure, databases, and InfiniBand switches.

• In-depth knowledge of Oracle RAC, Multitenant (CDB/PDB), Data Guard, RMAN, Flashback, and Point-in-Time Recovery (PITR).

• Proven skills in database performance tuning and SQL optimization in large-scale Exadata and RAC environments.

• Experience with Exadata tools such as DCLI, CellCLI, ILOM, OEM, and ExaCheck for monitoring, troubleshooting, and health assessments.

• Strong understanding of security vulnerability assessment and remediation across database, OS, Grid, and Exadata infrastructure layers.

• Working knowledge of Oracle GoldenGate for real-time data replication and troubleshooting.

Good-to-Have Skills

• Experience with IBM CDC replication, Exadata upgrades/migrations, and large-scale database consolidation initiatives.

• Exposure to automation/scripting, OEM upgrades, and audit-driven DR and compliance activities.