Programmer Analyst Iii

Salary: $12,212.00 - $15,125.00 Monthly
Location : 530 Water Street, CA
Job Type: Full-Time
Job Number: 2024-007
Division: Financial Services Division
Opening Date: 02/26/2024
Closing Date: 3/18/2024 5:00 PM Pacific
Job Description
*** All completed applications for this position must be submitted online no later than 5:00 pm, on the closing date of the recruitment. PAPER APPLICATIONS WILL NOT BE ACCEPTED. Please follow all submission instructions to ensure your application is complete. Resumes will not be accepted in lieu of online applications, therefore, it is important for online applications to be completed fully. Late applications will not be accepted beyond the closing time and date for any reason, including any technical issues, such as system, browser, or computer failures, etc. ***
The Port is currently recruiting for the position of Programmer Analyst III. Under direction, the Programmer Analyst III is responsible for development, implementation, support and maintenance of business application systems, including on-going production support and enhancement for existing business systems, new application development and system planning for user departments/divisions.
Examples of Duties
Anyone position may not include all the duties listed, nor do the examples cover all the duties which may be performed. Incumbent may perform other related duties at the equivalent level.

• Develop, design, customize, implement, configure and support Oracle eBusiness Suite in a functional and/or technical capacity.
• Participates in planning system projects for Port departments based on their business objectives and operational needs: identifies and recommends system and/or business solutions; consults on and evaluates the technical aspects of any project; reviews technological innovations for potential use; proposes major system improvements based on requirement changes.
• Provides technical advice on effectiveness of procedures, capabilities and limitations of hardware, software and telecommunications to IT end-users.
• Establishes computer resources and budget estimates, task lists and scheduling dependencies for assigned projects; monitors progress against plan and makes adjustments.
• Organizes specific systems development projects, including formally evaluating performance on large, complex, long term projects.
• Acts as the project manager coordinating Port personnel and vendor resources on large, complex, long term projects. Works with vendors to resolve issues with timing and proper utilization of their resources.
• Maintains continuous communications with IT and user department managers to advise on systems development project status; ensures that schedules are met and project development runs smoothly.
• Reviews performance of installed applications to insure that business needs are being met/ assists in writing up changes on appropriate Requirements Document forms for end-user approval.
• Prepares detailed design and system documentation for presentation to project team and end-users; makes technical presentations to non-technical personnel.
• Assists and trains junior programmers in technical and analytical skills.
• Coordinates and conducts technical interviews and surveys.
• Performs business systems configuration and performance monitoring functions as assigned for the applications, servers and network infrastructure on which the major IT supported systems are based.
• Resolves operational problems with systems which require advanced training and knowledge of the operating systems on which the major IT supported applications are based.
• Remains technically current operating systems, programming languages, internet based application technologies, productivity tools, and I/O interface techniques, including database, network, and PCs/laptops; maintains skill level through on-going education and technical seminars to adapt to the changing information systems needs of the Port.
• Performs related duties as assigned.

Minimum Qualifications
EDUCATION AND EXPERIENCE
This classification requires a combination of education and experience reflecting possession of the required knowledge, skills, and abilities. A typical combination would include a Bachelor's degree from an accredited college or university in computer science, mathematics, or related field; AND : Five years of experience developing, designing, customizing, implementing, configuring and supporting Oracle and eBusiness Suite of applications. Experience with technological tools, such as interactive development environments (IDE's) and specifically JDeveloper, internet application development tools, and fourth generation languages, report writers, and methodologies such as prototyping, object oriented programming and relational data bases is preferred.
KNOWLEDGE, SKILLS AND ABILITIES
To perform the typical tasks and duties of the position successfully, the knowledge, skills and/or abilities listed below are required.
Knowledge of:

• Principles and practices of Oracle's eBusiness Suite (EBS) in a technical capacity including PL/SQL Package development (including the applications of triggers in an Oracle database).
• Oracle Form and OAF development, BI Publisher template development and XML concepts, Oracle Reports, Oracle Public and Private APIs, Oracle Workflow development, Oracle Discoverer, Concurrent Manager, Dataloader, and Oracle. Database concepts related to running eBusiness Suite on an 11G database.
• Functional design and configuration of Human Resources and/or Financials/Procurement tracks.
• General SDLC processes and specific understanding of AIM Oracle methodology and Oracle's direction with OUM methodology.
• All levels of systems design and programming work involving the IT supported application systems.
• Basic Linux Operating system features and functions that is required for E-Business Suite including the use of directories, printing and process scheduling.
• Port specific industry and business requirements and practices.
• Principles and practices of project management.

Ability to:

• Develop, design, customize, implement, configure and support Oracle EBS in a functional and/or technical capacity;
• develop Oracle EBS reports, interfaces, conversions and extensions;
• develop reports programmatically and via tools (e.g. Discoverer);
• program using PL/SQL in an Oracle EBS environment;
• collect information, conduct surveys, and to conduct feasibility studies of systems applications;
• conduct system user interviews and define requirements for preparing application design specifications;
• interact and communicate with and motivate end-users, management and technical personnel;
• lead meetings with users, vendors, and other IT personnel to check status of projects and resolve issues;
• prepare and present oral and written reports to all levels of Port management;
• carry out design prototyping, programming, system documentation and installation tasks;
• analyze and solve problems of a complex nature;
• exercise sound independent judgment within general policy guidelines.

THE SELECTION PROCESS
Stage I: Application and Supplemental Questionnaire Evaluation (Pass/Fail) - The first stage in the selection process will consist of an application and supplemental questionnaire appraisal review (pass/fail). Applications submitted without the completed supplemental questionnaire will be deemed incomplete and not given further consideration. Meeting the minimum qualifications does not guarantee advancement to the next stage. Only the most suitably qualified candidates will be invited to Stage II.
Stage II: Assessment Examination (Weighted 100%) - The second stage of the selection process may consist of a combination of job-related situational project exercises and an oral panel interview designed to assess technical knowledge and any additional other KSAs. Job-related situational project exercises may consist of written exercises, performance exercises or other situational exercises that would assess the KSAs. The Assessment Examination is designed to test your overall aptitude for the position.
Candidates must achieve a scale score of 70 or more on this examination to be placed on the eligible list for employment consideration. The Port of Oakland reserves the right to modify the selection process as necessary to conform to administrative or business necessity.
ADVISORIES
Immigration and Reform Control Act: In compliance with the Immigration and Reform Act of 1986, the Port of Oakland will only hire individuals who are legally authorized to work in the United States. Social Security card must be presented, and the name on it must match the name on the application.
Americans with Disabilities ("ADA"): In compliance with State and Federal Laws, the Port will employ and promote qualified individuals without regard to disability. The Port is committed to making reasonable accommodations in the selection process and in the work environment. Individuals requesting reasonable accommodations during the selection process must notify Nancy Phetdaravanh at nphetdaravanh@portoakland.com within seven (7) calendar days of the closing date of the job announcement. The Port requires applicants to provide supporting medical documentation to substantiate a request for reasonable accommodation
The Port of Oakland is an Equal Opportunity Employer
Additional Requirements
Must possess a valid California Class C driver's license at the time and for the duration of appointment.
Willingness to work overtime on weekends, evenings, and holidays.
The Port of Oakland's benefit program ranks among the best in the region for public jurisdictions and is designed to reward performance and promote a balanced lifestyle, both at the workplace and away from the workplace, for its employees and their families. The Port is committed to the health and well-being of its employees and has been recognized as a FIT-Friendly Employer by the American Heart Association.

• The Port is part of the California Public Employees Retirement System (CalPERS). CalPERS is a defined pension provided to regular full-time employees that work for the Port. The CalPERS defined pension is based on predetermined formula that factors in an employee's earnings history, tenure of service and age. The retirement formula for new hires is 2% at 62 years of age or 2.5% at 55 for with other CalPERS service and/or reciprocity.
• The Port offers retiree medical benefits for employees and dependents after 10 years of CalPERS service (including 5 years at the Port).
• The Port pays 100% of the premium cost for employees and dependent health insurance coverage not to exceed the Kaiser-HMO Family Plan; cash in lieu of medical benefit is also available.
• The Port pays 100% of the premium cost for dental and vision coverage.
• The Port pays 100% of the premium cost for Long Term Disability (LTD) coverage and reimburses employees for the State Disability Insurance.
• The Port pays 100% of the premium cost for life insurance at one-time annual salary with certain limits.
• The Port offers a Deferred Compensation Plan allowing employees to save and invest money for retirement with tax benefits.

Time Away from Work

• From 2 to 5 weeks of vacation depending on years of employment at the Port.
• 10 days of management leave for employees exempt from the Fair Labor Standards Act (FLSA).
• 1 paid Floating Holiday per year.
• 12 days of sick leave per year after three months of employment which includes 4 days of personal leave.
• 13 paid holidays as well as the second half of the shift on December 24 and December 31.

01
The purpose of this Supplemental Questionnaire is to assess your qualifications, training and experience in specific job relevant areas. The information you provide will be reviewed and used to determine if you move forward in the selection process. Incomplete responses (such as N/A or see application), false statements, omissions, or partial information may disqualify you from the selection process. Therefore, please answer all of the questions thoroughly and truthfully. Your answers to these questions, along with your completed application, will be used to select the most qualified candidates to advance in the selection process.Please indicate that you have read and understand the instructions listed above.

• Yes
• No

02
Describe your experience with developing, designing, customizing, implementing, configuring, and supporting Oracle E Business Suite (R11 and/or R12). Please be specific in describing the roles and responsibilities of your involvement and dates of involvement. Organize your answer along the tracks listed below. We do not expect candidates to have experience in all the tracks. The thoroughness of your answer will assist us in the review process:a. Financialsb. HR/Payroll/OTLc. Projects/Grantsd. Procuremente. Property Managerf. Enterprise Asset Managementg. Other modules
03
Please describe your experience level with the following:a. PL/SQL programmingb. Developing BI Publisher reportsc. Oracle Reportsd. Oracle Formse. Oracle Application Framework personalizationf. Oracle Workflow developmentg. Oracle Discovererh. JDeveloperi. OBIEE
04
Describe a CEMLI component (Configuration, Extension, Modification, Localization, Integration) which you custom developed and are most proud of. What were the issues and business requirements? How did your component help the business users?
05
Describe your experience with training users. Also describe your experience with mentoring/training Oracle ERP support colleagues in IT.
Required Question