Oracle Developer

Design, develop, optimize and maintain Oracle database solutions that support business processes, ensuring high performance, information integrity and efficient automation through SQL and PL/SQL.

• Design and model relational database schemas, applying data normalization principles.

• 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 validations and process automation.

• Implement complex SQL queries, including subqueries, advanced joins and aggregate functions.

• Analyze and optimize execution plans (Execution Plans) to improve query performance.

• Perform SQL query tuning and adjustment of 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 multidisciplinary teams under agile methodologies, primarily Scrum.

• Manage code versions and collaborate through Git.

Required Technical Knowledge

Oracle Database

• Advanced SQL

• PL/SQL

• Oracle SQL*Plus

• Oracle SQL Developer

Performance and Optimization

• Query Optimization (SQL Tuning)

• Execution Plans Analysis

• SGA / PGA Parameter Tuning

• Use of AWR and optimizer statistics

Automation

• Scripts en PL/SQL

• Shell scripting o PowerShell para tareas programadas

Methodologies and Tools

• Metodología Scrum / Agile

• Version control with Git

Experiencia Requerida

• Proven experience in development with Oracle Database.

• Experience in design and optimization of relational databases.

• Experience in implementation of business logic through PL/SQL.

• Desirable experience in productive environments with high availability or high data volume.

Key Competencies

• Analysis and problem solving

• Results-oriented and quality focus

• Logical and structured thinking

• Teamwork

• Effective communication

• Time management and prioritization

Education

• Bachelor's degree or Engineering in Systems, Computer Science, Computing or related field. Desirable

• Certificaciones Oracle

• Experience in integration with external applications

• Basic knowledge of Linux/Unix operating systems

What we offer

• Continuous training programs and certifications.

• Access to learning platforms and professional development.

• Culture of innovation and collaboration.

• Physical and emotional wellness programs.

• Growth opportunities in international projects.

• Recognition and rewards for performance.

• Base salary

• Benefits exceeding those required by law

• Seguro de vida

• Major Medical Expense Insurance

• Grocery vouchers

• Esquema 100% nómina

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 are part of our team to continuously renew themselves, living their own digital flow positively.

With 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 that endorses our commitment to wellness, professional development and excellence in talent management.