Database Modeling Jobs

22 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 - Entry Level ($) - Est. Budget: $200 - Posted
I'm loooking for someone to develope a large searchable Database the has a web front end gui that users can search through, the web front end must have a login account for each user and each user can then perform searches based on such items such as email address, user names, name, sir name, password etc If you are interested please contact me for further deatils, a suitable proposable such as what type of database is suited and why should be highlighted in the proposal
Skills: Database Modeling Database Cataloguing Database design database programming
Fixed-Price - Intermediate ($$) - Est. Budget: $2,500 - Posted
In search of someone who can take data that is currently stored in an Excel spreadsheet and convert the data into a database. The database will need to be made relational as look up queries will need to be run against the database. Once the database has been created, the database will need to be customized in such a manner that an end user can go to a website and enter the desired search criteria and get a result returned. For example, something similar to but not exactly like the look up feature used on the following site: (Configure & Price): http://www.uprinting.com/custom-labels.html We've looked at using Microsoft Azure as a solution but am open to solution ideas Project timeline: 30 days
Skills: Database Modeling Database design GUI Design
Fixed-Price - Intermediate ($$) - Est. Budget: $500 - Posted
We are looking for a backend developer to create a website with user accounts, registration and login and profile pages. The website is a web catalog for event services - a „free event agency“. The catalog will list „projects“ and „events“. We will cover these two terms in the following text. The website will be launched in German, we plan more language versions in the future. System language and backend language is English. Future language versions will all use the same database. This requires for a multilingual database. We want you to deliver the database architecture and the html/php/… skeleton pages. We expect good and elegant code as well as great commentary/documentation for your code. You don’t do any front end design. It may be a good idea to use a noSQL database. Please share with us all frameworks and techniques you would like to use. We will give more detailed specifications, once we have chosen a candidate and discussed what framework we will use. Feel free to ask if you have any questions! PROJECTS -User registration with email, username and password, with email verification. -users can create „projects“ to present their service. -projects contain (amongst other things): project name, project main_category, project more_cagetories project profile_photo, project photo_gallery, project youtube_URLs, project soundcloud_URLs, project website_URL, project city, project ZIP_Code, project street, project country, project geolocation -from the project address (city, ZIP-Code, street, country), we need an automatic calculation of the geolocation. We need a free geocoding service like openstreetmap. Alternatively you can recommend other options. -the project category is to be chosen from a multilingual collection of categories in the database. (E.g. en: Wedding Band, de: Hochzeitsband / en: Jazz Singer, de: Jazz Sänger). en=English, de=German. There will be several hundred categories, each one in several languages. -each category has at least one parent category. Parent categories are again multilingual. -rating system for projects (one to five stars, different rating-categories). Everybody can give a rating. Should be protected via re-captcha or similar. -rating categories are multilingual - Any user can create any number of projects. When creating a project, the user is stored as Project Creator. The Project Creator of a project is supposed to be changed never.At the same time, the Project Creator will be a Project Administrator of the project. A project can have any number of Project Administrators. Project Administrators can administer/edit the project. Any Project Administrator can add or remove further/other Project Administrators. Project Administrators can give up their Administrator status if they wish. -project pages are dynamic pages and get an own URL: www.ourwebsite.de/project-name EVENTS - a project (not a user!) can create an event. - „event owner“ and „event administrator“ roles will work on the same principle as for projects with the only difference that projects administer events. - for events, we will call the administrators „event hosts“ - event pages contain( amongst other things): event name, event category (from multilingual collection), event address, event profile photo, event photo gallery. - event pages are dynamic pages and get an own URL: www.ourwebsite.de/event/yy/mm/dd/event-name OTHER PAGES ON THE WEBSITE - home page We need two search fields, WHAT? and WHERE? WHAT: Autocompletion with the categories of our category collection in the current language. WHERE: A city. Search Results: list all projects which match the category. Sort by distance, rating, or alphabetically. -events: We need two search fields, WHEN? and WHERE? WHEN: A period of time, start date and end date. WHERE: A city. Search Results: list all events that match. Sort by distance. -about (static page): text. -contact (static page): text.
Skills: Database Modeling Geolocation Website Development
Hourly - Intermediate ($$) - Est. Time: More than 6 months, 30+ hrs/week - Posted
Looking for an experienced SSRS report developer. Should be highly proficient with authoring/maintaining reports using Visual Studio and Report Builder. Must be highly proficient in Microsoft SQL Server, as well as solid understanding of relational databases. Must be highly proficient in data modeling, as well as ETL techniques. Must be highly proficient writing queries, stored procedures, functions, views, dynamic SQL.
Skills: Database Modeling "Extract, Transform and Load (ETL)" Microsoft SQL Server Programming Microsoft SQL SSRS
Fixed-Price - Expert ($$$) - Est. Budget: $500 - Posted
Core task: Normalize the database of our home grown platform to maximum level i.e. 3rd or 4th Normal Form. DB Structure: 238 Tables 40 - 60 GB data space PostgreSQL 8.4 Data present from day 1 without any archival End result / what do we want to achieve? Keep all DB backed up Only present 3-6 months data in the active DB Automatic archival of DB which is older than 6 months Why Normalization and archival are necessary? DB will become stable Insertion of manual / external records will be possible Removal or any other major operations will be done on front side / view of DB and actual DB will have no impact of any such operation Speed will increase exponentially. Who can do the task? DB Designer DB Normalizer DB professional How will it be done with live platform? Deploy latest backup DB on a separate server and give full DB access to the resource. Once operation is successfully completed then migrate it to Platform Manually inject any missing data during the migration process Key elements / points to be kept in mind of designer? - Provision to add tables - Methodology to change DB will be required. - Complete documentation and guidance to handle the DB will be required.
Skills: Database Modeling Database design database management database programming
Fixed-Price - Intermediate ($$) - Est. Budget: $2,000 - Posted
Looking for an experienced developer/team for a webapp to handle visual interaction response systems. We provide our clients with Interactive Vocal Response systems ("If you want to speak with support, press 1", etc.) and the corresponding interaction services (phone, chat, etc.). Now, we want to provide our clients (the companies) with the option to offer their own clients (those looking for support, information, etc.) access to a similar system on the web through their mobile. The flow is: our client's client calls our client's number and while waiting to speak with someone, receives an SMS with a personalized URL, which will allow them to open the webapp to monitor and control the current call. You will develop this web app. The web app will allow communication with external platforms to control the media flow through APIs (for instance to switch waiting lines, retrieve the expected waiting time, etc.). The APIs are OUT OF SCOPE of this project but their integration with the web app should be flexible enough to accommodate varying situations (cf. Admin mock-ups). Deliverables include: database, final client front-end, company front-end (to setup their own interactive visual system on our platform) and our back-end. Specifications documents available here: https://drive.google.com/a/prasquier.com/folderview?id=0BxihsQW4FxylOWpZLUZHVUhqYk0&usp=sharing
Skills: Database Modeling Laravel Framework Mobile App Development PHP
Fixed-Price - Expert ($$$) - Est. Budget: $1,100 - Posted
Study the database needs of our applications and optimize them using MongoDB and NoSQL. Improve database performance and capacity planning. Provide recommendations on database models. Write documentation and collaborate with technical peers online. Must be able to travel to the US for 1-2 weeks of on premises analysis. This opportunity is only available to consultants in the Greater Toronto Area.
Skills: Database Modeling MongoDB