: L2 SQL Support Engineer OBIEE Reporting Operations

Role Title: SQL Support Engineer / Database Support Specialist – L2 (OBIEE Reporting Team)

Function: Production Support / Operations

Experience: 3–6 years

About the Role

We're looking for an L2 Support Engineer with strong SQL and database troubleshooting expertise to join our OBIEE Reporting Operations team. This role is built around problem-solving depth, not tool familiarity — you don't need prior OBIEE exposure. What matters is that you can read complex SQL, trace data issues to their root cause, understand how stored procedures and jobs behave in production, and stay calm under incident pressure. OBIEE-specific concepts will be covered during onboarding.

Key Responsibilities

- Triage and resolve L2-level incidents related to report data discrepancies, failed jobs, and performance issues across the reporting stack
- Analyze and debug complex SQL queries, joins, and stored procedures to identify root cause of data or logic errors
- Work with ETL/batch job logs, scheduler outputs, and database logs to isolate failure points
- Perform data validation between source systems and report output to confirm accuracy
- Write and optimize SQL (queries, procedures, functions) for troubleshooting, patches, and ad hoc fixes
- Collaborate with L3/Engineering teams on recurring or complex defects, providing transparent technical handover documentation
- Maintain and update runbooks, known-issue logs, and RCA (root cause analysis) documents
- Participate in incident/change management processes (ITIL-aligned): ticket ownership, SLA adherence, escalation handling
- Support release/patch validation by testing SQL and procedure changes in lower environments
- Mentor L1 support staff on SQL fundamentals and troubleshooting approach

Must-Have Skills

- Strong hands-on SQL: complex joins, subqueries, window functions, CTEs,



query optimization/tuning, execution plan reading
- Solid understanding of stored procedures, functions, triggers — able to read and debug existing PL/SQL or T-SQL logic, not just call it
- Proven production troubleshooting experience: log analysis, incident triage, root-causing data issues under time pressure
- Familiarity with relational database concepts: indexing, normalization, transaction locking, performance bottlenecks
- Experience with ticketing/ITSM tools (ServiceNow, Remedy, JIRA, etc.) and SLA-driven support environments
- Comfortable working with scheduled jobs/batch processes (Cron, Control-M, Autosys, or similar)
- Strong communication skills — able to explain technical root cause to both technical and non-technical stakeholders

Good to Have (Not Mandatory)

- Exposure to OBIEE / OAC, or any BI/reporting tool (Tableau, Power BI, Cognos) — training provided if not already known
- Basic scripting (Shell/Python) for log parsing or automation
- Exposure to data warehousing concepts (star schema, fact/dimension tables)
- ITIL Foundation certification

What We're Really Screening For Given the current hiring market, this role should be positioned around transferable troubleshooting depth rather than tool-specific experience — OBIEE is a shrinking/legacy skill pool, and gatekeeping on it narrows your funnel unnecessarily. The candidate's value is in root-cause SQL debugging + production support maturity, which are portable skills, not OBIEE tenure.

- Depth over breadth in SQL — can they debug someone else's messy procedure, not just write clean queries from scratch
- Genuine L2 mindset — do they own an issue through resolution, or just escalate everything upward
- Composure in ambiguous, high-pressure incident scenarios
- Ability to pick up a new BI tool quickly given strong fundamentals (test via a scenario-based question, not a tool-knowledge question)

give me naukri search

📌 SQL Support Engineer OBIEE Reporting Operations (Bengaluru)
🏢 Wissen Infotech
📍 Bengaluru