AECOM - Chicago, IL
posted 3 months ago
AECOM is seeking a GIS Database Developer III to support a large capital improvement program in Chicago. The primary responsibility of the GIS Database Developer position will include the effective design and development of enterprise-wide database systems with specific attention on Geographic Information Systems (GIS) Enterprise Geodatabases for the City of Chicago. This position will leverage the Microsoft SQL Server platform along with Esri's ArcGIS Enterprise platform and will be responsible for identifying innovative approaches and solutions in a rapid application development environment. The candidate should be able to provide high quality support for the production, test, and development environments by implementing, managing, monitoring, and maintaining multiple database servers and databases. The GIS Database Developer will design stable, reliable, and effective database objects and procedures based on customer requirements. They will translate technical database issues, requirements, limitations, and parameters for management and staff, and understand business work processes and business impact. The role requires close collaboration with the GIS team to understand spatial data and Esri's Enterprise Geodatabase design. Monitoring GIS database and system performance, addressing possible issues, and ensuring the continuous delivery of high-quality information to the client are also key responsibilities. In addition, the developer will ensure data quality and integrity in database development techniques, provide data management support to the GIS team, and participate in all stages of the development life cycle, from concept planning to build, testing, delivery debugging, and documentation. They will work closely with stakeholders and other developers to dynamically link the backend databases to the web interfaces, write, debug, and unit test complex stored procedures and triggers, and review, develop, and design data models using standard diagramming techniques, in conjunction with application development teams. The role also involves creating logical data models and translating them into physical database structures that integrate with existing or proposed database structures, gathering user requirements, identifying new features, developing technical and training manuals, and mentoring the GIS team on database skill sets.