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.