Description
RESPONSIBILITIES
Oracle APEX Development
Create, design, update, document and implement logical and physical database changes.
Conduct meetings with Stakeholders to clarify and understand business requirements
Establish the high-level sprint schedule
Design and implement design solutions based on industry best practices.
Utilize existing SOA services where feasible. build new SOA services, APIs and microservices when applicable and ensure the code is modular, re-usable, and portable.
Modify or write new on-line programs, unit test cases, batch programs, interfaces, configuration changes, and reports. Build unit tests and integration tests as necessary.
Ensure proper exception handling and appropriate logging.
Identify and resolve information assurance weaknesses and vulnerabilities.
Perform peer code reviews and ensure automation build failures resulting from code issues are resolved.
Plans, directs and monitors the work of team members.
Sets priorities to meet the needs of users.
Formulates/defines system scope and objectives.
Devises or modifies procedures to solve complex problems considering computer equipment capacity and limitations.
Prepares detailed specifications from which programs will be written.
Designs, codes, tests, debugs, and documents programs.
Participates in related areas, such as such as design, implementation, integration, management, and maintenance of complex databases, with respect to the operating system, access methods, access time, device allocation, validation checks, organization, protection and security, documentation, guidelines, and statistical methods; evaluation of commercial off-the-shelf (COTS) products; and analysis of hardware/software issues.
May direct the work of other developers.
REQUIRED QUALIFICATIONS
APEX development and integration experience
Proficiency in SQL and PL/SQL
Proficiency in Oracle Database management is essential. This includes understanding database architecture, SQL, PL/SQL and database design principles.
8 years of technical experience in applications software development, 3 of which are in systems analysis, and 1 year of which is acting as technical lead.
Bachelor’s degree in Engineering/Computer Science or area related to the project’s functional requirement.
DOI Background Investigation, Entry on Duty US citizenship
DESIRED QUALIFICATIONS
Mastery of Oracle APEX development, including experience creating interactive web applications, reports, charts and dashboards.
In depth knowledge of APEX components and plugins
Experience with APEX security features and user management.
Demonstrated ability to integrate APEX applications with other systems and technologies, including web services and external data sources.
Expertise in optimizing APEX applications and SQL queries for performance
Proficiency in using version control systems like Git for managing APEX application code
Familiarity with RESTful and SOAP web services development for integration purposes
Strong skills in SQL for querying and manipulating data in Oracle databases.
Proficiency in PL/SQL for developing stored procedures, triggers and functions.
Ability to design and implement database structures, including tables, indexes and constraints, to ensure data integrity and optimal performance.
|
