Oracle Programmer Analyst

APPOINTMENT TYPE: Full-Time Regular

LOCATION: Oak Ridge, TN or Remote (U.S. Based Locations)

SALARY RANGE: $97,843.20 - $136,095.44

PURPOSE:

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.

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.

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.

Technology:

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

Interpersonal relationship experience:

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

*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