Oracle Developer

Design, develop, optimize, and maintain Oracle database solutions that support business processes, ensuring high performance, information integrity, and efficient automation using 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 to improve query performance. Perform SQL query tuning and database parameter adjustments such as SGA and PGA. Utilize diagnostic and performance tools such as Oracle Query Optimizer, AWR (Automatic Workload Repository), and Oracle statistics. Develop scripts for the automation of 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 using Git. Required Technical Knowledge: Oracle Database, Advanced SQL, PL/SQL, Oracle SQL*Plus, Oracle SQL Developer.