Salary Range: $68,025.07 - $102,026.27
Hiring Range: $68,025.07 - $85,025.67
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 conducts 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 position 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 are 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.
This position has remote/hybrid options but does look for availability to be at the office environment 1-2 days a week. The responsibilities here can be done virtually, from a home office or, if feasible, from any virtual location with reliable internet. The City of Greeley’s IT Department promotes a remote-friendly environment via virtual weekly team meetings and monthly departmental meetings through an MS Teams platform environment.
Experience, Knowledge, Skills & Education:
- Bachelor's degree is required in GIS, Planning, Geography, Computer Science, or a closely related field;
- 5 years of experience with Esri's ArcGIS suite of software with skills in GIS data entry, maintenance, and
- Knowledge and experience with ESRI enterprise geodatabase administration, including maintenance and
troubleshooting, versioning and replication, geometric networks, parcel fabric, and ArcGIS Workflow
- Extensive knowledge of SQL Server administration and 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;
- 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;
- Prefer 2 years' object-oriented development experience with at least one of the following languages: C, .NET (C# or VB.NET), Python, Java
- 2 years of experience with ESRI-related programming in ArcEnterprise, ArcGIS Desktop, and/or ArcGIS
- Equivalent combination of education and experience;
- Experience with Visual Basic for Applications using Esri's Component Object Model (COM) i.e., ArcObjects, Arcade, Active Server Pages(ASP), Visual Basic, SQL, ODBC connections, Oracle, 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 printers, 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 include problem-solving, database design, program languages, compilers, and abstract thinking required for programming and the 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 a quick turnaround may be required;
- Strong graphic design and/or cartographic abilities;
- Strong analytical abilities with a 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;
- 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 geospatial 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 technical 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 ongoing 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;
- 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 the day-to-day operation of the existing City GIS program;
- Use of abstract process documentation for 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, iPads, 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 to 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 for project assignments
Work Environment and Physical Requirements:
- Employees may be asked to work in a remote capacity and not have a fixed office within the City office space.
- The employee is subject to the inside environment: Protection from weather conditions but not necessarily from
- The employee is subject to both environmental conditions: Activities occur inside and outside.
- Employees may be asked to drive personal vehicles for business purposes.
- Employee may be required to travel with associated risks inherent to travel by car/air.
- The employee is subject to working alone and/or with groups and/or attending meetings.
- The employee spends extended periods of time at a fixed workstation.
- Employees 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.
- Employees may have frequent contact with the public--in person, via email/telephone; sometimes in adverse or confrontational situations. Includes internal/external customers.
- Employee is not substantially exposed to adverse environmental conditions--as in a typical office or administrative work. Work performed is sedentary.
- Safe to minimal hazards that are typically found in a 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 of moderate objects, grasping, standing, and walking; frequent hearing, repetitive motion, and talking; continuously fingering and sitting.
- The 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.
- The employee is required to have visual acuity for close vision, distance vision, color vision, peripheral vision, depth perception, and the ability to adjust focus.
- The 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.
- The 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.
***Applications MUST be submitted directly to the City of Greeley: