AECOM Database Developer in Chicago, Illinois
At AECOM, we’re delivering a better world.
We believe infrastructure creates opportunity for everyone. Whether it’s improving your commute, keeping the lights on, providing access to clean water or transforming skylines, our work helps people and communities thrive.
Our clients trust us to bring together the best people, ideas, technical expertise and digital solutions to our work in transportation, buildings, water, the environment and new energy. We’re one global team – 47,000 strong – driven by a common purpose to deliver a better world.
Here, you will have freedom to grow in a world of opportunity.
We will give you 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.
We will encourage you to grow and develop your career with us through our technical and professional development programs and diverse career opportunities. We believe in leadership at all levels. No matter where you sit in the organization you can make a lasting impact on the projects you work on, the teams and committees you join and our business.
We offer competitive pay and benefits, well-being programs to support you and your family, and the development resources you need to advance your career.
When you join us, you will connect and collaborate with a global network of experts – planners, designers, engineers, scientists, consultants, program and construction managers – leading the change toward a more sustainable and equitable future. Join us and let’s get started.
AECOM is seeking a talented Database Developer to join our Applied Technology Team to support it’s expanding work with the Chicago Water Management Program.
The primary responsibility of the Developer position will include the effective design and development of enterprise-wide database systems with specific attention on implementing inventory and work order management systems for the City of Chicago. This position will leverage Oracle and Microsoft SQL Server platforms, related data systems and management tools, 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.
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.
Modify database objects according to requests and perform tests.
Ensure data quality and integrity in database development techniques.
Liaise with system analysts and business owners to improve applications and establish best practices.
Prepare design specifications and functional documentation for assigned database projects.
Provide data management support to users.
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.
Respond to occasional requests for Production to resolve any database related customer issue.
Provide technical support for enterprise (on-premise) systems, middleware, and administration tools.
- B.S BA/BS + 4 YORE or demonstrated equivalency of experience and/or education.
B.S in the field of Computer Science or relevant field of study.
Experience with the following systems:
SQL Server 2014/2016, SQL Management Studio (SSMS), SQL Server Integration Services (SSIS), and/or SQL Server Reporting Services (SSRS).
Oracle 11g or 12c and Oracle SQL Developer.
Additional experience with the following systems will be an added bonus
Enterprise asset management systems such as Infor EAM or IBM Maximo
Business intelligence and reporting platforms such as PowerBI or SAP Business Objects
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.
Knowledge of software development and user interface web applications.
Ability to understand front-end users’ requirements and problem-solving attitude.
Oral communication skills to effectively explain technical concepts.
Ability to perform and develop ETL processes in the context of multiple integrations systems.
Experience with business process implementation in the design and implementation of systems and using database management systems and their integration.
Experience and ability to quickly learn new IT systems.
Relocation assistance is not provided for this role.
Sponsorship is not available for this role
All your information will be kept confidential according to EEO guidelines.
With infrastructure investment accelerating worldwide, our services are in great demand, and there’s never been a better time to be at AECOM! 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.
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.
As an Equal Opportunity Employer, we believe in each person’s potential, and we’ll help you reach yours.
Join us and let’s get started.
Business Line: Water
Business Group: DCS
Strategic Business Unit: West
Career Area: Digital & Engineering Technology
Work Location Model: Hybrid