Oracle Programmer Analyst

APPOINTMENT TYPE: Full-Time Regular

LOCATION: Oak Ridge, TN or Remote (US Based Locations)

SALARY RANGE: $73,257.60 - $99,944.00

PURPOSE:

To meet the support needs of the Information Technology Services (ITS) customers in their use of the Enterprise Resource Planning (ERP) Oracle system or other corporate business applications. 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 Corporate Business Applications (CBA) technical support analysts in ITS.

Support Oracle modules or other corporate business applications and the customers who use them.
• Initially focus on assigned Oracle module and then expand into support of other modules/applications as either primary or backup support. Duties included in this task include:
  • Maintaining extensive knowledge of assigned modules.
  • Understanding the integration implications of assigned modules with full system.
  • Troubleshooting and resolving technical problems with the Oracle software.

• Requires understanding of Procedural Language (PL)/Structured Query Language (SQL) code development. Also includes:
  • 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.

• Support 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. This involves working with end users to map business practices, identify gaps, propose and implement solutions, and document and place solutions into production.
• Maintain effective and secure tools and environments, and provide input to continuous improvement in this area. This duty requires developing broad understanding of the current ORAU IT Technologies and procedures, and following established procedures (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 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)/Affirmative Action (AA) 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.

Bachelor's degree in computer sciences, business administration, or a related scientific/engineering field and 2-4 years direct experience. An equivalent combination of education and experience performing duties as described may be substituted for the minimum requirements.

Technology experience needed includes:

• Oracle or other large relational database management system and their applications.
• Must understand Oracle database and applications underlying structure and processes to answer questions in the application area, troubleshoot, and meet customer needs.
• Must understand Oracle Support facilities and be able to apply the necessary technologies to support incremental upgrades and problem resolution (i.e., obtain software patches and develop test environments, coordinate testing by end users and technical staff, and communicate to database administrator (DBA) and other support professionals).
• Windows Operating Systems.
• Microsoft Office Suite.
• Oracle applications or other large commercial-off-the-shelf (COTS) application support experience.
• Reporting tools such as OBIEE
• Experience with development tools such as SQL and PL/SQL.

Interpersonal relationship experience needed includes:

• Effective communication skills.
• Continuous skills enhancement in customer service approaches.
• Good problem-solving skills and fostering of others' skills and confidence in technology.
• Ability to foster a cooperative work environment.

*The candidate's starting salary will be determined upon hire and ORAU will use salary survey data, internal comparators, and the candidate's qualifications to determine salary.

TOTAL REWARDS

ORAU has a strategic approach to providing total rewards to employees through a fair, equitable, and competitive total compensation package. The goal of our total rewards system is to integrate compensation, benefits, work-life balance, performance, recognition, development, and career opportunities to attract, engage, and retain the talent required to achieve ORAU's business objectives. The benefit component of our total rewards program supports business goals by offering the following benefits based on employee eligibility:

• Legally required benefits
• Group Health insurance including: Medical, Prescription, Dental, and Vision
• Retirement plan contribution matching
• Disability insurance
• Group life insurance
• Travel Accident Insurance
• Section 125 reimbursement accounts
• Other voluntary employee paid benefit and insurance offerings

The ORAU total reward package also promotes work-life balance. Mindful of the need for employees to care for themselves and their families, ORAU offers the following additional work-life benefits based on employee eligibility:

• Telework
• Paid Time Off (PTO)
• Paid Holidays
• Flexible work schedules or compressed work weeks
• Occupational Health and Wellness Programs
• Employee Assistance Program