PLSQL Architect

1 week ago

Singapore EXASOFT PTE. LTD. Full time $120,000 - $180,000 per year

Responsibilities:

  • Database Development: Analyze, Design, develop, and optimize complex PL/SQL stored procedures, functions, packages, triggers, and views to support insurance applications.
  • Data Integration: Develop ETL processes to integrate data from various sources, ensuring accurate data flow for policy administration, claims, and reporting.
  • Performance Tuning: Optimize SQL queries and PL/SQL code to enhance database performance, ensuring efficient processing of large datasets common in insurance systems.
  • Data Modeling: Collaborate with data architects to design and implement logical and physical data models tailored to insurance workflows (e.g., premiums, claims, reinsurance).
  • Reporting & Analytics: Develop database scripts to support business intelligence reports, dashboards, and analytics for actuarial, underwriting, and financial teams.
  • Compliance & Security: Ensure database solutions comply with insurance regulations (e.g., GDPR, HIPAA, or local standards) and implement secure coding practices to protect sensitive customer data.
  • Collaboration: Work with cross-functional teams, including business analysts, application developers, and QA engineers, to gather requirements and deliver robust solutions.
  • Documentation: Create and maintain technical documentation for database designs, processes, and code for future reference and audits.

Requirements:

  • 10+ years of experience in Oracle PL/SQL development with at least 4+ yrs of experience in Architecture & Design.
  • 3+ years of experience in the insurance industry or familiarity with insurance processes (policy administration, claims, underwriting, etc.).
  • Proficient in Oracle Database (11g/12c/19c), PL/SQL programming, and SQL query optimization.
  • Experience with Oracle tools like SQL Developer, TOAD, or SQL*Plus.
  • Knowledge of data modeling, indexing, and partitioning for high-volume databases.
  • Familiarity with ETL tools (e.g., Informatica, Oracle Data Integrator) is a plus.
  • Understanding of insurance-specific data structures (e.g., policy, claims, or customer data).
  • Strong problem-solving and analytical skills.
  • Excellent communication and collaboration abilities to work with technical and non-technical stakeholders.
  • Ability to work in a fast-paced environment and manage multiple priorities.
  • Experience with Oracle Forms/Reports, APEX, or Java integration with PL/SQL.
  • Knowledge of insurance platforms like Guidewire, Duck Creek, or InsureTech solutions.
  • Familiarity with cloud platforms (e.g., Oracle Cloud, AWS, or Azure) and database migration.
  • Certification in Oracle Database or PL/SQL development

  • PlSQL Architect

    3 days ago

    Singapore EXASOFT PTE. LTD. Full time

    **Responsibilities**: - Data Integration: Develop ETL processes to integrate data from various sources, ensuring accurate data flow for policy administration, claims, and reporting. - Performance Tuning: Optimize SQL queries and PL/SQL code to enhance database performance, ensuring efficient processing of large datasets common in insurance systems. - Data...

  • Senior Java Developer

    2 weeks ago

    Singapore JANUARY CONSULTANCY SERVICES PTE. LTD. Full time

    **Roles & **Responsibilities**: - Participate in the requirement elicitation and produce the required technical and operations documentation - Work with Architects on the analysis and design of the code matching to specifications - Perform code changes and test the system according to the requirements specifications - Ensure work performed complies to...

  • Software Consultant

    2 weeks ago

    Singapore CARLSYS TECHNOLOGIES PTE. LTD. Full time

    Participate in the requirement elicitation and produce the required technical and operations documentation - Work with Solution Architect/Technical Lead on the analysis and design of the code changes according to the finalized requirement specifications - Perform code changes and test the system according to the requirements specifications - Ensure work...

  • Software Developer

    3 days ago

    Singapore NETS SOLUTIONS PTE. LTD. Full time

    **NETS Solutions** NETS Solutions is NETS’ wholly owned subsidiary. It develops payment infrastructure and transaction processing solutions for central banks, banks and clearing houses in Singapore and the region. **Position Overview** **Key Responsibilities** - Participate in the requirement elicitation and produce the required technical and operations...

  • Software Developer

    5 days ago

    Singapore NETS SOLUTIONS PTE. LTD. Full time

    Team and Position Summary The Software Developer is a key member of the Products and Engineering in NETS Solutions and will report to the Software Development Lead for Product Development. He/She will participate in the application delivery to customers and will be responsible for application development and implementation. Key Responsibilities Participate...

  • Junior Java/j2ee Developer

    1 week ago

    Singapore NEW TONE CONSULTING PTE. LTD. Full time

    We are looking for a technical analyst with a prime emphasis on Trade finance IT Projects and the implementation of systems upgrades/patches. He/she will be responsible for the delivery and support group and will report to the technical lead. **Direct Responsibilities** - Work with geographically distributed Agile Scrum teams for designing and implementing...

  • Software Developer

    13 hours ago

    Singapore NETS SOLUTIONS PTE. LTD. Full time

    Team and Position Summary The Software Developer is a key member of the Products and Engineering in NETS Solutions and will report to the Software Development Lead for Product Development. He/She will participate in the application delivery to customers and will be responsible for application development and implementation.Key Responsibilities Participate in...

  • Project Development Lead

    7 days ago

    Singapore NETS SOLUTIONS PTE. LTD. Full time

    **Position Summary** **Key Responsibilities** - Participate in the requirement elicitation process and produce the required technical and operations documentation - Work with Solution Architect on the analysis and design of the code construction and changes according to the finalized requirement specifications - Lead a team of developers, delegate and...

  • Software Development Lead

    7 days ago

    Singapore NETS SOLUTIONS PTE. LTD. Full time

    Team and Position Summary The Software Development Lead will be a member of the Products and Engineering unit in NETS Solutions. He/She is responsible for overseeing development efforts, leading a team of software developers, and delegating tasks to ensure timely and high-quality output. This role involves close collaboration with the business analyst team,...

  • Software Development Lead

    13 hours ago

    Singapore NETS SOLUTIONS PTE. LTD. Full time

    Team and Position Summary The Software Development Lead will be a member of the Products and Engineering unit in NETS Solutions. He/She is responsible for overseeing development efforts, leading a team of software developers, and delegating tasks to ensure timely and high-quality output. This role involves close collaboration with the business analyst team,...