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.

Oracle Applications Developer II

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. Conducts detailed research and provides technical improvements. Reviews and establishes development and coding standards. Reviews designs to ensure that programming and systems standards are being adhered to and the methodology is being followed. Performs other duties of a similar nature as may be required.

ESSENTIAL FUNCTIONS

– Identifies, recommends and implements complex technical solutions for Oracle applications based on functional requirements and technology changes.

– Develops technical solutions to leverage Oracle applications functionality for any of the Oracle modules like, GL, AP, AR, PO, INV,i-Proc, i-Expense and HRMS areas and suggests technical improvements for business process enhancement.

– Assists in periodic reviews and updates the design, development and coding standards, as well as establishes new development procedures for the latest Oracle tools.

– 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.

– Works jointly with the IT Business Analyst and external consultants to develop end users’ technical requirements and operational needs. Identifies system intent, output requirements, input data acquisition and internal checks and controls in conformance with information systems and programming standards.

– Performs low complex technical support of enterprise applications through analysis, reviews and enhancements to increase the operating efficiency or adapt to new requirements.

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

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

– Provides minimum guidance to other programmers, such as Oracle Application Developers.

– Research and recommend development activities to support new tools and technologies.

– Develops and applies advanced expertise in software utilities used to create reports, screens, workflows and other productivity aids.

– Develops expertise in software troubleshooting tools and document the necessary actions/changes.

– Develops an advanced 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.

– Clearly defines 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.

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

– Works collaboratively with 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.