Programmer Analyst II



Job Details

Programmer Analyst II
Employer

City of Costa Mesa

Salary

See Position Description

Location

CA, CA

Job Type

FULL-TIME

Job Number

0044:09/17

Department

Information Technology

Opening Date

08/29/2017

Closing Date

Continuous

Description

SALARY RANGE:
  • Current:  up to $101,580 annually (Salary Range: $75,792 - $101,580)
  • Effective 07/08/18: up to $104,364 annually (Salary Range: $77,880 - $104,364)
  • Effective 07/07/19:  up to $107,244 annually (Salary Range: $80,028 - $107,244)
 
There are currently two (2) vacancies: one (1) assigned to General Programming and one (1) assigned to Geographic Information Systems (GIS).

Under general supervision, performs work of routine difficulty in the development and modification of software application programs in support of the information processing needs of city departments; to perform both routine and complex technical and administrative tasks related to the development and operation of the system; and to perform related duties as required. Incumbents may be assigned to any of the following assignments: General Programming or Geographic Information Systems (GIS).
 
CLASS CHARACTERISTICS:
 
This position receives functional supervision from the Systems and Programming Supervisor and performs a variety of software analysis functions in support of various user department needs.  This position may receive technical direction from the Senior Programmer Analyst in completing particular assignments. This position requires knowledge of a broader range of applications programs, operating systems and division operations than the Programmer Analyst I classification.

Note:   This classification is covered by Agency Shop provisions which require that employees pay union dues or service fees as a condition of employment.  Qualified religious exemptions can be accommodated.

APPLICATION AND SELECTION PROCESS:
 
Applications must be completed and submitted on-line.  This recruitment will remain open until filled and may close without prior notice, therefore prompt application is encouraged.  
 
The first application review date will be Wednesday, September 27, 2017.
 
Candidates are requested to provide specific information regarding their education and experience as it relates to the position by completing all fields of the application.  Applications may be rejected if incomplete.  Do not include text or attached resumes, as they will not be accepted or reviewed in the application process.  Based upon the information presented on the application, a limited number of candidates who possess qualifications most pertinent to the position will be invited to participate in the selection process.  The selection process may include, but is not limited to the following components:  application review and evaluation, written examination or exercise, physical examination, practical exercise and interview evaluation.     Please notify the Human Resources Division 72 hours in advance of the test date if you have a disability which requires accommodation for the testing process.  The eligibility list will be in effect for one (1) year, unless exhausted sooner.   The eligibility list established from this recruitment may be utilized to fill lower-level vacancies which occur during the life of the list.
 
It is recommended you use a personal email address on your application instead of a work email address.   Notifications during this recruitment will be sent by email only (regardless of the notification preference selected during the on-line application process).  Notifications will be sent to the email address that is listed on your on-line application. 
 
All employment offers made by the City are contingent upon establishing proof of a prospective candidate's legal authorization to work in the United States and successfully passing all components of the pre-employment process which may include, but is not limited to:  comprehensive background check, criminal history check (livescan fingerprint check), polygraph examination, post-offer psychological evaluation and post-offer medical evaluation (may include drug screen).
 
Note:  The provisions of this job bulletin do not constitute an expressed or implied contract.  Any provisions contained within may be modified or revoked without notice.

Essential Functions

These functions may not be present in all positions in this class. When a position is to be filled, the essential functions will be noted in the announcement of position availability. Management reserves the right to add, modify, change or rescind work assignments as needed.
 
Provide technical support and guidance to City departments by analyzing user requirements for modifications to existing computer programs and requests for new programs.
 
Research and adopt methods to install new or improve existing software applications.
 
Meet with various department representatives to define specific procedures and activities that can be converted to computer applications programs; answer related questions concerning the feasibility and impact of proposed changes.
 
Establish reasons for application failures and errors, including user errors or application errors.
 
Analyze, debug and document software applications problems.
 
Apply appropriate fixes and upgrades in test mode; check for proper operation before applying software to production environment.
 
Conduct training sessions in computer applications for end users.
 
Perform related duties as required.

When assigned to General Programming:
 
Create and update processes, programs, and reports to resolve problems such as new application designs, scripts, data tables, formulas, documents, security features and test operations.
 
Provide technical support and guidance to City departments in relational database design, connectivity, access and quality assurance.
 
Create and execute SQL queries and/or Crystal reports.
 
Assist users in learning new software and potential department applications.
 
Responsible for other systems and data such as web application development.
 
When assigned to Geographic Information Systems (GIS):
 
Provide technical support and guidance to City departments in GIS database design, connectivity, access and quality assurance.
 
Conduct GIS queries and analyze departmental data sources to develop decision-making tools critical to departmental and divisional needs.
 
Perform routine data management tasks such as data validation, correction, queries and editing in GIS.
 
Collect and research a variety of data (field studies, records reviews, statistical analysis, etc.).
 
Create and maintain GIS data sources and related applications.

Qualification Guidelines

A typical way to obtain the requisite knowledge and abilities to perform the duties and responsibilities of this classification is as follows:
 
EDUCATION, TRAINING AND/OR EXPERIENCE:
 
Equivalent to graduation from an accredited four-year college or university with a major course work in management information systems, computer science or a related field.
 
Three or more years of progressively responsible experience in computer programming and/or geographic information systems.
  
LICENSE AND/OR CERTIFICATE:
 
Possession of a valid California Driver's License.  Revocation of license during employment may result in disciplinary action or reassignment.
 
REQUISITE KNOWLEDGE AND SKILL LEVELS:
 
Knowledge of the principles and practices of computer science, computer programming languages, and processing principles.
 
Knowledge of relational or GIS database concepts, methodology, design and administration.
 
Knowledge of cross-platform computer solutions and software connectivity issues.
 
Knowledge of business processes and workflow.
 
Knowledge of data conversion methodologies.
 
When assigned to General Programming:
 
Knowledge of modern software development.
 
Knowledge of accounting, human resources, permitting and specialized database application programs.
 
Knowledge of programming languages including JavaScript, .Net and Java Language.
 
Knowledge of web application development software including Microsoft.Net framework.
 
When assigned to Geographic Information Systems (GIS):
 
Knowledge of Geographic Information Systems concepts.
 
Knowledge of GIS software including ESRI ArcGIS suite of products.
 
Knowledge of scripting languages including JavaScript, Python, Visual Basic and Arc Macro Language.
 
Knowledge of web application development software including ESRI ArcGIS Server API and ESRI Web AppBuilder.
 
REQUISITE ABILITIES:
 
Ability to organize and complete work independently and in accordance with established deadlines.
 
Ability to independently analyze and solve a variety of complex computer software application and database utilization problems.
 
Ability to communicate effectively both orally and in writing.
 
Ability to establish and maintain cooperative working relationships with management, supervisors, co-workers, and other departmental representatives.

Supplemental Information

PHYSICAL TASKS AND ENVIRONMENTAL CONDITIONS:

Please contact human resources for a summary of the essential tasks and environmental factors for this classification.

Employee accommodations for physical or mental disabilities will be considered on a case-by-case basis.

To view benefit information for all groups, Click Here

New Full-Time employees contribute the following amounts  on a pre-tax basis towards the 2%@60 or 2%@62 CalPERS retirement formula depending on eligibility:

  • Effective March 19, 2017:  14% of their salary
  • Effective July 9, 2017:  13% of their salary
  • Effective July 8, 2018:  12% of their salary
Full-Time employees receive the following health insurance flexible benefits contribution:
  • Effective March 19, 2017:  $1,100 monthly
  • Effective July 9, 2017:  $1,200 monthly
  • Effective July 8, 2018:  $1,300 monthly
  • Effective July 7, 2019:  $1,400 monthly
New Part-Time employees are appointed by and serve at the will of the Department Director. They are reviewed for merit salary advancement on a periodic basis. Generally, part-time employees are limited to no more than 1,000 hours of work per fiscal year (July 1 – June 30). Certain part-time employees, however, are permitted to exceed this limit. Part-time employees participate in either the Public Agency Retirement System (PARS) or the California Public Employees Retirement System (CalPERS) depending on eligibility. Employees enrolled in PARS contribute 3.75% of salary with a matching City contribution. Employees enrolled in CalPERS contribute 6.75% - 10.469% of salary depending on eligibility.  Part-time positions are eligible to receive general leave benefits. General leave can be used for sick, vacation, or holiday time.
 
The City does not participate in the Social Security system; however, federal mandate requires all new employees to contribute 1.45% of wages to Medicare.  As a condition of employment, all new employees are required to enroll and participate in the direct deposit program.

01
I understand that an incomplete application may lead to disqualification from the recruitment process and I have supplied all the applicable information in my application. Examples of incomplete/inaccurate information leading to disqualification include, but are not limited to: noting incorrect department, leaving dates of employment blank, leaving reason for leaving employment blank, leaving duties blank or noting "see resume", etc.
  • Agree
  • Disagree
02
If you are successful in completing the testing process, you may be selected to continue in the background process which includes a comprehensive investigation, fingerprinting, polygraph examination and credit check. Recent drug usage, theft, or other illegal activity may disqualify you. Record must be free from any felony conviction and/or any misdemeanor conviction involving moral turpitude and excessive traffic violations. I understand this requirement.
  • Agree
  • Disagree
03
Have you graduated from a four-year college or university with a major in Computer Science, Information Systems, Geographic Information System, Software Engineering or a related field?
  • Yes
  • No
04
Please specify what degree you possess and what was your major course of study? If none, indicate "N/A".
05
Do you have experience working for a public agency?
  • Yes
  • No
06
Please list the employers where you obtained the experience you indicated above. Include the name of your employer, job title, and dates of employment. If not applicable, indicate "N/A".
07
How many years of progressively responsible experience in information systems, computer programming, computer analysis, or geographic information systems do you have?
  • None
  • Less than 1 year
  • More than 1 year but less than 2 years
  • More than 2 years but less than 3 years
  • More then 3 years
08
Please indicate which of the following frameworks and languages you have experience working with:
  • Arc Macro
  • ASP.NET
  • C#
  • CSS
  • HTML
  • JavaScript
  • PHP
  • Python
  • SQL
  • Visual Basic
  • XML
09
Please describe your experience with debugging, performance profiling and optimization. If you do not have experience, indicate "N/A".
10
Please describe your experience with HTML 5, CSS 3.0, JavaScript (e.g. AngularJS), C#, ASP.NET, and MVC. If you do not have experience, indicate "N/A".
11
Please describe your experience working with ESRI ArcGIS suite of products. If you do not have experience, indicate "N/A".
12
Please describe your experience working with ESRI ArcGIS Server API, ESRI Web AppBuilder, ArcGIS Server Manager, GeoDatabase and Map services. If you do not have experience, indicate "N/A".
13
Please describe your experience working with relational database administration concepts, methodology, design and administration. If you do not have experience, indicate "N/A".

* Required Question

Employer
City of Costa Mesa
Address
77 Fair Drive
Post Office Box 1200
Costa Mesa, California, 92626
Phone
(714) 754-5350

Apply

OnlineApplication

Warning! You are using Internet Explorer 8. Some features of the Online Application are not fully supported in this version. Please upgrade to a later version of Internet Explorer for optimal performance.

Loading ...