MS SQL Server Mentor Data Mining Spatial Data Engineer (Jobs in Medford, OR)   Requirement id 10977 Job title Engineer Job location in Medford, OR Skills required Application Programming Interfaces, MS SQL Server, Functional ODB, Mentor Data Mining Spatial Data Open Date 11-Sep-2012 Close Date Job type Contract Duration 1 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: coolsoft Job Description Engineer: Application Programming Interfaces, MS SQL Server, Functional ODB, Mentor Data Mining Spatial Data [Note: Submission Deadline : 9/28/2012 ] [Note: Start Date : 10/15/2012 End Date : 11/16/2012] Description: Client wants to extract data from the Mentor Engineering database (TDB) by leveraging existing Mentor Engineering APIs and importing the mined data into clients own relational database (ODB). A General Transit Feed Specification Realtime (GTFS-realtime) feed will be created using the data in the ODB and published at regular scheduled intervals. A web service API will be made available for interaction with the ODB with anticipated use cases in mind. Task 1. Design of clients Own relational Database (ODB) The ODB will be a Microsoft SQL Server (version 2008 or later) relational database. The database should be architected and optimized with anticipated use-cases in mind. The database should have an efficient table structure and be properly indexed. Database table structure should effectively enable enforcement of anticipated user roles. The database should maintain referential integrity and employ a transactional data engine. The database should be configured in a manner consistent with the ACID model. Design should be informed by both the data to be received via the Mentor APIs as well as potential use-cases as outlined. The architecture and optimization of the database must be documented. Client will receive copies of all such documentation. Deliverables: • Functional ODB • Diagrams & Documentation of ODB architecture • ODB Instantiation,Testing, and Optimization Task 2. Mine Data Via Mentor API The ODB must be updated via the existing Mentor Engineering APIs by querying data at regular, scheduled intervals. The majority of data is static in nature. As such, most of the data may be scheduled to be updated daily outside of service hours. However, there should be a simple interface available to end users allowing the update to be run on demand. Data from Mentors Real Time Web service APIs should be updated during service hours and with high frequency. The update frequency for this data must be at least every two minutes. Sub-minute frequency, if feasible, is preferred. All mined data must be inserted into the ODB in a manner that is consistent with the sql-92 standard. Data may have to be processed and/or reformatted before insertion into the ODB. Deliverables: • Installation, configuration, and successful test of Mentor Data Mining • Accompanying documentation • Source code (if applicable) Task 3. Create and Publish GTFS-realtime GTFS- realtime is a feed specification that allows public transportation agencies to provide realtime updates about their fleet to application developers. One of the applications that uses GTFS-realtime is Live Transit Updates, which is a feature on Google Maps that provides live departure and arrival times. GTFS-realtime feeds will be generated using data from the ODB. All existing feed types should be supported (trip updates, service alerts, and vehicle positions). Upon creation the feeds should be transferred to the published location on a client web server. At minimum, a simple interface should be available to activate/deactivate feeds and manage basic configuration (such as published location). Deliverables: • Installation and configuration of solution • Validated GTFS-Realtime data feed • Accompanying documentation • Source code (if applicable) • Staff Training Required Skills: • The vendor must have experience in the design, development, and implementation of architecture for databases. • The vendor must have experience with the use of Application Programming interfaces (API). • The vendor must have experience using the proposed version of MS SQL server • E   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 10977 while calling.   Other jobs in OR: Orange (1), Portland (22), Salem (38), Tigard (3), Wilsonville (2),    Application Programming Interfaces job openings in other states Jobs List Identity And Authentication Management Project - 92652 - NSP Create date: 23-Sep-2021 start date:10/18/2021 submission deadline: Friday October 8th, 2021 by 2pm CST client info : Education Description: 1. Project Identification: a. Project Purpose and Objective The purpose of this project is to deploy a highly available, scalable.... (This job is for - job Jobs in TN Nashville Consultant - (in Nashville, TN)) C215027001-10 ECM Web Service Development -NSP Create date: 03-Oct-2017 Submission Deadline : 10/17/2017 5:00 pm Client : Project Assessment Quotation (PAQ) Description: Start Date: 11/01/2017 End Date : 04/05/2018 PROJECT GOALS AND OBJECTIVES: (Introduction/Overview, Background, Goals and Objectives) The Information Technology Services Division (ITSD) .... (This job is for - ECM Jobs in MO JeffersonCity Developer - (in Jefferson City, MO)) Drupal Web Development Services - NSPO Create date: 26-Mar-2015 *Description: *Client is seeking sealed proposals from prospective offerors for the acquisition of Drupal web development services. *Required Services: *Base Drupal Development Services: *Upon request of the state agency, the contractor shall provide Drupal development and consulting services for the configuration of.... (This job is for - job Jobs in MO JeffersonCity Developer - (in Jefferson City, MO))     (Engineer: Application Programming Interfaces, MS SQL Server, Functional ODB, Mentor Data Mining Spatial Data in Medford, OR)

Featured Jobs Budgeting Office Consultant (Jobs in Harrisburg, Pennsylvania) PMP Manager (Jobs in Atlanta, Georgia) Javascript Developer (Jobs in Tucker, Georgia) Architecture - - Specialist (Jobs in Raleigh, North Carolina) Typography Power Consultant (Jobs in Nashville, Tennessee) - Consultant (Jobs in Bismarck, North Dakota) SSIS JAVA Analyst (Jobs in Richmond, Virginia) TSOISPF Specialist (Jobs in Columbus, Ohio) Integration IT Specialist (Jobs in Columbus, Ohio) API CI Developer (Jobs in Richmond, Virginia)