Ardmore Roderick - Chicago, IL

posted 4 months ago

Full-time - Mid Level
Chicago, IL
Professional, Scientific, and Technical Services

About the position

Ardmore Roderick is a full-service civil engineering firm that specializes in providing infrastructure design, construction services, and program management to various agencies. Headquartered in Chicago, with additional offices in Champaign, IL, Orlando, FL, and Philadelphia, PA, Ardmore Roderick has been recognized by Crain's Chicago as one of the fastest-growing companies in the Chicagoland area. The firm is dedicated to advancing the design and construction of critical infrastructure to improve communities, emphasizing the safety, experience, and professional development of its team members. The company values excellence, diversity and inclusion, innovation, and community engagement. The Database Developer position is part of the DWMPMO, which provides program management, engineering, and IT implementation services to the Chicago Departments of Water Management (CDWM), Transportation (CDOT), and Assets, Information, and Services (AIS). The primary responsibility of the Database Developer will be to design and develop enterprise-wide database systems, focusing on inventory and work order management systems for the City of Chicago. This role will utilize Oracle and Microsoft SQL Server platforms and will require the candidate to identify innovative solutions in a rapid application development environment. The Database Developer will also be responsible for providing high-quality support for production, test, and development environments by managing 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.
  • 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.

Requirements

  • Bachelor's degree in Computer Science or a relevant field of study.
  • Minimum 3 years of related experience in database development and management.
  • Experience with SQL Server 2014/2016, SQL Management Studio (SSMS), SQL Server Integration Services (SSIS), and/or SQL Server Reporting Services (SSRS).
  • Experience with Oracle 11g or 12c and Oracle SQL Developer.
  • Ability to write complex queries for ad-hoc requests and data analysis, developing stored procedures, triggers, and functions across varied platforms with PL-SQL and T-SQL.
  • Understanding of troubleshooting, root-cause analysis, application design, solution development, and implementation of medium-sized projects.
  • Problem-solving skills combined with analytical skills to analyze data, perform research, and diagnose and solve problems.
  • Ability to work independently and as part of cross-functional teams, including with analysts and subject matter experts.

Nice-to-haves

  • Experience with enterprise asset management systems such as Infor EAM or IBM Maximo.
  • Familiarity with business intelligence and reporting platforms such as PowerBI or SAP Business Objects.
  • Experience with Visual Studio solution deployment utilizing Team Explorer / Team Foundation Server (TFS).

Benefits

  • Paid parental leave
  • Health savings account
  • Disability insurance
  • Health insurance
  • Dental insurance
  • Flexible spending account
  • Paid time off
  • Parental leave
  • Employee assistance program
  • Vision insurance
  • 401(k) matching
  • Life insurance
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service