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
View details
Apply Now