Lead Software Analyst

Job Description: Lead Engineer, Support

At Majesco, our vision is to create innovative, hyper-relevant, compelling, and personal ways of connecting people and Businesses to Insurance. We believe in bringing together the brightest minds to build the future of Insurance—a world where Insurance makes life and business more accessible, connected, and better protected. As a Lead Engineer and support, you will play a crucial role in realising this vision. If you share our vision and are ready to contribute to this exciting journey, we invite you to join us. 

The Triage Support role focuses on the timely identification, diagnosis, and resolution of production issues to ensure smooth and uninterrupted operations of critical systems and services. This role involves being a first responder, triaging incidents, assigning them to the right teams, and ensuring the quickest possible resolution while maintaining high service standards. If you are passionate about the power and possibilities cloud technologies have unleashed and want to deliver transformative and innovative solutions that have the potential to revolutionize the customer experience, join us

Majesco is actively seeking an Oracle PL SQL Analyst to join our team. This role is crucial for maintaining our Majesco Insurance Products, specifically the Policy products. As an analyst, you will be responsible for maintaining the data module of these applications, which are in the Oracle code base, ensuring their smooth operation and performance.

Job Description

The analyst will be responsible for maintaining Majesco Insurance Products. This requirement is specifically for Policy products. The analyst will be responsible for maintaining the data module of these applications, which are in the Oracle code base.

1. Incident Triage and Resolution:
   • Monitor production systems for alerts and incidents.
   • Prioritize and triage incoming incidents based on severity and impact.
   • Escalate critical incidents to the appropriate teams or subject matter experts.
   • Monitor, investigate, and troubleshoot production issues in Java J2EE applications.
2. Issue Tracking and Reporting:

• To support and maintain the existing Oracle code base and debug the application. 
• To Good knowledge of database packages and procedures 
• Database scripting and data verifications 
• UTP and UT
• Maintain accurate incident logs in ticketing systems (e.g., JIRA, ServiceNow).
• Ensure timely updates and communication regarding issue status to stakeholders.

Track and report on incident resolution progress and follow-up actions.

1. Collaboration with Cross-Functional Teams:
   • Work closely with Development, Operations, and QA teams to resolve production issues.
   • Coordinate and facilitate incident resolution meetings or "war rooms" when necessary.
   • Act as a liaison between technical and non-technical teams to streamline problem resolution.
2. Root Cause Analysis:
   • Participate in post-incident reviews to identify root causes and long-term solutions.
   • Analyze logs and diagnostic data to quickly identify the root cause of issues.
   • Perform Code Review, Performance Tuning 
   •  QC support 
   •  Functional expertise in modules 
3. Process Improvement:
   • Suggest and implement improvements to existing triage and support processes.
   • Assist in automating repetitive tasks and enhancing monitoring capabilities.
   • Provide feedback to improve system monitoring, documentation, and processes.
4. Documentation:
   • Create and maintain troubleshooting guides and SOPs for handling recurring issues.
   • Document incident resolution processes for future reference.

Skills / Attributes Required:

• Essential Technical Knowledge:
  • Strong understanding of production environments and IT infrastructure (e.g., databases, servers).
  • Proficiency in monitoring tools (e.g., Instana) and ticketing systems.
  • Experience with Linux/Unix commands and scripting for troubleshooting.
  • Experience with complex data modelling/entity relation modelling and design techniques, database normalisation theory, data dictionary, and schema design techniques. 
  •  Expertise in SQL: sub-queries, joins, oracle inbuilt functions 
  •  Expertise in PL/SQL: collections, VARRAY, exception handling, cursors, package/ procedure/ function 
  •  Knowledge of Version Control tools, e.g., SVN
  • Debug J2EE applications using tools like JProfiler, JConsole, or VisualVM.
  • Strong knowledge of Java/J2EE, JSP Servlet, Web Service, REST, SOAPUI 
• Performance Monitoring & Optimization:
  • Identify memory leaks, thread deadlocks, and performance bottlenecks.
  • Optimize database queries and enhance system efficiency.
• Problem-Solving Skills:
  • Ability to quickly diagnose complex technical issues under pressure.
  • Solid analytical and troubleshooting skills.
  • Review Java J2EE code, APIs, and system dependencies to understand and resolve issues.
• Communication:
  • Excellent verbal and written communication skills for interacting with technical teams and business stakeholders.
  • Experience in explaining technical issues.
• Collaboration & Coordination:
  • Strong interpersonal skills to work effectively with multiple teams and across departments.
  • Experience with managing and escalating critical incidents effectively
• Functional Skills:
  Property & Casualty Insurance background (preferred) with Policy domain expertise.

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.

Shift Timing:

• 5 PM - 2 AM IST

This role is critical in maintaining the stability of production systems, ensuring quick incident recovery, and preventing future disruptions through continuous improvement.