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.