TIA Insurance Developer

Description

A **TIA Oracle Developer** is responsible for developing, maintaining, and optimizing database solutions within the TIA (The Insurance Application) platform. The focus is on designing efficient Oracle database structures, developing PL/SQL functionality and supporting business processes within the insurance environment. The developer works closely with Product Owners, business analysts and other IT teams to translate functional requirements into robust and scalable technical solutions within TIA.**Core responsibilities*** Developing and maintaining **Oracle database components** within TIA * Writing and optimizing **PL/SQL code** (packages, procedures, triggers) * Analyzing and solving performance issues within databases * Support with **data migrations** (e.g. legacy TIA) * Designing **data models** to match insurance products (policy, non\-life, premium) * Performing **impact analyses** in the event of changes in data or processes * Collaborate with DevOps teams in CI/CD pipelines * Supporting test processes (unit, SIT, UAT) * Monitoring **data quality and integrity** **Required skills****Technical*** Strong knowledge of **Oracle Database** * Extensive experience with **PL/SQL** * Knowledge of **SQL tuning \& performance optimization** * Experience with **data integrations** (e.g. via APIs, ETL processes) * Familiarity with **version control** (Git, Azure DevOps) * Experience with **CI/CD pipelines** is a plus * Is open to AI applications and applying it to the work **TIA\-specific*** Knowledge of the **TIA platform (Sapiens)** * Understanding TIA data structures and configurations * Experience with **policies, claims and billing processes** within TIA **Domain knowledge (advantage)*** Insurance products (e.g. non\-life, life) * Basic knowledge of: + Premium calculations + Claims handling + Policy administration * Understanding of compliance requirements (e.g. Wft, GDPR) **Competencies*** Analytically strong and problem\-solving * Accurate and quality\-oriented * Good communication skills (switching between business and IT) * Proactive and independent * Team player within Agile/Scrum environment **Typical work in practice*** Implementing a new **product configuration** in TIA with associated database modifications * Optimizing slow batch processes (e.g. renewal or premium run) * Supporting a **data migration to TIA Retail** * Solving production issues around data consistency * Setting up queries for reports or audits (e.g. FEC checks)