Senior PL/SQL Developer

Description

About the opportunity We are looking for a **Senior PL/SQL Developer** to work on critical business systems, participating in the support, evolution, and modernization of corporate solutions. The professional will be responsible for analyzing, developing, and maintaining Oracle database components, ensuring performance, quality, and adherence to the company's business rules. Main Responsibilities * Develop, maintain, and optimize Procedures, Functions, Packages, Triggers, and Views in an Oracle environment. * Perform technical and functional impact analysis for evolutionary and corrective requests. * Identify and solve performance issues in SQL queries and PL/SQL routines. * Participate in the gathering and understanding of business rules implemented in the database. * Support development, support, and business teams in identifying root causes of incidents. * Prepare technical documentation and transfer knowledge to other team members. * Work on continuous improvement and legacy system modernization projects. Mandatory Requirements * Solid experience in **PL/SQL** development. * Advanced knowledge in: * Procedures * Functions * Packages * Triggers * Views * SQL Tuning and Performance * Data Modeling * Experience in the analysis and maintenance of high-complexity corporate systems. * Ability to understand and document business rules implemented in the database. * Experience in investigating and resolving incidents in a production environment. Differentiators * **Advanced experience in Oracle PL/SQL in large-scale corporate environments.** * **Knowledge of the Insurance market.** * **Experience with the Sapiens TIA system.** * Knowledge of integration between applications and Oracle databases. * Experience with agile methodologies (Scrum/Kanban). * Experience in functional analysis and requirements gathering. Behavioral Competencies * Analytical thinking and systemic vision. * Ease in solving complex problems. * Good communication and interpersonal skills. * Sense of collaboration and knowledge sharing. * Proactivity and autonomy in conducting activities. Education * Completed degree in Computer Science, Information Systems, Computer Engineering, or related fields. Position Highlights We are looking for a highly qualified professional in **Oracle PL/SQL**, with a strong ability to understand business rules implemented in the database and knowledge of the **Insurance** segment, with previous experience with the **Sapiens TIA system** being highly valued due to its relevance to the operating environment. Payment: R$9\.000,00 \- R$13\.500,00 per month Benefits: * Medical assistance * Dental assistance * Commercial agreements and discounts * Private pension * Life insurance * Remote work * Food voucher * Meal voucher * Transportation voucher Experience: * Oracle (Preferred) * PL/SQL (Mandatory) * TIA Insurance System (Preferred) * Insurance (Preferred) Work location: Remote