What are the responsibilities and job description for the Junior GIS and Database Administrator position at Cape Fear Public Utility Authority?
Incumbents in this position are responsible for supporting the GIS and Database Administrator in the administration, maintenance, and operation of the organization's Geographic Information System (GIS) and SQL Server database environments. This position assists with system monitoring, routine maintenance, data integrations, and troubleshooting to ensure the availability, performance, and integrity of geospatial and enterprise data systems. This position is assigned to pay grade IT4.
X Comprehends and uses technical or professional language, either written or spoken, to communicate complex ideas.
X Performs numerical operations using basic counting, adding, subtracting, multiplying, or dividing.X Performs complex quantitative calculations or reasoning using algebra, geometry, statistics, or abstract symbols.
X Requires travel between CFPUA sites.X Use or repair of small/light equipment (power tools).X Use or repair medium equipment and machinery (vehicles, commercial mowers). XUse or repair heavy or complex machinery (HVAC systems, construction equipment, water plants). X Physical Requirements
None: 0 hours or 0% of scheduled shift
Some: Up to 2 hours or 20% of scheduled shift
Frequent - 2 to 5 hours or 20% to 60% of scheduled shift
Very Frequent - More than 5 hours or 60% to 100% of scheduled shift NONESOMEFREQUENTVERY FREQUENTMinimal physical exertion. Very light physical work at desk or counter level with intermittent periods of sitting, standing, and walking. May involve data entry, telephone work, or use of various office equipment.
X Same as above with the addition of standing/sitting/walking for lengthy periods of time. May involve light physical exertion due to pushing, pulling, carrying, and lifting weights up to 20 pounds. X Physical exertion involving pushing, pulling, and lifting up to 20 pounds. May require prolonged standing and/or walking during which time objects are transported. May require occasional bending, squatting, and reaching.
X Sustained physical activity throughout the work period. Performs work tasks involving pushing, pulling, carrying, and lifting up to 50 pounds. May require bending, squatting, stooping, reaching, climbing, or walking in addition to other physical demands.
X Sustained physical activity throughout the work period. Performs work tasks involving pushing, pulling, carrying, and lifting up to 50 pounds. May require bending, squatting, stooping, reaching, climbing, or walking in addition to other physical demands.
X
- Assists the GIS and Database Administrator in maintaining the ArcGIS Enterprise environment, including ArcGIS Server, Portal, ArcGIS Data Store, ArcGIS Online, and desktop GIS applications such as ArcGIS Pro.
- Supports SQL Server environments by assisting with routine administration tasks including monitoring system health, validating backups, reviewing job status, and performing basic maintenance activities.
- Assists with the administration and maintenance of enterprise geodatabases and relational databases, including support for data integrity, access controls, and performance optimization activities.
- Supports ETL and data integration processes by assisting with the execution, monitoring, and troubleshooting of automated workflows using tools such as SQL Server Integration Services (SSIS), Python, or similar technologies.
- Assists with the creation and maintenance of database objects such as views, stored procedures, indexes, and scheduled jobs under the guidance of the GIS and Database Administrator.
- Helps manage user access and permissions within GIS and databases, and other enterprise systems, including Asset Management, CMMS, ERP, and related operational platforms.
- Provides technical support and troubleshooting assistance for GIS services, database-related issues, and data service interruptions, escalating complex issues as appropriate.
- Assists with system documentation, including updating standard operating procedures, system diagrams, configuration records, and recovery documentation.
- Supports routine monitoring and auditing activities to ensure compliance with organizational IT Standards, cybersecurity policies, and data governance requirements.
- Collaborates with other IT staff and departments to support organizational data and system needs.
- Performs other related job duties as assigned.
- Bachelor’s degree in Computer Science, Information Technology, GIS, or related course study.
- Two (2) to Three (3) years of professional experience in an IT role involving GIS, databases, or system administration, such as GIS Technician, GIS Analyst, or related position.
- Basic working knowledge of SQL Server, relational databases, and GIS platforms.
- Familiarity with ArcGIS Enterprise components and desktop GIS applications is preferred.
- Experience with scripting or automation tools such a T-SQL, PowerShell, or Python is preferred but not required.
X Comprehends and uses technical or professional language, either written or spoken, to communicate complex ideas.
X Performs numerical operations using basic counting, adding, subtracting, multiplying, or dividing.X Performs complex quantitative calculations or reasoning using algebra, geometry, statistics, or abstract symbols.
X Requires travel between CFPUA sites.X Use or repair of small/light equipment (power tools).X Use or repair medium equipment and machinery (vehicles, commercial mowers). XUse or repair heavy or complex machinery (HVAC systems, construction equipment, water plants). X Physical Requirements
None: 0 hours or 0% of scheduled shift
Some: Up to 2 hours or 20% of scheduled shift
Frequent - 2 to 5 hours or 20% to 60% of scheduled shift
Very Frequent - More than 5 hours or 60% to 100% of scheduled shift NONESOMEFREQUENTVERY FREQUENTMinimal physical exertion. Very light physical work at desk or counter level with intermittent periods of sitting, standing, and walking. May involve data entry, telephone work, or use of various office equipment.
X Same as above with the addition of standing/sitting/walking for lengthy periods of time. May involve light physical exertion due to pushing, pulling, carrying, and lifting weights up to 20 pounds. X Physical exertion involving pushing, pulling, and lifting up to 20 pounds. May require prolonged standing and/or walking during which time objects are transported. May require occasional bending, squatting, and reaching.
X Sustained physical activity throughout the work period. Performs work tasks involving pushing, pulling, carrying, and lifting up to 50 pounds. May require bending, squatting, stooping, reaching, climbing, or walking in addition to other physical demands.
X Sustained physical activity throughout the work period. Performs work tasks involving pushing, pulling, carrying, and lifting up to 50 pounds. May require bending, squatting, stooping, reaching, climbing, or walking in addition to other physical demands.
X