L2 Database Engineer

Toyota Automated Logistics; Maharashtra; On-site; INR 1,200,000 - 2,000,000; Full time

Job summary

Toyota Automated Logistics in Maharashtra is seeking an L2 Database Engineer to manage Oracle databases, perform health checks, and keep systems highly available.

You will monitor OEM dashboards, RMAN backups, Data Guard, GoldenGate, and storage with ASM, while collaborating with global teams to implement changes and optimize performance.

The role requires a strong SQL/PLSQL background and ITIL awareness to ensure incident and change processes are followed.

Qualifications

• 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 OEM/Cloud Control.
• Experience with 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.

Responsibilities

• 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.

Skills

Oracle Database

OEM/Cloud Control

RMAN Backup & Recovery

Data Guard

GoldenGate

ASM (Automatic Storage Management)

SQL

PL/SQL

Linux/Unix

ITIL processes

Education

Bachelor’s degree in Computer Science/Information Technology/Engineering

Tools

OEM/Cloud Control

RMAN

Data Guard

GoldenGate

ASM

Job description

Job Title

L2 Database Engineer

Job Description

Your Responsibilities:

• 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.