L2 Database Administrator (DBA) / Oracle DBA (Full Time role)

Experience: 8-10 years relevant experience

Support Model: 24/7 Operations

Education:

Candidate must have bachelor s degree. (Mandatory)

Skills and Experience:

• Handson experience administering Oracle databases in production environments, including instance startup/shutdown, parameter tuning, and routine operational maintenance.
• Strong working knowledge of Oracle operational maintenance, including RMAN full and incremental backups, restore operations, archive log management, optimizer statistics gathering, and scheduled health checks.
• Ability to perform routine Oracle health diagnostics and remediation, including identifying tablespace and storage growth risks, validating database integrity, and proactively addressing common availability and performance issues.
• Ability to execute approved Oracle changes (installations, upgrades, PSU/patch application, and configuration updates) by following documented runbooks, validation steps, and rollback procedures.
• Working understanding of ITSM processes using ServiceNow, including Incident, Problem, Change, and Request Management, with accurate ticket documentation and timely escalation to L3 Oracle DBAs.
• Practical experience with Oracle performance monitoring and basic tuning, including AWR/ASH analysis, slow SQL identification, waitevent diagnostics, and monitoring CPU, memory, and I/O contention.
• Ability to package and escalate complex SQL, optimizer, and performance issues to L3 DBAs with relevant diagnostics and supporting analysis.
• Handson execution of Oracle backup validation and restore activities, including support for recovery and disaster recovery exercises under L3 guidance.
• Experience supporting Oracle security operations, including user and role management, privilege administration, password and profile enforcement, and execution of approved security controls.
• Experience supporting audit and compliance activities for Oracle env., including evidence collection, remediation execution, and controlled documentation updates.

Recommended Certifications:

• Oracle Database Administration Certified Professional (OCP 19c)
• Oracle Cloud Infrastructure (OCI) Database Specialist is an advantage
• Windows 2019/22/ Redhat Linux 8.x/9.x

• ITIL V4