L2 Database Operations Engineer (Oracle & SQL Server)
Description
About Gruve
Gruve is an innovative software services startup dedicated to transforming enterprises to AI powerhouses. We specialize in cybersecurity, customer experience, cloud infrastructure, and advanced technologies such as Large Language Models (LLMs). Our mission is to assist our customers in their business strategies utilizing their data to make more intelligent decisions. As a well-funded early-stage startup, Gruve offers a dynamic environment with strong customer and partner networks.
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, permissions and connectivity.
- Knowledge of database backup, restore, recovery and high-availability fundamentals.
- Familiarity with Oracle Data Guard or SQL Server Always On is an advantage.
- Experience with monitoring tools and ServiceNow or equivalent ITSM platforms.
- Understanding of ITIL Incident, Problem, Change and Request Management.
- Experience in SLA-driven enterprise production operations and 24x7 support.
Preferred Skills:
- Oracle Database or Microsoft SQL Server certifications.
- Knowledge of Oracle RAC, Data Guard, SQL Server Always On and replication.
- Exposure to performance tuning, execution plans and index maintenance.
- Experience with database patching, upgrades and capacity management.
Location / Support Model
Global 24x7x365 support across APAC, EMEA and NLAM, working in a rotational shift-based, follow-the-sun operating model.
- Basic scripting using Shell, PowerShell or SQL.
- Familiarity with enterprise monitoring, backup and disaster recovery tools.
Why Gruve
At Gruve, we foster a culture of innovation, collaboration, and continuous learning. We are committed to building a diverse and inclusive workplace where everyone can thrive and contribute their best work. If you’re passionate about technology and eager to make an impact, we’d love to hear from you.
Gruve is an equal opportunity employer. We welcome applicants from all backgrounds and thank all who apply; however, only those selected for an interview will be contacted.
Skills
As published by greenhouse · 14 questions · 3 written answers
Basics
First Name, Last Name, Preferred First Name, Email, Phone, Resume/CV, Cover Letter
Short answers (5)
- LinkedIn Profile
- Website optional
- What is your permanent address?
- What is your official notice period only?
- What are your salary expectations for this role?
Pick from a list (6)
- Do you have at least 3 years of hands-on experience supporting Oracle and/or SQL Server in production, including backup monitoring, failed job troubleshooting and blocking/lock issues?
- Are you willing to work rotational shifts in a 24x7x365 follow-the-sun model?
- In SQL Server, can you take transaction log backups of a database set to the SIMPLE recovery model?
- I acknowledge my right to refrain from disclosing any confidential or proprietary information during the interview and understand that the company will not solicit such information, in accordance with the Non-Disclosure Agreement
- I consent to the use of AI-powered note-taking tools during the interview process and acknowledge that the interview may be recorded and stored for evaluation purposes.
- I hereby provide my consent to share my professional referees with Gruve and authorize Gruve, or its designated third-party representative, to contact them for the purpose of conducting business reference checks as part of the hiring process.
Written answers (3)
- Could you please share your current CTC breakdown, including the fixed and variable components (if applicable)?
- Users report an application is hanging and you suspect blocking in SQL Server. How would you identify and handle it?
- An Oracle database stops accepting new transactions with error ORA-00257 (archiver error). What is the cause and how would you resolve it?