Oracle Developer - Remote (WFH)

The Oracle Developer position is part of the Acquisition and Property Management (APM) Veteran Canteen Services (VCS) Automated Information System (AIS) team within the Acquisition and Property Management (APM) portfolio in support of the US Department of Veterans Affairs, Consolidated Corporate Support Services (CCSS) program.

Within the Acquisition and Property Management (APM) Product Line, VCS AIS represents two of the three primary VCS systems and back-end components that drive that the only revenue-generated system at VA's United Stated (US) facilities. Supporting the entirety of the on-campus restaurants/food services, as well as the on-site retail stores and related vending services, VCS AIS encompass and supports all of the cash register-based transactions (tills) at these locations, all the reporting requirements at all levels of the organization that support these monetary transactions, all the required interfaces to/from the other systems and sub-systems in support of VCS operations, and all of the supporting financial transactions, accounting, and related reporting and system interfaces. VCS AIS comprises the back-end and legacy components for VCS and is a system of systems. AIS supports retail management and financial management systems and services, including merchandise applications, retail planning, multiple application interfaces, and planning and forecasting.

Duties:

• Design, develop, and configure reports according to client requirements either end-to-end from analysis, design, implementation, quality assurance (including testing), to delivery and maintenance of the software product or system of for a specific phase of the lifecycle.
• Develops high quality reports with Oracle reports and BI Publisher.
• Applies knowledge of technologies, applications, methodologies, processes and tools.
• Expertise and proficiency in designing and developing Web Based Applications and development.
• Conducts product-level and code-level analysis, and collaborates with subject matter experts in the planning, design, development, and utilization of VA legacy and modernization tools and systems for information storage, processing, presentation, manipulation, display, or reporting. End product may be special use, customized, or COTS/GOTS software.
• Determines computer user needs; analyzes system capabilities to resolve problems on program intent, output requirements, input data acquisition, programming techniques and controls; prepares operating instructions; designs and develops autonomous services, desktop applications, web applications, scripts, and utility programs.
• Ensures software standards are met.
• Exercise care and quality in delivering products.
• Provides technical solutions to a wide range of difficult problems where analysis of data requires evaluation of identifiable factors. Solutions are imaginative, thorough, practicable and consistent with client objectives.

Requirements:

• For VA's Acquisition and Property Management Product Line:
  • VCS AIS:
    • Oracle Database 19c and/or later versions experience
    • Oracle Custom applications and/or Oracle Enterprise Business Suite application experience
    • Oracle Reporting (Oracle Reports, BI Publisher, OBIEE) Oracle Workflow experience
    • API Interface experience
    • Windows Server, 2019, Operating System
    • Experience with creating PL/SQL Packages, Procedures, Functions, and Exception handling for retrieving, manipulating, checking, and migrating complex data sets
    • Experience with creating data import, export jobs using SQL Loader, Oracle Data Pump PL/SQL APIs
• Required Education, Experience, and Clearance:
  • Bachelors and five (5) years or more experience, - OR -
  • Masters and three (3) years or more experience
  • Ability to obtain a VA Position of Public Trust - Medium Background Investigation (MBI)