Oracle Programmer Analyst

ORAU•Oak Ridge, TN

7d•$97,843 - $136,095•Remote

About The Position

To meet the support needs of the Information Technology Solutions (ITS) customers in their use of the Enterprise Resource Planning (ERP) Oracle system or other corporate business applications (CBA). To work with other ITS sections to develop and maintain effective service tools and environments as needed. Duties include resolving user problems, working with Oracle Support to maintain programs, maintenance of technical documentation, support in version upgrades, implementation of new Oracle modules or functionality, working with business process teams for process improvement initiatives, and to work closely with the other CBA technical support analysts in ITS.

Requirements

Bachelor's degree in computer sciences, business administration, or a related scientific/engineering field and 5-8 years direct experience. An equivalent combination of education and experience performing duties as described may be substituted for the minimum requirements.
Oracle or other large relational database management system and their applications.
Windows Operating Systems.
Microsoft Office Suite.
Oracle E-Business Suite (EBS) or other large Commercial Off-The-Shelf (COTS) application support experience.
Reporting tools such as OBIEE and development tools such as SQL and PL/SQL.
Position is a highly customer-oriented position requiring effective communication skills, continuous skills enhancement in customer service approaches, etc.
Good problem-solving skills and fostering of others’ skills and confidence in technology.
Fostering a cooperative work environment.

Responsibilities

Support Oracle modules or other corporate business applications and the customers who use them. This position will begin with an emphasis on an assigned Oracle module and expand into support of other modules/applications as either primary or backup support. Duties include:
Maintaining extensive knowledge of assigned modules, understanding the integration implications of assigned modules with full system, and troubleshooting and resolving technical problems with the Oracle software.
Procedural Language/Structured Query Language (PL/SQL) code development, maintaining awareness of business processes and needs of users.
Providing advice to users on methods for improving the use of existing modules.
Responding to user requests routed from ITS Support Center, initiation and follow-up of Service Requests (SRs) via My Oracle Support.
Attending all section technical meetings and required customer meetings.
Supporting any of the Oracle application modules and other corporate business applications in a primary, secondary, or tertiary backup role.
Assist with implementation of new Oracle modules, associated 3rd-party add-on software, and dormant functionality within an existing module. Involves working with end users to map business practices, identify gaps, and propose/implement solutions. Document and place solutions into production.
Maintain effective and secure tools and environments, and provide input to continuous improvement in this area. This requires developing broad understanding of the current ORAU IT Technologies and procedures, and following established procedures such as updating logs, following change management procedures, etc.
Promote new ideas that lead to continuous improvement in our approaches and tools.
Participate in ITS All-Staff meetings.
Remain up-to-date in current technology and related support tools, primarily Oracle applications, PL-SQL, Oracle Business Intelligence Enterprise Edition (OBIEE), and relevant Personal Computer (PC) desktop technologies such as Microsoft Office.
Responsible for compliance and participation in general administration such as:
Property assigned to incumbent, security issues (both individually and in support groups).
Administrative tasks.
Equal Employment Opportunity (EEO) awareness.
Use of ERP Oracle applications as an employee.
Administrative tasks include timekeeping, accounting activities related to incumbent’s purchases and travel, and completion of required training.