Database Design Jobs

55 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 - Entry Level ($) - Est. Time: Less than 1 week, 10-30 hrs/week - Posted
Hello, The product has been developed completely but I am stuck at a point. Point - We have a registration form to add a lead where we have to put the location in form of state, county and city. I need someone who has experience in mapping of selecting state county and city. for example - user clicks on "State" and selects a particular state, once the state is selected. then user will select the county for particular state and then user will select city for particular county. Go to this link - https://www.freemaptools.com/find-zip-codes-inside-state-county-city.htm I need same functionality as in above link. This is required ASAP. Tell me how much hours you need for this.
Skills: Database design JavaScript MySQL Administration
Hourly - Intermediate ($$) - Est. Time: Less than 1 week, 10-30 hrs/week - Posted
QGIS web client has been deployed on a test cloud server running Ubuntu 14.04 LTS. The freelancer is required to provide details on the following aspects: 1) Possibility to segregate projects on the basis of username/password (the default features of the system seem not embedding access rights modules); 2) Design of the server environment in order to organize projects into folders/directories and assign access to each project on the basis of user credentials, as per the above item 1; 3) Possibility to organize and categorize projects in the QGIS web client front-end interface: the freelancer is requested to provide working instructions on the publication of links and their visual organisation in the web page; 4) Possibility to Integrate QGIS web client with other GIS systems: the freelancer is requested to elaborate working instruction on: a. how projects are uploaded into the QGIS web client (in terms of background maps and layers); b. how projects are generated (QGIS-like file extension), if QGIS desktop is required or files generated from other systems (like ArgGIS, GW-Base, GeODin) can be directly uploaded as well; c. how the QGIS web client could read data directly from a database (running on the same cloud server) instead that from QGIS-like files. In case the deployment of QGIS will be feasible, on the basis of the above listed items, the contractor is requested to draft a brief user manual explaining to end-users how to: 1) Created a QGIS projects to be made available on the QGIS web client 2) How such project can be uploaded into the cloud server (e.g. via FTP or direct upload into a DB) 3) How link to the project are published on the front-end application webpage and managed
Skills: Database design Geographic Information System (GIS) QGIS Ubuntu
Hourly - Expert ($$$) - Est. Time: 3 to 6 months, Less than 10 hrs/week - Posted
JOB DESCRIPTION We are a construction company in Australia. We wish to write a “project costing” database that integrates with MYOB. Being a single company database, we hope to keep the data structures relatively simple. JOB REQUIREMENTS Stage 1: • To design and document all data structures (tables, fields and relationships) for capturing project costs, budgets, variations, inventory, purchase orders and progress invoicing • To consider the integration of our database with MYOB • Quality: To have perfect and simple data structures that are well thought out and consistent in approach • Speed: To be developed for speed. Stage 2: • Develop code in Filemaker (suggested) that works with MYOB APIs. APPLICANT REQUIREMENTS This advertisement is only for Stage 1. We are looking for someone who has: • Developed the architecture of a large accounting system • Understands double-entry accounting and the importance of fiscal integrity • Knowledge and experience of integrating with MYOB • Worked with Filemaker (preferred but not essential) • An accounting background (preferred but not essential). In responding, please address the points above and provide links/names to software that you have worked on. I consider this work to be hourly rate based but seek your feedback.
Skills: Database design Cost accounting Data Modeling FileMaker
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 - 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
Hourly - Expert ($$$) - Est. Time: Less than 1 month, 30+ hrs/week - Posted
I have a complex system used to handle payment transactions, we lost the database and the table structures. We recreated about 140 tables and estimate there is another 30 or so tables that needs to be recreated. We need a experienced programmer / database design specialist who can recreate the database for me based on the source code of the system and MySQL error logs. The system is written in PHP. There is no "triggers" used in the database, all tables should be InnoDB. You must be able to use proper indexes / keys in the database. Do not apply unless you have 3-4 years eCommerce / shopping cart experience and 6+ years experience with PHP The right candidate can get a maintenance contract. It will depend on initial performance. Please message me for example queries / code snippets. Full code will only be shared to the right candidate. I estimate it will be around 80-100 hours of work, you must be able to commit full time for the initial setup. Service contract should be less than 20 hours a month
Skills: Database design Database Modeling MySQL Administration MySQL Programming
Hourly - Entry Level ($) - Est. Time: More than 6 months, 10-30 hrs/week - Posted
***Please do not just respond with your skype contact info - we ask that you review the posting and data provided and answer the questions. Only the shortlisted candidates will be interviewed. Thank you! *** We need to be able to search and produce reports from existing data that is in the public domain. The type of search functionality is virtually identical to that set out here (this is NOT our site, we need to be able to replicate these searches on a subset of this exact data, all of which is stored on our servers and in the cloud): http://www.civicinfo.bc.ca/surveys.asp Specifics: The background data is all available on excel. It must be able to produce visual reports of performance over time. We do not favour a custom build, we prefer "off the shelf" so that we can manage it ourselves over time. Ideally there would be the ability to compare data between municipalities. Please outline: How you would approach building this What software you would recommend (we prefer something off the shelf as opposed to custom) An approximate budget Time to complete We will need ongoing work with our business after this project, but please only bid on duplicating this functionality. If you are interested put "Hello" in the first line of the interview question asking you what part of the project most appeals to you - if this is not in there the application won't be considered.
Skills: Database design Data scraping Microsoft Excel Tableau Software
Hourly - Entry Level ($) - Est. Time: Less than 1 month, 10-30 hrs/week - Posted
We are looking for a person to write robust and scalable python code that will interact with a range of different APIs and populate a database with the output. We want someone with a working knowledge of the various options and best practices for these APIs to advise the team on the best approach for our use-case. In terms of the API sources, we are looking for people with familiarity with the following services (we don't expect a single person to cover all of these, but if you have familiarity with multiple APIs that would be ideal): Moz , Ahrefs, SemRush
, Facebook for Business, Twitter (including ads)
, LinkedIn (incl. ads), 
Google+ , 
Instagram, Pinterest (incl. ads)
, Vine, 
Youtube (incl. ads), Reddit , Google Analytics 
, Google Adwords, Yahoo Gemini, StumbleUpon Ads, Instagram, Unbounce, Slideshare 
, Intercom, MixPanel, KissMetrics, AppsFlyer, AppAnnie, PipeDrive, Segment, VWO, Intercom, Mailchimp, Aweber, Vero, 
Xero When applying please make it clear which of these you are experienced with. In terms of writing the output, it would be enough to save the output to a local database but experience writing directly to S3 would be a bonus.
Skills: Database design