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 clear 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 hig

📌 Dev studio Designer (Pune)
🏢 Persistent
📍 Pune