Required Skills and Experience:
-Technical Expertise:
-7+ years of hands-on, professional development experience with Oracle
Application Express (APEX).
-Strong proficiency in SQL and PL/SQL, including advanced querying, stored
procedures, functions, packages, and triggers.
-Demonstrated experience in developing complex APEX applications from inception to
production deployment.
-Experience with APEX component development (pages, regions, items, dynamic
actions, reports, forms, themes, templates).
-Proficiency in designing and optimizing APEX security, including authentication and
authorization schemes.
-Solid understanding of Oracle Database concepts and architecture.
-Familiarity with front-end web technologies (HTML, CSS, JavaScript) as they relate to
APEX development.
-Demonstrable experience converting or migrating applications from other
platforms (e.g., Microsoft Access, Oracle Forms) to Oracle APEX.
-Problem-Solving & Support:
-Proven ability to diagnose, troubleshoot, and resolve complex application issues in a
production environment.
-Experience with performance tuning of APEX applications and underlying
SQL/PL/SQL code.
-Collaboration & Communication:
-Excellent communication skills, both written and verbal, with the ability to articulate
technical concepts to both technical and non-technical audiences.
-Strong interpersonal skills and a collaborative mindset, with a willingness to mentor
and share knowledge with an internal team.
-Ability to work effectively within a team-oriented environment and with external
vendors.
-Analytical Skills:
-Strong analytical and problem-solving skills to understand business requirements
and translate them into effective technical solutions.
Desired (Nice-to-Have) Skills and Experience:
-Experience with version control systems (e.g., Git) in an APEX development context.
-Familiarity with Oracle Forms or Microsoft Access applications (understanding their
structure and conversion challenges).
Experience in a government or public sector environment.
-Knowledge of Agile/Scrum methodologies.