Database Design Jobs

145 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: $2,000 - Posted
Apply if you had experience building 2-way integration with OTA's such as Expedia, Booking.com or Agoda. You obviously have to be really good with RESTful API development. More specifically, we already have Channel Manager built that integrates with Expedia and Booking.com. We need you to build integration on top the existing app that communicates with myAllocator & Siteminder.
Skills: Database design MySQL Programming
Fixed Price Budget - Expert ($$$) - $250 to $600 - Posted
We are trying to find a solution for a small publisher that owns four websites. Our goal is to create a dashboard for them so they can access their reporting easier. Please see the link for further details and provide us with the information needed. It describes the process that is needed to get the result we need for each month of reporting. We need to create and easier solution for entering the data in the backend. Then a user friendly front end for the client. https://drive.google.com/file/d/0BySt42-L-GoQZXBfaVd2cm91TEk/view?usp=sharing
Skills: Database design Microsoft Access Programming Microsoft Excel
Fixed-Price - Intermediate ($$) - Est. Budget: $80 - Posted
basically, it is the relationship that confuses me and i couldn't fix it. The requirement is when the tyre of the truck needs to be changed and when the truck is fueled, i need to record them - those are the number of tyres that each truck has (extended later), truck number, driver,.............First, i need the access expert, so that i can describe my requirement more in details.
Skills: Database design Data Entry Database testing Microsoft Access Administration
Fixed Price Budget - Expert ($$$) - $4,000 to $6,000 - Posted
The project will deliver a centralised company intelligence repository that enables easy storage and rapid retrieval of information relating to the activities, specialities and geographic scope of companies operating within the international real estate and investment sector. To ensure compatibility with other systems, the database will need to be developed in SQL Server, with all data tools coded in .NET. Over time, the database will provide a universal backbone for a number of public and private directories, intelligence systems and CRM tools and while these will not all form part of the initial phase of development, the long term context of the project may require some consideration. Database Structure The business already holds significant data in various data silos and non-integrated systems. Once the new structure and tool set is complete, the existing data will be migrated, system-by-system. The new database will initially hold 5 types of information: - Company: company-wide information stored at organisation level - Office: branch-level information for one or more offices in a Company - Contact: information pertaining to an individual within an Office or Company - Account: data that defines the parameters of any relationship with our business - Activity: enquiries, meetings, event attendance and other transactional logs During 2015, a piece of work was started to define the database table structure and the relationships between them. While this project was not fully completed, it does provide a useful starting point for the project. Data Associations Companies may have one or multiple office IDs, Account IDs or Contact IDs associated with them. Office IDs have a fixed association with a Company, but may have multiple Account or Contact IDs. Each Contact ID may potentially move between Offices, Companies and/or Accounts. Activity may be specifically associated with a Contact, Account, Office or Company. Database Tools 1. Add Record Critical to the organic growth of the system is the capability for research staff to quickly and easily add new contacts, offices and companies, with minimal effort or cross-checking of records. - Mandatory Fields Very few fields should be mandatory: Company Name and either email or telephone. - Assumed Data Where only one Contact or Office is added for a Company, data can be cross-populated automatically, in order to populate fields such Email, Phone 1 and 2 across both tables. - Potential Matches While the Company ID is the primary key for this data, there should be Ajax matching on certain fields, such as Company Name, URL, email and telephone number, to automatically check for existing records with the same value. 2. Bulk Import A function should be created that allows bulk importing of data, provided it is in a compatible structure. This should be a CSV or Excel file, formatted to match a specified set of column headings. 3. Merge Records As disparate data sources are cleaned up over time, it may be necessary to merge specific records. Ideally, where there are different values for the same field, it should be somehow possible to select which value to retain and which to overwrite 4. Edit Record A single page input form should be used to for editing any data that can be modified manually by the user (with a log of any changes). There is already an existing page for managing our customer information - it may make sense to restructure this page to accommodation any new data fields. 5. Auto Create New data is available daily, as a result of our client campaigns, our outreach activity and our internal marketing. Where responses are created and no match can automatically be found, a new record should be created in the Company / Office / Contact table. 6. Search Database The search module is a key component of the initial functionality. A simple form should allow fast retrieval of matching records, using a variety of parameters to filter the results set, with matches displayed in an easy to digest format. Search fields should at a minimum include the following: Company Class, Country, Geographic Focus, Specialisation, Geographic Areas, Priority, Call List, Status (see below). The results should be presented in a snapshot view, with key data compiled into an easy to digest format, with additional information available as an Ajax call on hover, allowing the user to expand on the information initially presented. Tick a tickbox to add new matches to the pre-selected Call List. 7. Call List Call lists are lists of companies to contact in relation to a specific piece of work. These should be managed from a Job Management page, where they can be created, deleted or retrieved. The retrieve function should be exactly the same as the Search Database results, wwith an additional status filter and a status for each record in relation to the job in question. The statuses should be a simple traffic light system, with Success, Progress, Fail as the 3 settings.
Skills: Database design ASP.NET ASP.NET MVC C#
Hourly - Expert ($$$) - Est. Time: More than 6 months, 30+ hrs/week - Posted
Binary.com is a binary options company with offices in Malta, Malaysia, and Japan. Founded in 1999, the company has been recently undergoing fast-paced growth, and is seeking to recruit an experienced PostgreSQL DBA to assist us with scalability and performance of our databases. Our main PostgreSQL database currently processes over 1 million transactions per day, and is expected to grow further in the near future. The other elements of our technology stack include Linux, Perl, Mojolicious, Starman/PSGI, Redis, Chef, nginx. Required skills include: - ability to understand a complex relational model - experience with large PostgreSQL deployments - confident in MVCC - PLPGSQL and SQL - triggers and notifications - ability to find missing and unnecessary indexes - physical and logical replication - monitoring - OLTP and OLAP - Perl knowledge would be a plus - MDX and icCube knowledge is a plus - experience with OLAP cubes would be a plus Interested candidates should attach their CV and detail their experience with large-scale PostgreSQL deployments. Thank you.
Skills: Database design database management Database Modeling database programming
Hourly - Entry Level ($) - Est. Time: 1 to 3 months, Less than 10 hrs/week - Posted
Hi As described on the title , online tutor needed urgently for daily online classes in Computer Science . the areas should include , Computer Science basics , Data Structures , Data Types , Algorithms , Networking etc . please if you feel you have something to pass feel free to contact me . thanks
  • Number of freelancers needed: 2
Skills: Database design Algorithm Development Computer Networking Data Structures
Hourly - Intermediate ($$) - Est. Time: Less than 1 month, Less than 10 hrs/week - Posted
Frontier Health currently has a database (excel spreadsheet) of medical devices and companies and it's difficult to navigate. We need a freelancer to design a database with improved functionality that makes it easier to find and enter information, and to migrate the current database into the newly designed one. Currently there are nearly two hundred products, but we expect this to grow to over 1000 products. Eventually we'd like to link the database to our website, but that is a far off goal and is a long way from the current timeline. We'd send our current database and get your thoughts on how best to move forward. We hope that this is a relatively quick turn around project, 1-2 weeks, but will rely on your educated guess as to the timeframe. Knowledge of excel and other, perhaps more applicable database systems is imperative. Understanding how to hyperlink and display different sets of information, depending on the audience. Knowledge of how database systems link to the web is also important. Please include your background (including similar projects you've worked on), your hourly rate, and an estimate of the number of hours you believe this project will take (understanding that you have limited information at this time). Thanks and look forward to hearing from you -
Skills: Database design database management database programming Microsoft Access Administration
Fixed-Price - Intermediate ($$) - Est. Budget: $4,000 - Posted
We have developed a database program for our school using Filemaker Pro 12. We are very far along in completing this database. However, we have not started working on the online portals. Our goal is to upgrade the current database to FMP 14 from FMP 12 and then build the online portals in FMP 14. Aside from the web portal components, the remaining parts of the database is almost complete. DON'T BID ON THIS JOB WITHOUT LOOKING AT THE DETAILED FEATURE LIST WE ARE INCLUDING. Also let us know how long it would take for you to complete this job. Please note that we will allow you access to review the back-end of our current database before we finalize the hiring of the freelancer.
Skills: Database design FileMaker Graphic design User interface design
Hourly - Expert ($$$) - Est. Time: More than 6 months, Less than 10 hrs/week - Posted
Hello, I’m glad to meet you. Maybe you are interested in this job. I would be glad to get a short response, thanks. What we look for: A freelancer / staff who has skills in Microsoft Access Administration, Microsoft Access Programming, Database design, Database Modeling, database programming, Online and web applications (not the focus on mobile applications) and is interested in doing interesting job for smart start-up activity. What we would like to be solved: • Requirement 1: Data-Entry Procedure (manual, automated) - Focus in designing the manual (by human) and automated data management. • Requirement 2: Database Infrastructure - Focus on set-up of infrastructe either on local server or on cloud, depends on worldwide online data entry, security,… • Requriement 3: Workflow Design and User-Interface Design (UI) - Focus on design and development of the workflow und UI. • Requirement 4: Category List Management - Focus on management of hierarchical data sets, key words with „relation factor“ (to be explained) We would like to prefer MS Access due to our reasonable experience and well established interface to excel and ms office at all. We have started MS Access database with some tables, forms, queries… on a desktop/server version. Users of this database can be experts as well as absolut beginners (e.g. for simple data entry). How we would like to start: 1. A paid Interview focusing on set of questions about our database vision, strategies and requirements. You will get the questions before our interview. I can explain the question in interview if desired. After the interview please make a short summary of your answers. All be on fixed price or hourly rate. Please make your proposal. 2. After internal review and discussion we would like to set a second interview with further questions, if necessary. 3. After that we talk about future cooperation. Who we are: We are a smart start-up „Sensing Innovations“ from Germany with good funding in background and looking for longterm cooperation freelancer experts. I’m responsible to design and realise our database with specific requirements for B2B in the field of Market & Technology Intelligence Reports with analyst experts and latest machine learning technologies. Thanks for your interest and we are glad to hear from you, Kind regards, Thomas
  • Number of freelancers needed: 2
Skills: Database design Database Administration database management Database Modeling