I worked on a GIS project only once in my career, but it was a lot of fun. Learning about different map projections, coordinate systems, WGS84, etc was pretty interesting. Tooling wise we started off with MySQL but migrated to PosrgreSQL with PostGIS for far superior GIS support.