Database Design Jobs

130 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}})
Hourly - Expert ($$$) - Est. Time: Less than 1 week, 10-30 hrs/week - Posted
Hello, We're currently experiencing some issues with our database being inefficient and possibly corrupting. I'm unsure if it's on the web hosts side or ours, but I know it needs to be sorted out. What I'm looking for is someone to analyze the database and then propose changes to make. I'm going to dump some information to help anyone who applies with some context. The web host is saying that the following is why our database is crashing: 2016-04-28 07:02:17 7ff57b5fe700 InnoDB: Recalculation of persistent statistics requested for table "getmetri_metrincom"."cache_form" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead. 2016-04-28 07:02:23 7ff57b5fe700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2016-04-28 07:02:23 7ff57b5fe700 InnoDB: Recalculation of persistent statistics requested for table "getmetri_metrincom"."sbp_path" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead. Additionally: I noticed that there are some records regarding memory exhaust of your server: Code: [1413138.644058] httpd invoked oom-killer: gfp_mask=0x201da, order=0, oom_adj=0, oom_score_adj=0 [1413138.645347] [<ffffffff8112add2>] ? oom_kill_process+0x82/0x2a0 [1413138.662487] [ pid ] uid tgid total_vm rss cpu oom_adj oom_score_adj name I also found recent records regarding slow MySQL queries: Code: 9. Executed 1h 52m 32s ago for 375.042983 sec on Database --> Unknown (NOT FOUND / DELETED) Date: 2016-04-27 19:58:04 Query_time: 375.042983 Rows_examined: 0: Rows_sent 0 Lock_time: 0.000000 # Schema: getmetri_metrincom Last_errno: 1160 Killed: 0 SELECT cid, data, created, expire, serialized FROM cache_rules WHERE cid IN ('rules_event_whitelist'); -------------------------------------------------------------------------------------------------- 10. Executed 1h 52m 32s ago for 375.037469 sec on Database --> Unknown (NOT FOUND / DELETED) Date: 2016-04-27 19:58:04 Query_time: 375.037469 Rows_examined: 0: Rows_sent 0 Lock_time: 0.000000 # Schema: getmetri_metrincom Last_errno: 1160 Killed: 0 SELECT cid, data, created, expire, serialized FROM cache_rules WHERE cid IN ('rules_event_whitelist'); === Top 5 Largest Tables in getmetri_metrincom == Table name Size -------------------------------------- -------- watchdog 288.0 MB cache 126.6 MB advancedqueue 116.1 MB commerce_order 102.0 MB commerce_order_revision 84.0 MB -------------------------------------------------
Skills: Database design MySQL Programming SQL
Fixed Price Budget - Expert ($$$) - $20 to $40 - Posted
Looking to have on online registration page created for summer camp. http://bramptonsummercamp.com/ticket.html Form is complete however it requires payment integration with Paypal and proper business logic, and functioning SUBMIT Button Section 1: Parent demographic Section 2: Camper demographic Section 3: Dates to register for Section 4: Payment information (additional children in same house will get a 10% discount) Thank you page and then send confirmation to parent. All details should be stored into a MySQL database for easy export into CRM Software. *** Please do not apply if you are inexperienced, you will not be awarded this job, it's a quick fix that is required. ***
Skills: Database design
Hourly - Intermediate ($$) - Est. Time: Less than 1 month, Less than 10 hrs/week - Posted
The concept is this: Need a website with a DB backend for ice cream flavors and ice cream shops. Need a database that can house unlimited amount of ice cream flavors and allow registered public users review and comment and grade their favorite flavors. Need secondary portal for registered private ice cream shops and vendors that can upload and change their menu when ever they please. The menu will tie into the ice cream flavor DB so as to allow the public to view the menu from a particular vendor and then research the flavor and look at what others have graded. Tie in a payment processing component that can charge a monthly fee to the ice cream vendors. Preferably built on wordpress if at all possible.
Skills: Database design Paypal Integration Web design WordPress
Hourly - Intermediate ($$) - Est. Time: More than 6 months, 10-30 hrs/week - Posted
I'm currently filtering a massive pricing and inventory file for IT products in excel with macros by deleting rows of data. The File is usually over 200,000 rows and 63 columns. This method is obviously crushing my computer and causing major delays in the process. I need someone who can filter this list based on 7-8 simple and complex conditions in a database of your choosing. All I will ask for is an exported excel file. I already have some excel macros built to do this, so that should cut out some of the guess work. We update this price list every 3 months so if I hire you, there will be plenty of work in the future. I've attached a small pricing file for your reference.
Skills: Database design database management
Fixed-Price - Intermediate ($$) - Est. Budget: $8,000 - Posted
Seeking a experienced app developer to work across a variety platforms (ios & Android) . Starting from a blank canvas we require a experienced developer to build the search function, database and a payment portal . if your up for a challenge please get in touch and we can take it from there
Skills: Database design Database Modeling Payment Gateway Integration
Fixed-Price - Intermediate ($$) - Est. Budget: $2,000 - Posted
Need an archiving site built with a modern design. List of needs. Organization ability to login and upload PDF archives of old books, photos, and submit RSS feeds Students ability to login and save archives in site for further reading. Admin ability to approve or disapprove AJAX Search Feature Platform I would love this site to be built on the React.js platform Site to connect to mySQL database
Skills: Database design HTML5 JavaScript MySQL Programming
Fixed-Price - Intermediate ($$) - Est. Budget: $50 - Posted
I have a desktop software and I want to integrate a support for licensing into it. The planned flow is very straight: The application sends a login/password and a 'license number' to my server. The server validates the license for this particular user and sends back the result of validation to indicate can the software continue the work or not. So I need a developer to create such a backend to store/manage users/licenses and perform validation. A quick research show me the licensecloud.com that seems to be suitable for this purpose, but I'm open to your suggestions. also you can add that I'm open to support (change data format, provide a sample app for testing, etc), but better place it in a personal conversation with chosed developer
Skills: Database design C# JavaScript PHP