GIS Programmer (Systems Programmer II)

Anne Arundel County; Annapolis (MD); Hybrid; USD 75,000 - 100,000; Full time

Job summary

Anne Arundel County is seeking a full-time Systems Programmer II to support GIS programming for geospatial enterprise applications and services. The role involves designing and maintaining geospatial scripts, coordinating with project teams, and ensuring compatibility of county software and hardware.

The position expects strong SDE data modeling skills in Microsoft SQL Server Geospatial environments, plus broad knowledge of hardware, networks, and databases.

Qualifications

• Strong understanding of SDE data models in MS SQL Server Geospatial environments.
• Experience with hardware, software, network management, and data communications.
• Ability to coordinate with multiple project teams to ensure compatible designs.

Responsibilities

• Design and implement GIS data models in SQL Server for geospatial apps.
• Coordinate with managers and contractors to ensure system compatibility.
• Install, configure and support major operating systems and network software.
• Perform disaster recovery planning for all servers.
• Provide technical support to external customers on servers and devices.
• Develop training for end users and supervise special projects.

Skills

GIS programming

SDE data models

SQL Server

Geospatial

Education

Bachelor's degree in math or related field

Tools

Esri ArcGIS Enterprise

ArcGIS Pro

ArcGIS Online

Geocortex

Job description

This vacancy announcement will be used to fill a full-time Systems Programmer II position in the Office of Information Technology. The work location for this position is the Riva Road Heritage Complex in Annapolis, MD.

This position is designated to support GIS programming for implementation and maintenance of geospatial enterprise applications, support of enterprise geospatial services, design and maintenance of geospatial scripts, and support of various databases.

This position requires a strong understanding of and practical experience designing and implementing SDE data models in Microsoft SQL Server SDE Geospatial environments. This position coordinates with multiple project teams to ensure that the design of the County software and hardware are compatible and work together efficiently. Work involves coordinating with Technical Services, County managers, project managers and contractors developing systems and monitoring operational effectiveness.

NATURE AND VARIETY OF WORK

Work involves working with County managers, employees and contractors developing systems and monitoring operational effectiveness and contractors. Employees in this classification perform their duties independently, exercise independent judgment in designing and resolving network problems, and are given wide latitude to complete work assignments. These employees receive general supervision from a Systems Analyst or higher-level administrator. The work is primarily sedentary, and performed in an office environment. However, the work does involve some walking, standing, bending, stooping, lifting and bending when installing, moving, and repairing computers or peripherals. The employee may be required to lift equipment weighing fifty pounds or more. Employees may also be required to work nights, weekends, and holidays. (Note: The duties and responsibilities enumerated in this class specification are for the purpose of determining a common set of minimum qualifications and salary level for all positions in this class. They are not intended to include all of the essential functions of all positions in the class.)

• This position is designated to support GIS programming for implementation and maintenance of geospatial enterprise applications, support of enterprise geospatial services, design and maintenance of geospatial scripts, and support of various databases.
• This position coordinates with multiple project teams to ensure that the design of the County software and hardware are compatible and work together efficiently. Work involves coordinating with Technical Services, County managers, project managers and contractors developing systems and monitoring operational effectiveness.
• Design, schedule, install and upgrade hardware, software and computer equipment. Prepare all relevant documentation. Install, configure, and support major multiple operating software systems, and network management software to support network attached file servers, client work stations, printers, communication routers, CD-ROM towers/jukeboxes, and related equipment.
• Perform disaster recovery for all servers.
• Analyze, test and calibrate network equipment using state-of-the-art network and software test equipment to improve LAN and WAN network performance, and assess and correct problems.
• Run backups of network data, and archive as required. Research, evaluate and test new technologies for existing and proposed network systems.
• Recommend new enhancements as needed. Perform network security of access, usage and protection of all servers, e-mail client workstations, printers, folders, files, and documents.
• Provide technical support to external customers concerning the daily care of servers, desktop computers, network-attached printers, and multimedia network devices.
• Provide advice and guidance to staff members as required. Work with contractors, vendors, and employees concerning hardware, software, servers and mainframe systems.
• Perform related duties as required.

KNOWLEDGE, SKILLS, AND ABILITIES

• Strong understanding of and practical experience designing and implementing SDE data models in Microsoft SQL Server SDE Geospatial environments.
• Considerable knowledge of a wide array of hardware and software operating systems, cabling, and power requirements.
• Considerable knowledge of network management and router configuration, personal computer equipment and data communications networks.
• Considerable knowledge of the functions and capabilities of electronic data processing equipment, and personal computer equipment.
• Skill in evaluating, analyzing, troubleshooting and resolving network connectivity, server, hardware, and software problem.
• Ability to establish and maintain effective and harmonious working relationships with internal and external consumers.
• Ability to communicate effectively orally and in writing presenting information through charts and graphs to display data.
• Ability to read and comprehend complex technical manuals.
• Ability to evaluate and make recommendations on different applications and software packages;
• Ability to plan, schedule, and coordinate special projects and assignments.
• Ability to develop and implement formal training for the end users.

Graduation from an accredited four-year college or university with major coursework in mathematics, public or business administration, or a related field, including or supplemented by specialized training in electronic data processing, programming, operations, and methodologies; and two (2) or more years of experience in telecommunications, computer operating systems, and database management.

Please note: Graduation from an accredited four-year college or university with major course work in mathematics, public or business administration, or a related field, including or supplemented by specialized training in electronic data processing, programming, operations, and methodologies, may be substituted on a year-for-year basis with four (4) years of work experience in GIS programming or related experience, this is in addition to the two (2) or more years of of experience in telecommunications, computer operating systems, and database management.

Note: Normal work schedule is currently hybrid with 2 days per week in the Annapolis Office.

Note: This position requires a full background check.

Note: Preference will be given to candidates with state and local government experience.

Note:

Pay will be based on education and direct experience, generally within fifteen percent (15%) of the base pay. Please note that the Pay Scale shown represents the full proficiency of the position, not the starting range.

Preferences will be given to applicants who possess the following:

• 1) Experience with database management tools, reporting, and business intelligence software
• 2) Experience developing interfaces and web services for GIS applications
• 3) Experience working with Esri ArcGIS Enterprise, ArcGIS Pro, ArcGIS On-Line, VertiGIS/Geocortex software stack, and Model Builder
• 4) Web development skills (ReactJS, Typescript, JSON, Python, JavaScript, ArcGIS JavaScript 4x API, ArcGIS REST, ArcGIS/arcpy python libraries, or HTML5/CSS)
• 5) Experience with relational and/or NoSQL database design
• 6) Experience working with on premises and Cloud based services (AWS)