Address
Form of workJob Description
TITLE: GIS Data Administrator DATE: August 2022
EEO CATEGORY: Professional GRADE: 14
FLSA: Exempt BRIEF DESCRIPTION: The purpose of this position is to administer and support enterprise geospatial applications and related databases that form part of the NCTCOG Geographic Information System (GIS) environment. This is accomplished by coordinating the planning, development, maintenance, and monitoring of various enterprise systems and applications. This position is the primary provider of these functions and requires liaising with agency IT staff and other GIS staff in multiple departments. ESSENTIAL FUNCTIONS: Note: This information is intended to be descriptive of the key responsibilities of the position. The list of essential functions below does not identify all duties performed by any single incumbent in this position. Additionally, please be aware of the legend below when referring to the physical demands of each essential function.
(S) Sedentary (L) Light (M) Medium (H) Heavy (V) Very Heavy Exerting up to 10 lbs. occasionally or negligible weights frequently; sitting most of the time. Exerting up to 20 lbs. occasionally; 10 lbs. frequently; or negligible amounts constantly; OR requires walking or standing
to a significant degree. Exerting 20-50 lbs.
occasionally; 10-25 lbs. frequently; or up to 10 lbs. constantly. Exerting 50-100 lbs.
occasionally; 10-25 lbs. frequently; or up to 10-20 lbs. constantly. Exerting over 100 lbs. occasionally; 50-100 lbs. frequently; or up to 20-50 lbs. constantly. # Code Essential Functions 1 S Administers GIS server(s); performs regular operating system updates; manages federation, authentication, and access control systems; creates and maintains web- services; monitors performance and utilization of the system(s) and databases including hardware resources; determines operational, technical, and system requirements for the location, installation, operation, and maintenance of data
processing, data communication, system software, and server hardware. 2 S Coordinates and/or conducts the analysis, design, and maintenance of database structures and schemas. Designs and implements procedures necessary to save, retrieve, and recover databases from hardware and software failures. Establishes and implements database security standards and controls, and user access levels. Supports the enterprise GIS environment and agency GIS users; collaborates with stakeholders on all matters relating to GIS data and databases. 3 S Plans, coordinates, and supports the installation of database software and migrations to new data management system software levels; verifies and tests the migrations to ensure data reliability and functionality. Performs database performance monitoring and implements efficiency improvements relational database management system (RDBMS) administration. Manages federation, authentication, and access control of an enterprise RDBMS; provides technical
advice, assistance, and status reports to management; maintains overall health and efficiency of the RDBMS. 4 S Creates automation tools and scripts for data processes; configures
automation routines; provides guidance in troubleshooting and problem-solving related to system software and hardware; analyzes and defines agency disaster recovery responsibilities and procedures; might evaluate and recommend action
EEO CATEGORY: Professional GRADE: 14
FLSA: Exempt BRIEF DESCRIPTION: The purpose of this position is to administer and support enterprise geospatial applications and related databases that form part of the NCTCOG Geographic Information System (GIS) environment. This is accomplished by coordinating the planning, development, maintenance, and monitoring of various enterprise systems and applications. This position is the primary provider of these functions and requires liaising with agency IT staff and other GIS staff in multiple departments. ESSENTIAL FUNCTIONS: Note: This information is intended to be descriptive of the key responsibilities of the position. The list of essential functions below does not identify all duties performed by any single incumbent in this position. Additionally, please be aware of the legend below when referring to the physical demands of each essential function.
(S) Sedentary (L) Light (M) Medium (H) Heavy (V) Very Heavy Exerting up to 10 lbs. occasionally or negligible weights frequently; sitting most of the time. Exerting up to 20 lbs. occasionally; 10 lbs. frequently; or negligible amounts constantly; OR requires walking or standing
to a significant degree. Exerting 20-50 lbs.
occasionally; 10-25 lbs. frequently; or up to 10 lbs. constantly. Exerting 50-100 lbs.
occasionally; 10-25 lbs. frequently; or up to 10-20 lbs. constantly. Exerting over 100 lbs. occasionally; 50-100 lbs. frequently; or up to 20-50 lbs. constantly. # Code Essential Functions 1 S Administers GIS server(s); performs regular operating system updates; manages federation, authentication, and access control systems; creates and maintains web- services; monitors performance and utilization of the system(s) and databases including hardware resources; determines operational, technical, and system requirements for the location, installation, operation, and maintenance of data
processing, data communication, system software, and server hardware. 2 S Coordinates and/or conducts the analysis, design, and maintenance of database structures and schemas. Designs and implements procedures necessary to save, retrieve, and recover databases from hardware and software failures. Establishes and implements database security standards and controls, and user access levels. Supports the enterprise GIS environment and agency GIS users; collaborates with stakeholders on all matters relating to GIS data and databases. 3 S Plans, coordinates, and supports the installation of database software and migrations to new data management system software levels; verifies and tests the migrations to ensure data reliability and functionality. Performs database performance monitoring and implements efficiency improvements relational database management system (RDBMS) administration. Manages federation, authentication, and access control of an enterprise RDBMS; provides technical
advice, assistance, and status reports to management; maintains overall health and efficiency of the RDBMS. 4 S Creates automation tools and scripts for data processes; configures
automation routines; provides guidance in troubleshooting and problem-solving related to system software and hardware; analyzes and defines agency disaster recovery responsibilities and procedures; might evaluate and recommend action
on testing and certification of system software and hardware upgrades; modifies existing databases and database management systems. 5 S Works with vendors to ensure products operate as required; interfaces with internal and external technical support staff to resolve issues promptly; provides support for NCTCOG Help Desk tickets related to GIS software and associated tools; coordinates and communicates with agency IT staff and participates in pertinent support meetings. 6 S Develops and maintains add-ins and other data access systems; generates and publishes services and database connections; builds light applications for interaction with GIS data. 7 L Consults on GIS initiatives; works with others in the agency to identify needs and develop and implement strategies for improving agency GIS systems, services, and tools; provides input on strategic planning and priorities; implements action
plans; clearly communicates status of agency GIS; presents goals and plans to a variety of internal audiences. 8 L Increases skill set by participating in professional development opportunities such as continuing education and specialized training; proactively maintains knowledge of current trends and advancements in the field of GIS and associated technologies; attends seminars, workshops, and conferences; interfaces with other GIS professionals both internally and externally.
JOB REQUIREMENTS: -Description of Minimum Job Requirements- Formal Education/ Knowledge Work requires broad knowledge in a general professional or technical field. Knowledge is normally acquired through four years of college resulting in a Bachelor's degree. Experience Over three years up to and including five years Certification and Other Requirements Valid state issued driver's license Reading Advanced - Ability to read literature, books, reviews, scientific or technical journals, abstracts, financial reports, surveys, legal descriptions, engineering documents, and/or legal documents. Ordinarily, such education is obtained at the college level or above. However, it may be obtained from experience and self-study. Math Advanced Ability to apply fundamental concepts of theories, work with advanced mathematical operations methods, and functions of real and complex variables. Ordinarily, such
education is obtained at the college level or above. However, it may be obtained from experience and self-study. Writing Advanced - Ability to write editorials, journals, speeches, manuals, or critiques. Ordinarily, such education is obtained at the college level or above. However, it may be obtained from experience and self-study. Managerial Receives General Direction: Work is non-standardized and varied and requires the incumbent to produce expected results and meet deadlines by following general procedures. The employee normally performs the job by following established operating
plans; clearly communicates status of agency GIS; presents goals and plans to a variety of internal audiences. 8 L Increases skill set by participating in professional development opportunities such as continuing education and specialized training; proactively maintains knowledge of current trends and advancements in the field of GIS and associated technologies; attends seminars, workshops, and conferences; interfaces with other GIS professionals both internally and externally.
JOB REQUIREMENTS: -Description of Minimum Job Requirements- Formal Education/ Knowledge Work requires broad knowledge in a general professional or technical field. Knowledge is normally acquired through four years of college resulting in a Bachelor's degree. Experience Over three years up to and including five years Certification and Other Requirements Valid state issued driver's license Reading Advanced - Ability to read literature, books, reviews, scientific or technical journals, abstracts, financial reports, surveys, legal descriptions, engineering documents, and/or legal documents. Ordinarily, such education is obtained at the college level or above. However, it may be obtained from experience and self-study. Math Advanced Ability to apply fundamental concepts of theories, work with advanced mathematical operations methods, and functions of real and complex variables. Ordinarily, such
education is obtained at the college level or above. However, it may be obtained from experience and self-study. Writing Advanced - Ability to write editorials, journals, speeches, manuals, or critiques. Ordinarily, such education is obtained at the college level or above. However, it may be obtained from experience and self-study. Managerial Receives General Direction: Work is non-standardized and varied and requires the incumbent to produce expected results and meet deadlines by following general procedures. The employee normally performs the job by following established operating
procedures and/or policies. There is a choice of the appropriate
procedure or policy to apply to duties. Performance is reviewed upon completion for approval. Budget/Financial Responsibility Does not have any budget responsibility. Organizational Control Work may require the occasional direction of helpers, assistants, seasonal employees, interns, or temporary employees. This level also measures duties that require working with regular employees within the department or across department lines to complete specific projects. Complexity Work requires analysis and judgment in accomplishing diversified duties. Requires the exercise of independent thinking within the limits of policies, standards, and precedents. Interpersonal/
Human Relations Skills Work requires frequent and regular contact with others in a direct reporting relationship and may involve contact with others outside of the direct reporting relationship. The purpose of the contact is to address specific issues and/or general policies. Contact may involve support of controversial positions or the negotiation of sensitive issues. Evaluates customer satisfaction develops cooperative associations and relationships and utilizes resources to continuously improve external customer relations and satisfaction. Makes presentations and answers questions in regard to presentation materials and findings. Technical Skills Work requires a comprehensive, practical knowledge of a technical field with use of analytical judgment and decision-making abilities appropriate to the work environment of the Agency. Skill in solving problems; in testing, installing, and implementing geographic information system programs; and in troubleshooting system issues. Knowledge of cartography and an ability to interpret orthophotographs and digital imagery. The ability to gather, assemble, correlate, and analyze data; to devise solutions to problems; to prepare reports; to communicate effectively; to manage projects; and to train, lead, assign, and/or prioritize the
work of others are essential for this position. Consequences of work affect large groups as well as the customer-base at large.
OVERALL PHYSICAL STRENGTH DEMANDS: -Physical strength for this position is indicated below with "X - Sedentary X Light Medium Heavy Very Heavy Exerting up to 10 Exerting up to 20 lbs. Exerting 20-50 lbs. Exerting 50-100 Exerting over 100 lbs. occasionally or occasionally, 10 lbs. occasionally, 10-25 lbs. occasionally, lbs. occasionally, negligible weights frequently, or negligible lbs. frequently, or up 10-25 lbs. 50-100 lbs. frequently; sitting amounts constantly OR to 10 lbs. constantly. frequently, or up frequently, or up to most of the time. requires walking or standing to 10-20 lbs. 20-50 lbs. to a significant degree. constantly. constantly. PHYSICAL DEMANDS: C F O R N
procedure or policy to apply to duties. Performance is reviewed upon completion for approval. Budget/Financial Responsibility Does not have any budget responsibility. Organizational Control Work may require the occasional direction of helpers, assistants, seasonal employees, interns, or temporary employees. This level also measures duties that require working with regular employees within the department or across department lines to complete specific projects. Complexity Work requires analysis and judgment in accomplishing diversified duties. Requires the exercise of independent thinking within the limits of policies, standards, and precedents. Interpersonal/
Human Relations Skills Work requires frequent and regular contact with others in a direct reporting relationship and may involve contact with others outside of the direct reporting relationship. The purpose of the contact is to address specific issues and/or general policies. Contact may involve support of controversial positions or the negotiation of sensitive issues. Evaluates customer satisfaction develops cooperative associations and relationships and utilizes resources to continuously improve external customer relations and satisfaction. Makes presentations and answers questions in regard to presentation materials and findings. Technical Skills Work requires a comprehensive, practical knowledge of a technical field with use of analytical judgment and decision-making abilities appropriate to the work environment of the Agency. Skill in solving problems; in testing, installing, and implementing geographic information system programs; and in troubleshooting system issues. Knowledge of cartography and an ability to interpret orthophotographs and digital imagery. The ability to gather, assemble, correlate, and analyze data; to devise solutions to problems; to prepare reports; to communicate effectively; to manage projects; and to train, lead, assign, and/or prioritize the
work of others are essential for this position. Consequences of work affect large groups as well as the customer-base at large.
OVERALL PHYSICAL STRENGTH DEMANDS: -Physical strength for this position is indicated below with "X - Sedentary X Light Medium Heavy Very Heavy Exerting up to 10 Exerting up to 20 lbs. Exerting 20-50 lbs. Exerting 50-100 Exerting over 100 lbs. occasionally or occasionally, 10 lbs. occasionally, 10-25 lbs. occasionally, lbs. occasionally, negligible weights frequently, or negligible lbs. frequently, or up 10-25 lbs. 50-100 lbs. frequently; sitting amounts constantly OR to 10 lbs. constantly. frequently, or up frequently, or up to most of the time. requires walking or standing to 10-20 lbs. 20-50 lbs. to a significant degree. constantly. constantly. PHYSICAL DEMANDS: C F O R N
Continuously
2/3 or more of the time. Frequently
From 1/3 to 2/3 of the time. Occasionally
Up to 1/3 of the time. Rarely
Less than 1 hour per week. Never
Never occurs. Note: This is intended as a description of the way the job is currently performed. It does not address the potential for accommodation.
-Physical Demand- -
Frequency- -Brief Description- Standing O Making presentations, meeting with coworkers Sitting C Desk work, operating computer, attending meetings Walking O To offices, to meeting rooms, to printer Lifting O Documents, binders, boxes, supplies, furniture and electronic equipment Carrying O Documents, binders, boxes, supplies, furniture and electronic equipment Pushing/Pulling R Boxes, carts, dolly, file drawers, furniture and electronic equipment Reaching O For supplies, various documents, books, the telephone Handling O Paperwork, telephone, calculator, various documents Fine Dexterity C Computer keyboard, documents, telephone Kneeling R Retrieving items from low shelves or drawers Crouching R Retrieving items from low shelves or drawers Crawling N Bending R Retrieving items from low shelves or drawers Twisting R Retrieving items from low/high shelves or drawers, answering telephone, reaching for documents Climbing O Stairs Balancing N Vision C Reading and computer use Hearing C Communicating with co-workers and on telephone Talking C Communicating with co-workers and on telephone Foot Controls O Driving to meetings and other work-related activities Other N
MACHINES, TOOLS, EQUIPMENT, SOFTWARE, AND HARDWARE:
Telephone, copier, plotter, CD burner, projector, computer, printer and related software -Primary Work Location- Office Environment X Other N/A
PROTECTIVE EQUIPMENT REQUIRED:
N/A
NON-PHYSICAL DEMANDS: C F O R N
Continuously2/3 or more of the time. Frequently
From 1/3 to 2/3 of the time. Occasionally
Up to 1/3 of the time. Rarely
Less than 1 hour per week. Never
Never occurs. Note: This is intended as a description of the way the job is currently performed. It does not address the potential for accommodation.
-Physical Demand- -
Frequency- -Brief Description- Standing O Making presentations, meeting with coworkers Sitting C Desk work, operating computer, attending meetings Walking O To offices, to meeting rooms, to printer Lifting O Documents, binders, boxes, supplies, furniture and electronic equipment Carrying O Documents, binders, boxes, supplies, furniture and electronic equipment Pushing/Pulling R Boxes, carts, dolly, file drawers, furniture and electronic equipment Reaching O For supplies, various documents, books, the telephone Handling O Paperwork, telephone, calculator, various documents Fine Dexterity C Computer keyboard, documents, telephone Kneeling R Retrieving items from low shelves or drawers Crouching R Retrieving items from low shelves or drawers Crawling N Bending R Retrieving items from low shelves or drawers Twisting R Retrieving items from low/high shelves or drawers, answering telephone, reaching for documents Climbing O Stairs Balancing N Vision C Reading and computer use Hearing C Communicating with co-workers and on telephone Talking C Communicating with co-workers and on telephone Foot Controls O Driving to meetings and other work-related activities Other N
MACHINES, TOOLS, EQUIPMENT, SOFTWARE, AND HARDWARE:
Telephone, copier, plotter, CD burner, projector, computer, printer and related software -Primary Work Location- Office Environment X Other N/A
PROTECTIVE EQUIPMENT REQUIRED:
N/A
NON-PHYSICAL DEMANDS: C F O R N
2/3 or more of the time Frequently
From 1/3 to 2/3 of the time Occasionally
Up to 1/3 of the time Rarely
Less than 1 hour per week Never
Never occurs -Description of Non-Physical Demands - -Frequency- Time Pressure O Emergency Situation R Frequent Change of Tasks F Irregular Work Schedule/Overtime O Performing Multiple Tasks Simultaneously F Working Closely with Others as Part of a Team C Tedious or Exacting Work F Noisy/Distracting Environment R Other
SIGNATURE REVIEW AND COMMENTS:
I have reviewed this description and find it to be an accurate representation of the demands of the position.
Printed Name of Employee
Signature of Employee
Date
Comments:
The above statements are intended to describe the general nature and level of work being performed
by individuals assigned to this position. They are not intended to be an exhaustive list of all responsibilities, duties, and skills required. This description is subject to modification as the needs.
Date Request Received 02/20/24 10:53 AM Requester Extension 59168 Department RIS Proposed Start Date 03/11/24 Anticipated End Date 09/27/24 Type of Request Temporary to Hire Title of Position GIS Data Administrator Hourly pay rate 40.58 Duties & Responsibilities Administer the enterprise GIS deployment which includes managing GIS software, associated components, and related data. Also serve as the primary point of contact for the enterprise GIS infrastructure. Scheduled Hours 7:30 am - 4:30 pm Will you want to review resumes? Yes Will this individual need to be certified? Not Required - But I would like certification if possible Certification Description GISP Will you need skill testing for this individual? No Skill Testing Description Will this person need temporary access badge? Yes Will this individual need computer access? Yes Will this individual be required to travel? No Will this individual need to submit expenses? Preferred Skills must have experience administering Esri products; relational database administration; scripting (e.g. Python) Additional Notes to Staffing Agency
