Oracle APEX Software Engineer

TekSynap - New Orleans, LA

Full-time

Remote - New Orleans, LA

Professional, Scientific, and Technical Services

About the position

We are seeking an Oracle Apex Software Engineer to join our team supporting DOI BSEE TIMS contract in New Orleans, LA. BOEM and BSEE are responsible for managing the nation's offshore energy, minerals, and natural resources on the Federal Outer Continental Shelf (OCS). BSEE promotes safety, protects the environment, and conserves resources offshore through vigorous regulatory oversight and enforcement. BOEM manages the responsible exploration and development of offshore energy and marine mineral resources on the OCS. OCS production accounts for about 18 percent of domestic crude oil and four percent of domestic natural gas supply. TekSynap is a fast growing high-tech company that understands both the pace of technology today and the need to have a comprehensive well planned information management environment. "Technology moving at the speed of thought" embodies these principles - the need to nimbly utilize the best that information technology offers to meet the business needs of our Federal Government customers.

Responsibilities

• Demonstrate mastery in Oracle APEX development, including creating, designing, updating, documenting, and implementing logical and physical database changes.
• Lead the design and implementation of Oracle APEX solutions, ensuring adherence to industry best practices and standards.
• Modify or develop new online programs, unit test cases, batch programs, interfaces, configuration changes, and reports within the Oracle APEX environment.
• Conduct meetings with stakeholders to clarify and understand business requirements, ensuring alignment with project objectives.
• Establish the high-level sprint schedule, setting priorities and timelines to meet the needs of users and stakeholders.
• Plan, direct, and monitor the work of team members, providing guidance and support to ensure project success.
• Utilize existing Service-Oriented Architecture (SOA) services where feasible and develop new SOA services, APIs, and microservices within Oracle APEX applications. Ensure the code is modular, reusable, and portable.
• Ensure proper exception handling and appropriate logging within Oracle APEX applications to facilitate troubleshooting and maintenance.
• Identify and resolve information assurance weaknesses and vulnerabilities, maintaining the security and integrity of Oracle APEX solutions.
• Perform peer code reviews and ensure automation build failures resulting from code issues are promptly resolved.
• Formulate and define system scope and objectives, devising or modifying procedures to solve complex problems within Oracle APEX applications.
• Prepare detailed specifications from which programs will be written, ensuring clarity and accuracy in programming tasks.
• Design, code, test, debug, and document programs within Oracle APEX applications, adhering to established guidelines and standards.
• Participate in related areas such as design, implementation, integration, management, and maintenance of complex databases, ensuring optimal performance and security.
• May direct the work of other developers, providing guidance and oversight to ensure project deliverables are met.
• Collaborate with cross-functional teams on design, implementation, and management tasks, fostering a collaborative and productive work environment.

Requirements

• Bachelor's degree in Information Systems, Engineering, Business or relevant field. Master's degree preferred.
• Proven track record of successful Oracle APEX development projects and integration efforts, showcasing advanced proficiency in leveraging Oracle's Application Express platform.
• Strong command of SQL and PL/SQL languages for efficient database management, manipulation, and querying, ensuring robust data-driven solutions.
• A minimum of ten years of hands-on experience in applications software development, demonstrating a depth of technical knowledge and expertise in the field.
• Must have the ability to pass a DOI Background Investigation for a Public Trust Clearance, ensuring compliance with security and regulatory requirements.
• Certification or specialized training in APEX.

Nice-to-haves

• Mastery of Oracle APEX development, including creating interactive web applications, reports, charts and dashboards.
• In depth knowledge of APEX components and plugins.
• Experience with APEX security features and user management.
• 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.
• Proficiency in Oracle Database management is essential. This includes 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 and functions.
• Ability to design and implement database structures, including tables, indexes and constraints, to ensure data integrity and optimal performance.

Benefits

• Health insurance
• Dental insurance
• Vision insurance
• 401K
• Life insurance
• Short-term and long-term disability plans
• Vacation time
• Holidays