Submissions Due 6/1/12
12 month contract
DDOE – 1200 1st St NE, 5th Floor
This DDOE Project seeks to link together the data from 17 different “databases” into a system that can initially provide (1) DDOE Management and the District Council with real time reports of the status of our investigations, compliance actions and enforcement cases (“ICE”) for all data,.(2) members of the public/others with non-confidential information regarding concluded enforcement actions and investigations and (3) provide varying levels of access for other data depending on the individual. (This is “the Project” or “the ICE Project”.)
The project seeks to provide integration of the present and anticipated DDOE ICE Systems databases to a common interface that will allow one-time data entry and report generation, even if data are actually stored in different program formats. Additional hardware, particularly, storage and processing capacity, may be required.
The interface and access should be through web-based systems, whether the DDOE intranet or the agency’s public internet website. While initially the system might be accessible only over wires or through existing wifi clients, ultimately field staff should be able to use a wireless account. The system should be made ready for future access through smartphone apps.
This project requires a strong background in Quickbase and the use of MS Suite migration tools for Access, Excel and good XML experience.
After concluding the assessment for the requirements, the Architect will be responsible for the implementation, installation, testing, training and documentation of the “ICE Project” Data Warehouse:
• Implement multiple methods of data extraction.
• Write Packages, Procedures and Functions for data transformations.
• High level of expertise in parallel operations and parallel executions.
• Maintenance and support of Materialized views.
• Support for data profiling, meta data analysis, data modeling and relational schema.
• Backup & recovery
• Create data models, develop Data Warehouses and relational databases (MS SQL Server)
• Works well as a team and independently.
Required Experience:
Experience with building and maintaining databases (Required 5 Years)
Experience with data migrations (Required 5 Years)
Experience with GIS Integration (Required 5 Years)
Experience with Quickbase (Required 5 Years)
SQL Server Database Management Experience (Required 8 Years)