Job Information
AECOM Database Administrator in Chicago, Illinois
Company Description
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.
Job Description
AECOM is seeking a talented Database Administrator (DBA) to join our Applied Technology Team to support it’s expanding work with the Chicago Water Management Program.
We are currently searching for a Database Administrator (DBA) who can provide high quality support for the production, test, and development environments by designing, implementing, managing, monitoring and maintaining multiple database servers and databases. The ideal candidate will have the ability to work both independently and with a team in a fast-paced environment with tight deadlines and changing priorities. The candidate must be able to translate technical database issues, requirements, limitations and parameters for management and staff, and understand business work processes and business impact.
Responsibilities:
System performance monitoring and capacity planning, database installation and configuration, database backup & recovery, patch upgrades, security compliance, audit trail monitoring.
Design and implement database solutions by defining database physical structure and functional capabilities, database security, data back-up, and recovery specifications.
Design and develop stored procedures, triggers, functions, and SSIS packages.
Analyze and study complex application/database requirements to proactively design, plan, and deploy needed capabilities.
Evaluate and analyze database systems for enhancements design, develop and maintain databases that interact with software applications.
Prepare design specifications and functional documentation for assigned database projects.
Design and create 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.
Modify database objects according to requests and perform tests.
Ensure data quality and integrity in database development techniques.
Translate technical database issues, requirements, limitations and parameters for management and staff, and understand business work processes and impact.
Schedule and coordinate routine database maintenance tasks with minimal impact to users and ongoing projects.
Maintain database performance by calculating optimum values for database parameters; implementing new releases; completing maintenance requirements; evaluating computer operating systems and hardware products.
Maintain and support existing enterprise applications along with internal and external integration components.
Maintain quality service by establishing and enforcing organization standards.
Participate in on-call and off-hours production problem resolution activities.
Minimum Requirements:
- BA/BS + 4 YORE or demonstrated equivalency of experience and/or education
Preferred Qualifications:
Experience with Oracle 11g or 12c, Oracle SQL Developer, SQL Server 2014/2016, SQL Management Studio (SSMS), Team Foundation Server (TFS), Visual Studio, SQL Server Reporting Services (SSRS), and SQL Server Integration Services (SSIS).
Extensive experience writing SQL Queries, Views, Stored Procedures, Functions and Triggers.
Experience in full software development life cycle and working with developers, business analysts, and project managers on a regular basis.
Experience working with enterprise asset management systems such as Infor EAM or IBM Maximo, and ESRI GIS is a plus.
Experience modernizing and upgrading legacy systems is a plus.
Be able to perform and develop ETL processes in the context of multiple integrations systems.
Ability to map middleware and front end of applications to the backend database objects.
Ability to effectively troubleshoot system problems by identifying and implementing software or process changes that allow business applications to operate with minimal risk.
Excellent understanding and practical experience with T-SQL, data modeling and data analysis.
Present understanding of troubleshooting, root-cause analysis, application design, solution development, human factors/usability design, and implementation of medium sized projects.
Strong oral and written communication skills to effectively explain technical concepts.
Exceptional problem-solving skills combined with analytical skills to analyze data, perform research, and diagnose and solve problems.
Must be highly motivated and enjoy working in a team environment.
Microsoft SQL Server administration/development experience.
Qualifications
Minimum Requirements:
- BA/BS + 4 YORE or demonstrated equivalency of experience and/or education.
Preferred Qualifications:
Experience with Oracle 11g or 12c, Oracle SQL Developer, SQL Server 2014/2016, SQL Management Studio (SSMS), Team Foundation Server (TFS), Visual Studio, SQL Server Reporting Services (SSRS), and SQL Server Integration Services (SSIS).
Extensive experience writing SQL Queries, Views, Stored Procedures, Functions and Triggers.
Experience in full software development life cycle and working with developers, business analysts, and project managers on a regular basis.
Experience working with enterprise asset management systems such as Infor EAM or IBM Maximo, and ESRI GIS is a plus.
Experience modernizing and upgrading legacy systems is a plus.
Be able to perform and develop ETL processes in the context of multiple integrations systems.
Ability to map middleware and front end of applications to the backend database objects.
Ability to effectively troubleshoot system problems by identifying and implementing software or process changes that allow business applications to operate with minimal risk.
Excellent understanding and practical experience with T-SQL, data modeling and data analysis.
Present understanding of troubleshooting, root-cause analysis, application design, solution development, human factors/usability design, and implementation of medium sized projects.
Strong oral and written communication skills to effectively explain technical concepts.
Exceptional problem-solving skills combined with analytical skills to analyze data, perform research, and diagnose and solve problems.
Must be highly motivated and enjoy working in a team environment.
Microsoft SQL Server administration/development experience.
Additional Information
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.
ReqID: J10082719
Business Line: Water
Business Group: DCS
Strategic Business Unit: West
Career Area: Digital & Engineering Technology
Work Location Model: Hybrid