Duck Creek Technologies logo

Software Engineer II - PL/SQL Developer

Duck Creek Technologies
NewPosted today

LOCATION

Bengaluru · Hybrid

EXPERIENCE

8 - 12 Years

TYPE

FullTime

SKILLS REQUIRED

SQLPL/SQLPerformance OptimizationRoot Cause AnalysisExecution Plan AnalysisOracle Database

Job description

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.

Stay safe

Hiring on Abekus is free for applicants

We never charge a fee, and employers are prohibited from doing so. If a recruiter asks for payment, please report them right away.

Software Engineer II - PL/SQL Developer