PROGRAMMER/ANALYST I (ORACLE)

State of careers Rhode Island

16h

About The Position

GENERAL STATEMENT OF DUTIES: To conduct technical work in systems analysis, systems design and programming activities in a specialty area; to assist a superior in performing the most complex and difficult technical work; and to do related work as required. SUPERVISION RECEIVED: Works under the general supervision of a superior with latitude for the exercise of independent judgement; work is reviewed in process and upon completion for results obtained and conformance with policies and objectives. SUPERVISION EXERCISED: As required, may supervise the work of subordinate technical and clerical employees assigned to assist in a project. ILLUSTRATIVE EXAMPLES OF WORK PERFORMED: To conduct technical work in systems analysis, systems design and programming activities in an area of specialization; to assist a superior in performing the most complex and difficult technical work. To interview users and formulate problem statements; to devise data processing solutions for projects under development. To consult with and advise users on applicable software and hardware. To create a detailed list of activities for each project or sub-system being developed. To check all system logic for compliance with standards and needs. To install, test, document and maintain application packages and subroutines received from vendors and users. To conduct necessary user education on various programming systems and available software packages. To provide end user support and technical assistance for application packages. To assist in the development and evaluation of systems and programming standards. To perform and/or coordinate data processing tasks necessary for project completion. To do related work as required.

Requirements

• A working knowledge of the principles, practices and techniques required in assessing the feasibility, applicability, necessity, goals and cost of data processing systems
• a working knowledge of the capabilities, programming techniques and intricacies of automated systems and peripheral equipment directly relating to a programming specialty
• the ability to install, test, document and maintain application packages and subroutines associated with software specialty
• a working knowledge of the personal computer and the ability to utilize it effectively
• the ability to communicate effectively with subordinates, superiors and departmental personnel
• related capacities and abilities
• graduation from a college of recognized standing including or supplemented by successful completion of courses in computer science
• employment in an analytical position involving applications programming in the area of specialization
• any combination of education and experience that shall be substantially equivalent to the above education and experience

Nice To Haves

• experience with Oracle E-Business ERP applications and Oracle databases 10g or higher
• experience with Windows Server or HP UX
• a thorough understanding of Oracle E-Business Suite database architecture to include the following modules: (Timesheets--Oracle Internet Time, Grants/Projects, General Ledger, Payables, Purchasing, ISupplier, Sourcing, Receivables, Human Resources and Inventory)
• strong PL/SQL with thorough knowledge of PL/SQL procedures, functions and triggers
• creating and supporting custom reports utilizing Oracle Reports Builder 6i and custom written PL/SQL packages used to produce Excel reports, and XML publisher reports
• Experience in using Develop Tools such as Oracle's Enterprise Manager, TOAD, SQL, Plus, Oracle Forms Builder, Oracle Reports Builder, Oracle Workflow Builder

Responsibilities

• To conduct technical work in systems analysis, systems design and programming activities in an area of specialization; to assist a superior in performing the most complex and difficult technical work.
• To interview users and formulate problem statements; to devise data processing solutions for projects under development.
• To consult with and advise users on applicable software and hardware.
• To create a detailed list of activities for each project or sub-system being developed.
• To check all system logic for compliance with standards and needs.
• To install, test, document and maintain application packages and subroutines received from vendors and users.
• To conduct necessary user education on various programming systems and available software packages.
• To provide end user support and technical assistance for application packages.
• To assist in the development and evaluation of systems and programming standards.
• To perform and/or coordinate data processing tasks necessary for project completion.
• To do related work as required.

Benefits

• For information regarding the benefits available to State of Rhode Island employees, please visit the Office of Employee Benefits' website at http://www.employeebenefits.ri.gov/.
• Also, be advised that a new provision in RI General Law 35-6-1 was enacted requiring direct deposit for all employees. Specific to new hires, the law requires that all employees hired after September 30, 2014 participate in direct deposit. Accordingly, any employee hired after this date will be required to participate in the direct deposit system. At the time the employee is hired, the employee shall identify a financial institution that will serve as a personal depository agency for the employee.

What This Job Offers

• Job Type: Full-time
• Career Level: Entry Level