PLSQL Architect

2 days ago

Singapore EXASOFT CONSULTING PTE. LTD. Full time

Roles & Responsibilities 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. Tell employers what skills you have Technical DocumentationActuarialOracleData ModelingReinsuranceData StructuresInformaticaOracle Data IntegratorData IntegrationSQLUnderwritingPerformance TuningOracle DatabaseToadHIPAAJava

  • PLSQL Architect

    2 days ago

    Singapore EVO OUTSOURCING SOLUTIONS PTE. LTD. Full time

    Job Title: PLSQL Architect We are seeking an experienced Oracle PL/SQL Architect to design, develop, and maintain database-driven applications for our insurance systems. The ideal candidate will have strong expertise in Oracle PL/SQL programming and a solid understanding of insurance industry processes, such as policy management, claims processing,...

  • PLSQL Architect

    4 days ago

    Singapore HORIZON GLOBAL SERVICES PTE. LTD. Full time

    Key Responsibilities Design, develop, and optimize complex PL/SQL objects - procedures, functions, triggers, packages, and views. Develop ETL solutions to integrate data across various internal/external systems. Perform SQL and PL/SQL performance tuning for large-scale databases. Work with data architects on design of logical & physical data models. Build...

  • PLSQL Architect

    4 days ago

    Singapore HORIZON GLOBAL SERVICES PTE. LTD. Full time

    Key Responsibilities Design, develop, and optimize complex PL/SQL objects — procedures, functions, triggers, packages, and views. Develop ETL solutions to integrate data across various internal/external systems. Perform SQL and PL/SQL performance tuning for large-scale databases. Work with data architects on design of logical & physical data models. Build...

  • PLSQL Architect

    2 days ago

    Singapore HORIZON GLOBAL SERVICES PTE. LTD. Full time

    Roles & Responsibilities Key Responsibilities Design, develop, and optimize complex PL/SQL objects — procedures, functions, triggers, packages, and views. Develop ETL solutions to integrate data across various internal/external systems. Perform SQL and PL/SQL performance tuning for large-scale databases. Work with data architects on design of logical &...

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

  • PLSQL Architect

    2 days ago

    Singapore EVO OUTSOURCING SOLUTIONS PTE. LTD. Full time

    Roles & Responsibilities Job Title: PLSQL Architect Job Summary: We are seeking an experienced Oracle PL/SQL Architect to design, develop, and maintain database-driven applications for our insurance systems. The ideal candidate will have strong expertise in Oracle PL/SQL programming and a solid understanding of insurance industry processes, such as policy...

  • PlSQL Architect

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

  • PLSQL Architect

    2 days ago

    Singapore EXASOFT PTE. LTD. Full time

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

  • PLSQL Architect

    4 days ago

    Singapore CORNERSTONE GLOBAL PARTNERS PTE. LTD. Full time

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

  • Java Developer

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