Lead Software Analyst
Core
Ensure stability, reliability, and performance of critical enterprise software applications through Level 2 production support, incident triage, and advanced database troubleshooting.
Role type
Lead Software Analyst (Production Support & Database)
Builds
Enterprise-scale software applications and database systems
Domain
Enterprise Software / Database Administration
Required skills
Oracle PL/SQL, SQL query optimization, Java/J2EE troubleshooting, root cause analysis, incident management, database scripting, log analysis, debugging tools
Preferred skills
Enterprise system monitoring, cross-functional collaboration, performance optimization
Technologies
Oracle PL/SQL, Java, J2EE, SQL, Monitoring Tools
Responsibilities
Monitor, prioritize, investigate, and resolve production incidents based on severity and business impact; Maintain and troubleshoot Oracle PL/SQL codebases, write and optimize complex SQL queries, and execute data patches; Investigate production issues in Java/J2EE applications, review code and dependencies, and analyze logs to identify defects; Conduct detailed root cause analysis, isolate issues, and escalate validated code-fix requirements to engineering teams; Participate in customer calls and address technical queries to explain complex issues.