Programmer Analyst II

  • City of Costa Mesa, CA
  • Costa Mesa, California
  • Nov 28, 2021
Full Time Administrative Analysis and Research Information Technology and Communication Services
  • Salary: See Position Description USD

Job Description


SALARY: Up to $118,236 annually(salary range: $88,224 - $118,236)

*Effective July 2022: 2% Salary Increase will be applied

There are currently 2 (two) full-time vacancies assigned to General Programming.


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) and related programming.


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.


Applications will be reviewed on a weekly basis until all vacancies are filled.

Applications must be completed and submitted online. This recruitment will remain open until filled and may close without prior notice, therefore prompt application is encouraged.

Candidates are required 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 online application process). Notifications will be sent to the email address that is listed on your online 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 (Live Scan 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.

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.

Coordinate, administer, maintain, and support the City's Geographic Information System (GIS) and other systems, as assigned; related hardware and software including research and adopt methods to install new or improve existing software applications; configure and maintain the City's GIS database, application, web servers, and web enabled GIS applications.

Create and maintain multiple GIS layers including parcels, streets, right-of-way, zoning and other development layers, and Police Department Computer Aid Dispatch (CAD) system layers.

Develop, design, plan, and implement various GIS projects including integration with other City systems and data sources.

Develop, test, prepare reports, and implement quality assurance (QA) and quality control (QC) processes; perform routine data management tasks, data validation and correction, queries and editing in GIS to ensure data accuracy, integrity, and completeness. Analyze, debug and document software applications problems.

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.

Perform a variety of GIS tasks and activities including data input and map generation.

Qualification Guidelines

A typical way to obtain the requisite knowledge and abilities to perform the duties and responsibilities of this classification is as follows:


Graduation from an accredited four-year college or university with major course work in management information systems, computer science, mathematics, geography or a related field.

Three or more years of progressively responsible experience in computer programming and/or geographic information systems.


Possession of a valid California Driver's License Class C. Revocation of license during employment may result in disciplinary action or reassignment.


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 GIS software including ESRI ArcGIS suite of products.

Knowledge of ArcGIS Server databases and system management;

Knowledge of ArcGIS Online application building, sharing and securing;

Knowledge of Relational Database Management Systems (RDBMS) such as Microsoft SQL Server, database and geodatabase principles and design, transact-SQL scripting, and database management and analysis techniques.

Knowledge of web application development software including ESRI ArcGIS Server API and ESRI Web AppBuilder.

Knowledge of scripting languages including Python, Visual Basic, HTML and Javascript.

Knowledge of land-based management systems including permitting, licensing, and other development processes. Tyler EnerGov experience preferred.

Knowledge of development report specifications and generating reports.

Knowledge of system integrations such as GIS, Bluebeam, LaserFiche and Sharepoint.

Knowledge of data conversions.


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


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 July 8, 2018: 12% of their salary

Full-Time employeesreceive the following health insurance flexible benefits contribution:
  • Effective July 7, 2019: $1,400 monthly
  • Effective June 2022: $1,500 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 7.50% - 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.

Closing Date/Time: Continuous

Special Instructions


Job Address

Costa Mesa, California United States View Map