Software Engineer II - PL/SQL Developer
Duck Creek
·Today
- Location
- Mumbai, India
- Workplace
- Hybrid
- Type
- Full-time
- Department
- Engineering
- Experience
- 8+ years
- Education
- Bachelor
- Source
- Workday
Description
TITLE : Software Engineer II
WHO WE ARE
Duck Creek Technologies is the intelligent solutions provider defining the future of the property and casualty (P&C) insurance industry. Our modern SaaS platform enables insurers to run agile, cloud-based operations and deliver better customer experiences.
Duck Creek is a flexible-first company, offering employees autonomy in how they manage their work. As part of our Flying Together approach, we are thoughtfully increasing opportunities for in-person collaboration by focusing on hiring in designated locations. This role is aligned to a specific location, and you’ll partner with your leader to participate in meaningful in-person moments that support team connection and collaboration.
ABOUT VISTA
Duck Creek Technologies is a portfolio company of Vista Equity Partners, a global investment firm that partners with mission-critical enterprise software and technology-enabled businesses to drive growth and operational excellence. As part of a Vista portfolio company, you’ll work in an environment backed by deep expertise, long-term investment, and a strong commitment to building market-leading businesses and meaningful careers.
POSITION OVERVIEW
The Software Engineer II is a senior, hands-on individual contributor within the Software Engineering discipline, with technical leadership responsibility. This role takes ownership of performance improvements in the DCR calculation engine, a system that has evolved over nearly 30 years, contains approximately 400,000 lines of PL/SQL, and implements complex reinsurance rules. Improving it requires both deep Oracle expertise and the ability to understand the functional consequences of a change. The role investigates and improves the engine directly, while providing a credible, evidence-based roadmap for further performance gains. It is an individual contributor role and does not include 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'VE DONE
• 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.
• Reinsurance experience is a plus, but not required: the domain can be taught.
CORE COMPETENCIES
Our team is built on strong core values that guide how we work and grow together. We prioritize clear and thoughtful communication, fostering open collaboration across diverse perspectives to achieve shared goals. We approach challenges with curiosity and critical thinking, seeking creative solutions while remaining adaptable in a fast-changing environment. We take accountability for our work and outcomes, holding ourselves to high standards of integrity and professionalism. Above all, we are committed to doing the right thing—treating others with respect, embracing continuous learning, and engaging inclusively across cultures and backgrounds.
LEARN MORE
- Company Website – Transforming Insurance with Duck Creek's SaaS Solutions
- Life at Duck Creek – Life at Duck Creek - Duck Creek
- Benefits & Rewards – Wellbeing & Rewards - Duck Creek
LOCATION & WAYS OF WORKING
Duck Creek is a flexible-first company, offering employees autonomy in how they manage their day-to-day work. As part of our Flying Together approach, we are thoughtfully increasing opportunities for in-person collaboration by focusing on hiring in designated locations.
This role is aligned to a specific location, and you are expected to reside within reasonable proximity to that location. You will partner with your leader to participate in meaningful in-person moments that support team connection, collaboration, and business priorities.
At the start of your employment, your work may be performed remotely, subject to business needs and company guidelines. As our Flying Together approach continues to evolve, you may be expected to transition to a hybrid work arrangement, including working from a designated office location on a schedule determined by your leader and organizational needs.
The Company reserves the right to modify your work arrangements, including location expectations and in-person requirements, based on business needs, organizational policy, or regulatory considerations.
WHAT WE STAND FOR
Our global team values the unique perspectives each employee brings. Our success is driven by an inclusive culture where everyone can learn from one another, regardless of role or background. This collaborative approach helps us continuously improve our products, services, and systems.
Duck Creek is committed to equal opportunity for all employees and applicants, with decisions based on skills, experience, and achievements—without regard to any protected status.
We strive to lead by example in inclusion, diversity, and equity, creating an environment where employees can be their authentic selves. Our values guide us: We Prioritize Respect, We Listen, We Care, We Add Value, and We Lead.
To learn more: https://www.duckcreek.com/life-at-duck-creek/
AI STATEMENT
To ensure an equitable and consistent process, candidates are expected to complete all interviews based on their own knowledge and experience. The use of AI tools during interviews is not permitted.
PRIVACY NOTICE
By submitting your application, you acknowledge that Duck Creek Technologies may collect and process your personal data – Refer Privacy Notice
NOTICE
Duck Creek Technologies does not accept agency resumes.