Oracle Applications Developer I

JOB SUMMARY

Provides technical support during the implementation, upgrade and maintenance of Oracle Applications and other Sewer District software. Collaborates with Sewer District departments, IT functional teams and external consultants to research, design, document and develop programs, as well as test and deploy solutions to achieve business functionalities in conformity with established coding standards, methodologies, policies and procedures. Performs other duties of a similar nature as may be required.

ESSENTIAL FUNCTIONS

- Develops and provides technical solutions for Oracle and Cloud applications to achieve end user requirements and operational needs.

- Researches, recommends and implements technical solutions to address the needs of stakeholders and issues that arise related to Oracle applications functionality for Financials modules like modules like, GL, AP, AR, PO, INV,i-Proc, i-Expense and HRMS.

- Gathers requirements and creates technical specification documents.

- Utilizes Oracle tools, such as SQL, PLSQL, Toad, Workflow builder, Data loader, Forms, BI Publisher, OAF and ALERTS to enhance Oracle applications. Provides reporting solutions and builds interfaces and data migrations that meet the business requirements of the Sewer District.

- Follows the Sewer District's Coding and Migration standards for development, customization and enhancements of the software applications.

- Prepares program test scripts and data, analyzes test results and uses data control procedures for new and existing programs. Tests systems for correct functionality and checks work completion for accuracy.

- Performs baseline technical support of enterprise applications through enhancements to increase the operating efficiency or adapt to new requirements.

- Performs analysis and programming tasks, such as designing, coding, testing, documenting and maintaining host-based or departmental systems, which follow systems standards and methodology.

- Develops a working knowledge of Oracle database engine, database concepts, relationships and structures to support end users with programming application solutions and offer alternatives to the coding approach.

- Ascertains technical specification for software solutions to meet end user needs by translating functional requirements, workflows and diagrams into logical instructions and programs.

- Reviews operating systems software and upgraded application programs to ensure proper integration.

- Provides periodic performance and usage summaries as well as any other statistics needed to make decisions on technology support.

- Keeps current on new developments in information technology and their application to make recommendations for implementing appropriate technology advancements.

- Works collaboratively with other Sewer District departments and functional IT teams to complete tasks.

- Performs other duties of a similar nature as may be required.

MINIMUM JOB REQUIREMENTS

EDUCATION

Candidate must possess a bachelor's degree, preferably in Programming, Computer Science, Information Technology, or closely related field.

EXPERIENCE

- Candidate must possess three (3) years of experience in IT related to application, support and maintenance.

- Experience must include two (2) years of experience in the Oracle Enterprise Applications Suite (EBS) and Oracle development tools (e.g., SQL, PLSQL, Toad, Workflow builder, Data loader, Forms, BI Publisher, OAF, ALERTS), as well as working experience in at least two (2) of the following, reports, interfaces, conversion, workflow, extensions and customization of EBS objects.

OTHER REQUIREMENTS

KNOWLEDGE, SKILLS AND ABILITIES

- Candidate must possess knowledge in information technology, structured design and development methodologies. Must possess working knowledge of supporting Oracle tools like XML or BI publisher, OA Framework, Oracle Forms, Oracle Reports, Oracle Workflow, integration tools, AOL Setups. Knowledge in configuration and maintenance of Oracle EBS applications and in cloud applications. Must be motivated to learn new tools and technologies.

- Candidate must possess effective written and verbal communication, organizational skills, decision-making abilities.

- Candidate must possess ability to manage projects, meet deadlines and tackle emergencies and difficult situations.

- Candidate must possess the ability to effectively plan and coordinate, establish and maintain effective working relationships and prioritize workloads based on available resources.

PHYSICAL AND MENTAL REQUIREMENTS

During the course of performing the essential functions of this position the employee must be able to compare, compute, analyze, synthesize, copy, compile, coordinate, negotiate, and instruct. Ability to communicate while exhibiting strong interpersonal skills is required. Physical work will need to be performed, such as standing, sitting, balancing, kneeling, crawling, handling, feeling, hearing, walking, climbing, stooping, crouching, reaching, fingering and talking. Must be able to lift up to 10 lbs. on an occasional basis. Position will require visual demands of near acuity, far acuity, color vision and accommodation. The position requires office work. While visiting the plant or construction site the employee may be exposed to extreme weather, wet and/or humid conditions, or confined/restricted working environments.