
Software Engineer II - PL/SQL Developer
Duck Creek Technologies2 days ago
Bengaluru, IndiaMid Level
Responsibilities
- Own performance improvements in the DCR calculation engine and deliver measurable gains on representative workloads.
- Establish performance baselines, benchmarks, and representative workloads to measure optimization progress.
- Diagnose bottlenecks in large Oracle SQL and PL/SQL codebases using execution plans, SQL tracing, AWR/ASH, and PL/SQL profiling.
- Prioritize and implement SQL and PL/SQL optimizations based on expected impact.
- Validate that optimizations preserve calculation results through regression comparisons and automated tests.
- Work with engineers and domain experts to understand the functional effects of changes to reinsurance rules.
- Improve team practices for diagnosing and preventing performance regressions through tooling, monitoring, guidelines, and knowledge sharing.
- Provide an evidence-based roadmap, technical guidance, and code review support.
Requirements
- Bachelor’s degree in Computer Science, Engineering, or a related field, or equivalent practical experience.
- 8–12 years of experience.
- Demonstrated performance-engineering expertise in complex Oracle SQL and PL/SQL systems.
- Proven ability to diagnose performance issues in large Oracle applications and deliver measurable improvements.
- Ability to establish baselines, identify bottlenecks, prioritize changes by impact, and validate result preservation.
- Experience working with large, long-lived legacy codebases and understanding the functional implications of technical changes.
- Strong analytical, problem-solving, communication, collaboration, and knowledge-sharing skills.
- Reinsurance experience is preferred but not required.
Benefits
- Flexible-first work arrangement with autonomy in day-to-day work.
- Role is aligned to a designated location, with an expectation of residing within reasonable proximity.
- Work may begin remotely and may transition to a hybrid arrangement with designated-office attendance based on business needs and leader direction.
- Wellbeing and rewards benefits are referenced by the employer.
- Inclusive equal-opportunity workplace focused on respect, collaboration, learning, and diversity.
About Duck Creek Technologies
Duck Creek Technologies builds cloud-based core systems for property and casualty insurers, including policy administration, billing, claims, rating, data, and agent/consumer portals, sold as SaaS or modular products. It generates revenue from software subscriptions and services that modernize and integrate insurers’ operations. Founded in 2000 and headquartered in Boston, it is privately held and backed by Vista Equity Partners.