Oracle APEX Senior Developer

Description

Job Summary: We are seeking a Senior Oracle Developer for analysis, design, development, and optimization of enterprise solutions built on Oracle technology, ensuring high performance and quality. Key Highlights: 1. Application development and maintenance using Oracle Forms and Reports 2. Oracle database design, modeling, and optimization 3. Collaboration in multidisciplinary teams under agile methodologies **Description:** ---------------- We are seeking a Senior Oracle Developer with solid experience in developing and maintaining enterprise solutions based on Oracle technology. The candidate will be responsible for the analysis, design, development, and optimization of mission-critical applications and databases, ensuring high levels of performance, availability, and quality. **Requirements:** --------------- **Responsibilities** * Develop and maintain applications using Oracle Forms and Oracle Reports. * Design, model, and optimize Oracle databases. * Develop stored procedures, functions, packages, and other PL/SQL objects. * Build and optimize complex SQL queries. * Implement data loading and migration processes using SQL Loader. * Perform database, query, and PL/SQL code performance analysis and tuning. * Participate in support, evolutionary maintenance, and corrective maintenance activities. * Collaborate with multidisciplinary teams under agile methodologies. **Technical Requirements** **Methodologies** * Experience working under Scrum methodology. **Oracle Database** * Advanced knowledge of Oracle SQL. * Oracle Database 12c or later. * Relational database design and modeling. * Data structure analysis and design. Oracle Development * Oracle Forms 11g or later. * Oracle Reports 11g or later. * Advanced PL/SQL development. * Creation and maintenance of: * Stored procedures. * Functions. * Packages. * Triggers. * Views and other database objects. **SQL and Optimization** * Advanced use of DDL and DML statements. * Development of complex SQL queries. * SQL query optimization and tuning. * PL/SQL code optimization. * Performance analysis in Oracle environments. **Middleware and Tools** * Experience with Oracle WebLogic 11g or later. * SQL Loader. * File processing and handling for bulk data loading. **Desirable Knowledge** * Experience with advanced features of Oracle 12c or later versions. * Participation in technology modernization projects. * Experience with mission-critical enterprise systems.