L2 Database Operations Engineer (Oracle & SQL Server)

Position summary:

We are looking for a skilled L2 System Administrator to support enterprise Oracle and Microsoft SQL Server database environments. The role is responsible for database monitoring, incident resolution, routine administration, backup validation, performance troubleshooting, job monitoring and operational maintenance. The administrator will work closely with L1 operations, L3 Database SMEs, Application, Server, Storage and Infrastructure teams to ensure database availability, data integrity and SLA compliance.

Key Responsibilities:

Oracle Database Operations

• Provide L2 support for Oracle Database incidents, alerts and service requests.
• Monitor database availability, tablespace utilization, sessions, locks, alert logs and critical database processes.
• Troubleshoot connectivity issues, failed jobs, space utilization and routine database performance problems.
• Support tablespace management, user administration, privileges and approved configuration changes.
• Monitor RMAN backup status and coordinate restore and recovery activities with the DBA team.
• Support scheduled database maintenance, health checks and patching activities as per approved procedures.
• Monitor Data Guard status & replication alerts where applicable, escalate complex issues to L3.

Microsoft SQL Server Operations

• Provide L2 operational support for Microsoft SQL Server instances and databases.
• Monitor database availability, SQL Agent jobs, database growth, disk utilization and error logs.
• Troubleshoot failed jobs, connectivity issues, blocking sessions and basic performance problems.
• Support database user administration, permissions and approved configuration changes.
• Monitor backup status and validate scheduled backup and maintenance jobs.
• Support database maintenance, patching and post-change validation.
• Assist with Always On availability groups and replication monitoring where applicable.

Operations & Service Management

• Resolve database incidents and service requests within defined SLAs.
• Follow ITIL Incident, Problem, Change and Request Management processes.
• Perform routine database health checks and investigate monitoring alerts.
• Support major incident restoration, backup verification and disaster recovery activities.
• Escalate complex performance, corruption, recovery and availability issues to L3 Database SMEs.
• Maintain runbooks, operational documentation, incident records and shift handover notes.
• Coordinate with Application, Server, Storage/Backup, Network and Infrastructure teams.
• Ensure effective APAC–EMEA–NLAM follow-the-sun handovers.

Required Skills:

• 3–6 years hands-on experience supporting Oracle Database and/or Microsoft SQL Server environments.
• Knowledge of database availability, sessions, locks, logs, space utilization and job monitoring.
• Working knowledge of SQL queries and basic database troubleshooting.
• Experience monitoring Oracle RMAN or SQL Server backup and maintenance jobs.
• Understanding of database users, roles