Know ATS Score
CV/Résumé Score
  • Expertini Resume Scoring: Our Semantic Matching Algorithm evaluates your CV/Résumé before you apply for this job role: PLSQL Architect (Oracle PL/SQL, Architecture, Oracle Database, Insurance).
Singapore Jobs | Expertini

Urgent! PLSQL Architect (Oracle PL/SQL, Architecture, Oracle Database, Insurance) - EXASOFT PTE. LTD. Career in Singapore

PLSQL Architect (Oracle PL/SQL, Architecture, Oracle Database, Insurance)



Job description

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+ years 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
#J-18808-Ljbffr


Required Skill Profession

Other General



Your Complete Job Search Toolkit

✨ Smart • Intelligent • Private • Secure

Start Using Our Tools

Join thousands of professionals who've advanced their careers with our platform

Rate or Report This Job
If you feel this job is inaccurate or spam kindly report to us using below form.
Please Note: This is NOT a job application form.


    Unlock Your PLSQL Architect Potential: Insight & Career Growth Guide