L2 Database Operations Engineer – Oracle, SQL Server

This is a fully remote position, open to applicants in India.

📋 Description

• Deliver L2 support for Oracle Database incidents, alerts, and service requests.

• Oversee Oracle database availability, tablespace usage, sessions, locks, alert logs, and essential processes.

• Diagnose connectivity issues, failed jobs, space usage, and routine database performance challenges.

• Assist with Oracle tablespace management, user administration, privileges, configuration alterations, maintenance, health checks, and patching.

• Supervise RMAN backup status and coordinate restore and recovery operations.

• Track Data Guard status and replication alerts, escalating complicated issues to L3.

• Provide L2 operational assistance for Microsoft SQL Server instances and databases.

• Monitor SQL Server availability, SQL Agent jobs, database expansion, disk usage, and error logs.

• Troubleshoot SQL Server failed jobs, connectivity issues, blocking sessions, and basic performance challenges.

• Support SQL Server user administration, permissions, configuration changes, maintenance, patching, and post-change validation.

• Oversee backup status and validate scheduled backup and maintenance tasks.

• Aid with Always On availability groups and replication oversight.

• Resolve database incidents and service requests within established SLAs.

• Adhere to ITIL Incident, Problem, Change, and Request Management protocols.

• Conduct database health checks and investigate monitoring alerts.

• Assist with major incident restoration, backup validation, and disaster recovery efforts.

• Escalate intricate performance, corruption, recovery, and availability issues to L3 Database SMEs.

• Maintain runbooks, operational documentation, incident logs, and shift handover notes.

• Collaborate with Application, Server, Storage/Backup, Network, and Infrastructure teams.

• Ensure APAC–EMEA–NLAM follow-the-sun handover processes.

• Operate in a rotational shift-based, global 24x7x365 support model.

⛳️ Requirements

• 3–6 years of hands-on experience supporting Oracle Database and/or Microsoft SQL Server environments.

• Familiarity with database availability, sessions, locks, logs, space utilization, and job monitoring.

• Proficient in SQL queries and basic database troubleshooting.

• Experience in monitoring Oracle RMAN or SQL Server backup and maintenance jobs.

• Understanding of database users, roles, permissions, and connectivity.

• Knowledge of database backup, restore, recovery, and high-availability principles.

• Familiarity with Oracle Data Guard or SQL Server Always On is advantageous.

• Experience with monitoring tools and ServiceNow or similar ITSM platforms.

• Understanding of ITIL Incident, Problem, Change, and Request Management processes.

• Experience in SLA-driven enterprise production operations and 24x7 support.

• Oracle Database or Microsoft SQL Server certifications are preferred.

• Knowledge of Oracle RAC, Data Guard, SQL Server Always On, and replication is preferred.

• Exposure to performance tuning, execution plans, and index maintenance is preferred.

• Experience with database patching, upgrades, and capacity management is preferred.

• Basic scripting skills in Shell, PowerShell, or SQL.

• Familiarity with enterprise monitoring, backup, and disaster recovery tools.

🏝️ Benefits

• Dynamic environment with robust customer and partner networks.

• Culture of innovation, collaboration, and continuous learning.

• Diverse and inclusive workplace.

• Equal opportunity employer.