The City of Greeley is seeking a Spatial Database Administrator with extensive experience in both GIS and database administration. The successful candidate will join the Information Technology Department and the Applications Services team conducting day-to-day geospatial and non-spatial data management activities in support of critical City functions. This position has a multi-departmental focus and requires a strong commitment to customer service and the high availability of geospatial data stores and related applications.
This positon will lead the development, implementation, and maintenance of various databases making up the enterprise GIS, including client-side and server-based GIS applications. Participate in the design, development, and implementation of information databases that maintain the enterprise database and use relational database technologies to enhance access and responsiveness to client-side and server based GIS applications. Ensure that data quality and information is consistently maintained and reliably accessible for departmental use. Ability to learn new concepts quickly, retain technical information, and adapt to a dynamic and changing work environment.
Experience, Knowledge, Skills
- Bachelors degree is required in GIS, Planning, Geography, Computer Science or closely related field;
- 5 years' experience with ESRIs ArcGIS suite of software with skills in GIS data entry, maintenance, and QA/QC techniques; Equivalent combination of education and experience may be considered.
- Knowledge and experience with ESRI enterprise geodatabase administration, including maintenance and troubleshooting, versioning and replication, geometric networks, parcel fabric, and ArcGIS Workflow Manager.
- Extensive knowledge of SQL Server administration and T-SQL programming with SQL Server 2014 and/or SQL Server 2016.
- Create small applications, modules, or interfaces; working proficiency with standard programming languages, such as SQL and Python.
- Able to perform complex data manipulation, conversion, load and clean up.
- Perform database design and documentation.
- Demonstrated knowledge of the ESRI Local Government Infrastructure Model (LGIM).
- Excellent communication skills and the ability to collaborate effectively with teammates and customers.
- Excellent writing skills. Experience documenting new and existing processes as well as updating existing documentation when changes are necessary.
- 2 years' object-oriented development experience with at least one of the following languages: C, .NET (C# or VB.NET), Adobe Flex (ActionScript), Java, Visual Basic desired;
- 2 years' experience with ESRI-related programming in ArcGIS Desktop and/or ArcGIS Server;
- Experience with Visual Basic for Applications using ESRIs Component Object Model (COM) i.e., ArcObjects, Active Server Pages(ASP), Visual Basic, SQL, ODBC connections, IBM Informix, Python, and batch files;
- Experience with graphic platforms such as Adobe Illustrator, Adobe Photoshop and/or equivalent;
- Knowledge of computer systems, procedures, analysis and design as well as system uses, capabilities, characteristics, and limitations;
- Experience with computer system peripheral devices, such as printer, plotters, and scanners;
- Microsoft Office tools under Windows platforms, including Microsoft Project and Microsoft Visio;
- Formal training desired in ESRIs ArcObjects, Visual Studio, and C#;
- Skill sets to include problem solving, database design, program languages, compilers, and abstract thinking required for programming and ability to decipher requests and create data analysis products to complete customer requests;
- Excellent verbal and written communication skills;
- Experience with project management;
- Excellent interpersonal skills and the ability to work and learn independently;
- The ability to train a wide range of users on the ESRI ArcGIS platforms;
- Candidates should be flexible due to rapid prototyping, and quick turnaround may be required;
- Strong graphic design and/or cartographic abilities;
- Strong analytical abilities with high degree of technical competence in analysis, design, and programming;
- Thorough working knowledge and understanding of cartographic rules and principles, including data sources, data projections, and data integration;
- Spanish/English bilingual fluency desired;
- Current driver's license with good driving record.
- Plan, design and deploy up-to-date GIS architecture to include both SQL and GIS server software and hardware in support of supplemental geo-spatial components and geo-enabled and dependent software systems to ensure system scalability, performance and reliability
- Design GIS databases and data structures, initiated by gathering business requirements from customers and other GIS staff to meet both the technical needs of the GIS and the business requirements of the customer
- Consult with customers to identify appropriate technical solutions, develop standards and guidelines, and communicate technical actions and expectations to a diverse audience of both technical and non-technical users. In order to provide business solutions, will collaborate with other development staff and system administrators to determine application server and database requirements for new applications
- Review vendor specifications and verify technical requirements for geospatially dependent software and hardware
- Provide project management on longer term GIS requests that have broader scopes and organizational impacts
- Identify, analyze, and resolve technical issues with regard to organizational SQL and GIS server infrastructure and server performance. Design, configure, implement, tune, upgrade and secure GIS and SQL servers
- Consult with GIS and geo-data impacted application vendors to troubleshoot technology issues with software and/or hardware
- Develop and operationalize data integration processes for both internal systems as well as inter-agency data
- Plan, implement and execute on-going GIS system support, customization, process automation, hardware sizing and maintenance of GIS Servers, SQL Servers and other geo-enabled applications and systems
- Create, edit and maintain technical documentation and instructions for servers, databases, applications and processes
- Collaborate with other DB Administrators and System Administrators to provide viable GIS software solutions, support and maintenance
- Develop, implement, and enforce application-related database standards; establish common practices for database design, documentation, naming conventions, security, reporting, and access.
- Investigate and resolve issues with ESRI versioned geodatabases, including user issues on the desktop as well as performance issues in the geodatabase itself
- Investigate and resolve user database issues, including troubleshooting batch processing jobs in various environments.
- Identify database requirements by interviewing customers; analyze department applications, programming, and operations; evaluate existing systems and design proposed systems.
- Run data import, export and processing routines from external data sources, FTP sites, and conversions of data between SQL, Oracle, and other data sources.
- Explore and facilitate data integration opportunities between GIS and other enterprise systems.
- Create and modify SQL queries and stored procedures, implement automated processes, and perform systems upgrades and general troubleshooting.
- Assist in day-to-day operation of the existing City GIS program;
- Use of abstract process documentation to functional application development;
- Supervisory duties are not a responsibility but this position will function as a Lead role for interns and project teams;
- Communicate face to face, by telephone, and in written form with both individuals and groups;
Input data completely and accurately into a computer system using keyboards, scanners, PDA's, Trimble GPS receivers and from third party sources;
- Use blueprints, schematics, layouts, maps, and other visual aids;
- Comprehend and make inferences from written material;
- Presentation preparation and demonstrations to a wide variety of audiences;
- Perform advanced level mathematical calculations;
- Operate a variety of computer equipment and software packages;
- Use GIS tools in conjunction with map graphics, map scale, and real-world coordinate systems develop and maintain GIS map products;
- Receive instructions from supervisor on work results required with some latitude to make decisions based on policies, principles, and departmental objectives and the ability to use sound judgment;
- Work under the guidance of the Application Services Manager to for project assignments
- Work Environment and Physical Requirements
- Employee may be asked to work in a remote capacity and not have a fixed office within the City office space.
- Employee is subject to inside environment: Protection from weather conditions but not necessarily from temperature changes.
- Employee is subject to both environmental conditions: Activities occur inside and outside.
- Employee may be asked to drive personal vehicle for business purposes.
- Employee may be required to travel with associated risks inherent to travel by car/air.
- Employee is subject to working alone and/or with groups and/or attends meetings.
- Employee spends extended periods of time at fixed workstation.
- Employee may be required to conduct business in alternate locations within City buildings or field sites; sometimes in formal settings.
- Employee may be required to work overtime, holidays, evenings, shifts, or weekends.
- Employee may have frequent interruptions; required to multi-task; inflexible deadlines.
- Employee may have frequent contact with the public--in person, via email/telephone; sometimes adverse or confrontational situations. Includes internal/external customers.
- Employee is not substantially exposed to adverse environmental conditions--as in typical office or administrative work. Work performed is sedentary.
- Safe to minimal hazards that are typically found in general office environment where there is rarely little or no exposure to injury or accident.
The essential functions of this job require occasional carrying/lifting moderate objects, grasping, standing, and walking; frequent hearing, repetitive motion, and talking; continuously fingering and sitting
- Employee is required to have close visual acuity to perform an activity such as: preparing and analyzing data/figures; transcribing; viewing a computer terminal; extensive reading of printed materials; visual inspection involving small defects, small parts, and/or operation of machines (including inspection); using measurement devices--graphs and gauges; and/or assembly or fabrication of parts at distances close to the eyes.
- Employee is required to have visual acuity for close vision, distance vision, color vision, peripheral vision, depth perception, and ability to adjust focus.
- Employee is required to have visual acuity to perform an activity such as: operating machinery where the seeing job is at or within arm's reach; performing mechanical or skilled trades tasks of a non-repetitive nature such as ones by carpenters, technicians, service people, plumbers, painters, mechanics, etc.
- Employee is required to have visual acuity to operate motor vehicles or heavy equipment.
- Employee is required to have visual acuity to determine the accuracy, neatness, and thoroughness of the work assigned (i.e., custodial, general labor, etc.) or to make general observations of facilities or structures for inspection purposes.
When you apply, please indicate that you are responding to the posting on My GIS Jobs.