GIS Database Developer III - AECOM

**Company Description** **Work with Us. Change the World.** At AECOM, we're delivering a better world. Whether improving your commute, keeping the lights on, providing access to clean water, or transforming skylines, our work helps people and communities thrive. We are the world's trusted infrastructure consulting firm, partnering with clients to solve the world’s most complex challenges and build legacies for future generations. There has never been a better time to be at AECOM. With accelerating infrastructure investment worldwide, our services are in great demand. We invite you to bring your bold ideas and big dreams and become part of a global team of over 50,000 planners, designers, engineers, scientists, digital innovators, program and construction managers and other professionals delivering projects that create a positive and tangible impact around the world. We're one global team driven by our common purpose to deliver a better world. Join us. **Job Description** **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. Responsibilities: + Design stable, reliable, and effective database objects and procedures based on customer requirements. + Translate technical database issues, requirements, limitations, and parameters for management and staff, and understand business work processes and business impact. + Work alongside GIS team to understand spatial data and Esri’s Enterprise Geodatabase design. + Monitor GIS database and system performance, address possible issues and ensure the continuous delivery of high-quality information to the client. + Ensure data quality and integrity in database development techniques. + Provide data management support to GIS team. + Participate in all stages of the development life cycle, from concept planning to build, testing, delivery debugging, and documentation. + 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. + Review, develop, and design data models using standard diagramming techniques, in conjunction with application development teams. + Create logical data models and translate into physical database structures that integrate with existing or proposed database structures. + Gather user requirements and identify new features. + Develop technical and training manuals. + Mentor GIS team on database skill sets. **Qualifications** **Minimum Requirement:** + BA/BS + 4 years of relevant experience or demonstrated equivalency of experience and/or education **Preferred Qualifications:** + Experience with the following systems: + SQL Server 2014/2016, SQL Management Studio (SSMS) + Esri’s ArcGIS Desktop, Esri’s ArcGIS Enterprise + Additional experience with the following systems will be a bonus. + Python script development using arcpy, pandas, and other geospatial data modules. + Visual Studio solution deployment utilizing Team Explorer / Team Foundation Server (TFS) + Aptitude to work on multiple assignments simultaneously including working under pressure to meet project and task deadlines. + Ability to write complex queries for ad-hoc requests and data analysis, developing stored procedure, triggers, and functions across varied platforms with PL-SQL and T-SQL. + Understanding of troubleshooting, root-cause analysis, application design, solution development, human factors/usability design, and implementation of medium sized projects. + Ability to effectively troubleshoot system problems by identifying and implementing software or process changes that allow business applications to operate with minimal risk. + Problem-solving skills combined with analytical skills to analyze data, perform research, and diagnose and solve problems. + Capability to work independently and as part of cross-functional teams, including with analysts and subject matter experts. **Additional Information** \#LI-EM1 Offered compensation will be based on location and individual qualifications. The expected range is $85,000.00 - $115,000.00. **About AECOM** AECOM is proud to offer a comprehensive benefits program to meet the diverse needs of our employees. Depending on your employment status, AECOM benefits may include medical, dental, vision, life, AD&D, disability benefits, paid time off, leaves of absence, voluntary benefits, perks, U.S. and global well-being programs, employee assistance program, business travel insurance, service recognition awards, retirement savings plan, and employee stock purchase plan. AECOM is the world’s trusted infrastructure consulting firm, delivering professional services throughout the project lifecycle – from advisory, planning, design and engineering to program and construction management. On projects spanning transportation, buildings, water, new energy and the environment, our public- and private-sector clients trust us to solve their most complex challenges. Our teams are driven by a common purpose to deliver a better world through our unrivaled technical and digital expertise, a culture of equity, diversity and inclusion, and a commitment to environmental, social and governance priorities. AECOM is a Fortune 500 firm and its Professional Services business had revenue of $14.4 billion in fiscal year 2023. See how we are delivering sustainable legacies for generations to come at aecom.com and @AECOM. **Freedom to Grow in a World of Opportunity** You will have the flexibility you need to do your best work with hybrid work options. Whether you’re working from an AECOM office, remote location or at a client site, you will be working in a dynamic environment where your integrity, entrepreneurial spirit and pioneering mindset are championed. You will help us foster a culture of equity, diversity and inclusion – a safe and respectful workplace, where we invite everyone to bring their whole selves to work using their unique talents, backgrounds and expertise to create transformational outcomes for our clients. AECOM provides a wide array of compensation and benefits programs to meet the diverse needs of our employees and their families. We also provide a robust global well-being program. We’re the world’s trusted global infrastructure firm, and we’re in this together – your growth and success are ours too. Join us, and you’ll get all the benefits of being a part of a global, publicly traded firm – access to industry-leading technology and thinking and transformational work with big impact and work flexibility. As an Equal Opportunity Employer, we believe in each person’s potential, and we’ll help you reach yours. All your information will be kept confidential according to EEO guidelines. **ReqID:** J10108118 **Business Line:** Water **Business Group:** DCS **Strategic Business Unit:** West **Career Area:** Digital & Engineering Technology **Work Location Model:** Please Select **Legal Entity:** AECOM Technical Services Inc