I need a time series database and data warehouse developed, with PostgreSQL as the database backend. You must have vast and detailed experience with PostgreSQL - especially in terms of server programming (particularly procedural languages but also,triggers and functions). Knowledge on performance tuning, optimization and any gotchas that may entrap the unwary is a definite plus. Demonstrable (i.e. verifiable from past projects) experience of designing a data warehouse using a relational database, preferably PostgreSQL is a requirement. Any experience with the S language (from SPLUS) will be a huge advantage. Knowledge of XML would be useful in making the realtime data parser more configurable. I am a system architect/programmer by profession, and I have already prepared most of the functional and technical specs, along with benchmark tests and data. It will be up to you to provide the optimal database design, given the requirements spec. Regarding the Java programming element of this bid request, it is worth pointing out that as a fellow programmer, I will very easily spot the ff: sloppy programming, 'extreme programming' or 'workaround hacks' - so don't respond to this bid request if that is your style of programming. You must be familiar with design patterns and object modelling concepts such as UML etc. The database application will have two main components/parts: 1). A realtime data collection daemon (this is currently written as a Linux application in C/C++ and needs to be re-written in Java as an EJB). 2). Data maintainance part comprising of queries, stored procs and data warehousing/archiving. The data to be stored comprises of the following: 1). realtime data collection (to be made available to users at different time resolutions -i.e. some users want data at x minute intervals, others want data at y minute intervals, others at daily intervals etc, etc ..). 2). Historical time series data 2). Data warehouse component - Historical management accounting and transactional data (to facilitate the creation of drill-down management reports)
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).
Linux (Redhat v. 8.0)