Loading...

City of El Monte-Oracle Applications System and Database Administrator

8/26/2021 9:59:38 AM 1004

Salary$32.57 - $68.77 Hourly $5,645.75 - $11,920.50 Monthly $67,749.00 - $143,046.00 Annually

$67,749.00 - $143,046.00 Annually

Location Access Services, El Monte, CA

El Monte, CA

Job Type

Full-Time

Department

Procurement

Job Number

2021-10

Closing date and time

9/17/2021 at 5:00 PM Pacific Time (US & Canada); Tijuana








click to apply


Description

The Oracle Applications System and Database Administrator plans the day-to-day administration of Oracle Fusion ERP applications and performs service-specific administrative tasks and maintenance. This position is highly collaborative, working with project managers, system administrators, developers, and external representatives to complete projects and troubleshoot and resolve issues as they arise.
 
SUPERVISORY RESPONSIBILITIES
Receives general supervision from the Manager of Procurement. No supervision of staff is exercised. 
WHO WE ARE:
Access Services, a local public entity, is the Los Angeles County Consolidated Transportation Services Agency ("CTSA") and administers the Los Angeles County Coordinated Paratransit Plan ("Plan") on behalf of the County's 45 public fixed-route operators (i.e., bus and rail). Pursuant to the Plan, Access facilitates the provision of complementary ADA paratransit services to certain persons with disabilities as required by 42 U.S.C. §12143 under the name "Access Paratransit." Paratransit is an alternative mode of flexible passenger transportation that does not follow fixed routes or schedules.

OUR LOCATION:
Access Services headquarters is located in METRO's Division 9, El Monte Station.

WHAT WE BELIEVE:
Mission:
 Access Services promotes access to all modes of transportation and provides quality and safe ADA paratransit service on behalf of public transit agencies in Los Angeles County.

Vision: Access Services serves the community as the leader in promoting accessible and innovative transportation solutions. We accomplish this vision by:
  • Providing quality, efficient, safe, and dependable ADA paratransit service.
  • Leading the national dialogue as an advocate for universal access to transportation.
  • Partnering with other entities to secure alternate funding sources and legislation that expands transportation options.

Examples of Duties

Duties may include, but are not limited to, the following:
  • Add, manage, terminate, and issue provision roles and data access based on organization-defined security policies and user roles defined by the agency. 
  • Maintain Self-Service module for all staff. Add, modify, and terminate user roles based on organizational chart and hierarchy. Continuously modify roles based on promotions, departures, and new hires. Roles are associated with modified user roles allowing specific access and viewing ability based on staff roles. Build customized solutions by tailoring processes, workflows, and interface interaction based on user-specific roles. 
  • As needed, modify approval workflow to mirror agency hierarchy and in relation to procurement policies. 
  • Review and audit end-user accounts, permissions, and access rights to align segregation of duties and security access.
  • Perform service-specific administrative tasks and maintenance.
    1. Handle updates issued by Oracle where versions are updated and rolled out to our cloud platform. Test updated versions to assure functionality is consistent with previous versions, without bugs. If bugs are found or if specific functionality is lost in updated versions of Oracle Fusion, ensure that a SR ticket is created and bugs are worked out before the update is rolled out to the production site. 
    2. This task also includes running scheduled processes in both accounting and procurement modules to update data using an autonomous process. This can include updating asset management, integrating connections from outside services/external services to plug into Oracle Fusion. This is also related to P-card transactions from the banking system into Oracle expenses. 
  • View, monitor, and communicate service details and notifications related to service patches, critical updates, downtime, system cloning.
    1. With new Oracle, Fusion versions notify frequent users of upcoming changes to the modules and interfaces. Notify all users of downtime for maintenance, which may affect performance due to transitioning to alternative servers and a lower priority on cloud networks during that time. 
  • Manage User account access and license issuance per agency organizational chart. 
  • Manage internal control functions and assess applicability in order to streamline processes and enhance system interactions with end-users. 
    1. Review and modify specific workflows to increase streamlined processes. review and communicate with end-users to obtain information about how Oracle can help with external work processes by departments other than Procurement. 
    2. Meet with end-users periodically to obtain information to assess how the workflow or system, in general, can be tweaked for greater efficiency and increase improve user experiences to enable them to go into the system more often and discover actions to be taken as the owners of the PO and Contract. More specifically, identify when invoices are being applied to contracts where the Scope of Work (SOW) does not include that task or work requirement; this may require a modification to SOW to now include specific tasks in the contract. 
  • Manage all Service Requests (SRs) with Oracle consulting firm and Oracle cloud operations to coordinate and complete any administrative task. 
  • Maintain and create Business Intelligence Data Models, Analysis, and Dashboard.  Also, maintain any delivery of outgoing reports.
    1. Work with Oracle consulting firm to create Oracle reports for both Procurement and Accounting modules, including open PO reports, supplier performance reports, historical PO PDF captures, aggregate suppliers award totals for a Fiscal Year, supplier listing reports indicating new suppliers added to the system for virtual debit card payments by third-party financial institutions, and the project manager report, which includes a significant amount of dedication to assuring reports can capture expense data associated with contracts/POs that are not being captured by the system through invoice payments. 
  • Develop training materials based on interactions with requestors, user inquiries, and frequently asked questions. Include training to orient new users to the system. The successful candidate must be able to integrate procurement policies into Oracle training that are specific to the type of usage, per user. 
  • Monitor and communicate system performance metrics and works with internal staff and 3rd party consultants to resolve any issues.  
  • Be familiar with and manage banking integrations (ACH, PosPay, BAI, Corporate Card Expenses).
  • Understand internal business processes related to self-service procurement and expense report entry.
  • Manage Financial Structures: to include Chart of Account maintenance.
  • Must understand and be able to maintain BPM Workflows (REQs, POs, Invoices, Journals, Expense Reports).

Typical Qualifications

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable qualified individuals with disabilities to perform the essential functions. 

KNOWLEDGE, SKILLS, AND ABILITIES
Knowledge of:
  • The Americans with Disabilities Act (ADA) and its application to public transit.
  • Database backup procedures, recovery systems, and SQL.
  • Electronic equipment, and computer hardware and software, including applications and programming, such as: oracle database design, coding; documentation and programming languages; and application programming interface (API).
Skill in: 
  • Customer service to respond to and resolve questions and fix issues.
  • Delivering information, to explain procedures, and to follow verbal and written instructions.
  • Identifying complex problems and reviewing related information to develop and evaluate options and implement solutions. 
  • Operating Microsoft Office and standard procurement software systems.
  • Communicating and working well with others in a team environment.
  • Using logic and reason to identify the strengths and weaknesses of alternative solutions, conclusions or approaches to problems.

 Ability to:
  • Read a variety of technical documentation, directions, instructions, and methods and procedures. 
  • Speak with and before others with poise, voice control, and confidence using correct English usage as well as communicating with the general public.
  • Visualize algorithmic structures.
  • Write job related documentation and reports with proper format, punctuation, spelling and grammar, using all parts of speech. 
 
QUALIFICATIONS: To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable qualified individuals with disabilities to perform the essential functions. 

EDUCATIONAL/PROFESSIONAL QUALIFICATIONS

Education: A bachelor's degree from an accredited college or university is required. A major in Computer Science, Management of Information Systems, or a related field is desirable, but not required.

Certificate(s); one or more of the following Oracle certifications is highly desirable: 
 
  • Oracle Financials Cloud: General Ledger 2021 Certified Implementation Specialist
  • Oracle Financials Cloud: Payables 2021 Certified Implementation Specialist
  • Oracle Financials Cloud: Receivables 2021 Certified Implementation Specialist
  • Oracle Financials Cloud: Procurement 2021 Certified Implementation Specialist
 
Experience:  Two years of related experience with progressive responsibility in an Oracle database environment.
 
DESIRABLE QUALIFICATIONS
  • Strong knowledge of Oracle Fusion ERP applications, ideally with Oracle Fusion Procurement and Finance modules. This is a cloud-based system, rather than an in-house hosted service.   
  • Experience working for a government agency or non-profit, specifically in the areas of procurement and/or accounting is useful, but not required.

Supplemental Information

Application Procedure: All applicants are required to complete and submit an Access Services application form online.  Resumes or faxed copies will not be accepted in lieu of the online application.  To apply, click on the "Apply" link located at the top of this page. New users must create an account first.
 
Selection Procedure: Applicants will be screened and evaluated for relevant training and experience. Only those applicants determined to be among the most qualified may be invited to participate in the selection process. The selection process may consist of any combination of written, performance, and/or oral appraisal exams. Examination parts will be weighed according to their relevance to the job performance criteria. Applicants passing the selection criteria will be placed on an eligibility list, which remains active for six months. 
 
Vacancy information: The resulting eligible list will be used to fill vacancies as they occur. Eligible lists may expire or exhaust when the eligibility pool is insufficient to draw from.
 
OTHER REQUIREMENTS:
 
Pre-employment: All potential employees are required to successfully pass a post-offer pre-employment medical examination (which will include a drug/alcohol screening) and satisfactory results from an administrative screening.
 
Immigration and Reform Control Act: In compliance with the Immigration and Reform Control Act of 1986, Access Services will only hire individuals who are legally authorized to work in the United States. Access Services does not provide sponsorship.
 
E-Verify: Access Services is an E-Verify employer. E-Verify is an internet-based system operated by the Department of Homeland Security (DHS) in partnership with the Social Security Administration (SSA) that allows participating employers to electronically verify the employment eligibility of newly hired employees in the United States. Access Services does not sponsor H-1B or related work visas.

Agency
Access Services
Phone
213-270-6000
Website
http://www.accessla.org
Address
PO Box 5728

El Monte, California, 91734

图片翻摄自网路,版权归原作者所有。如有侵权请联系我们,我们将及时处理。

推薦企業