PLSQL Architect

4 days 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

    5 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...

  • Software Developer

    5 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...

  • Java Developer

    7 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

    7 days ago

    Singapore NodeFlair Full time

    **Job Summary**: **Salary** S$6,519 - S$8,827 / Monthly EST **Job Type** Contract **Seniority** Mid **Years of Experience** At least 3 years **Tech Stacks** Rest API Oracle Spring MQ Modular JEE Java kafka Springboot Angular JavaScript SQL XML MySQL React CSS **Key Responsibilities** - Participate in the requirement elicitation and produce the required...

  • Technical Analyst

    2 weeks ago

    Singapore INFRASOFT TECHNOLOGIES PTE LTD Full time

    **Direct Responsibilities** - Work with geographically distributed Agile Scrum teams for designing and implementing digital solutions using JAVA / J2EE technologies. - Handle development/design projects using Java, J2EE, Oracle, Angular and Tomcat. - Works closely with technical team lead and cross teams for technical/functional solution. - Establishes...

  • Software Developer

    2 weeks ago

    Singapore Network For Electronic Transfers (S) Full time

    Team and Position Summary The Software Developer is a key member of the Delivery and Support Group in NETS Solutions and will report to the AMMO Support Manager. He/She will participate in the application delivery to customer and will be responsible for application development and PROD L3 software maintenance support. Key Responsibilities Participate in the...

  • Project Development Lead

    1 week 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 Developer

    3 days ago

    Singapore NETS SOLUTIONS PTE. LTD. Full time $80,000 - $120,000 per year

    Team and Position SummaryThe Software Developer is a key member of the Delivery and Support Group in NETS Solutions and will report to the AMMO Support Manager. He/She will participate in the application delivery to customer and will be responsible for application development and PROD L3 software maintenance support.Key ResponsibilitiesParticipate in the...