Systems Applications Programmer II

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 Jos Police Department relies on mission-critical technology systems that operate 24 hours a day, 7 days a week, 365 days a year to support public safety operations. The Department maintains one of the largest and most complex technology environments within the City of San Jos, including 21 remote facilities, more than 1,000 desktop workstations, approximately 450 Mobile Data Computers (MDCs), and over 80 application and database servers operating within a Microsoft Active Directory environment.

Under the direction of the Information Systems Analyst within the Systems Development Division's Applications Team, the Systems Applications Programmer II will provide technical support, application development, systems integration, and operational support for critical public safety applications used by the Police Department.

The Systems Applications Programmer II will be responsible for the following functions:

• Support, maintain, and enhance mission-critical public safety systems, including Computer-Aided Dispatch (CAD), Records Management System (RMS), Automated Field Reporting (AFR), Mobile Data Computer (MDC), and other departmental applications.
• Design, develop, test, implement, and maintain software applications, interfaces, scripts, reports, and automation solutions that improve operational efficiency and business processes.
• Provide programming, scripting, coding, troubleshooting, and technical support for CAD, RMS/AFR, and other Department applications.
• Collaborate with Department personnel, business stakeholders, City departments, and software vendors to analyze business requirements, troubleshoot issues, and implement technical solutions.
• Support Software-as-a-Service (SaaS) platforms and cloud-based applications utilized by the Department.
• Perform regular system audits, quality assurance reviews, and data validation activities to ensure system integrity, accuracy, security, and compliance.
• Develop, create, and deliver user training, technical documentation, and procedural guides tailored to the operational needs of various Department units.
• Compile, analyze, extract, and report data from Department systems to support operational, administrative, and executive decision-making.
• Develop reports, dashboards, data visualizations, and business intelligence solutions utilizing reporting tools such as Power BI and SQL-based reporting platforms.
• Implement, test, and support application upgrades, patches, releases, interfaces, and new technology deployments.
• Develop and maintain Department-specific applications, tools, workflows, and integrations to improve business processes and operational effectiveness.
• Support application programming interfaces (APIs), data exchanges, and integrations between internal and external systems.
• Provide customer support through phone, email, walk-in assistance, remote support, and the Department's Help Desk ticketing system.
• Track, document, and follow through on issues involving CAD, RMS/AFR, mobile applications, and other Department systems while coordinating with vendors and stakeholders through resolution.
• Participate in project planning, testing, implementation, and support activities for technology initiatives and public safety modernization projects.
• Ensure compliance with Criminal Justice Information Services (CJIS), Department of Justice (DOJ), City, and Department technology policies and standards.
• Participate in an on-call rotation and provide after-hours support for critical public safety applications operating in a 24x7 environment., Only candidates whose backgrounds best demonstrate the knowledge, skills, and abilities required for successful performance in this role will be invited to continue in the selection process.

Additional phases of the selection process may include one or more interviews and a background investigation.

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.

Describe your experience providing application development, programming, scripting, coding, troubleshooting, and technical support for enterprise applications. Include any experience supporting Computer-Aided Dispatch (CAD), Records Management Systems (RMS), Automated Field Reporting (AFR), Mobile Data Computing (MDC), public safety systems, or other mission-critical applications. Please identify the technologies used, your specific role, and the outcomes achieved.

Please list all technical certifications you currently hold or have held, including the certification name, issuing organization, and year obtained. Examples may include Microsoft, Oracle, Azure, SQL, SharePoint, ITIL, Project Management, Security, or other technology-related certifications.

Describe your experience administering, supporting, developing, implementing, or integrating enterprise applications in a Microsoft Windows environment. Include any experience with Computer Aided Dispatch (CAD), Records Management Systems (RMS), SharePoint, Microsoft 365, Microsoft Teams, Azure, cloud-based solutions, Software-as-a-Service (SaaS) applications, workflow automation platforms (e.g., SimpliGov), and systems integration. Please identify the systems you have supported and describe your specific role, responsibilities, and level of involvement with each.

Describe your experience providing technical support in a Help Desk, Application Support, or Information Technology environment. Include the types of users supported, the applications and systems supported, the tools or ticketing systems utilized, the complexity of issues handled, and your approach to diagnosing, troubleshooting, and resolving technical problems. Please provide specific examples of challenging issues you have successfully resolved.

Describe your experience working with Microsoft SQL Server, Oracle Database, SQL*Plus, SQL Developer, or other relational database management systems. Include examples of database administration, SQL query development, report generation, data analysis, troubleshooting, data integration, data migration, or application support activities you have performed. Please describe your level of responsibility and provide specific examples of projects or tasks you have completed.

Describe your experience working in a 24x7 operational environment supporting mission-critical applications and services. Include any on-call responsibilities, incident response activities, after-hours support, and your role in diagnosing issues, coordinating response efforts, and restoring service during system outages or critical incidents. Please provide specific examples of incidents you have managed and the actions you took to resolve them.

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 Alexandria Rodriguez at, Describe your experience providing application development, programming, scripting, coding, troubleshooting, and technical support for enterprise applications. Include any experience supporting Computer-Aided Dispatch (CAD), Records Management Systems (RMS), Automated Field Reporting (AFR), Mobile Data Computing (MDC), public safety systems, or other mission-critical applications. Please identify the technologies used, your specific role, and the outcomes achieved. 05

Please list all technical certifications you currently hold or have held, including the certification name, issuing organization, and year obtained. Examples may include Microsoft, Oracle, Azure, SQL, SharePoint, ITIL, Project Management, Security, or other technology-related certifications. 06

Describe your experience administering, supporting, developing, implementing, or integrating enterprise applications in a Microsoft Windows environment. Include any experience with Computer Aided Dispatch (CAD), Records Management Systems (RMS), SharePoint, Microsoft 365, Microsoft Teams, Azure, cloud-based solutions, Software-as-a-Service (SaaS) applications, workflow automation platforms (e.g., SimpliGov), and systems integration. Please identify the systems you have supported and describe your specific role, responsibilities, and level of involvement with each.Describe your experience providing technical support in a Help Desk, Application Support, or Information Technology environment. Include the types of users supported, the applications and systems supported, the tools or ticketing systems utilized, the complexity of issues handled, and your approach to diagnosing, troubleshooting, and resolving technical problems. Please provide specific examples of challenging issues you have successfully resolved. 07

Describe your experience working with Microsoft SQL Server, Oracle Database, SQL*Plus, SQL Developer, or other relational database management systems. Include examples of database administration, SQL query development, report generation, data analysis, troubleshooting, data integration, data migration, or application support activities you have performed. Please describe your level of responsibility and provide specific examples of projects or tasks you have completed. 08

Describe your experience working in a 24x7 operational environment supporting mission-critical applications and services. Include any on-call responsibilities, incident response activities, after-hours support, and your role in diagnosing issues, coordinating response efforts, and restoring service during system outages or critical incidents. Please provide specific examples of incidents you have managed and the actions you took to resolve them. 09

In addition to the Citywide Systems Applications Programmer II competencies, successful candidates should possess experience with one or more of the following technologies:

• Microsoft SQL Server
• Oracle Database, SQL*Plus, and SQL Developer
• Microsoft Visual Studio / .NET Development
• SharePoint Online and Microsoft 365
• Microsoft Azure and Cloud Services
• SimplGov
• JavaScript
• HTML/XML
• Application development and release management

Highly Desirable Qualifications

The following experience is highly desirable:

• Supporting law enforcement, public safety, emergency communications, or criminal justice technology environments.
• Experience with CAD, RMS, AFR, Mobile Data Computing (MDC), Computer-Aided Dispatch, or other public safety applications.
• Experience working with CJIS security requirements and DOJ compliance standards.
• Experience supporting enterprise-level SaaS and cloud-based applications.
• Experience with systems integration, data conversion, API development, and vendor-supported applications.
• Experience providing technical support in a 24x7 mission-critical environment.

Ideal Candidate

The ideal candidate is a customer-focused technology professional with strong analytical, technical, and problem-solving skills. The successful candidate will possess the ability to manage multiple priorities, communicate effectively with technical and non-technical users, and deliver reliable solutions in a fast-paced public safety environment. The candidate should demonstrate initiative, accountability, attention to detail, and a commitment to providing exceptional customer service.

Additional Information

Selected candidates will be required to successfully complete an extensive background investigation and satisfy all requirements necessary to access Criminal Justice Information Services (CJIS) systems and related law enforcement technologies.

Minimum Qualifications 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: Candidates selected for this position must successfully complete a comprehensive background investigation as required by the Police Department., The ideal candidate will possess the following competencies, as demonstrated through education, training, and experience: Desirable competencies for this position include:

Job Expertise: Demonstrates knowledge of application development, systems analysis, software implementation, systems integration, database management, and enterprise application support. Possesses an understanding of industry best practices, information technology principles, security standards, and applicable federal, state, and local regulations. Experience supporting public safety, criminal justice, or mission-critical technology systems is highly desirable.

Professional certifications related to application development, database administration, cloud technologies, business intelligence, or Microsoft technologies are desirable.

Communication Skills: Communicates effectively both verbally and in writing. Prepares clear technical documentation, reports, training materials, and user communications. Demonstrates active listening skills and the ability to explain technical concepts to both technical and non-technical audiences.

Computer Skills: Experienced with common business computer applications including but not limited to: Microsoft SQL Server, Oracle SQL Plus, Visual Studios, SharePoint, SimplGov, Azure, JavaScript, HTML, XML, Web Technology, Powershell, and SaaS applications and cloud solutions.

Decision Making: Identifies issues, evaluates alternatives, and exercises sound judgment when developing solutions. Demonstrates the ability to balance operational requirements, technical considerations, security requirements, and customer needs when making decisions.

Problem Solving: Analyzes complex technical and business issues, gathers relevant information, identifies root causes, and develops effective solutions. Demonstrates initiative, creativity, and persistence in resolving problems while maintaining system reliability and service continuity.

Teamwork and Interpersonal Skills: Builds and maintains productive working relationships with colleagues, customers, vendors, and stakeholders. Collaborates effectively across organizational boundaries, supports team objectives, and demonstrates professionalism, flexibility, and respect in all interactions.

Customer Service: Provides responsive, professional, and solution-oriented support to users and stakeholders. Demonstrates a commitment to delivering high-quality service, managing customer expectations, and ensuring timely resolution of issues in a mission-critical public safety environment., * High School Diploma or the equivalent (GED)

• College (1 to 29 semester units/ 1 to 44 quarter units)
• College (30 to 59 semester units/ 45 to 89 quarter units)
• College (60 to 89 semester units/ 90 to 134 quarter units)
• College (90 to 119 semester units/ 135 to 179 quarter units)
• College (120 or more semester units/ 180 or more quarter units)
• Associate's Degree
• Bachelor's Degree
• Master's Degree
• Doctoral Degree
• Other
• None of the above

02

If you have a Bachelor's degree or higher from an accredited college or university in a related field, please state the field of study and the issuing accredited college or university. 03

How many years of experience do you have in computer systems applications programming? Please Note: One year of Full-Time experience = 2080 Hours.

• Less than two (2) years
• Two (2) years or more

During the past ten years of employment history how many times have you been involuntarily terminated, failed probation or resigned to avoid being fired?

• Zero (0)
• One (1)
• Two (2)
• Three (3)
• Four (4) or more

10

If four or more are selected for your employment history, please explain and list the dates of leaving the employer. 11

Did you ever work (even on the side) without reporting it while collecting unemployment?

• Yes
• No

12

If you answered "Yes" to the question above (Did you ever work (even on the side) without reporting it while collecting unemployment?) Please explain with the last date money was collected, and the amount that was collected in total. 13

Have you been issued any moving violations (Moving violations include: speeding, illegal U-turns, illegal lane changes, following too close.) in the last three (3) years? Do not include parking citations. If "yes", how many?

• No
• One (1)
• Two (2)
• Three (3)
• Four (4) or more

14

If four or more are selected for moving violations, please explain and list the dates of moving violations. 15

Have you been "at fault" in any traffic collisions within the last three (3) years where you were the driver? If "yes", how many? (At fault refers to you being the primary reason for the collision)

• No
• One (1)
• Two (2)
• Three (3)
• Four (4) or more

16

If four or more are selected for traffic collisions, please explain and list the dates of traffic collisions. 17

How many times have you been convicted, pleaded guilty, or pleaded no contest to a misdemeanor as an adult?

• Zero (0)
• One (1)
• Two (2)
• Three (3)
• Four (4) or more

18

If you answered anything other than ZERO to the question above (How many times have you been convicted, pleaded guilty, or pleaded no contest to a misdemeanor as an adult), please explain details, including the charge and date of conviction. 19

When was the last time you were convicted of a misdemeanor?

• Does not apply
• 0-36 months
• 37 months - 6 years
• 6 years or more

20

How many times have you been convicted, pleaded guilty, or pleaded no contest to a felony?

• Zero (0)
• One (1)
• Two (2)
• Three (3) or more

21

Have you ever been convicted of, pleaded guilty, or pleaded no contest to a domestic violence (273.5/243e PC)?

• Yes
• No

22

If you answered "YES" to the question above (Have you ever been convicted of, pleaded guilty, or pleaded no contest to a domestic violence (273.5/243e PC)), please explain. 23

Have you ever been convicted of, pleaded guilty, or pleaded no contest to assault, battery, or resisting arrest as an adult?

• Yes
• No

24

If you answered "YES" to the question above (Have you ever been convicted of, pleaded guilty, or pleaded no contest to assault, battery, or resisting arrest as an adult?), please explain. 25

Have you ever been convicted of, pleaded guilty, or pleaded no contest to forgery or embezzlement?

• Yes
• No

26

If you answered "YES" to the question above (Have you ever been convicted of, pleaded guilty, or pleaded no contest to forgery or embezzlement?), please explain. 27

Have you ever been convicted of, pleaded guilty, or pleaded no contest to arson?

• Yes
• No

28

If you answered "YES" to the question above (Have you ever been convicted of, pleaded guilty, or pleaded no contest to arson?), please explain. 29

Have you ever been convicted of, pleaded guilty, or pleaded no contest to any type of sex crime?

• Yes
• No

30

If you answered "YES" to the question above (Have you ever been convicted of, pleaded guilty, or pleaded no contest to any type of sex crime?), please explain. 31

Are you currently on court-ordered probation or parole for any offense, including traffic violations?

• Yes
• No

32

If you answered "YES" to the question above (Are you currently on court-ordered probation or parole for any offense, including traffic violations?), please explain. 33

Do you currently have any outstanding warrants for your arrest?

• Yes
• No

34

"Since the age of 18, have you ever committed theft or embezzlement for an amount totaling $950.00 or more? (This includes theft from an employer, items other than unintended supplies such as pens, pencils, etc...)"

• Yes; I have committed theft or embezzlement for an amount totaling $950.00 or more.
• No; I have never committed theft or embezzlement for an amount totaling $950.00 or more.

35

How many times have you been convicted of, pleaded guilty, or pleaded no contest to DUI in the last three years?

• None
• One (1)
• Two (2)
• Three (3)
• Four (4) or more

36

Have you ever caused or been convicted of, pleaded guilty, or pleaded no contest to a DUI accident involving death or injury to another person?

• Yes
• No

37

If you answered "YES" to the question above (Have you ever caused or been convicted of, pleaded guilty, or pleaded no contest to a DUI accident involving death or injury to another person?), please explain. 38

Have you ever caused or been convicted of, pleaded guilty, or pleaded no contest to a reckless driving accident involving death or injury to another person?

• Yes
• No

39

If you answered "YES" to the question above (Have you ever caused or been convicted of, pleaded guilty, or pleaded no contest to a reckless driving accident involving death or injury to another person?), please explain. 40

Have you ever caused or been convicted of, pleaded guilty, or pleaded no contest to a vehicular manslaughter?

• Yes
• No

41

If you answered "YES" to the question above (Have you ever caused or been convicted of, pleaded guilty, or pleaded no contest to a vehicular manslaughter?), please explain. 42

Have you ever slapped, punched, or otherwise injured a spouse or romantic partner (not in self-defense)?

• Yes
• No

43

If you answered "YES" to the question above (Have you ever slapped, punched, or otherwise injured a spouse or romantic partner (not in self-defense)?), please explain. 44

Have you ever tried, used or experimented with any substance or illegal drug, under limited circumstances (without a prescription) including: Cocaine Powder, Barbiturates (Downers), Hallucinogens (LSD, Mescaline, Mushrooms, and Peyote), GHB (Gamma Hydroxybutyrate), Amphetamines, Methamphetamine, Amyl Nitrate, Quaaludes, Steroids or synthetic steroids, Designer drugs (Ecstasy, Bath Salts, Synthetic Heroin, etc.), Nitrous Oxide, Paint or any substance containing Toluene (for the purpose of getting high), Or any other illegal drug not listed above, OTHER than marijuana?

• Yes
• No

45

If you answered "Yes" to the question above (Have you ever tried, used or experimented with any substance or illegal drug, under limited circumstances (without a prescription) including: Cocaine Powder, Barbiturates (Downers), Hallucinogens (LSD, Mescaline, Mushrooms, and Peyote), GHB (Gamma Hydroxybutyrate), Amphetamines, Methamphetamine, Amyl Nitrate, Quaaludes, Steroids or synthetic steroids, Designer drugs (Ecstasy, Bath Salts, Synthetic Heroin, etc.), Nitrous Oxide, Paint or any substance containing Toluene (for the purpose of getting high), Or any other illegal drug not listed above, OTHER than marijuana?) -- Please explain and provide which drug, last date of use, and number of usages. 46

Have you ever used Crack Cocaine, Opiates, Morphine, Demerol or other substances other than a prescription drug or treatment legally prescribed to you?

• Yes
• No

47

If you answered "Yes" to the question above (Have you ever used Crack Cocaine, Opiates, Morphine, Demerol or other substances other than a prescription drug or treatment legally prescribed to you?), please explain and provide which drug, last date of use, and number of usages. 48

Have you ever used PCP or heroin?

• Yes
• No

49

Since the age of 18, have you ever engaged in any of the activities listed below for drugs, narcotics or illegal substances, including marijuana? (Please check all that apply).

• Sold
• Furnished
• Manufactured
• Cultivated
• None of the above

50

If you answered "Yes" to the question above (Since the age of 18, have you ever engaged in any of the activities listed below for drugs, narcotics or illegal substances, including marijuana?), please explain and include date of incident. Required Question

Our diverse and inclusive workforce of more than 7,000 employees play a key role in the success of San Jos, the heart of the Silicon Valley. All City of San Jos employees work together as one team to make San Jos a vibrant, innovative, and desirable place to live and work. Visit to learn more about our One Team Leadership Values and Expectations, including quality and excellent customer service and here to learn more about San Jos.