Overview
Senior, hands-on individual contributor role with technical leadership responsibility, owning performance improvements in the DCR calculation engine, a PL/SQL system of approximately 400,000 lines implementing complex reinsurance rules. No direct people management.
What you'll do
- Take ownership of performance improvements in the DCR calculation engine, delivering measurable gains on representative workloads.
- Establish performance baselines and benchmarks, and define representative workloads to measure progress objectively.
- Diagnose performance issues in large Oracle SQL and PL/SQL code bases and identify the actual bottlenecks (e.g. execution plans, SQL tracing, AWR/ASH, PL/SQL profiling).
- Prioritize optimization work by expected impact, and design and implement improvements to complex SQL and PL/SQL code.
- Validate that every optimization preserves calculation results, through regression comparisons and appropriate automated tests.
- Work closely with the existing engineering team and domain experts to understand the functional consequences of changes to reinsurance rules.
- Build the team's ability to diagnose and prevent performance regressions, through tooling, monitoring, guidelines, and knowledge sharing.
- Provide an evidence-based roadmap for further performance gains, and provide technical guidance and code review support to the team.
What you'll need
- Bachelor's degree in Computer Science, Engineering, or a related field, or equivalent practical experience with 8 to 12 years of experience.
- Demonstrated performance engineering expertise in complex Oracle SQL and PL/SQL systems (key hiring criterion).
- Proven track record of diagnosing performance issues in large Oracle applications and delivering measurable improvements.
- Ability to establish baselines, identify real bottlenecks, prioritize changes by impact, and validate that optimizations preserve results.
- Comfortable working with large, long-lived legacy code bases and understanding the functional implications of technical changes.
- Strong analytical and problem-solving skills, with an evidence-driven approach to decision making.
- Effective communication and collaboration skills, with the ability to share expertise and raise the team's performance engineering practices.
Nice to have
- Reinsurance experience (the domain can be taught).
Details
- Location: Bengaluru, India; reside within reasonable proximity to the designated location.
- Work arrangement: may start remotely subject to business needs; may transition to hybrid, including working from a designated office on a schedule set by the leader.
- Company may modify work arrangements, location expectations and in-person requirements based on business needs.
- Interviews must be completed without AI tools.
Read the full description and apply on the company’s own careers page.