Noida, Uttar Pradesh

Job Summary

Oracle Database Administrator (L3) Position: Oracle Database Administrator (DBA) - L3 Experience: 6-10+ Years Location: As per business requirement Shift: Rotational / On-call Support (if applicable) Role Summary The Oracle DBA (L3) serves as the highest level of technical support for Oracle database environments, responsible for database architecture, performance optimization, high availability, disaster recovery, security, automation, and strategic database initiatives. The role involves resolving critical production issues, leading complex projects, mentoring L1/L2 teams, and ensuring robust, secure, and scalable database platforms. Key Responsibilities Database Architecture & Administration Design, implement, and maintain enterprise Oracle database environments. Lead database installation, upgrades, migrations, and patch management activities. Define database standards, best practices, and governance frameworks. Perform capacity planning and infrastructure optimization.



Advanced Performance Tuning Analyze and resolve complex database performance issues. Perform SQL tuning, execution plan analysis, and index optimization. Review AWR, ASH, ADDM, and Statspack reports. Optimize Oracle database configurations for maximum performance and scalability. High Availability & Disaster Recovery Design and manage Oracle RAC environments. Implement and maintain Oracle Data Guard solutions. Lead disaster recovery planning, testing, and execution. Support business continuity initiatives and HA architectures. Backup & Recovery Management Define backup and recovery strategies using RMAN. Execute complex database recovery scenarios. Ensure recovery objectives (RTO/RPO) are met. Conduct periodic backup and recovery testing. Incident & Problem Management Act as the highest escalation point for critical production incidents. Conduct detailed Root Cause Analysis (RCA) and problem management reviews. Collaborate with Oracle Support for complex issues.

📌 Track Manager (Noida)
🏢 HCLTech
📍 Noida