Technical Analyst 1-Support

The interview process typically consists of an online aptitude test followed by a technical interview focusing on SQL, troubleshooting scenarios, and incident management. The HR round assesses cultural fit, communication skills, and willingness to work night shifts. Overall difficulty is moderate, and thorough preparation on SQL and real‑world support cases greatly improves success chances.

Oracle promotes a collaborative, inclusive environment where employees are encouraged to innovate and share ideas across borders. The company offers structured learning programs, mentorship, and a balanced work‑life approach, especially for shift‑based roles, with clear policies for overtime and on‑call duties.

Bachelor's degree in Computer Engineering, Computer Science, Information Systems, Software Engineering or related field; 0‑2 years of experience in application support, incident/problem management; Minimum 60% aggregate (or CGPA 6.0/10); No active backlogs; Ability to work night shift (5:30 PM‑2:30 AM IST); Proficiency in English (read, write, speak).

Round 1: Online assessment (aptitude & basic SQL) → Round 2: Technical interview (scenario‑based troubleshooting, SQL queries, system design) → Round 3: HR interview (behavioral fit, shift availability)

Oracle is a global leader in cloud, AI, and enterprise software, serving customers across more than 175 countries. With a heritage of innovation that dates back to the 1970s, Oracle has expanded its portfolio to include database solutions, middleware, applications, and a robust cloud infrastructure. The company’s culture emphasizes continuous learning, collaboration across geographies, and a commitment to diversity and inclusion, making it an attractive destination for fresh talent looking to grow in a technology‑driven environment. As a Technical Analyst 1‑Support (also referred to as Technical Solution Analyst), you will be the first line of defense for Oracle’s front‑end applications used by enterprise clients. Your day‑to‑day responsibilities will involve investigating incidents reported by end‑users, capturing detailed information, applying fix tools, shadowing users to reproduce issues, and testing workflows both internally and externally. You will also work on backend tasks such as gathering log files, querying database tables, updating fields, and cycling servers to ensure a swift resolution. Effective verbal and written communication is essential, as you will document every step of the investigation, create knowledge articles, and coordinate with cross‑functional teams to route complex problems to the right experts. Key responsibilities include: 1. Perform root‑cause analysis of application issues reported by clients. 2. Use SQL to extract, manipulate, and validate data from Oracle databases. 3. Gather and analyze log files, system metrics, and configuration details. 4. Apply standard fix tools and scripts to remediate identified problems. 5. Shadow end‑users to reproduce issues and validate fixes. 6. Document investigation notes, resolutions, and create knowledge‑base articles. 7. Prioritize tickets based on severity and business impact. 8. Collaborate with development, product, and infrastructure teams for escalated cases. 9. Participate in on‑call rotation and work the 5:30 PM‑2:30 AM IST shift as required. 10. Continuously improve support processes and share best practices. The tech stack revolves around Oracle Cloud services, SQL, basic scripting, and ticketing tools. Growth paths typically lead to senior analyst roles, specialist positions in cloud operations, or transition into product engineering and solution architecture. Joining Oracle offers exposure to cutting‑edge technologies, mentorship from industry veterans, and a clear roadmap for career advancement, all while contributing to solutions that impact billions of users worldwide.