Database Administration

Charlesbank Ventures, a Boston MA USA leader in enterprise systems for the real estate industry, is currently seeking the re-programming of several dts/import processes and supervising those over 4 to 12 week period. The bid should be responded to on the initial coding and 30 days monitoring of its success. The project consists of importing a group of 40 cvs files using dts, converting them using existing transformation packages (java), and loading them in sql server. The previous administrator of these tasks spent approximately 3 hours per day on administration, though we expect the winning bidder to spend initial more than that, but subsequently lesser times testing its repeadatable success. The bidder will be expected to take the data from the cvs file, transform it with exiting java code, and ensure that each file is accurately reflected in the sql server table. Upon initial selection, bidders will get samples of the input and output files. ## Deliverables 1) Successful bidder need to sign the companies NDA. 2) Quality of the mirroring is important, so final payment will be based upon accuracy and timeliness of operations. 3)Support will be provided by a 24x7 team of dba's for administration and performance of the servers through the week. 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 SQL Server, TSql. Candidates with ASP experience, and shell scripting will be given top consideration. The winning coder will possess expert level proficiency in the administration of sql server functions including DTS packages, stored procedures, jobs, and tsql statements. Candidates must have ip connectivity of effectively 128kps to our server center in Medford MA, USA.