Database Design Jobs

134 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 - 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 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
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
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
Skills: Database design Database Administration database management Database Modeling
Fixed-Price - Expert ($$$) - Est. Budget: $2,000 - Posted
Hi, My requirement is as below: Say there are 2 large physical servers A and B, as part of a VMware cluster. Server A has 32 processors while Server B has 16 processors. Now as part of this A/B VMware cluster, there is a Virtual Machine C which is created and configured in such a way that the number of physical resources (processors) allocated to this Virtual Machine C can be dynamically changed based on the processing power required. For example, this VM called C, based on the capacity needed, has been dynamically allocated the following resources: 4 Processors have been allocated to the VM at 2pm on 01/Jan/2016. 8 Processors have been allocated to the VM at 4am on 02/Jan/2016. 2 Processors have been allocated to the VM at 7pm on 03/Jan/2016. What I am looking for is a way to actively track over a period of time the amount of resources (cores or processors) that the Virtual Machine C is using. I think this should ideally happen by taking into account the log files from the VMware set-up, and then processing them to find the highest usage and average usage over a period of time (say 3 months, 6 months or 12 months). Please let me know if you are able to accomplish the job. The budget for this assignment is flexible.
Skills: Database design Virtual Machine Virtualization VMware Administration
Hourly - Expert ($$$) - Est. Time: 3 to 6 months, 30+ hrs/week - Posted
We are looking for a high level SQL DBA with significant experience in performance tunning and deadlock resolution to consult with on our custom DB driven application. The application uses MS SQL Server, and it has some real-time processing requirements as it interacts with both a phone server and crm system. We only have about 150 users, but are having some considerable deadlocking issues, as we have a lot of dependency on a few resources. We have identified and serialized all parts of code which cause deadlocks, however we need someone with considerable experience and ability in performance tuning / deadlock resolution to do a thorough review of our database, and optimize it to resolve all deadlock causes.
Skills: Database design Database Administration database management database programming
Fixed-Price - Intermediate ($$) - Est. Budget: $1,000 - Posted
I want a very simple MS Access database (or any other form of database, does not have to be Access), for a small recruitment business, with maybe 2 or 3 users. It should: -Enable us to enter information about candidates -Enable us to enter information about employers -Enable us to enter information about job openings -Produce a list of employers, for each candidate, whose job openings match the candidate's skills -Create an e-mail for each candidate entered, sending them information about the relevant job openings -Have a search function, for us to find specific candidates based on their skills -Send out e-mails to groups of employers and candidates
Skills: Database design database programming Microsoft Access Programming