Lead Software Analyst

About the Company

At Majesco, our vision is to create innovative, hyper-relevant, compelling, and personal ways of connecting people and businesses to Insurance. We bring together the brightest minds to build the future of Insurance. As a Lead Engineer (Support), you will play a crucial role in realising this vision by supporting and maintaining critical production systems, especially Policy products in the Oracle code base.

Responsibilities

• Monitor production systems for alerts and incidents; prioritize, triage, and escalate based on severity and impact.
• Act as first responder for incidents, assign to appropriate teams, and ensure fastest possible resolution while maintaining service standards.
• Investigate and troubleshoot production issues in Java J2EE applications using tools such as JProfiler, JConsole, or VisualVM.
• Support and maintain the existing Oracle code base for Policy products, including database packages, procedures, scripting, and data verifications.
• Maintain accurate incident logs in ticketing systems (e.g., JIRA, ServiceNow) and provide timely updates to stakeholders.
• Coordinate with Development, Operations, and QA teams; facilitate incident resolution meetings or "war rooms" as needed.
• Participate in post-incident reviews to identify root causes and recommend long-term fixes; perform code review and performance tuning.
• Provide QC support and apply functional expertise in relevant modules.
• Suggest and implement improvements to triage/support processes and help automate repetitive tasks and monitoring.
• Create and maintain troubleshooting guides, SOPs, and documentation for recurring issues and incident resolution processes.

Skills / Required Skills

• Strong understanding of production environments and IT infrastructure (databases, servers).
• Proficiency with monitoring tools (e.g., Instana) and ticketing systems.
• Experience with Linux/Unix commands and scripting for troubleshooting.
• Expertise in SQL: sub-queries, joins, Oracle inbuilt functions; strong PL/SQL knowledge (collections, VARRAY, exception handling, cursors, packages/procedures/functions).
• Experience with complex data modelling/entity relation modelling, normalization, data dictionary, and schema design techniques.
• Knowledge of version control tools (e.g., SVN).
• Strong knowledge of Java/J2EE, JSP/Servlet, web services (REST, SOAP), and tools like SOAPUI.
• Ability to identify memory leaks, thread deadlocks, and performance bottlenecks; optimize database queries and enhance system efficiency.
• Solid analytical and troubleshooting skills to diagnose complex technical issues under pressure.
• Excellent verbal and written communication skills for interacting with technical teams and business stakeholders.
• Strong interpersonal skills for cross-team collaboration and effective incident escalation/management.

Qualifications

• Bachelor’s degree in Computer Science, Information Technology, or related field (or equivalent experience).
• Prior experience in production support, incident management, or triage roles.
• Certifications in ITIL, DevOps, or relevant areas are a plus.

Additional Information

• Functional background: Property & Casualty Insurance (Policy domain) preferred.
• Shift timing: 5 PM - 2 AM IST.