Senior GIS & Database Engineer - CIMS

Trilon Group 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, focusing on maintaining GIS environments and managing relational databases.

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

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
• 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