Systems Applications Programmer II - Police Department

About The Department

Our diverse and inclusive workforce of more than 7,000 employees plays a key role in the success of San José, the heart of 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.

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.

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.

• 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 24‑x‑7 environment.

• 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
• Simpl Gov
• Java Script
• HTML/XML
• Application development and release management

• 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.
• E…