Lead Software Analyst
J
JobgetherEnterprise insurance software
Remote working arrangement within IndiaFull-TimeLead
Salary not disclosed
Apply NowOpens the employer's application page
Job Details
- Required Skills
- SQLServiceNow
Requirements
- Bachelor’s degree in Computer Science, Information Technology, or a related discipline, or equivalent practical experience.
- Experience in L2 production support, incident management, application troubleshooting, and SLA-driven environments.
- Strong Oracle PL/SQL expertise, including collections, VARRAY, cursors, exception handling, packages, procedures, and functions.
- Advanced SQL knowledge, including complex queries, subqueries, joins, Oracle built-in functions, and database scripting.
- Working knowledge of Java/J2EE and hands-on experience investigating and debugging enterprise applications.
- Familiarity with JProfiler, JConsole, or VisualVM debugging and profiling tools.
- Knowledge of web services, SOAP, REST APIs, and application integrations.
- Experience with monitoring solutions such as Instana and Glowroot, and ticketing platforms such as JIRA and ServiceNow.
- Familiarity with version control systems such as SVN and GitHub.
- Experience using Linux/Unix commands and Microsoft PowerShell for troubleshooting and scripting.
- Understanding of database architecture, data modeling, entity relationships, normalization, data dictionaries, and schema design.
- Previous experience in Property and Casualty insurance, general insurance, or banking is advantageous; ITIL, DevOps, or other relevant technical certifications are a plus.
Responsibilities
- Monitor, prioritize, investigate, and resolve production incidents according to severity, business impact, and established SLAs.
- Maintain and troubleshoot Oracle PL/SQL code, write and optimize SQL queries, perform database scripting, validate data, and execute data patches.
- Investigate Java/J2EE production issues by reviewing code and dependencies, analyzing logs, and using debugging tools.
- Conduct root cause analysis, document findings, and escalate validated code-fix requirements to engineering teams.
- Participate in customer calls, address technical queries, and communicate incident status, workarounds, and resolutions.
- Coordinate incident resolution with development, QA, operations, and infrastructure teams.
- Identify database inefficiencies, memory leaks, thread deadlocks, and application bottlenecks to improve reliability and performance.
- Track incidents and resolution progress in JIRA and ServiceNow, and communicate follow-up actions.
- Develop troubleshooting guides, standard operating procedures, and technical documentation; identify opportunities to automate repetitive tasks and improve support workflows.
- Follow production support procedures and operational standards, and contribute to post-incident reviews.
View Full Description & ApplyYou'll be redirected to the employer's site