Lead Software Analyst
Free account needed to apply or save. It takes a minute, and we'll bring you right back to this job.
How well do you match this job?
Key details
- Location
- India
- Work style
- Remote
- Level
- Senior
- Job type
- Full-time
- Function
- Software engineering
- Focus area
- Backend
- Posted
- 11h ago
Skills
About the role
This position is listed on behalf of a partner company, who manages all applications and next steps. Our partner is looking for a Lead Software Analyst based in India.
In this role, you will play a key part in ensuring the stability, reliability, and performance of critical enterprise software applications. You will focus on Level 2 (L2) production support, incident triage, and advanced database troubleshooting, with a strong emphasis on Oracle PL/SQL development. Working across technical and business teams, you will investigate complex production issues, identify root causes, and coordinate effective resolutions. You will also contribute to application maintenance, performance optimization, and continuous improvement initiatives. This position offers the opportunity to work with enterprise-scale systems, modern monitoring tools, and cross-functional engineering teams. Your technical expertise and customer-focused approach will help minimize service disruptions and maintain high-quality application operations.
Accountabilities:
-
Incident Management and Triage: Monitor, prioritize, investigate, and resolve production incidents based on severity and business impact, ensuring timely resolution within established SLAs.
-
Database Development and Support: Maintain and troubleshoot Oracle PL/SQL codebases, write and optimize complex SQL queries, perform database scripting, validate data, and execute necessary data patches.
-
Application Troubleshooting: Investigate production issues in Java/J2EE applications, review application code and dependencies, analyze logs, and use debugging tools to identify software defects and performance bottlenecks.
-
Technical Investigation and Escalation: Conduct detailed root cause analysis, isolate issues, document findings, and escalate validated code-fix requirements to engineering teams with clear technical evidence and recommendations.
-
Customer and Stakeholder Communication: Participate in customer calls, address technical queries, explain complex issues, and provide clear updates on incident status, workarounds, and resolutions.
-
Cross-Functional Collaboration: Work closely with development, QA, operations, and infrastructure teams to coordinate incident resolution and facilitate technical discussions or emergency response meetings when required.
-
Performance Optimization: Identify database inefficiencies, memory leaks, thread deadlocks, and application bottlenecks to improve system reliability and performance.
-
Issue Tracking and Reporting: Maintain accurate incident records using tools such as JIRA and ServiceNow, monitor resolution progress, and communicate follow-up actions to relevant stakeholders.
-
Process Improvement and Documentation: Develop troubleshooting guides, standard operating procedures, and technical documentation while identifying opportunities to automate repetitive tasks and improve monitoring and support workflows.
-
Operational Compliance: Follow established production support procedures, ensure adherence to operational standards, and contribute to post-incident reviews and long-term service improvements.
-
Bachelor's degree in Computer Science, Information Technology, or a related discipline, or equivalent practical experience.
-
Proven experience in L2 production support, incident management, application troubleshooting, and SLA-driven environments.
-
Strong expertise in Oracle PL/SQL, including collections, VARRAY, cursors, exception handling, packages, procedures, and functions.
-
Advanced SQL knowledge, including complex queries, subqueries, different types of joins, built-in Oracle functions, and database scripting.
-
Working knowledge of Java/J2EE, with hands-on experience investigating and debugging enterprise applications.
-
Familiarity with debugging and profiling tools such as JProfiler, JConsole, and VisualVM.
-
Knowledge of web services, SOAP, REST APIs, and