Database Design Jobs

128 were found based on your criteria {{|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 - Entry Level ($) - Est. Budget: $150 - Posted
If you're a database guru, preferably MS SQL server, this should be a fairly straight forward project. I sell products online. I use an auction website that I have to list products on. I have an HTML template which I fill in the variables using product data from 4 different product suppliers. My suppliers update their data a few times a day, I would like a SQL procedure to automatically download, import, and repopulate the data into the HTML template each day. That way everytime my suppliers add a new product, it would automatically be added to my online inventory. Each supplier has between 15,000 and 45,000 products. Each supplier will have some unique products, but many will overlap. Even though some items will be the same across each supplier, I still want to assign unique product ID's (SKU) to every single product. I'll need this for my point-of-sale system I'm working on down the road. I'm open to other programming languages, but I choose SQL because I am somewhat familiar with SQL so I can make small changes myself if necessary. To summarize: I have 5 different suppliers 1 HTML template I need to automatically download (HTTP and FTP) these datafiles (some CSV, XLS, Access DB) The "script" or "query" should run 4 to 6 times per day to recomplie this product data into a database. There should be a field in the database that holds all of the HTML data. I have current examples that I can send over to you, but they are greater than 5MB so I can't attach them to's site. Data is in the following folder so you can see what we're working with. You won't need all files, just some of them. 5 of these suppliers have data, 2 will not so ignore them. Main data files (you can see these in dropbox link) chattanooga - InventoryList_08_24_16_Morgan.xlsx greensupply - gsprods.xls gzanders - zandersinv.csv & detaildesc.xml (more data that needs imported about each product) williams - willshoot_items.czv rsr - rsrinventory-keydlr-new.txt & attributes-all.txt These files won't always be in dropbox, they are available via FTP and HTTP download from suppliers. I want to COMPLETELY automate this process. Download, and import into on big master table that I can work with. The HTML template is also included in this Dropbox link. Feel free to ask questions, maybe you have a better idea about how to do this?
Skills: Database design database programming SQL
Fixed-Price - Intermediate ($$) - Est. Budget: $300 - Posted
At first, I'll try to explain the context of what I'm looking for. I'm director of a Pathfinder Club, also knows as Pfadfinder (German), Desbravadores (Portuguese) or Conquistadores (Spanish). We are an organization similar to Scouts, that work with children of different ages. We meet every week to develop activities related to nature, physical skills, social works and so on. We perform several activities weekly that need to be tracked and appointed, giving notes for their presence and performance during the year. Think of that as a class sheet that a teacher use to evaluate the student during the year. We have used from Excel spreadsheets to mobile apps during the last few years, but now I want to go further. So basically what I need is the following: - Create moderator or administrator accounts/users, each responsible for evaluating different group of users - Create/add members, with several fields for information - Update the member database, manually on the app and from external sources (.csv for example) - Create group names and add members to those groups - Weekly update and give points to each member in by different criteria - See an online summary of members and points, ranked by total points or by criteria - Export this summary of points or other reports. AND MOST IMPORTANT: - Add these points to a common online database, which will be updated every week by different moderators. I've attached a pdf file which contains schemes of what some screens should look like. I'm actually from Brazil, but there would be no problem if the the app is developed in English. Further information on next contacts.
Skills: Database design Android Android App Development Data Backup
Fixed-Price - Intermediate ($$) - Est. Budget: $100 - Posted
*MUST be proficient with google sheets *MUST be completed within a few days *MUST include the process for transforming sheets outlined/shared in a document *Confident & Capable Applicants to apply ONLY PROJECT: We have multiple living google sheets "calling lists", that we use to make appointments for clients. We need to convert qualitative data within these sheets, as it is being entered, into a linked summary sheet showing the quantitative data conversions. We are trying to tally up the information from the lists onto a real time summary page. In short, we want to track the number "dials", "contacts verified", "contacts qualified", etc. from a master google sheet list into a separate progress report snapshot. We currently have (10) lists were calling into and entering data in daily - more to come Here is a link to a copy of (1) of the (10) sheets, all structured basically the same (private information/columns not relevant to data gathering have been removed): KEY FOR DATA CURRENTLY IN LISTS Column A = Rep Name Column A * if colored (purple or pink) = signifies a particular campaign Column B = Status (Choices: In Process,Partially Verified,No Longer w Co,Referred To Another,Not Qualified,duplicate contact at the company,Refusal,Do not call,disconnected/ not in service,L&L Appt Set,Rep Appt Set,VM Left,Emailed Info,Permission List- but no Appt Set,Verified & Qualified,Already Customer- not interested in appointment) Column E = Particular Campaign (Mailer #1 or Non-Mailer - currently) more campaigns to come Currently, we are not auto pulling any of the data from the lists into our tracking summary sheet, it is all manual input. Aside from being manual input, we are not tracking everything we want. Here is a link to a copy of our current tracking sheet: We are wanting to track the following AUTOMATICALLY/Real Time from our (10) call lists. We need to know the following from each list, as well as the list combined totals on daily, monthly & TOTAL basis: Dials Connects No Connects Voicemails sent Surveys Sent Verified & Qualified (and which REP this was done for) LnL appointments Set (and which REP this was done for) Appts Set (and which REP this was done for) Declined/ Refusal Email Attempt Call Back Requested Call/Appt Setting Time Data Correction Time Spent Campaign Specific Information: Number of targets in particular campaign, Number of targets for each rep per campaign, Number of LnL Appts, Number of Appts, Number In Process, Number of Declined/Refusal & Conversion Ratio (this type of information is currently in the "List Correlation: Mailers/Cold Calls Tab) LINK: To show what we're trying to do:
Skills: Database design Data Analytics Data Entry
Fixed-Price - Intermediate ($$) - Est. Budget: $50 - Posted
We are coming up with a Paas (Platform as a service) and we need someone to create the design and architecture of the web interface for this service. The main motive is to use efficiently the resources we have and come up with state of the art design for the web application. We are planning to use php and apache web server for this but we can discuss if you have better solution for this. Paas is a multimedia service so its important that you have some previous knowledge and experience of multimedia software solutions. Developer shall have experience in design of large enterprise applications. Output of this task will be a word document describing the design and architecture of the web interface.
Skills: Database design HTML5 PHP Web design
Fixed-Price - Expert ($$$) - Est. Budget: $2,500 - Posted
I need someone with in depth experience building and maintaining a large scale email application. I am looking for expert assistance in building an SMTP email application to include the following: -Email sending application -Proper setup and maintenance of all required records (mx, spf, etc...) -Campaign management - ability to send and track multiple email campaigns -List management - create, maintain and track multiple email lists -In depth knowledge of bulk email and deliverability - inboxing
Skills: Database design database management Email Deliverability Postfix SMTP Server
Fixed-Price - Intermediate ($$) - Est. Budget: $2,000 - Posted
We require a mobile friendly web application The theme is for based on ERP, CRM, MRP and towards the Fresh Produce Industry. The site will have the following users: - Admin - Area Manager - Suppliers - Trade Customers - Domestic Customers [consumers]. The site needs to offer the supply and services of registered butchers, who list their products, list the price available, list a trade customer price, list a consumer price, assign volume discounts. In addition to the general stock management, listings, ordering systems, tracking etc, the site also needs to have a customer loyalty program, whereby customers can earn points on purchases and earn rewards, to use such points, on future purchases. The development requires a well researched analysis on the languages and components. This is highly critical, so that there are no issues in future and all aspects are extensible, and the application is also scaleable, within minimal fuss at future points. The successful candidate must be able to carry out the pre analysis of the project, prior to it going to the development phase. This includes all wireframes etc, after having discussed and gone over the requirements. This part need a lot of experience and background in systems, to be able to intuitively pick up on various aspects, functions, the way process flows and such things in the world of ERP, CRM, ONLINE ORDERING, SUPPLIERS, DELIVERY, STOCK MANAGEMENT etc. The development also requires a great level of creativity, with new and more efficient ways of developing and presenting the solution and its respective functions. We would ideally require the development team to be ongoing dedicated to this project, to carry out ongoing work and enhancements. To be successfully considered for this role you must demonstrate: - up to date knowledge - an ability to track and report on the development process seamlessly [ideally having a job management portal, and not just communicate from emails only - a mock up on your own servers - a willingness more to develop solutions on contract for an ongoing level as the foremost principle - a regularity and being up to date in communication, responses, and not "disappear" for periods of time - references - a reliable background - consistency in the discussions and enough patience to allow for our customers to make up their minds and decisions. - a dedicated solutions developer, and not just a "gamer" trying to make a few bucks on the side. Thus vital in knowing business processes and development methods of management. - a written demonstration from your end, on how you see the project, your idea of it, and how you are able to also enhance and add ideas and value to the project [to which you will be rewarded well]. The initial seed project budget to get up and going is $AUD2500. This is also an ongoing project with more additions at stages after the first stage for seed deployment has been completed. Quotes that are considered are based on what you as a development team can offer for that amount, and the quality and churn in a reasonable time frame.
Skills: Database design SQL