Oracle Apex Software Engineer

About the Role

Key Responsibilities

• Oracle APEX development, including creating, designing, updating, documenting, and implementing logical and physical database changes ensuring data integrity and performance optimization.
• Conduct meetings with stakeholders to clarify and understand business requirements, translating them into technical solutions effectively.
• Establish the high-level sprint schedule for agile development projects, ensuring alignment with project goals and timelines.
• Design and implement software solutions based on industry best practices, focusing on scalability, security, and usability.
• Utilize existing SOA services where feasible; build new SOA services, APIs, and microservices when applicable, ensuring code modularity, reusability, and portability.
• Modify or develop new online 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 across projects to facilitate troubleshooting and maintenance.
• Identify and resolve information assurance weaknesses and vulnerabilities, adhering to security best practices throughout development.
• Conduct peer code reviews and ensure automation build failures resulting from code issues are promptly resolved.
• Plan, direct, and monitor the work of team members, providing technical guidance and mentoring as needed.
• Set priorities effectively to meet user needs and project deadlines, adapting procedures as necessary to solve complex problems.
• Formulate and define system scope and objectives based on user requirements and organizational goals.
• Prepare detailed specifications from which programs will be written, ensuring clarity and accuracy in implementation.
• Design, code, test, debug, and document programs, adhering to coding standards and software development methodologies.
• Participate in the design, implementation, integration, management, and maintenance of complex databases, ensuring optimal performance and security.
• Direct the work of other developers on specific projects, providing leadership and technical expertise as required.

Requirements

• Must have the ability to pass a DOI Background Investigation for a Public Trust Clearance, ensuring compliance with security and regulatory requirements.
• Oracle APEX development and database management.
• Bachelor's degree in Engineering/Computer Science or area related to the project's functional requirement.
• Eight years of technical experience in applications software development, three of which are in systems analysis, and one year of which is acting as technical lead.
• Experience in software engineering, with a strong emphasis on Oracle APEX development and database management.
• Experience in agile software development methodologies, including sprint planning, iterative development, and continuous integration.
• Proficiency in SQL and/or PL/SQL programming languages for data manipulation, querying, and database procedures.

Nice to Have

• Extensive experience in creating interactive web applications, reports, charts, and dashboards using Oracle APEX.
• Proficiency in utilizing and customizing APEX components and plugins to enhance application functionality and user experience.
• Hands-on experience in implementing APEX security features and user management capabilities to ensure data protection and access control.
• Ability to integrate APEX applications with other systems and technologies, including web services (RESTful and SOAP) and external data sources.
• Expertise in optimizing APEX applications and SQL queries for performance, including query tuning, indexing strategies, and caching mechanisms.
• Proficiency in using version control systems like Git for managing APEX application code.
• Familiarity with RESTful and SOAP web services development for integrating APEX applications with external APIs and services.
• Proficiency in Oracle Database management, including understanding database architecture, SQL, PL/SQL, and database design principles.
• Strong skills in SQL for querying and manipulating data in Oracle databases.
• Proficiency in PL/SQL for developing stored procedures, triggers, functions, and packages.
• Ability to design and implement database structures, including tables, indexes, and constraints.

Qualifications

• Bachelor's degree in Engineering/Computer Science or related field.

Benefits & Perks

• Competitive benefits package including health, dental, and vision insurance.
• 401K plan.
• Life insurance.
• Short-term and long-term disability plans.
• Vacation time and holidays.