City of San Luis Obispo, CA
System Application Specialist I-II - Oracle
City of San Luis Obispo, CA, San Luis Obispo, California, us, 93403
Salary :
$84,240.00 - $114,790.00 Annually
Location :
City of San Luis Obispo, CA
Job Type:
Regular Full Time
Department:
Information Services
Opening Date:
10/31/2024
Closing Date:
11/18/2024 5:00 PM Pacific
FLSA:
Non-Exempt
JOB DESCRIPTION
The City of San Luis Obispo Information Technology Department has an opening for a System Application Specialist I-II.
The level of responsibility and salary will be based on qualifications of the applicant (see Education and Experience below).
This recruitment will establish an eligibility list for the Oracle specialty area.
If you are selected for interviews, they will take place in-person on Tuesday, December 10, 2024, so please hold that date.
If selected to move forward, second round interviews will be held in-person, tentatively on Friday, December 13, 2024.
Hiring incentives are not guaranteed but may be valued up to $2,500 for positions deemed hard to fill by the Director of Human Resources.
JOB SUMMARY
:Performs a variety of application configuration and acts as liaison between the City and the application provider(s); incorporates business process changes; provides leadership and training for users; integrates identified cross-functional efficiencies, and emphasizes problem-solving and effective communication, and efficient service to the public and the City; supports system upgrade and release management; provides support to Subject Matter Experts and Super Users. Incumbents may be assigned to focus on one or more system applications, such as finance and human resources, asset management, geographic information system, and license and permit processing; however, they may also be cross-trained to assist with other applications.
CLASS CHARACTERISTICS:This classification requires the skill and ability to implement, configure, program, and maintain the System. This class is distinguished from the higher-level class of Information Services Supervisor in that the latter directly supervises professional and technical staff and manages all backend data management, data analytics, benchmarking, and visualization solutions across the organization.SUPERVISION
SUPERVISION RECEIVED AND EXERCISED
:Receives general supervision from the Information Services Supervisor. May provide technical and function direction to lower-level and less-experienced staff.EXAMPLES OF DUTIES
EXAMPLES OF DUTIES AND RESPONSIBILITIES:(Any one position may not include all of the duties listed nor do the listed examples include all tasks that may be found in positions of the class. Some duties may be performed in a learning capacity for entry-level positions.)Provides application and business expertise to support end users across all departments.Gathers requirements and gain first-hand understanding of user needs.Interprets business process changes and develops specifications for software and configuration modifications.Serves as the technical lead for projects assigned by the Information Services Supervisor. This can include project management and contract management.Coordinates with vendors and leads acceptance testing.Troubleshoots technical issues and manages technical support with the application's parent company.Conducts research regarding software system connections and communications.Documents work processes, configurations, and prepares training materials.Conducts departmental and citywide application-related training.Provides recommendations to maintain compatibility of data and user needs.Develops standards for configuration and business processes, including custom-field layouts and case-type configuration.Ensures data conversion requirements are met.Assists with efforts to integrate data and work processes across City systems.Performs day-to-day application administration tasks.In coordination with the application's parent company technical support, supports ongoing release management, testing, and implementation tasks.Analyzes workflows, prepares recommendations, and identifies testing and training needs for implementing improvements for ongoing releases.Integrates knowledge of operational processes, end-user needs and larger organizational needs, general database concepts, and other City software systems.Analyzes, diagnoses, and resolves complex software issues.Makes configuration corrections as required and communicates the changes to the system navigation to the subject matter experts, super users, and other City staff.Serves as a "just in time" higher-tier resource for application incident resolution requests.Engages third-party resources for resolving highly impactful application problem management issues in conjunction with the application's parent company technical support. Provides leadership and training for the application.Performs related duties as required by management to meet the needs of the City.In addition to the above, a System Application Specialist assigned to EnerGov will be required to:
Create and modify custom reports using SQL Server Reporting Services andMS PowerBI.Participate in initiatives to continuously improve the City's interface with the public.Provide reporting and data analysis.In addition to the above, a System
Application Specialist assigned to Oracle will be required to:Create and modify custom reports using Oracle BI and Oracle BI PublisherKeep abreast of enhancements and new functionality released by Oracle (in context of the product licenses to which the City subscribes) and actively identify their application to City business and process requirements.In addition to the above, a System Application Specialist assigned to Geographic Information Systems (GIS) will be required to:
Create, maintain, analyze, and display spatial data.Develop scope of work for Citywide or departmental GIS application projects.Develop innovative solutions using GIS technology for complex business problems.Design and build browser-based interactive mapping applications.Train other staff in the use of GIS.KNOWLEDGE AND ABILITIES
:Knowledge of:Principles and business practices of computer systems, relational databases, and enterprise financial applications.Basic theories and applications of computer science.Operation, maintenance, and troubleshooting of computer systems and applications.Information-based software systems.Data Model principles.Data integration and analytics methodologies and technologies.Report authoring software (e.g., Crystal Reports, SQL Server Reporting Services, BI Publisher).Principles and practices of project management.Microsoft Office Suite Programs (Word, Excel, PowerPoint, SharePoint).In addition to the above, a
System Application Specialist assigned to EnerGov will be required to have knowledge of:Fundamental concepts of GIS and basic skills using ArcGIS applications (ArcGIS Pro/ArcGIS Server).Basic or working understanding of development review principles and community development processes.In addition to the above, a System Application Specialist assigned to Oracle will be required to have knowledge of:Principles of segregation of duties and securityBasic or working knowledge of at least one of the following:
Core financial accounting principles (general ledger, accounts payable, accounts receivable, fixed assets, cash management)Core purchasing principles (procure to pay, contracts, supplier management)Core human resources principles (employee master data administration, actions, position control, employee development tools)Core payroll and time principles (time keeping, scheduling, absences, payroll processing)
In addition to the above, a System Application Specialist assigned to Geographic Information System (GIS) will be required to have knowledge of:Geographic Information System (GIS) concepts and practices.ArcGIS enterprise geodatabase, server, and online management.Principles of cartography, survey, and mapping.Basic methods and equipment used for data acquisition with Global Positioning Systems.Principles and techniques required to convert manually-created maps and drawings into GIS format.Concepts and techniques of spatial analysis in GISAbility to
:Problem solve and resolve conflict.Translate business requirements and needs to application solutions and configuration.Analyze and recommend business solutions to meet technology needs.Respond to and identify user needs and determine resolutions.Prepare clear, concise and accurate reports and recommendations, including investigation results, work programs, and other related items.Meet the expectations and requirements of internal and external customers; get first-hand customer information and use it for improvements in products and services; act with customers in mind; establish and maintain effective relationships with customers and gain their trust and respect.Lead, coach, instruct and motivate employees, and foster a team work environment.Communicate clearly and concisely, both orally and in writing.Configure and support applications and systems.Ability to identify, evaluate, and solve application processes and technical problems to maintain system availability and performance.Work effectively with others in a team-oriented environment, including the ability to convey complex or technical information to others.Attend application technical training as well as other meetings as assigned.Work under deadlines and manage multiple tasks with limited supervision.Work independently with minimal supervision, to assume responsibility, to prioritize and resolve problems, to work under pressure, to pay close attention to detail, to coordinate tasks to completion and provide quality control for responsiveness and customer satisfaction.Develop effective working relationships with all city staff members who are Subject Matter Experts (SMEs) that maximize the benefits of diverse perspectives.Use standard office equipment.TYPICAL QUALIFICATIONS
SYSTEM APPLICATION SPECIALIST I - EDUCATION AND EXPERIENCE
:Graduation from a four-year college or university with major coursework in information technology, management information systems, computer science, or a related field;andOne year of experience with an information-based software system, including databases;orAn equivalent combination of education and experience.
SYSTEM APPLICATION SPECIALIST II - EDUCATION AND EXPERIENCE
:Graduation from a four-year college or university with major coursework in information technology, management information systems, computer science, or a related field;and
Three years of experience with an information-based software system, including databases;orAn equivalent combination of education and experience.
POSSESSION AND MAINTENANCE OF:
A valid California class C driver's license and a satisfactory driving record.THIS POSITION WILL BE REQUIRED TO COMPLETE THE FOLLOWING BEFORE A FINAL OFFER IS MADE:
Police Background InvestigationLive Scan Fingerprinting (DOJ & FBI)
For a detailed spreadsheet of employee benefits by bargaining group, please view our
Retirement:
California Public Employee's Retirement System (PERS). The City participates only in the medicare portion of Social Security.
Health:
the City has a cafeteria plan for health, dental and vision insurance and contributes towards medical insurance. Employees may choose from several health insurance options. There are also two dental plans to choose from. See the Benefits Summary link to determine the contribution amount.
Life and Accidental Death and Dismemberment (AD&D) Insurance:
group term life and AD&D insurance is provided for all regular employees. The amount of coverage varies depending on the classification. Employees may purchase additional life and AD&D insurance for themselves and their dependents.
Vacation:
employees receive 12 days per year increasing to 20 days after 20 years.
Holidays:
employees receive 12-13 days per year depending on the classification.
Sick Leave:
employees receive 12 days per year.
Administrative Leave:
is a benefit available to management employees. The number of administrative leave hours varies depending on the classification.
Flexible Work Schedule:
is available to many positions within the City organization.
Long Term Disability Insurance:
is available for regular employees. The amount of benefit and contribution by employee varies by classification.
Deferred Compensation:
is available for employees to set aside a portion of their salary on a pre-tax basis to supplement retirement.
Wellness Program:
offered to help employees gain knowledge, skills and motivation to improve the quality of their lives and well-being.
Employee Assistance Program:
a counseling and consultation service designed to help employees and eligible family members with a wide range of personal issues.
Flexible Benefits Program:
available to help employees save taxes on: (1) Pre-tax health insurance premium deductions, (2) Unreimbursed/ uncovered medical expenses, and (3) Dependent care expenses.
Tuition Reimbursement:
up to $1500 annually for job-related educational costs is available to employees who have passed probation.
Trip Reduction Incentive Program (TRIP):
incentives are available for employees who voluntarily participate in alternative forms of transportation to and from work.
Computer Purchase Program:
interest-free loans to employees who have passed probation and who purchase computers for personal use with City approved software configuration.
Professional Association for City Employees
(PACE):
voluntary organization for professional development training classes, monthly membership meetings with a variety of speakers, and social functions designed to facilitate interaction with employees from all departments in a relaxed setting away from work.
01
Which of the following best describes your highest level of education?
Master's degree or higherBachelor's degreeAssociate's degree or vocational equivalentSome collegeHigh School/G.E.D.None of the above
02
Did you major in one of the following fields?
Information TechnologyComputer ScienceManagement Information SystemsOther Field - RelatedOther Field - UnrelatedN/A - Did not attend college
03
If you answered "Other Field - Related" or "Other Field - Unrelated" to the previous question, please explain. Otherwise, please put "N/A".
04
How many years of professional experiences do you have with an information-based software system?
8 years or more7 years to 7 years 11 months6 years to 6 years 11 months5 years to 5 years 11 months4 years to 4 years 11 months3 years to 3 years 11 months2 years to 2 years 11 months1 year to 1 year 11 monthsLess than 1 yearNo Experience
05
Please explain your experience in detail.
06
Please list any specific experience you have with Oracle Cloud ERP products. If you do not have experience with Oracle Cloud ERP products, please put "N/A".
07
Do you possess a valid California class C driver's license and a satisfactory driving record?
YesNo
Required Question
$84,240.00 - $114,790.00 Annually
Location :
City of San Luis Obispo, CA
Job Type:
Regular Full Time
Department:
Information Services
Opening Date:
10/31/2024
Closing Date:
11/18/2024 5:00 PM Pacific
FLSA:
Non-Exempt
JOB DESCRIPTION
The City of San Luis Obispo Information Technology Department has an opening for a System Application Specialist I-II.
The level of responsibility and salary will be based on qualifications of the applicant (see Education and Experience below).
This recruitment will establish an eligibility list for the Oracle specialty area.
If you are selected for interviews, they will take place in-person on Tuesday, December 10, 2024, so please hold that date.
If selected to move forward, second round interviews will be held in-person, tentatively on Friday, December 13, 2024.
Hiring incentives are not guaranteed but may be valued up to $2,500 for positions deemed hard to fill by the Director of Human Resources.
JOB SUMMARY
:Performs a variety of application configuration and acts as liaison between the City and the application provider(s); incorporates business process changes; provides leadership and training for users; integrates identified cross-functional efficiencies, and emphasizes problem-solving and effective communication, and efficient service to the public and the City; supports system upgrade and release management; provides support to Subject Matter Experts and Super Users. Incumbents may be assigned to focus on one or more system applications, such as finance and human resources, asset management, geographic information system, and license and permit processing; however, they may also be cross-trained to assist with other applications.
CLASS CHARACTERISTICS:This classification requires the skill and ability to implement, configure, program, and maintain the System. This class is distinguished from the higher-level class of Information Services Supervisor in that the latter directly supervises professional and technical staff and manages all backend data management, data analytics, benchmarking, and visualization solutions across the organization.SUPERVISION
SUPERVISION RECEIVED AND EXERCISED
:Receives general supervision from the Information Services Supervisor. May provide technical and function direction to lower-level and less-experienced staff.EXAMPLES OF DUTIES
EXAMPLES OF DUTIES AND RESPONSIBILITIES:(Any one position may not include all of the duties listed nor do the listed examples include all tasks that may be found in positions of the class. Some duties may be performed in a learning capacity for entry-level positions.)Provides application and business expertise to support end users across all departments.Gathers requirements and gain first-hand understanding of user needs.Interprets business process changes and develops specifications for software and configuration modifications.Serves as the technical lead for projects assigned by the Information Services Supervisor. This can include project management and contract management.Coordinates with vendors and leads acceptance testing.Troubleshoots technical issues and manages technical support with the application's parent company.Conducts research regarding software system connections and communications.Documents work processes, configurations, and prepares training materials.Conducts departmental and citywide application-related training.Provides recommendations to maintain compatibility of data and user needs.Develops standards for configuration and business processes, including custom-field layouts and case-type configuration.Ensures data conversion requirements are met.Assists with efforts to integrate data and work processes across City systems.Performs day-to-day application administration tasks.In coordination with the application's parent company technical support, supports ongoing release management, testing, and implementation tasks.Analyzes workflows, prepares recommendations, and identifies testing and training needs for implementing improvements for ongoing releases.Integrates knowledge of operational processes, end-user needs and larger organizational needs, general database concepts, and other City software systems.Analyzes, diagnoses, and resolves complex software issues.Makes configuration corrections as required and communicates the changes to the system navigation to the subject matter experts, super users, and other City staff.Serves as a "just in time" higher-tier resource for application incident resolution requests.Engages third-party resources for resolving highly impactful application problem management issues in conjunction with the application's parent company technical support. Provides leadership and training for the application.Performs related duties as required by management to meet the needs of the City.In addition to the above, a System Application Specialist assigned to EnerGov will be required to:
Create and modify custom reports using SQL Server Reporting Services andMS PowerBI.Participate in initiatives to continuously improve the City's interface with the public.Provide reporting and data analysis.In addition to the above, a System
Application Specialist assigned to Oracle will be required to:Create and modify custom reports using Oracle BI and Oracle BI PublisherKeep abreast of enhancements and new functionality released by Oracle (in context of the product licenses to which the City subscribes) and actively identify their application to City business and process requirements.In addition to the above, a System Application Specialist assigned to Geographic Information Systems (GIS) will be required to:
Create, maintain, analyze, and display spatial data.Develop scope of work for Citywide or departmental GIS application projects.Develop innovative solutions using GIS technology for complex business problems.Design and build browser-based interactive mapping applications.Train other staff in the use of GIS.KNOWLEDGE AND ABILITIES
:Knowledge of:Principles and business practices of computer systems, relational databases, and enterprise financial applications.Basic theories and applications of computer science.Operation, maintenance, and troubleshooting of computer systems and applications.Information-based software systems.Data Model principles.Data integration and analytics methodologies and technologies.Report authoring software (e.g., Crystal Reports, SQL Server Reporting Services, BI Publisher).Principles and practices of project management.Microsoft Office Suite Programs (Word, Excel, PowerPoint, SharePoint).In addition to the above, a
System Application Specialist assigned to EnerGov will be required to have knowledge of:Fundamental concepts of GIS and basic skills using ArcGIS applications (ArcGIS Pro/ArcGIS Server).Basic or working understanding of development review principles and community development processes.In addition to the above, a System Application Specialist assigned to Oracle will be required to have knowledge of:Principles of segregation of duties and securityBasic or working knowledge of at least one of the following:
Core financial accounting principles (general ledger, accounts payable, accounts receivable, fixed assets, cash management)Core purchasing principles (procure to pay, contracts, supplier management)Core human resources principles (employee master data administration, actions, position control, employee development tools)Core payroll and time principles (time keeping, scheduling, absences, payroll processing)
In addition to the above, a System Application Specialist assigned to Geographic Information System (GIS) will be required to have knowledge of:Geographic Information System (GIS) concepts and practices.ArcGIS enterprise geodatabase, server, and online management.Principles of cartography, survey, and mapping.Basic methods and equipment used for data acquisition with Global Positioning Systems.Principles and techniques required to convert manually-created maps and drawings into GIS format.Concepts and techniques of spatial analysis in GISAbility to
:Problem solve and resolve conflict.Translate business requirements and needs to application solutions and configuration.Analyze and recommend business solutions to meet technology needs.Respond to and identify user needs and determine resolutions.Prepare clear, concise and accurate reports and recommendations, including investigation results, work programs, and other related items.Meet the expectations and requirements of internal and external customers; get first-hand customer information and use it for improvements in products and services; act with customers in mind; establish and maintain effective relationships with customers and gain their trust and respect.Lead, coach, instruct and motivate employees, and foster a team work environment.Communicate clearly and concisely, both orally and in writing.Configure and support applications and systems.Ability to identify, evaluate, and solve application processes and technical problems to maintain system availability and performance.Work effectively with others in a team-oriented environment, including the ability to convey complex or technical information to others.Attend application technical training as well as other meetings as assigned.Work under deadlines and manage multiple tasks with limited supervision.Work independently with minimal supervision, to assume responsibility, to prioritize and resolve problems, to work under pressure, to pay close attention to detail, to coordinate tasks to completion and provide quality control for responsiveness and customer satisfaction.Develop effective working relationships with all city staff members who are Subject Matter Experts (SMEs) that maximize the benefits of diverse perspectives.Use standard office equipment.TYPICAL QUALIFICATIONS
SYSTEM APPLICATION SPECIALIST I - EDUCATION AND EXPERIENCE
:Graduation from a four-year college or university with major coursework in information technology, management information systems, computer science, or a related field;andOne year of experience with an information-based software system, including databases;orAn equivalent combination of education and experience.
SYSTEM APPLICATION SPECIALIST II - EDUCATION AND EXPERIENCE
:Graduation from a four-year college or university with major coursework in information technology, management information systems, computer science, or a related field;and
Three years of experience with an information-based software system, including databases;orAn equivalent combination of education and experience.
POSSESSION AND MAINTENANCE OF:
A valid California class C driver's license and a satisfactory driving record.THIS POSITION WILL BE REQUIRED TO COMPLETE THE FOLLOWING BEFORE A FINAL OFFER IS MADE:
Police Background InvestigationLive Scan Fingerprinting (DOJ & FBI)
For a detailed spreadsheet of employee benefits by bargaining group, please view our
Retirement:
California Public Employee's Retirement System (PERS). The City participates only in the medicare portion of Social Security.
Health:
the City has a cafeteria plan for health, dental and vision insurance and contributes towards medical insurance. Employees may choose from several health insurance options. There are also two dental plans to choose from. See the Benefits Summary link to determine the contribution amount.
Life and Accidental Death and Dismemberment (AD&D) Insurance:
group term life and AD&D insurance is provided for all regular employees. The amount of coverage varies depending on the classification. Employees may purchase additional life and AD&D insurance for themselves and their dependents.
Vacation:
employees receive 12 days per year increasing to 20 days after 20 years.
Holidays:
employees receive 12-13 days per year depending on the classification.
Sick Leave:
employees receive 12 days per year.
Administrative Leave:
is a benefit available to management employees. The number of administrative leave hours varies depending on the classification.
Flexible Work Schedule:
is available to many positions within the City organization.
Long Term Disability Insurance:
is available for regular employees. The amount of benefit and contribution by employee varies by classification.
Deferred Compensation:
is available for employees to set aside a portion of their salary on a pre-tax basis to supplement retirement.
Wellness Program:
offered to help employees gain knowledge, skills and motivation to improve the quality of their lives and well-being.
Employee Assistance Program:
a counseling and consultation service designed to help employees and eligible family members with a wide range of personal issues.
Flexible Benefits Program:
available to help employees save taxes on: (1) Pre-tax health insurance premium deductions, (2) Unreimbursed/ uncovered medical expenses, and (3) Dependent care expenses.
Tuition Reimbursement:
up to $1500 annually for job-related educational costs is available to employees who have passed probation.
Trip Reduction Incentive Program (TRIP):
incentives are available for employees who voluntarily participate in alternative forms of transportation to and from work.
Computer Purchase Program:
interest-free loans to employees who have passed probation and who purchase computers for personal use with City approved software configuration.
Professional Association for City Employees
(PACE):
voluntary organization for professional development training classes, monthly membership meetings with a variety of speakers, and social functions designed to facilitate interaction with employees from all departments in a relaxed setting away from work.
01
Which of the following best describes your highest level of education?
Master's degree or higherBachelor's degreeAssociate's degree or vocational equivalentSome collegeHigh School/G.E.D.None of the above
02
Did you major in one of the following fields?
Information TechnologyComputer ScienceManagement Information SystemsOther Field - RelatedOther Field - UnrelatedN/A - Did not attend college
03
If you answered "Other Field - Related" or "Other Field - Unrelated" to the previous question, please explain. Otherwise, please put "N/A".
04
How many years of professional experiences do you have with an information-based software system?
8 years or more7 years to 7 years 11 months6 years to 6 years 11 months5 years to 5 years 11 months4 years to 4 years 11 months3 years to 3 years 11 months2 years to 2 years 11 months1 year to 1 year 11 monthsLess than 1 yearNo Experience
05
Please explain your experience in detail.
06
Please list any specific experience you have with Oracle Cloud ERP products. If you do not have experience with Oracle Cloud ERP products, please put "N/A".
07
Do you possess a valid California class C driver's license and a satisfactory driving record?
YesNo
Required Question