Senior GIS & Database Engineer - CIMS
About The Position
The CIMS (Construction Information Management System) team is seeking a Senior GIS & Database Engineer to support a GIS-based construction data platform used for inspection, testing, and project management workflows. This role combines enterprise GIS administration with professional database management. The position supports a production system built on spatial and non-spatial relational data, web services, and mobile workflows. The successful candidate will demonstrate strong technical capability, sound database practices, and effective collaboration within a highly technical team. Position Characteristics This is an enterprise systems role rather than a traditional GIS analyst position. The role requires ownership of GIS infrastructure, relational database health, ETL processes, and automation within a production environment.
Requirements
- Bachelor’s degree in GIS, Computer Science, Engineering, Information Systems, or related field
- 5+ years of experience in enterprise GIS, database administration, or geospatial systems support
- Experience managing relational databases (PostgreSQL preferred)
- Experience with designing and maintaining ETL processes
- Experience administering ArcGIS Enterprise or ArcGIS Server
- Strong SQL skills, including query optimization
- Experience with Python scripting for automation
- Experience supporting multi-user production environments
- Understanding of data security and database role management
- Enterprise geodatabase management
- Relational database administration (schema design, normalization, documentation, indexing, constraints, roles)
- SQL performance tuning
- ETL design and data transformation workflows
- ArcGIS Server administration
- Backup and recovery procedures
- Sync-enabled/mobile GIS workflows
- Cloud-hosted systems (AWS or similar)
- Ability to work effectively within a highly technical team
- Clear communication with developers and technical stakeholders
- Strong troubleshooting and analytical mindset
- Professional judgment in balancing technical standards with operational needs
- Ability to work independently while contributing to a collaborative environment
Nice To Haves
- Experience performing core DBA functions (performance monitoring, storage planning)
- Experience developing custom automation tools or database scripts
- Familiarity with Linux environments
- Experience supporting production systems with uptime expectations
- Basic understanding of civil design concepts and terminology.
Responsibilities
- Administer and maintain enterprise GIS environments
- Manage spatial and non-spatial relational databases (PostgreSQL-based)
- Design and maintain ETL workflows for spatial and tabular data
- Develop database schemas, relationships, and constraints
- Monitor and optimize database performance (queries, indexing)
- Implement backup, recovery, and data integrity procedures
- Publish and maintain GIS services for web and mobile use
- Support offline data collection and synchronization workflows
- Troubleshoot system performance and data reliability issues
- Develop automation scripts and custom tools to support operations
- Collaborate with software developers and technical staff on system improvements
Benefits
- Medical, dental, vision, life, and disability insurance
- Generous paid time off
- 401(k): 50% match of contribution up to 6%
- Professional development opportunities including in-house training
- Paid professional organization membership and professional licensure
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
