Application Developer

at  San Diego Association of Governments

DESCRIPTION

The Application 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 Application Developer will be detail-oriented, capable of maintaining accurate data and records, with superior quantitative analytical capabilities, organized, with effective communication skills.

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 five 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 knowledge of advanced GIS concepts, principles, practices, and techniques, including cartography, sophisticated design principles, and map creation; extensive hands-on experience with ESRI’s ArcGIS for Desktop software; experience using ArcGIS for Server, ArcGIS Pro, Spatial Analyst, and 3D Analyst; experience designing complex geodatabases with ArcGIS architecture; adeptness in seamlessly compiling and integrating data from multiple GIS sources, including SANGIS.
• 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.
  First review of applications: May 17, 2024
  Expected start date: July 2024

• 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.
• Design, develop, integrate, and maintain complex geographic information databases, and related tables, forms, and reports used to support public safety data and application workflows.
• Upgrade current GIS applications related to public safety; implement enhancements to ensure effective GIS systems are in place; support the ongoing development and maintenance of GIS application tools; perform geocoding to ensure data is valid.
• 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.