Salary: $92,577.65 – $143,495.36 Annually
Location : 401 B Street, San Diego
Job Type: Full-Time
Remote Employment: Flexible/Hybrid
Department: Data Science
Division: ARJIS
Opening Date: 07/31/2023
Closing Date: 8/18/2023 11:59 PM Pacific
FLSA: Exempt
Description
ARJIS is recognized as a leader in the use of technologies for regional, State, and national public safety applications. ARJIS’s technology portfolio includes Software AG’s webMethods suite, Microsoft SharePoint 2010 and IIS, JBoss, Apache, ESRI GIS suite, and Microsoft SQL Server. Within these products, ARJIS uses both .net and Java to implement customer facing solutions.
The Developer will participate in a variety of advanced professional, analytical, and coordination support duties for programming, design, development, deployment, and maintenance of ARJIS applications technology. As the agency continues toward its goal of delivering data products in alternate formats, the ability to develop and implement innovative tools and resources, develop solutions to meet the needs of projects and customers, and participate in inter-departmental and/or cross-functional project teams will be an increasingly important aspect of the position.
The Developer will be detail-oriented, capable of maintaining accurate data and records, with superior quantitative analytical capabilities, organized, with effective communication skills.
The final candidate selected for this position must successfully pass a preemployment criminal background check in compliance with the FBI and the California Department of Justice requirements. Periodic rechecking of criminal background history will be a condition of employment; the selected candidate can anticipate a driving record check upon hire, and approximately annually thereafter. The results of the check may determine whether the selected candidate will be permitted to drive for SANDAG business.
About the Automated Regional Justice Information System
The ARJIS Division develops and maintains a complex, multi-agency information network that allows real-time law enforcement applications and data to be shared among 82 local, state, and federal criminal justice agencies. Averaging 50,000 transactions daily, ARJIS is used by more than 4,400 officers and investigators for tactical analysis, statistical information, crime analysis, and investigative purposes. Providing real-time shared access to information increases collaboration among law enforcement jurisdictions, improves the overall effectiveness of the regional criminal justice system, and helps to address and anticipate public safety issues to improve the quality of life for residents of the San Diego region.
Job Responsibilities
- Participate in large, complex technical projects and grants; design, test, and deploy Java code for new applications and enhancements to existing systems.
- Serve as the primary support staff for the ARJIS Enterprise MQ Series; monitor, troubleshoot, and manage MQ Series queues for the ARJIS Enterprise and member agencies.
- Write common and custom Web services for mobile devices and interfaces going through the ARJIS Enterprise middleware flow.
- Maintain the existing Java code for custom built ARJIS applications and interfaces to include the License Plate Reader interface, CAD 911 incident, citations to Court interfaces, and County interfaces for ONS (Officer Notification).
- Develop SQL queries, triggers, views, and stored procedures in various relational database environments.
- Develop Business Rules that validate and enhance data for ARJIS Interfaces.
- Assist ARJIS team members, as well as member agencies.
- Work with the technical team to analyze issues associated with the ARJIS Operational Storage database updates and recommend solutions.
- Code Hibernate layers to provide framework for Java communication with databases.
- Work with daily application backups, procedures, logs, and checkpoints.
- Develop documentation and provide technical support for Desktop and Web-based applications, including computer models.
- Map incoming data files from ARJIS member agencies to XML data files for standardization in the ARJIS Operational storage data.
- Create new screens and maintain existing screens for a variety of ARJIS applications to include the data entry screens and the web portal user interface screens.
- Write queries to search database fields and .net web services to query databases.
- Maintain and use the code management library.
- Utilize the ARJIS development products (webMethods and SharePoint) as necessary to implement solutions.
- Provide 24 hour, 7 days a week support as scheduled.
Typical Qualifications
- A bachelor’s degree from an accredited college or university with major course work in computer science, information technology, or a related field. A combination of relevant education and recent work experience may be considered in lieu of the bachelor’s degree requirement.
- Minimum of three years of full-time professional information technology experience preferably in a public safety environment; understanding of pertinent federal, state, and local laws, codes, and regulations regarding public safety is preferred.
- Demonstrated experience developing, deploying, maintaining, and enhancing client web and mobile based applications in a Microsoft Windows/IIS/Visual Studio/SQL Server environment; ability to design debugging, testing, and performance monitoring routines.
- Demonstrated application development experience using Visual Studio and the Microsoft .NET Framework; demonstrated knowledge and implementation of programming technologies including C#.NET, Entity Framework 6.x, SQL, HTML5, CSS3, JavaScript, and jQuery; demonstrated knowledge and understanding of object-oriented programming methodologies and best practices; knowledge of VBA for Access, Java, MVC, and Python is desirable.
- Knowledge of and experience with standard software engineering methodologies and tools including development of requirements, modeling, code development tools, shared code libraries, debugging and testing methodologies, and documentation.
- Knowledge of design SQL principles; experience creating SQL queries, stored procedures, and data views; demonstrated ability to work with data from numerous sources.
- Demonstrated understanding of multiple computer operating systems including Windows and LINUX/UNIX.
- Experience using MS Azure for cloud hosted solutions is preferred.
- Demonstrated ability to establish and maintain effective working relationships with those contacted in the course of work.
- Strong written and oral communication skills, including the ability to identify user needs and effectively communicate technical information to non-technical users.
- Excellent organizational skills, attention to detail, and the ability to maintain accurate records and work independently on concurrent projects.
The final candidate selected for this position must successfully pass a preemployment criminal background check in compliance with the FBI and the California Department of Justice requirements. Periodic rechecking of criminal background history will be a condition of employment; the selected candidate can anticipate a driving record check upon hire, and approximately annually thereafter. The results of the check may determine whether the selected candidate will be permitted to drive for SANDAG business.
SANDAG employees are expected to live within the San Diego region and work in-person in our San Diego office; there are telework options available (Monday and Wednesday), as well as a 9/80 work schedule (every other Monday off).
Advertise Date: July 31, 2023
Close Date: August 18, 2023
We offer a complete benefits package to full-time employees including:
- Hybrid work options
- 9/80 flexible work schedule
- Pay-for-performance merit increases
- CalPERS pension plan with employer and employee contributions
- Excellent health insurance options for employees and their eligible dependents
- Free dental and vision insurance for employees and their eligible dependents
- Education Assistance of up to $5,250 a year for regular employees
- Free transit pass for use throughout the San Diego region, bus, Rapid Express, Trolley, and COASTER
- Paid time off including 12 paid holidays, 2 floating holiday days, generous paid time off (PTO) per year, depending on length of service
01
SANDAG employees are expected to live within the San Diego region and work in-person in our San Diego office; there are telework options available (Monday and Wednesday), as well as a 9/80 work schedule (every other Monday off).This is not a fully remote position.Are you able and willing to adhere to the onsite and work schedule described above?
- Yes
- No
02
Can you provide 24 hour, 7 days a week support as scheduled.
- Yes
- No
03
From the list below, select the programming languages that you have experience with (select all that apply).
- C#.NET
- CSS3
- Entity Framework 6.x
- HTML5
- JavaScript
- jQuery
- SQL
- Other
Required Question