Job Summary: Design, develop, and optimize Oracle database solutions for business processes, ensuring high performance and efficient automation with SQL and PL/SQL. Key Responsibilities: 1. Relational database design and modeling 2. PL/SQL development and maintenance 3. SQL performance optimization and tuning **Company Description** Inetum is an international agile digital consulting group. In the post-digital transformation era, our purpose is to enable each of the more than 27,000 people who make up our team to continuously renew themselves, positively living their own digital flow. With a presence in 26 countries, we promote flexible career paths, local innovation, and a healthy balance between personal and professional life. Additionally, Inetum has been recognized as a **Top Employer**, a certification validating our commitment to employee wellbeing, professional development, and excellence in talent management. **Job Description** Design, develop, optimize, and maintain Oracle database solutions supporting business processes, ensuring high performance, data integrity, and efficient automation through SQL and PL/SQL. **Requirements** * Design and model relational database schemas, applying principles of **data normalization**. * Create and maintain **tables, views, indexes, sequences, and constraints** in Oracle. * Develop and maintain **stored procedures, functions, and triggers in PL/SQL**, implementing business logic, data validation, and process automation. * Implement **complex SQL queries**, including subqueries, advanced joins, and aggregate functions. * Analyze and optimize **execution plans** to improve query performance. * Perform **SQL query tuning** and adjust database parameters such as **SGA and PGA**. * Use diagnostic and performance tools such as **Oracle Query Optimizer, AWR (Automatic Workload Repository)**, and Oracle statistics. * Develop scripts for **automating administrative tasks and scheduled processes** using PL/SQL, **shell scripting or PowerShell**. * Maintain and document code following best practices and quality standards. * Collaborate with cross-functional teams under agile methodologies, primarily **Scrum**. * Manage code versions and collaborate using **Git**. **Required Technical Knowledge** **Oracle Database** * Advanced SQL * PL/SQL * Oracle SQL*Plus * Oracle SQL Developer **Performance and Optimization** * Query optimization (SQL Tuning) * Execution Plan analysis * SGA / PGA parameter tuning * Use of AWR and optimizer statistics **Automation** * PL/SQL scripting * Shell scripting or PowerShell for scheduled tasks **Methodologies and Tools** * **Scrum / Agile** methodology * Version control with **Git** **Required Experience** * Proven experience developing with **Oracle Database**. * Experience in relational database design and optimization. * Experience implementing business logic using PL/SQL. * Desired experience in high-availability or high-volume production environments. **Key Competencies** * Problem analysis and resolution * Results- and quality-oriented mindset * Logical and structured thinking * Teamwork * Effective communication * Time and priority management **Education** * Bachelor’s degree or Engineering in Systems, Computer Science, Computing, or related field. **Desirable** * Oracle certifications * Experience integrating with external applications * Basic knowledge of Linux/Unix operating systems **Additional Information** **What We Offer** * Continuous training and certification programs. * Access to learning and professional development platforms. * Innovation- and collaboration-driven culture. * Physical and emotional wellbeing programs. * Opportunities for growth on international projects. * Performance recognition and rewards. * Base salary * Benefits exceeding statutory requirements * Life insurance * Major Medical Expense Insurance * Grocery vouchers * 100% payroll-based compensation scheme