GIS system administrator with SQL DBA :: Herndon, VA

Company: Software People Inc.
Location: Alexandria
Posted on: November 20, 2020

Job Description:

In person interview is needed Location: Herndon, VA Duration: 12+ months Pls note: along with the GIS exp - solid exp with SQL database is REQUIRED and being able to provide specific details around the depth of their exp will be an important part of the selection. Client is looking for senior GIS engineer to provide an array of technical geospatial and / or database development and business analytics solutions in support of the Town of Herndon Information Technology and Business Analytics Program. This position will provide technical expertise in ArcGIS Portal, Datastore, SDE configuration/maintenance and SQL database. Client currently utilizes Azteca Systems Cityworks and has recently embarked on implementation of Tyler Technology EnerGov application that will utilize ArcGIS Portal. GIS engineer will interact with EnerGov Product Managers and other members of the development team to make recommendations on use of current GIS technologies in future product releases. This role is responsible for GIS system administration and configuration, datastore, data automation services, application deployment, documentation, end user support and training data analysis, data modeling, web service creation, application testing and troubleshooting. Looking for someone who is detail oriented and can recommend best practices for data management and ingesting new data. Resource will assist in user training and demonstrations on use of GIS tools and GIS applications, and assists with the development and implementation of department/division GIS initiatives and programs. Responsibilities: Lead needs assessments/requirements meetings and document solutions for GIS enterprise use Provide/write GIS system technical recommendations, standard operating procedures, administrative and help documents for clients and technical teams. Apply industry-recognized best practices to support the design and development of spatial and non-spatial databases, web mapping applications, and enterprise system integrations in support of Town of Herndon strategic objectives. Create and maintain GIS environments for the EnerGov application that will be used by towns permitting, code enforcement, public works, zoning and community development departments. Develop and maintain GIS documentation as it relates to configuration, best practices, as well as test scripts for the EnerGov product Advise project implementation teams and clients on incorporating GIS capabilities into their EnerGov environment. Interact with Support staff for technical support in troubleshooting client problems Create and maintain database schema using prescribed best practices. Conduct versioned editing workflow management, database design, management and maintenance. Support and maintain simple data visualizations in spatial, tabular and graphical formats within various software systems. Pursue innovation and mentor the work of team members. Create new and innovative solutions for GIS data integration, administration, and management. Assess Towns existing GIS environments and recommend areas for improvements in application technology, system performance, and disaster mitigation plans Communicate with departments to successfully deploy GIS solutions Present system design information to technical and non-technical audiences Create mapping, imagery and data services Works with town departments and IT staff to identify available GIS data, evaluate for accuracy, and consolidate into centralized data source for the town. Work with IT department to secure GIS and make it application accessible internally and externally. Publish departmental maps and integrate GIS services with SeeClickFix mobile application and Cityworks. Train users on the use and adoption of Cityworks technologies Works with town departments to define and meet mapping and GIS data needs, implement GIS best practices and ensure compliance with relevant data standards, policies and regulations. Creates moderately complex cartographic products, dynamic web maps, static maps, charts, reports and graphs as needed by departments and assists in the management of department/division GIS layers and related data. Assists in the development of automated data management routines and various projects to improve department or program efficiency. Reviews, creates and maintains metadata to specifications for datasets and services. Assists and trains other users with GIS software and workflow processes. Resolves technical issues in cooperation with IT staff. Serves as liaison to Fairfax County GIS for updates. Utilizes GIS tools and data to improve the development of business processes within the department/division. Designs, develops and implements GIS enhancements using various ESRI programming tools and methodologies. Identifies and resolves complex GIS issues that affect the towns ability to meet objectives. Assists in the design and implementation of integrating GIS with other enterprise systems. Assists in maintaining and administering ArcGIS Server including security, publishing map services and content management. Assist in preparing disaster recovery plans. Troubleshoot solution errors and support end users Lead the development of simple data visualizations. Translate business process workflows into technical requirement documentation. Demonstrate advanced qualitative, quantitative (statistical) analytical skills. Lead, guide, coach, and mentor others and work with teams on the technical component of GIS system configuration workflows, GIS application development initiatives, and database management and design protocols. Performs other duties as assigned or required. Skills Needed Expert Esri ArcGIS (ArcGIS Online, ArcGIS 10.x ArcGIS Server, enterprise geodatabase) server platform software Required 4 Years ArcGIS Online and Tyler Technologies EnerGov software integration experience Required 3 Years Knowledge of Data Management as it relates to Asset Management and Geospatial applications Required 3 Years Experience providing ArcGIS knowledge transfer and training to administrators and end users Required 3 Years Create mapping, imagery and data services Required 4 Years Publish departmental maps and integrate GIS services with SeeClickFix mobile application and Cityworks Required 3 Years Merging data between multiple sources and verifying data integrity Required 3 Years Python Programming Language and ArcGIS Python Toolbox scripting Required 3 Years Configuring Cityworks and ArcGIS systems to align with asset or work management business requirements Required 3 Years SQL 2016 admin. Experience to include configuration/maintenance and SQL database Required 3 Years Creates moderately complex cartographic products, dynamic web maps, static maps, charts, reports and graphs as needed by departments Required 3 Years Experience with Tyler technologies EnerGov and Azteca systems Cityworks Highly desired 2 Years SDE configuration/maintenance Required 4 Years ArcGIS portal configuration and maintenance Required 3 Years Data automation Required 3 Years Question 1 Does your candidate have solid (recent) exp with configuration/maintenance and SQL database? Thanks Gaurav Gaurav Tyagi Software People Inc. Gaurav.tyagi@softwarepeople.us Ph: 617-237-9936 Fax: 631-574-3122 Twitter: Software People @spincjobs Certifications: SBA 8a/SDB, NY MWBE, VA SWaM, DE OMWBE, MA MWBE

Keywords: Software People Inc., Alexandria , GIS system administrator with SQL DBA :: Herndon, VA, IT / Software / Systems , Alexandria, Virginia