Database Developer
Chicago, IL

Job Description

At EXP, we know that great experiences start with the right people. We believe that work should be challenging, and the challenge should be fun. We also believe that exponential possibilities are more likely to occur with a respectful, satisfying and empowering company. We value and respect our employees - their experience and expertise as well as their energy, passion and diversity - and their innovative approach to work and to life.

Your Challenge

We are seeking a Database Developer for our Chicago team. This individual will need expertise in Inventory and Maintenance management systems with specific expertise in the InforEAM product. Specifically, the position will support DWM with its inventory management system and assist with establishment and maintenance of parallel systems for two other City of Chicago departments: Facilities and Fleet Management (2FM) and Transportation (CDOT). This role requires a thorough knowledge of the inventory management subject area and an understanding of the related software management systems.

Candidates can expect to work independently as well as on teams staffed with management consultants, IT professionals, engineers and scientists from various backgrounds and experience levels. The ability to effectively troubleshoot database related system problems by identifying and implementing business process changes that allow enterprise application systems to operate with minimal risk is a must. Responsibilities also include performance monitoring, capacity planning, data recovery, security compliance, audit trail monitoring, and create custom reports using business intelligence tools.

Your Responsibility

* Database administration, development and database performance analyzing and optimization for Oracle 11g and 12c. SQL Server experience will be a plus.
* Workflow implementation, configuration, and maintenance of InforEAM database system for inventory management
* Review, evaluation, and implementation of best practices for inventory and maintenance management systems
* Provides backend technical support for InforEAM users
* Document and establish organization standards and procedures
* Detailed client contact pertaining to specific projects/tasks; work will be performed in client facilities
* Keeps abreast of state-of-the art technology developments and identifies opportunities where new technologies can be applied on assigned projects

Job Requirements

The Skills and Abilities You Bring

* BS or MS with a basic or applied science, computer science, or engineering degree required
* Five to ten years of experience preferred
* Workflow process development, documentation, and performance evaluation for inventory and business processes
* Preparation of user requirements for database software development, sampling, quality control procedures, etc.
* Ability to respond proactively in a high-paced environment and willingness to adjust and respond effectively to changes
* Strong oral and written communication and organizational skills
* The ability to take ownership, prioritize workload and meet project task milestones and deliverable deadlines set by the program leadership team
* Work on multi-discipline projects with ability to communicate complex technical concepts to non-technical users
* The ability to work effectively in an agile environment managing multiple priorities and tasks.
* Be able to analyze data, perform and develop ETL (extraction, transformation, and loading) processes in the context of multiple integrations systems
* Extensive experience of writing SQL Queries, Views, Stored Procedures, Functions and Triggers.
* Hands-on exposure to MS BI Technology stack (SSIS, SSRS, SSAS, Power BI) and data warehousing principals.

What exp Can Offer

With a mission to understand, innovate, partner and deliver, exp provides professional, technical and strategic services related to the world's built and natural environments in six key practice areas: Buildings, Earth & Environment, Energy, Industrial, Infrastructure, and Sustainability. Our heritage dates back to 1906, when the earliest of exp's predecessor companies started its engineering infrastructure practice in northern Ontario. Today, close to 3,000 creative exp professionals across North America and around the globe provide the expertise and experience needed to deliver successful projects for clients.

Our promise is to offer you a challenging career in a positive and dynamic work environment, and it's a promise we take seriously.

Join a dynamic team at exp that provides you with innovative projects, the capacity to develop your career, a full range of benefits, flexible working hours, and much more! When you explore what exp has to offer, you'll find exponential possibilities.

For more information, visit www.exp.com.

EXP is proud to be an Equal Opportunity Employer who fully and actively supports equal access for all people regardless of Race, Color, Religion, Gender, Age, National Origin, Veteran Status, Disability, Genetic Information or Testing, Family and Medical Leave, Sexual Orientation and Gender Identity or Expression.

#LI-JH1