L2 Database Engineer

Job Title

L2 Database Engineer

Job Description

Your Responsibilities:

As a Database Engineer, you will be responsible for providing Level 2 operational support for Oracle database environments, including:

· Perform routine Oracle database health checks to ensure database availability and stability.

· Start and stop Oracle databases, Oracle Enterprise Manager (OEM)/Cloud Control, Oracle Listeners, and Oracle Monitoring Agents.

· Monitor Oracle Enterprise Manager dashboards, alert logs, and scheduled database jobs, and resolve operational issues.

· Monitor Oracle GoldenGate replication and Oracle Data Guard environments, including replication lag and service availability.

· Prepare periodic database health reports and operational dashboards.

· Monitor database host servers for CPU, memory, disk utilization, and system alerts.

· Monitor tablespace utilization and perform storage administration, including adding or resizing datafiles and managing ASM disk groups.

· Execute database cleanup activities such as compression, identifying top space consumers, and reclaiming storage through truncate or shrink operations.

· Monitor RMAN backup execution, archive log backups, and perform approved database recovery and restore activities.

· Investigate Oracle database errors (ORA-xxxx), generate AWR reports, identify blocking sessions, and support performance troubleshooting.

· Implement approved database configuration changes, including SGA/PGA parameter updates.

· Renew database-related certificates and remove invalid objects associated with decommissioned schemas.

· Ensure all activities are executed in accordance with established operational procedures, change management processes, and service level agreements.

What You Bring:

· Bachelor’s degree in Computer Science, Information Technology, Engineering, or a related discipline.

· Experience supporting Oracle Database Administration in enterprise environments.

· Good understanding of Oracle Database architecture and administration.

· Hands-on experience with Oracle Enterprise Manager (OEM)/Cloud Control.

· Experience with Oracle RMAN Backup & Recovery.

· Knowledge of Oracle Data Guard and Oracle GoldenGate.

· Experience with Oracle ASM (Automatic Storage Management).

· Ability to analyze Oracle alert logs, AWR reports, and troubleshoot database issues.

· Working knowledge of SQL, PL/SQL, and Linux/Unix operating systems.

· Understanding of ITIL processes, incident management, and change management is preferred.

Competencies:

· Strong analytical and problem-solving skills.

· Proactive approach to monitoring and issue resolution.

· Excellent communication and stakeholder management skills.

· Ability to work effectively within a global, cross-functional team.

· Customer-focused with a commitment to operational excellence.

· Ability to prioritize tasks and perform in a fast-paced environment.