About Position:

We are seeking an experienced Devstudio Designer to implement and maintain Insurance products using the Devstudio toolkit. Devstudio is low-code development platform, built using Oracle and open-source technologies, which enables developers to create application software through graphical user interfaces and configuration.

- Role: Dev studio Designer
- Location: All Persistent Location
- Experience: 8 to 10 Years
- Job Type: Full Time Employment

What You'll Do:

- Design and develop Oracle objects, including packages, procedures, views, materialised views, and triggers, for high-performing transactional and reporting applications.
- Design and develop Oracle objects for high-performing database batch processes.
- Design databases for transactional and reporting applications.
- Provide work estimates for proposed changes of varying scope.
- Prepare explicit program and module-level technical specifications.
- Perform coding and testing and provide Quality Assurance support for complex Oracle procedures.
- Conduct peer reviews of team members work.
- Perform SQL performance tuning, profiling, and monitoring using relevant tools and applications.
- Support application benchmarking activities in collaboration with the performance-tuning group.
- Troubleshoot technical problems and analyse appropriate solutions.
- Lead a team of 4-5 developers.

Expertise You'll Bring:

- Strong experience in designing and developing Oracle objects such as tables, views, indexes, stored procedures, functions, PL/SQL packages, materialised views, and Dynamic SQL.
- Extensive experience in analysing, designing, and building complex database transaction and reporting solutions.
- Hands-on experience in performance tuning, profiling, and monitoring slow-performing SQL.
- Experience with complex data modelling and entity-relationship modelling.
- Solid understanding of database normalisation,



data dictionaries, and schema design techniques.
- Good communication skills with a highly motivated and self-driven approach.
- Experience in object-oriented design and development using the Java technology stack is desirable.
- Experience in application or product performance tuning is preferred.
- Exposure to design frameworks and automation tools is desirable.
- General Insurance domain experience is preferred; Life Insurance experience may also be considered.
- Understanding of accounting, commerce, or finance principles is desirable.

Benefits:

- Market-competitive salary and benefits package
- Culture focused on talent development with quarterly growth opportunities and company-sponsored higher education and certifications
- Opportunity to work with cutting-edge technologies
- Employee engagement initiatives such as project parties, flexible work hours, and Long Service awards
- Annual health check-ups
- Insurance coverage: group term life, personal accident, and Mediclaim hospitalization for self, spouse, two children, and parents

Values-Driven, People-Centric & Inclusive Work Environment: Persistent is dedicated to fostering diversity and inclusion in the workplace. We invite applications from all qualified individuals, including those with disabilities, and regardless of gender or gender preference. We welcome diverse candidates from all backgrounds.

- We support hybrid work and flexible hours to fit diverse lifestyles.
- Our office is accessibility-friendly, with ergonomic setups and assistive technologies to support employees with physical disabilities.
- If you are a person with disabilities and have specific requirements, please inform us during the application process or at any time during your employment

Let's unleash your full potential at Persistent - persistent.com/careers "Persistent is an Equal Opportunity Employer and prohibits discrimination and harassment of any kind."

📌 Dev studio Designer (Pune)
🏢 Persistent
📍 Pune