




Position Summary: Development, maintenance, and evolution of PL/SQL solutions in Oracle environments, optimizing performance and participating in new functionality and migration projects. Key Highlights: 1. PL/SQL development and maintenance on Oracle 12c/19c. 2. Query and batch process optimization for high performance. 3. Active participation in new functionality projects and migrations. Development, maintenance, and evolution of PL/SQL packages, procedures, functions, and triggers in Oracle 12c/19c environments. Implementation of performance improvements using features specific to modern Oracle versions. Optimization of complex queries and batch processes to ensure stability and high performance. Active participation in new functionality projects and upgrades to newer Oracle versions. Generation of reports and data extraction using advanced SQL and associated tools. Detailed technical documentation and requirement tracking in Jira, ensuring quality and traceability. ### **Benefits** Employment relationship \+ private health insurance **Work Location:** \-, Ciudad Autónoma de Buenos Aires, Argentina **Working Days:** Monday, Tuesday, Wednesday, Thursday, Friday **Working Hours:** 09:00 to 06:00 ### **Requirements** **Mandatory Experience:** Yes **Residence Location:** Ciudad Autónoma de Buenos Aires **Education Level:** Tertiary **Languages:** * Spanish ### **Computer Skills** **Internet:** Yes **Office Suite:** No **Accounting Systems:** No **Programming:** Yes: Javascript **Database:** Yes: Other **Specific Knowledge:** Proven experience of \+2 years in PL/SQL development on Oracle 11, 12c, and/or 19c. Proficiency in advanced SQL: complex joins, subqueries, analytic functions, WITH clause, and MODEL clause. Knowledge and application of modern Oracle 12c/19c features (e.g., ROW LIMITING, FETCH FIRST, JSON in database, advanced partitioning). Experience in query tuning, index optimization, and execution plan analysis. Familiarity with Jira and documentation tools (Confluence, etc.).


