We are in need of click-stream data warehousing. We need the database converted from an existing schema to fit into a data-warehousing model. We also need new SQL statements written for the BI reports we provide. We will need to port all of our existing data (more than 3 million records) into the new DW schema. Currently we are using PostgreSQL but are looking to move toward a more robust database for BI Workload (currently looking into Bizgres [login to view URL]). However, we are open to other database suggestions to be used for large live-update click-stream data marts that are scalable and extensible. We are looking for a full solution. We need the schema written (for data warehousing), all of our SQL statements rewritten and tuned for the new data warehouse (around 50 statements), an ETL written to move over 3 million records to the new schema, a new SQL statement for adding new clickstream data (live data coming in) to the data warehouse, tuning on the database to ensure we can handle heavy click-stream loads and large amounts of data. It must scale and be extensible. If you are not proficient in data-warehousing, please do not bid.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
Linux, Apache, PHP, PostgreSQL (Bizgres) This is for an existing web based application.