Dbms Projects
Looking for freelance Dbms jobs and project work? PeoplePerHour has you covered.
Post an offer to educate them
Past "Dbms" Projects
Database Management System (DBMS) Migration Specialist
Job Description: We are seeking a skilled Database Management System (DBMS) Migration Specialist to assist in transitioning from Google Sheets to a more robust solution for managing production data. The successful candidate will be responsible for recommending and implementing the migration to a suitable DBMS, such as MySQL or PostgreSQL for structured data, or MongoDB for semi-structured data. Integration with data integration tools like Apache NiFi or Talend will be required to streamline the migration process. Additionally, expertise in utilizing BI tools like Tableau or Power BI for data analysis and visualization is essential to enhance decision-making processes. Consideration of cloud platforms such as AWS or GCP for storage solutions will be part of the project scope. Skills Required: Proficiency in database management systems, including MySQL, PostgreSQL, and/or MongoDB. Experience with data integration tools such as Apache NiFi or Talend. Familiarity with BI tools like Tableau or Power BI for data analysis and visualization. Knowledge of cloud platforms such as AWS or GCP for storage solutions. Expertise in frontend frameworks like React.js or Angular, and backend technologies like Node.js or Django. Experience Level: Intermediate to Expert Budget: To be discussed based on experience and project scope. Timeline: Flexible, with preference for timely completion. Communication Preferences: Regular communication via email, messaging platforms, or video calls as needed. Additional Requirements: Ability to recommend and implement the most suitable DBMS solution based on project requirements. Experience in migrating data from Google Sheets to the chosen DBMS. Proficiency in setting up data integration pipelines and configuring BI tools for effective data analysis. Familiarity with cloud storage solutions and best practices for data management. Strong problem-solving skills and attention to detail. Portfolio or Sample Work: Interested candidates are encouraged to provide examples of previous DBMS migration projects or relevant experience. Terms and Conditions: Terms and conditions will be discussed and agreed upon before the start of the project. Call to Action: Interested candidates are invited to submit their proposals, including relevant experience and proposed approach for the project. Review Process: Proposals will be reviewed based on qualifications, experience, and proposed solutions. Shortlisted candidates may be contacted for further discussion.
opportunity
Software engineering and agile
Need a python developer you would be creating a help desk ticket system used in an organisation for this assignment task 1 Use Python programming language and an appropriate framework, IDE, DBMS to build and test a web application based on an agile software development approach that satisfies the criteria detailed in the requirements and guidelines section above. Evidence required: • A summary/explanation of the application and any dependencies (This could be included in a read me text document). • A Source code that can be submitted in any of the following options: o Option 1: A URL to an online source control repository such as GitHub. o Option 2: A zip file of all coding artefacts, including the database. o Option 3: MS Word file containing the source code for all coding artefacts as text (copy/paste), plus screenshots of the running application used to perform activity in the application. • A running web application hosted on a free public cloud platform such as Heroku, AWS or Azure Task 2: Report on Web Application (10%) suggested word count 500 words Explain the elements you used (or could have used) based on an agile framework in the development of your web application. Explain what each of the elements does, how you may have used it and where possible provide evidence of its use in your web application development. Evidence required: • A brief explanation of the web development project and artefacts. • Task 3 – Report on Agile Overview (20%) – suggested word count 1000 words Select a framework of Agile software development approach that is of interest to you and your organization in relation to various aspects such as: · running IT/software development projects · running IT/software development teams (including roles and responsibilities of team members) · measuring IT/software development operations and tasks · automating IT/software development operations and tasks.• · Compare, contrast, and critically evaluate the chosen framework against other Agile software development framework such as SCRUM, KANBAN, LEAN, etc. Ensure that you cover all the important features of agile project development principles that relates to the framework you have chosen. · Propose an improvement to the chosen agile development approach in a way that would benefit your organisation. Suggest ways of implementing your proposed improvement review file attached for more detailed instructions
opportunity
Database Specialist, Philanthropy
I am looking for a skilled Database Specialist to assist with data management for our philanthropy project. The ideal candidate should have experience in data management and be familiar with both hosted and on-premises database solutions. Responsibilities: - Manage and organize large amounts of data for our philanthropy project - Ensure data integrity and accuracy - Develop and implement data management strategies - Collaborate with team members to design and optimize the database structure Skills and Experience: - Proven experience in data management - Proficiency in database management systems (DBMS) - Knowledge of both hosted and on-premises database solutions - Strong attention to detail and ability to organize and analyze data effectively - Familiarity with reporting modules and ability to create reports based on project requirements If you are a reliable and detail-oriented Database Specialist with experience in data management and a passion for philanthropy, we would love to hear from you. Please submit your proposal detailing your relevant experience and skills.
DATABASE MANAGEMENT SYSTEM
DESIGN AND PROPOSAL OF A DATABASE MANAGEMENT SYSTEM 1 Westlake Research Hospital Design and Proposal of a Database Management System Marco Abuaitah © February 21, 2016 PROBLEM Challenge. Westlake Research Hospital is conducting a double-blinded trial or study in order to test a new depression medication. The study will consist of 400 patients and 20 doctors. In order to be able to run a study like this, effective documentation and tracking of resources is extremely essential. A database management system (DBMS) solution would be extremely beneficial for this study, but first, the database must be designed effectively and efficiently in order to comply with the needs of the two researchers that are conducting the study. Westlake Research Hospital does not currently have a database system designed to conduct such studies. The hospital is in fact using a paper-based system where all patients’ records are kept in physical charts. There are several challenges that must be overcome in order to design the database needed for this study. Some of the challenges presented in working with this type of study and in designing its database are pertinent to its restrictions. According to the Encyclopedia of Psychopharmacology (2010), “Double-blinded study is a term used to describe a study in which both the investigator or the participant are blinded to (unaware of) the nature of the treatment the participant is receiving” (p. 418). Therefore, the doctors and the patients of this trial must not know what type of drugs they are giving to the patients. “Only two test supervisors will know who is getting what” (Conger, 2014, p. 18). The database must be designed so that only those who are authorized to access certain information (e.g., the type of drug that is given to patients) are able to do so. What makes this database even more significant is the fact that some patients may elect to drop from this trial, in which case it may be necessary to completely remove their information from the database and update the database accordingly so that doctors continue to see a fair amount of patients. Business Requirements. There are several requirements and expectations for this project. Requirements currently include: (1) providing patients with the ability to view their medical records and doctor’s notes, (2) providing the doctors with the ability to view their patients’ records, (3) allowing doctors to enter information regarding their patients, and (4) providing full access to the two supervisors only. Some expectations may include: (1) automatically updating the information in the database upon the withdrawal of a patient from the trial and (2) creating a secure database so that patients’ data is not being accessed by unauthorized individuals, possibly from a different institution. Table 1 below illustrates a list of requirements that are more specifically related to the database design. Stakeholder Requirements Doctors Access their own patients’ information Enter blood test results Enter depression indicators Enter own notes Enter explanation for dropping patients out of study Patients Access their own medical profile Access the doctor’s notes Supervisors Access all patient information Access all doctors’ notes Access information about the drug each patient is taking Add and remove patients from the database Secretary Access to the patients’ schedule Nurses Enter vital signs including blood pressure, heart rate, and weight Table 1. Database Requirements. This table illustrates the business requirements related to the database design. Westlake Research Hospital is in need of this database so that the management of patients’ data is more effective, and an extreme significance fall into the administration of medication to patients. It is quite important to make sure that patients are receiving the intended medication. For example, if a patient is assigned to receive the new drug, the database would help the supervisors maintain a record of what medication this patient is to receive each time the patient visits the facility. Moreover, if for some reason, the supervisors decide to change the medication and assign a different physician to that patient, then the database needs to be updated accordingly based on being a relational database. The database is needed so that supervisors can easily link between doctors, patients, and drug type. Certain business rules must be met while doing so, which include the following: The drug given is to only be known by the supervisors (double-blinded study) Doctors can only see their own patients Doctors must see their patients each month Doctors must see their patients 2 times each 1 month Patients can be removed entirely from the database Supervisors have the highest level of access to the database.
Install an opensource TMS system on Google Cloud Server
We are looking to install an existing opensource translation management systme that is built mainy on a linux environment in PHP and to install it on Google Cloud Server. We also want to customise some of the branding on this system and add a payment ordering system for clients. You can have a look at the opensource Translation Management System on www.matecat.com We're looking for someone who has most of the following and is willing to learn the rest on the job as needed: Deep understanding of Javascript ES6+ Experience with Node.js, its tools and ecosystem Experience with React.js Experience with DBMS MySQL Experience with version control GIT Innate care for structured, modular, clean and efficient code. Quick learner and good communication skills. Proactive, self-driven and enjoys solving complex problems, not just in the primary area of responsibility but across boundaries. Nice to have Experience with Typescript Experience with PHP Experience with Docker Experience with Linux environments, configuration and troubleshooting. For this position we can accept remote working
Up to 1 hour Software Consultation to help our decision for DBMS
We have launched a new business venture and need the input of a software guru who can help us make the best decision with regards to our DBMS. This project is just to identify our needs and make recommendations on the best course of action considering required outcomes, short and long term benefits and cost restrictions.
Back end developer to implement one feature to my website - ESPORTS EXPERIENCE PREF
Experienced dev - familiar with MySQL, Laravel, built website from scratch, code esportsuniverse.co.uk - This is the website General information for the website: Tournament and online match hoster for ps4 and xbox games Database management system (DBMS): MySQL Description of requirements/features: esportsuniverse.co.uk Experienced Laravel developer PHP framework PHP 7.1 Experience with Composer Features required: • Adding new games to my platform from the back office admin panel Please see attached document.
Database implementation
Hi , I have a project which have a scenario, and from this scenario we need to build a Database. You need to draw an ER diagram, Physical design and implement the database in any DBMS software and finally you have to able to write query to retrieve or manipulate data for some given requirements I have attached the scenario Time Limit : 5days
pre-funded
Database update
UPDATE 13 Feb 2018: I have the necessary information now. Anyone wishing to bid please communicate. UPDATE: I am waiting for the cPanel login.... therefore I am sorry I haven't answered anyone yet. General information for the website: investment Database management system (DBMS): MySQL Description of requirements/features: We need to delete all the data in an existing database and upload all new data. It is just a table- a big table, but its all there. Extra notes:
SQL query and results
General information for the business: Data Database management system (DBMS): Microsoft SQL Server Description of requirements/functionality: I have data and need queries to be obtained from the tables with report outputs. You need to be good at SQL, SQL server and understand relationship between tables. Extra notes:
I need to install php my admin on a linux server with alibaba
General information for the website: I have a server set up and can give logins. I need to get phpmyadmin set up and working. Database management system (DBMS): MySQL Description of requirements/features: Currently we are using the ipaddress of the server but we would like it to be something like. www.domainname.com/phpmyadmin to then be able to login to access the database. Pretty urgent job :) Kind regards, Michael Extra services needed: Installation Extra notes:
Create mySQL database
General information for the business: Crypto trading Database management system (DBMS): MySQL Description of requirements/functionality: I need to create mySQL database on EC2 instance, which would call API once per hour with one request and store the values in the database. API request should be called here at the top of each hour: https://coinmarketcap.com/api/. Everything can be returned with just one API request, example here - https://api.coinmarketcap.com/v1/ticker/?limit=10000 The following values should be stored for each coin at the top of each hour: "id": "bitcoin", "name": "Bitcoin", "symbol": "BTC", "rank": "1", "price_usd": "14377.4", "price_btc": "1.0", "24h_volume_usd": "17051600000.0", "market_cap_usd": "241442366774", "available_supply": "16793187.0", "total_supply": "16793187.0", "max_supply": "21000000.0", "percent_change_1h": "-0.53", "percent_change_24h": "-5.86", "percent_change_7d": "-5.51", "last_updated": "1515564260"
Hobby electronic parts database
General information for the business: Hobby Database management system (DBMS): Microsoft Access Description of requirements/functionality: For storing electronic parts and kits with picture ,location, datasheet, search function... Extra notes: For storing electronic parts and kits with picture ,location, datasheet, search function...
Some uploaded user info isnt showing on public profiles
General information for the website: ASP.NET with exp. in c# and vb Database management system (DBMS): MySQL Kind of development: Customization of existing website Description of requirements/features: When new members upload their cv,etc, it is not showing up when others view their public profile. Simple job, small project, but will lead to: - future projects (advertising banners, forum section, etc) - outsourcing to you to build/design banners for members (8000 members at last count) - technical support opportunities for long term - more to be discussed and arranged - Extra notes: preferably devs within the EU as time zone probs are too difficult to deal with
I need an experienced back end developer to make some changes to 1 website feature
General information for the website: Tournament and online match hoster for ps4 and xbox games Database management system (DBMS): MySQL Description of requirements/features: esportsuniverse.co.uk Experienced Laravel developer PHP framework PHP 7.1 Experience with Composer We are soon to be launching a new feature in our website, it is currently in staging after review we want to change the logic and require the assistance of an experienced back end developer. In summary, the user will post a match, best of 1, best of 3 and best of 5. Once playing against another opponent, the database automatically provides the users with i) Maps and ii) Gamemodes. The users then report the score as - e.g. best of 3; 2-0 & best of 5; 3-2 etc. The wins and losses are then recorded on the team page of the winners and losers. What we want to introduce is that on the team page instead of showing a generic win or loss, we want to show wins and losses for each map and gamemode. So on the report page we would require some changes so the user ticks each map and gamemode won or lost. These results will then be reflected on the team page. We have provided some additional information in the attached. This should not take too long and is simpler once explained further. We are happy to provide more information in a Skype call. Extra notes:
Sql query help
General information for the website: query Database management system (DBMS): MySQL Description of requirements/features: I need a query to calculate the average journey time made to a location. vehicles go over a weighbridge, the weighbridge records the registration of the vehicle, location they came from, the time they went on the weighbridge and the time they finished emptying. The journey time can be calculated by using the previous weighbridge end time and the start time of the next one for that vehicle reg and location and the query needs to not include anything that took longer than 4 hours in the average. there are many vehicles that go to the location and this needs to average them all. Extra notes:
I need someone familiar with code, database, for one simple change in our admin panel
General information for the website: tournament website hoster Database management system (DBMS): MySQL Kind of development: Customization of existing website Description of requirements/features: Essentially at the moment, when we create a Tournament on the live site we have an image with an EU Flag We need an option in the admin panel to select NA or EU. When selecting NA it will show an American flag, when selecting EU show an EU Flag. We would also need some text change from 'BST' to 'CT' on the time zones. When selecting EU show BST and when selecting NA show CT. If possible change the date format to long form dd.mmmm.yyyy to avoid confusion. Please see attached, for further information. Website - esportsuniverse.co.uk Extra notes:
Trouble shoot VPS issues
General information for the website: I write a daily blog of mental health and emotional wellbeing and sell my services as a psychotherapist Database management system (DBMS): MySQL Kind of development: Customization of existing website Description of requirements/features: Two problems: 1)Website keeps going offline almost daily and needs rebooting each time. 123Reg can't identify any problem and say it isn't their VPS server. 2) Website sometimes displays a screen with blog posts from a date in November 2017 and any work I have done since then does not show on the website. At other times, the website shows up to date posts. I post daily so it is easy to see when it reverts to the old date. It always goes back to the way the site looked on this specific date in November 2017. I have been unable to fix the problem this far and it's driving me nuts! Extra services needed: Hosting, Installation, Customization Extra notes: Please only get in touch if you are very knowledgeable regarding building VPS sites and the necessary IT skills related to this. Thanks.
I need a PHP programmer familiar with MySQL and MVC Code Igniter
General information for the business: Membership Portal for New Product Development Database management system (DBMS): MySQL Description of requirements/functionality: I am building a membership portal for new product development. A previous programmer has developed worksheets that allow members to work through the various stages of new product development from idea generation to financing. This programmer had submitted a proposal to add additional functionality to the membership database. This additional functionality would have allowed members to have several new projects under evaluation. As well, the proposal would have implemented a new interface to the database. Unfortunately, the programmer has taken ill and is unable to complete the proposal. What I need is a programmer to take up this proposal under the following conditions: 1. Sign a confidentiality agreement. 2. Stick with the current Code Igniter database. 3. Set up a bitbucket account. 4. Review the proposal submitted and provide an estimate to complete the work. 5. Be prepared to communicate by email and Skype. If you are interested, I would be pleased to discuss the specifics of the proposal directly with you. Extra notes:
Need someone to install MongoDB onto my server
General information for the website: Online holiday website Database management system (DBMS): MySQL Kind of development: Customization of existing website Description of requirements/features: I need someone to install MongoDB onto my server and configure. I have had some work carried out on my website where I am pulling villas though to a listings page (see link below) using API's and the developer has requested I have MongoDB installed on my server, the villas are currently pulling from the developers install of MongoDB. My hosting provider is 1and1 on a Linux operating system. I need the successful developer to: Determine what version of MongoDB installed Download the correct package Install onto my server Configure correctly ready for the developer to transfer correct data Extra services needed: Hosting, Installation Extra notes: