GIS Programmer (Systems Programmer II)

Anne Arundel County – Information Technology Department; Maryland; Hybrid; USD 85,000 - 110,000; Full time

Job summary

Anne Arundel County – Information Technology Department is seeking a Systems Programmer II to design and maintain GIS applications and geospatial scripts. The role focuses on implementing SDE data models in SQL Server geospatial environments and supporting enterprise GIS services.

The position requires coordinating with multiple teams to ensure software and hardware work together efficiently, including disaster recovery, backups, security, and user support.

Qualifications

• Requires graduation from an accredited four-year college/university with relevant coursework and two+ years of related experience.
• Substitution: four years GIS programming or related experience may replace the degree requirement.
• Proficiency with GIS software and geospatial databases is essential.

Responsibilities

• Design, implement, and maintain GIS programs and geospatial scripts.
• Support enterprise geospatial services and databases.
• Coordinate with Technical Services, managers and contractors to ensure system compatibility.

Skills

GIS data modeling

Hardware & OS knowledge

Networking basics

Troubleshooting

Project coordination

Technical writing

Communication

Data management

Education

Bachelor's degree

GIS-related training

Tools

Esri ArcGIS Enterprise

ArcGIS Pro

ArcGIS Online

Geocortex/VertiGIS

ArcGIS REST API

ArcPy Python

SQL Server

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 involved 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.

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

• 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)