What are the responsibilities and job description for the Oracle Application Express (APEX) Developer position at Stratford Solutions Inc.?
Job Title: Oracle Application Express (APEX) Developer
Location: State Albany, NY
Job Type: Contract
Work schedule: 40 hours per week during the hours of 7 a.m. and 5 p.m.
Duration: 24 months, with a strong possibility of an extension
Pay Rate: $60 - $70 per hour
Responsibilities:
- Work under the guidance of the APEX Team Manager and Supervisor.
- Help OSC Management develop APEX Roadmap and Strategy.
- Contribute to the development and establishment of the APEX Operating Model.
- Assess OSC APEX methodologies, practices, and activities and advise APEX Team on how they can be improved.
- Evaluate business functions, analyze business requirements, and assess feasibility, impact, and/or implications of using APEX.
- Guide development of APEX designs that are scalable and meet business requirements.
- Help the APEX team to establish a robust APEX Security Model, including integration with Active Directory for authentication and authorization.
- Assist APEX developers with building shared components.
- Develop custom APEX applications.
- Prepare documentation associated with the development and implementation of new APEX applications.
- Perform quality assurance checks and post-implementation reviews.
- Collaborate and/or share knowledge with other staff in troubleshooting tasks.
- Keep management, APEX Team, and stakeholders fully informed on the status of work.
- Follow APEX industry best practices throughout the process.
- Hold Knowledge Transfer sessions with OSC Staff
Mandatory Qualifications:
- Three or more years of experience with using Oracle APEX software, with experience in Oracle APEX 17.x-21.x and Oracle Database 11g-21c.
- Three or more years of experience with Oracle APEX security, authentication, and authorization schemes.
- Three or more years of experience with Oracle APEX analysis, design, development, testing, implementation, and maintenance of forms, interactive reports, interactive grids, collections, graphs, dashboards, and generating reports.
- Three or more years of experience with JavaScript, JSON, Web Services, XML, HTML, and UI/UX.
- Three or more years of experience with designing, developing, testing, and documenting new applications and supporting/enhancing existing applications on the Oracle APEX platform.
- Three or more years of experience with migration of legacy applications to Oracle APEX.
- Four or more years in creation of dynamic reports in Oracle APEX environment using reporting tools (e.g., BI Publisher).
- Four or more years of experience with SQL and query performance tuning.
- Four or more years of experience with PL/SQL (procedures, functions, packages), cursors, triggers, collections, transactional modeling, database normalization, indexing methods, constraints, performance tuning, security, auditing, metadata management.
Preferred Qualifications:
- Strong communication skills.
- Ability to work well independently and in teams.
- Knowledge of application development principles and best practices.
- Familiarity with agile project methodologies
Salary : $60 - $70
