Database Design Jobs

135 were found based on your criteria {{ paging.total|number:0 }} were found based on your criteria

show all
  • Hourly ({{ jobTypeController.getFacetCount("0")|number:0}})
  • Fixed Price ({{ jobTypeController.getFacetCount("1")|number:0}})
Fixed-Price - Intermediate ($$) - Est. Budget: $160 - Posted
Hello - I am attempting to build a long term relationship with a developer or database administrator, and the initial task is to design a process for downloading and filtering a large file on a routine basis (i.e., 2x per week), most likely. This initial task will help me become familiar with you and your skill set so that you can hopefully continue to help with long term needs with our company's data. The file size is 4GB, about 14 million rows, and about 45 columns. It is originally in a .dat format. The file is called "Stock V2 Full." It is important to note that an ISBN is an internationally recognized unique identifier for a book. There are two kinds of ISBNs for each book, one is a 13 digit ISBN (ISBN-13) and another is a 10 digit ISBN (ISBN-10). I tend to focus on using the 10 digit ISBN. The goal is for me to use the incoming source file (i.e., StockV2 full) to update our inventory so that (1) the price columns are updated, and (2) the items that are no longer in stock are known via a separate report. Using the reports described below, I will be updating prices and deleting inventory manually (weekly or daily) The attached documentation has been created by the 3rd party that provides the data to me and describes exactly how the process should work, along with data columns locations and formats. It also outlines an option for either using the Main file (titled "Stock V2 Full"), or for using the weekly or daily Delta files to update the Main file. I don't mind which method is used, but I would encourage the design of the simpler, less problematic method. The data file needs to be retrieved (via FTP), and then filtered to provide the following reports, which then will need to ultimately be imported into Microsoft Access 2010 (i.e., Access is what I currently use to manage my inventory). Just ask, and I can send you a small sample of the Stock V2 file. We can use whichever Database system or file splitting tools you recommend, but please also keep in mind that we are hoping to build on this project to add a more robust database management process in the long run. I do have MySQL and and MySQL workbench installed on a desktop computer, but I have not been using it yet, and I am not very experienced with SQL. Below are the reports that need to be filtered from the file, and pulled into Microsoft Access. Note that I will need to have the ability to manually update a .txt file (i.e., IngramActiveInventory.txt) that contains up to 100,000 ISBNS with the active inventory. The resulting reports outlined below will then be related to that Active Inventory File. Report 1 - Out of Stock (and Deletes) Report. This report simply shows items that, compared to the Active Inventory File are no longer available in the Stock V2 Full File. a. filter = 'La Vergne, TN On-Hand Quantity' = "00000000" (see full definition of 'out of stock' on page 5) b. Join to 'IngramActiveInventory.txt' table (mentioned above) b2. Location of Active Inventory Table: C:\Users\***\***\***\Access Database Test\Ingram Access Data) c. Select these 2 Columns c1. ISBN-10 c2. La Vergne, TN On-Hand Quantity d. Append to the report any ISBNs where the Join from IngramActiveInventory.txt does not produce a match (i.e. where the ISBN-10 located in the Active Inventory no longer exists in the StockV2 file). This is simply the list of books in active inventory file that have been removed altogether from the stockV2 file. This list of "deletes" can also be placed in an entirely separate report, if that makes it easier. d. Place resulting file showing all deleted ISBNs and all ISBNs that have a quantity of 0 into Microsoft Access Table, or txt file that can be imported into Microsoft Access e. Final location of report will ultimately be C:\Users\***\***\***\Access Database Test\Ingram Access Data\1002_IngramOutofStockReport.mdb Report 2 - Active Inventory Report - This Report simply shows selected columns from the Stock V2 File, as related to the smaller list of ISBNs located in the Active Inventory Table. a. Filter Stock V2 file where 'La Vergne, TN On-Hand Quantity' > "00000000" b. Select these Columns (see positions of the columns in attached specs, page 11-13) b1. ISBN10 b2. La Vergne, TN On-Hand Quantity b3. Ft. Wayne, IN On-Hand Quantity b4. Price b5. Discount Level b6. Publisher Status Code b7. La Vergne, TN Stock Flag b8. Publication Date b8. On Sale Date b9. Returnable Indicator b10. Media Mail Indicator b11. Product Type b12. Weight b13. Ingram Publisher Number b14. Product Classification Type c. Final location of report will ultimately be C:\Users\***\***\***\Access Database Test\Ingram Access Data\1003_IngramActivesReport.mdb d. If possible, it would also be helpful to set up the option for me to simple queries of the full Stock V2 report (or the list of columns listed above) within Access or MySQL, though splitting may be necessary to do so, in light of the size constraints.
Skills: Database design Automation Database Administration "Extract, Transform and Load (ETL)"
Fixed-Price - Intermediate ($$) - Est. Budget: $2,500 - Posted
We currently have developed several applications within QuickBase. Many of which are integrated through relationships. We are now developing a Project Management Application which is meant to manage all projects and also manage the resources available. We are very interested in being able to view, assign and modify task through a calendar view and also to assign several resources to specific tasks/ projects, so it is easier to manage for our Scheduling Team. Also we would like to incorporate having a table (library of tasks) of standard task, which can be added to the Project, so Project Managers don't have to spend too much creating these. Please
Skills: Database design JavaScript Intuit QuickBase SQL
Hourly - Expert ($$$) - Est. Time: Less than 1 month, Less than 10 hrs/week - Posted
I am trying to get a quote for a project to develop a strategy in Ninjatrader. I am not sure if it is even possible so i need to speak with someone about what you 'can' and 'cant' do capability wise, not only from the programmers expertise but also the ability of NinjaTrader. Basically i want to have a strategy that i would charge for and this would look to a central database every x seconds for orders and if the trader so chooses the would be retrieved and placed for them on their chart/dom. Also management stop order and targets for profit.
Skills: Database design NinjaTrader
Fixed-Price - Expert ($$$) - Est. Budget: $5,000 - Posted
Develop a Social Media Platform/Website revolving around people's passions. The assignment will require web development, web design, and strong database (freebase or equivalent) development skills. Project is one-time assignment but may require ongoing maintenance. Specs are available upon request (and after pre-screening). Looking for a reliable, solid partner. Share of equity possible for the right candidate.
Skills: Database design Database Modeling HTML JavaScript
Fixed-Price - Expert ($$$) - Est. Budget: $250 - Posted
I work with about 50 companies and I'd like to build a database of all the members of their Management Team of these companies (approx. 5 to 15 per company) by starting with scarping the names, titles, company name, emails, phone numbers and mailing addresses of those 5 to 15 company leaders per company. I have the links to the company websites, now I need someone to find the right page where the Management Team are listed and to gather their contact info. Thanks!
Skills: Database design Database Caching Website Analytics