Database Design Jobs

132 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}})
Hourly - Intermediate ($$) - Est. Time: Less than 1 month, 10-30 hrs/week - Posted
Hi, I’m looking for a database + python expert consultant. I have a database of 5M rows * 10 columns text table. (Please look at the sample data file. It's just 1 row but I have 5 million rows of this.) The text isn't too long- it has about maximum 300 CHARACTERs in each text field. 2 columns contain numpy array of 50 floats. What I need to do is to search a specific substring (or multiple substrings using OR) from specific column, and return that result. For example, in sample data, I'd like to to return the row if the 'DO' column string contains 'revenue' substring. Your job is: 1. Pick the best (fast) database to do this type of job. (if it's not mysql) 2. Write a code: how to install database on the ec2 3. Write(wrap) db search queries in PYTHON (for example if it’s sql: db = MySQLdb.connect() cursor = db.cursor() sql = "SELECT tvct_raw.estimated_users from tvct_raw WHERE id = '%s' " % the_id try: cursor.execute(sql) results = cursor.fetchall() for row in results: xxx=row[0] except: pass 4. The database is currently in python pandas Dataframe format stored in hundreds of pickle files (<100mb). Write query to migrate(store for the first time) them in the database. 5. Our server(ec2) is only 4G RAM. Considering the size of the data, recommend the ec2 upgrade option (if necessary.) I was pretty satisfied with Pandas dataframe until now to use df[df['A'].str.contains("hello|jello")] method to match substring because it's pretty fast. But the reason why I need to go DB is after loading 10 Million rows in Pandas DF, my macbook says "out of space". I'm looking for someone who can nicely comment on the code in each step. If you are too cool for commenting on the code, please don't apply for this job.
Skills: Database design Database Modeling Python
Hourly - Entry Level ($) - Est. Time: More than 6 months, 10-30 hrs/week - Posted
We are looking for someone that has the following skills. The backend of the database is done we need someone to design the user interface. Pantheon Developers will need to have a Pantheon account. Developers will need to have a firm understanding of how to work with the following team development tools/strategies we use: -Git -Pantheon Multidev Website/Database: Drupal Hire someone who has experience working with Drupal 7. The project is built on the Panopoly distribution. The project is built on the Panels paradigm. The main project functionality depends on the following modules: -Organic Groups -Domain Access -CRM Core -Relation -Flag -Views Design/Theming: all of the above, plus: Bootstrap Hire someone who has experience working with Bootstrap 3. The project is designed with subthemes of Kalatheme. The project is designed with the Panels paradigm.
Skills: Database design Drupal
Fixed-Price - Intermediate ($$) - Est. Budget: $75 - Posted
I am looking for an experienced web app developer(prefer Ruby On Rails/SQL) to review a small database(less then 10 tables) for continuity, logic, and superior performance. This assignment does not require any coding, but does require an expertise in database design and real world applications with a ROR app. The two documents that will need to be reviewed are a db schema and a rails model associations.
Skills: Database design MySQL Programming Ruby
Fixed-Price - Entry Level ($) - Est. Budget: $60 - Posted
Looking for a freelancer who has a good experience in php & mysql. actually I have a simple web interface connected to a database (mysql). need to fix the following: 1- MVC Architecture. 2- The DAO Design Pattern. 3- Film(s) being returned by customers. 4- Films that are overdue should be flagged up on the web interface Report and Evaluation of the Application a. The design/modelling (UML) components for your application as derived from the problem specification. b. An analysis of the MVC architecture and the design patterns used in your application. c. A critical evaluation of your application, describing the PHP files and objects you have created, why you have created them and how they function in your application. d. A discussion of client and server interaction within web applications e. A discussion of alternative approaches to web application development and data interaction.
Skills: Database design Database Administration database management MySQL Programming
Hourly - Intermediate ($$) - Est. Time: 1 to 3 months, 10-30 hrs/week - Posted
I need to build a feed where Google Forms can feed into a SQL database in the cloud to collect survey responses and do some light data transformation (e.g. create a view that converts a field with the value "5 - Strongly Agree" to simply "5"). I have the Google Forms establishes and have some historical information that will need to be uploaded from flat files to start. The person I am looking to hire would set up the database instance, establish the schema, create the connections to the Google forms data values, and create the view layers to perform some minimal transformation on the raw data using rules I provided.
Skills: Database design Google Apps Relational Databases
Fixed-Price - Expert ($$$) - Est. Budget: $50 - Posted
design a database including a full report with all models related to design. i want someone have an academic background to do a database using MS access software with full analysing using right requested models. please any one want to take this project should give me a prove about his ability to do this project such as giving the basic models related to design such as DFD or ERD models, to know if he understand the project or no. moreover, this project should be finishing in 2 days
Skills: Database design Academic Writing System Analysis
Fixed-Price - Expert ($$$) - Est. Budget: $5 - Posted
Looking for an experienced mobile app developer to help build a project for iOS and Android. We are looking for either Phone Gap or Native developers. You will work along side our UI/UX designers and see the app through from beta to launching on the app store. This app needs to be built by Sept. 1, 2016, fully tested and public. Before I can release details you will be required to sign an NDA. Please note that before applying. I will supply it to you quickly after you respond and show your interest.
Skills: Database design