San Jose

Senior Systems Applications Programmer - Police Department

Information Technology
South Bay
2/27/2018 at 11:30pm
$93,308.80-$113,464.00 Annually


201 West Mission Street San Jose, 95110


The San Jose Police Department is recruiting to fill a Senior Systems Applications Programmer position. This position is in the Systems Development Division. The Systems Development Division supports a main campus and 20 field offices, ensuring availability and reliability of their critical software/hardware systems. This position reports directly to the Department Information Technology Manager – Applications Team.


The ideal candidate will provide significant technical assistance with major computer systems which support Police operations such as: developing and maintaining programming and associated tasks for application systems, including integrated software and hardware application configurations; analyze and define business processes for application functional requirements and technical specifications; and will participate in and direct software release and installation tasks; designing and delivering meaningful business reports using business intelligence reporting tools; knowledge and experience in computer systems applications. The Senior Systems Applications Programmer will be under general supervision, and may provide specific guidance to others on complex assignments. This position requires excellent command of verbal and written communications skills.


Specific duties include but are not limited to:


Understanding and experience using enterprise relational DBMS such as: Oracle, Microsoft SQL Server, IBM's Informix or other similar platforms.


Understanding of software application development including Web development environment and the understanding of industry Object Oriented Design (OOD) methods and practices. Demonstrate experience maintaining and/or performing maintenance of existing software applications.


Understanding complex database concepts as well as the implications of different database designs on future report generation.


Preparing and supervising preparation of testing of new or updated programs.


Supervising and training front-line staff.


Maintaining systems software and trains others on new software releases and upgrades.


This recruitment may be used to fill multiple positions in this, or other divisions or departments. If you are interested in employment in this classification, you should apply to ensure you are considered for additional opportunities that may utilize the applicants from this recruitment.


Ideal Candidate

Education: A Baccalaureate Degree from an accredited college or university in Business Administration, Public Administration, Computer Technology, or a closely related field.


Experience: Three (3) years of increasingly progressive experience in computer systems applications programming.


Acceptable Substitutions: Additional years of directly related work experience may be substituted for up to a maximum of two years of the educational requirement on a year-for-year basis.


Licenses or Certificates: Possession of a valid California driver’s license.


Background: Submit to and successfully pass a comprehensive background investigation as required by the San Jose Police Department.


Employment Eligibility: Federal law requires all employees to provide verification of their eligibility to work in this country. Please be informed that the City of San Jose will NOT sponsor, represent, or sign any documents related to visa applications/transfers for H1-B or any other type of visa which requires an employer application.





The ideal candidate will possess the following competencies, as demonstrated in past and current employment history. Desirable competencies for this position include:


Job Expertise – Demonstrates knowledge of and experience with applicable professional/technical principles and practices, Citywide and departmental procedures/policies and federal and state rules and regulations. Demonstrates knowledge and experience of structured SQL, textual or graphic report writing applications such as Crystal Reports and/or similar reporting and analytical tools.


Teamwork & Interpersonal Skills - Develops effective relationships with co-workers and supervisors by helping others accomplish tasks and using collaboration and conflict resolution skills.

Technology Use/Management – Uses efficient and cost-effective approaches to integrate technology into the workplace and improve program effectiveness.


Project Management - Ensures support for projects and implements agency goals and strategic objectives.


Planning – Acts to align own unit's goals with the strategic direction of the organization; defines tasks and milestones to achieve objectives, while ensuring the optimal use of resources to meet those objectives.


Customer Service – Demonstrates the ability to anticipate customers' needs and deliver services effectively and efficiently using professional demeanor.


Communication Skills - Effectively conveys information and expresses thoughts and facts clearly, orally and in writing; demonstrates effective use of listening skills; displays openness to other people’s ideas and thoughts.



Selection Process


The selection process will consist of an evaluation of the applicant's training and experience based on the application and responses to the Job Specific Questions. Only the candidates whose backgrounds best match the position will be invited to proceed in the selection process. Additional phases of the selection process will consist of one or more interviews, one of which may include a practical/writing exercise.



You will be prompted to answer the following job-specific questions during the online application process. Please note that there is a 4,000-character limit, including spaces, for each text response.


- Please describe your increasingly progressive experience in Computer Systems Applications Programming. Include the name of the employers and number of years of experience. Your response should be consistent with your work history.


- If you have experience in web development, please describe your experience including languages used.


- Please select your experience with the following database architectures: (Select all that apply)

      • Oracle
      • Microsoft SQL Server
      • Other enterprise DBMS system

- Please describe your experience with each of the database architectures you selected above.

- Please describe your experience using various software products to run analytical reports.

- Please describe your experience developing or creating analytical data reports using the various software products you listed above.You must answer all job-specific questions in order to be considered for this vacancy or your application will be deemed incomplete and withheld from further consideration.

If you have questions about the duties of this position, please contact Rudy Yeung at If you have questions about the selection or hiring processes, please contact Rose Lara at