Oracle Database Consultant

We have an onsite requirement for a Core DBA with a Kerala-based client. Candidates should have 7+ years of relevant experience and be available to work Monday through Saturday (6 days working).

We are seeking Oracle Database professionals to provide 24x7 operational and advanced support for mission-critical customer environments. The role includes database administration, monitoring, troubleshooting, performance tuning, high availability, backup/recovery, patching, and incident resolution across Oracle Database platforms.

Key responsibilities include:

- Administer, monitor, maintain, patch, upgrade, and troubleshoot Oracle Database environments.
- Perform SQL, database, memory, and performance tuning; analyze AWR/ASH and resolve complex performance issues.
- Manage Oracle RAC, ASM, RMAN, Data Guard, Fast-Start Failover, backup/recovery, and disaster-recovery operations.
- Support Oracle GoldenGate, Exadata, multitenant databases (CDB/PDB), Enterprise Manager, and OCI-hosted databases where applicable.
- Conduct database health checks, capacity reviews, proactive risk identification, and operational reporting.
- Resolve incidents within SLA, lead technical escalations,



document root causes, and maintain support runbooks.
- Work closely with customer IT teams, Oracle Support, Development, and internal SMEs to drive issues to closure.
- Support database security capabilities including TDE, Oracle Key Vault, Database Vault, wallets, and AVDF where required.
- Provide clear customer communication, technical status updates, and action plans during critical incidents.

Desired profile:

- L3 DBA / SME: 10+ years of experience with advanced expertise in Oracle Database, Exadata, RAC, ASM, Data Guard, GoldenGate, performance tuning, backup/recovery, and high-severity escalations.
- Experience with Oracle Database 11g, 12c, 18c, and 19c; OCI and Oracle Enterprise Manager experience is preferred.
- BE/BTech/MCA/MS or equivalent experience; Oracle OCA/OCP, OCI, or Autonomous Database certifications are desirable.
- Solid troubleshooting, analytical, communication, customer-management, and escalation-management skills.
- Willingness to work in a 24x7 support model and travel to customer locations when required.

📌 Oracle Database Administrator (Ernakulam)
🏢 Prudence Technology
📍 Ernakulam