You've landed at the right place. oDesk is now Upwork. Learn about the new platform.

Database Design Jobs

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

show all
  • Hourly ({{ jobTypeController.getFacetCount("hourly") | number:0}})
  • Fixed Price ({{ jobTypeController.getFacetCount("fixed") | number:0}})
show all
only
only
only
show all
only
only
only
only
only
show all
only
only
only
Looking for the Team App?
Download the New Upwork Team App
Fixed-Price - Intermediate ($$) - Est. Budget: $3,000 - Posted
We are a small local business that provides construction leads to contractors. I am looking to redesign our database software (which is out-of-date) and serve it to web-centric software where my clients can search on any and all fields and view/download/print/email the plans & specs associated with each project of interest. I also want to have different logins for members, guests and one time users. Other info: We are looking for a database program that allows you to do data entry on the back end, and have multiple display options for clients on the front end. And an online subscription service to allow you to deliver that information to the clients and selectively provide online plans to subscribers.
Skills: Database design PHP Web design
Fixed-Price - Intermediate ($$) - Est. Budget: $800 - Posted
Looking for a filemaker solution for a dog daycare to keep track of attendance and payments for all our customers. Right know we are using a combination of filemaker and Apple numbers-want to simplify, and make it faster and simpler for our clerks. Needs to be able to track attendance, incoming payments, balances due, and make reports to reconcile cash drawers at end of day. Ability to run it on iPads a plus. Will be happy to share copies of what we use now.
Skills: Database design
Fixed-Price - Intermediate ($$) - Est. Budget: $150 - Posted
GENERAL DESCRIPTION: We are an independent music label and need a tool that processes earnings reports (tab delimited text files), stores them in a database, matches them with our music catalogue and then shows the statistics a user friendly way. A sample report and mockups of the different screens are attached in this job posting. If you feel the budget is too low, please make us an offer. DETAILS: The reports contain earnings from mp3 sales and streams from itunes, spotify and so on. We receive two reports for each month - downloads report and streams report. So there has to be different upload options for downloads and streams. 1. So first of all we would have an ARTISTS tab, where we would create profiles of all our artists (See Mockup 1). We click create new profile and enter artist name, email, and default payout share (Mockup 2). 2. Then we have SONGS tab (Mockup 4), where we add the information for the song - Artist (dropdown menu with the artists from the artists tab), featuring artists (every artist in new field and separatly saved in the DB; option to add more then one featuring artist - may be a + sign next to the box or something like that), Title, ISRC, UPC, SHARE (the share field is filled automatically with the default share of the respective artist, but is editable). The ISRC field would generate automatically but is editable. An ISRC looks like this: BGA741600001. The first component is always the same: "BGA74", then comes the year "16", and then the number of the track "00001". The first track, that is entered in the DB in 2016 gets number 00001 so its ISRC is BGA741600001, the second track - number 00002 - ISRC BGA741600002 and so on. When we choose the main Artist from the dropdown menu, this song is assgined to the artists profile and is shown in it (Mockup 3). When we enter all artists and all songs, we would be able to go to the ARTIST tab, open Artist X's profile and find there all his songs and the total earnings of every song for the respective period (Artist's earnings = Income from music store x Artist Share for the particular song)(Mockup 3). The period is adjusted from a calender selector. When we click on a SONG, the details for that song opens and shows the information (ARTIST, TITLE, ISRC, UPC, ARTIST SHARE) and earnings (Mockup 5). Processing the reports file and matching with the songs in the db: The information from the reports has to be matched to the information from the songs database by ISRC or UPC. This means the script has to look for the ISRC of Song 1 in the report and when it finds a match, it would import the data from the report to the respective songs database. In the report there is only one field - ISRC/UPS. The problem is, that some stores use the UPC to identify the song and some use the ISRC. So the script should look up both ISRC and UPC from the songs db in this field. Also in the ISRC/UPC field of the report there are some stores that put dashes between the ISRC components like this BGA7-416-00001. The script should discard the dashes and any other punctuation in this field in order to match the record with our database, where we would enter the ISRC without any punctuation. If the script can't identify some of the records in the report, a message with the unidentified records is shown and we can manually assign each record to a specific song. 3. Then we have the downloads tab (Mockup 6), which is basicaly a big table, containing all songs and all earnings from all periods. Every coloumn has a filter. The displayed results can be exported in excel. There is a period selector. The coloumns are: Store (matches same field from report), Sales (matches same field from report), Period (matches same field from report), UPC/ISRC (matches same field from report), Artist (matches DB), Title (matches DB), Units (matches same field from report), Country (matches same field from report), Single Price (matches same field from report), Total Income (= Unit x Single Price), Artist Share (matches field from Song DB), Artist Revenue (=Total Income x Artist Share). 4. The next tab is the stream tab. It is the same as the downloads tab, but shows only the stats from streams reports. We would preffer bootstrap or some other nice looking framework.
Skills: Database design
Fixed-Price - Intermediate ($$) - Est. Budget: $1,005 - Posted
I need to create a database and UI to manage my member profiles. I need it to do the following: 1. Integrate somewhat seamlessly with our website 2. Sign-on credentials 3. Store general information about members 4. All for them to upload documents for us and for us to upload docs for them 5. Integrate with our payment app so they can see if they have a payment due 6. Secure Willing to discuss/negotiate cost
Skills: Database design database programming User interface design Web design
Fixed-Price - Intermediate ($$) - Est. Budget: $100 - Posted
right now I have 2 lists of inventory items I am selling both are around 900,000 items long. so a total of about 1,600,000 products total. each product corresponds to a inventory listing, so for example item number 45637 might have 6 listings with different names 45637 = 45637,new+2 45637 = 45637-75648 and so on I use a count if file against a Instock list of item in excel but the amount of listings I have is to much for excel now and it takes forever to process what I need is a program or setup that takes my list of skus (item numbers) and a list of Instock items and will tell me what is not in the instock list and what is in the instock list. its just a big inventory management file. if you know of a better way I would be willing to go that way also. I can send you all my inventory numbers with what instock items they should match to. also I can send you current inventory if you can create something that only outputs what has changed. I set my stock levels at 500 for anything in the instock list so there is no need for actual stock levels. let me know if you think you can help.
Skills: Database design Excel VBA Microsoft Access Programming Microsoft Excel
Fixed-Price - Expert ($$$) - Est. Budget: $3,500 - Posted
Develop an interactive map for recording property level data. Map elements should be clickable with pop-up information, which can be edited or added to. The map is to be for all New York City properties. NYC PLUTO data should be integrated into the app, and easily updated when the city releases updates to this information. Additional fields not currently present in the PLUTO data will need to be added now, with flexibility to add an infinite number of new fields in the future. We can provide design, or work collaboratively on design. All development work needs to be provided. App can function either as a web, or desktop app. Desktop app to be Windows compatible. Web app to be password protected.
Skills: Database design ArcGIS database management Microsoft Excel
Fixed-Price - Expert ($$$) - Est. Budget: $4,000 - Posted
We are looking for a Node.js Developer responsible for managing the interchange of data between the server and the users. Your primary focus will be the development of server-side logic, definition of the central database and data schema, and ensuring high performance and responsiveness to requests from the front-end. You will work with already existing code, based on react starter kit boiler plate, and make sure that server side rendering of some of the front-end elements work correctly. Therefore, a basic understanding of front-end technologies is necessary as well. We are building a staffing platform with both a web and a mobile component to it. Therefore the back-end should be able to work and integrate with both. Responsibilities - Writing reusable, testable, and efficient server-side code. - Ensure a secure and efficient API for data manipulation. Work closely with the front-end developer for consistency in codes. - Designing data schema and and set up database. - Implementation of a safe online payments service system. - Implementation of security and data protection Skills And Qualifications - Strong proficiency with JavaScript (NodeJS ES6) - Experience with setting up online payment system. - Creating database schemas that represent and support business processes - Good understanding of server-side CSS preprocessors (LESS) - Understanding of front-end technologies (HTML5 and CSS. understanding ReactJS would be a plus). - User authentication and authorization between multiple systems, servers, and environments - Understanding fundamental design principles behind a scalable application - Understanding differences between multiple delivery platforms, such as mobile vs. desktop, and optimizing output to match the specific platform - Implementing automated testing platforms and unit tests - Proficient understanding of code versioning tools, such as Git
Skills: Database design HTML5 JavaScript MongoDB
Looking for the Team App?
Download the New Upwork Team App
Fixed Price Budget - ${{ job.amount.amount | number:0 }} to ${{ job.maxAmount.amount | number:0 }} Fixed-Price - Est. Budget: ${{ job.amount.amount | number:0 }} Open to Suggestion Hourly - Est. Time: {{ [job.duration, job.engagement].join(', ') }} - Posted
Skills: {{ skill.prettyName }}
Looking for the Team App?
Download the New Upwork Team App