Systems Applications Programmer II - Police Department

The San José Police Department is dedicated to providing public safety through community partnerships and 21st Century Policing practices, ensuring equity for all. The Department is committed to treating all of San Jose's diverse community members with dignity, fairness, and respect, while protecting their rights and providing equal protection under the law.The San Jose Police Department requires data and communications resources to be functioning twenty-four hours per day, seven days a week, 365 days per year.  The Police Department has the largest network in the City of San Jose.  The Police Department includes 21 remote sites.  The Local Area Network (LAN) provides technical support to over 1000 desktop computers, 450 Mobile Data computers, and over 80 Application and Data servers. The department's main network is currently using Microsoft Active Directory.

This position, working under the supervision of the Information Systems Analyst in Application team of Systems Development Division and will provide application systems solutions and support users at San Jose Police Department and will be responsible for the following functions:

• Continue support of several critical systems including the CAD, RMS/AFR and other applications. This may include the enhancement of these systems.

• Provide programming, scripting, coding / technical level support for the RMS/AFR, CAD,  and other applications

• Perform regular RMS/AFR systems audits

• Develop, create and deliver trainings relative to each Unit's needs on the RMS/AFR systems.

• Compiles and export the systems' data to include analysis and preparation of reports for management as requested.

• User support through phone, email, walk-in and Helpdesk ticketing system.

• Follow through issues on CAD, RMS/AFR, and other Department applications with stakeholders and vendors.

• Support SaaS applications by collaborating with users and vendors.

• Implementation of deployment of new application releases

• Development of Police department specific tools and applications tools as appropriate to improve business processes and procedures.

• 24X7 environment on-call expectation to CAD and RMS/AFR.

In addition to the Citywide SAP skills requirements the following technical skills will be essential:

• Microsoft SQL Server

• Oracle SQL Plus/SQL Developer

• Visual Studios

• SharePoint, 

• Microsoft Teams

• Azure

• JavaScript

• HTML/XML

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.

Training and Experience

Any combination of training and experience equivalent to successful completion of advanced undergraduate course work from an accredited college or university in computer science, business administration or related field and two (2) years of computer systems applications programming experience.

Background: Submit to a personal background investigation as required by the Police Department.

Competencies

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. Possession of Microsoft Certified Professional Certification.

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.

Computer Skills

• Experienced with common business computer applications including but not limited to: Microsoft SQL Server, Oracle SQL Plus, Visual Studios, SharePoint MS Teams , Azure, Javascript, and HTML/XML.

Decision Making

• Identifies and understands issues, problems, and opportunities; uses effective approaches for choosing a course of action or developing appropriate solutions.

Problem Solving

• Approaches a situation or problem by defining the problem or issue; determines the significance of problem; collects information; uses logic and intuition to arrive at decisions or solutions to problems that achieve the desired outcome.

Team Work and Interpersonal Skills

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

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, and a background investigation.

Please describe your computer-related experience such as programming, scripting, coding, technical troubleshooting, application support, or other computer-related duties in CAD and RMS.

Please list the certifications you hold as well as the year received for each.

Please describe your experience working with CAD, RMS, SharePoint, Azure, and SaaS in Windows environment.

Please describe your experience working in a Helpdesk and Application Support environment.

Please describe your experience with Microsoft SQL and Oracle SQL Plus

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 rudy.yeung@sanjoseca.gov.

If you have questions about the selection or hiring processes, please contact Alexandra Rodriguez at Alexandra.Rodriguez@sanjoseca.gov