Database Modeling Jobs

24 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: $150 - Posted
We have a dealer section ordering tool with a database behind it in our site and we would like to update some of the features. some are very direct and some could take a while. It requires Custom PHP / CSS and other skills. The changes to be made are listed in the file and I can take you through via a call assuming price indication and skill level is correct. If all goes well, we would work together for a long time as we need to do lot of developments under and include a full dealer section from scratch in it. But this is after the good starting partnership of existing site. Please kindly provide some info about you and your relevance to this task. Thanks Akshat
Skills: Database Modeling CSS3 HTML5 jQuery
Fixed-Price - Expert ($$$) - Est. Budget: $3,000 - Posted
I would like to have someone develop a database based website that allows thousands of my current clients to log into. I am in the business of giving out business awards and require a database that will allows people to place votes towards their favourite companies. As these voted companies receive votes they will be eligible to win my business award. all the data needs to be tracked as well as email marketing and keeping track of all the winning companies that are involved.... eCommerce will be required for companies to pay for their award. So simply i need a voting system database.... that can track thousands of company details and their online votes...
Skills: Database Modeling Database design Ecommerce Platform Development Email Marketing
Fixed-Price - Expert ($$$) - Est. Budget: $4,000 - Posted
We need to build a DBMS that we can pull out forms/data from that can be sent along to our parent company, and in general help us better manage our business. We would need to provide our supervisors, and employees with electronic forms accessible either via iOS and Android apps or a web based app that are integrable to the database we create. We are undecided as to the environment/database and are open to suggestions. Possibly access, excel, or oracle as the parent company uses a mixture of oracle and excel sheets, so these may be our best choice. We need to build a database to help us organize our 40-50 employees, all their personal information, weekly work hours, multiple forms required to be used by supervisors and employees and roughly 300 work orders a day, and other vital pieces of information. I have a basic understanding of database design and an associates degree using Access SQL, MYSQL, excel, and some oracle. I took it upon myself to create a relationship model that includes many of the fields we will need. I am sure that there are redundancies and other mistakes but I believe it will be a useful resource. With this in mind, I am still looking for input and suggestions/ideas from the experienced developers when modeling and designing the database. We need to store many pieces of information, and be able to query the database to pull forms that we can use to send to our parent company as well as save the files in an organized fashion for future usage and reference. A small example of some of the database functionality would be every day having a new sheet that would add to a master document that keeps a back log of all the past works that are all date/time stamped as this is required when billing our parent company. We want to have developed either an iOS/Android or web app that can be used by our employees for their daily time sheets etc that can be sent to us in the main office and seamlessly integrated. We would need to be able to differentiate from things like a completed job, an open job, employees current job site, hours worked that week being calculated by the integrable sheets that we would received from the employees each day upon completion of work, and many other similar features to streamline this companies data and daily work load. I will go into more detail upon requests/interest in this job One of the electronic forms we would need is a street supervisor sign off sheet. Without the proper information we will not receive payment for the work. It would include fields such as Employee Name, Signature(electronic), Emp. I.D. #, Date, Start Time, End Time, Location, Purchase Order Number, Parent Company Rep Name, Parent Company Rep Signature-(electronic), Parent Company Employee ID#. For start time, end time, we would also want to have the database calculate the hours worked by that employee and be able to flag employees that reach a certain amount of hours worked each week. This is an example of 1 of approx. 4 electronic sheets that needs to be given to the street employees that can be integrated back into our database across 50 employees multiple times a day. I believe the work is fairly straight forward. Although I can tell some components require superior knowledge to create the database, the supplemental sheets, and the nitty gritty bits like calculating the hours worked per employee based on their sign-off sheet. I think I have sufficiently given the scope of work at hand so I will stop here. I look forward to communicating with you and addressing my concerns. If this is a reach in any aspect for you I kindly request that you do not apply, for those that have extensive experience with work like this you are whom i'm looking for. I expect daily updates and constant open communication with daily calls as I have an understanding of the work I am requiring, as well as detailed time-frames. With that in mind I do expect the people whom are signed on to work with me to optimize the end result and use their learned skill sets to help deliver the best possible product. I want to be able to leverage this DBMS in such a way that we can reduce company error, increase productivity and performance, better manage and direct company employees, as well as gain interest from the parent company based on reduced error and efficient data storage that allows us to perform the duties required on a day to day basis in a way that currently no competitors are doing. I understand the included document has errors, redundant data etc... It hopefully gives you an idea of what I am looking for. That said, I am sure that with the experts help more will be needed. With certainty I know there are at least 2 other tables I need to include but am awaiting the protocol from the parent company.
Skills: Database Modeling Android App Development Database Caching Database design
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 Modeling Database design Python
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 Modeling Database design MySQL Administration MySQL Programming
Hourly - Intermediate ($$) - Est. Time: 3 to 6 months, 10-30 hrs/week - Posted
Knowledge: * Deep understanding of MySQL / SQL * Deep understanding of how database internals work vExperience with Amazon's AWS and/or similar alternatives, it would be great if the DBA could advise us * Preferably extensive experience with making databases run more efficient. Some of his tasks might be: * Manage our DB system, currently 6 million records but this is likely to be 100s of millions of records soon * Currently we get our data from third-party-vendors, sometimes this data is incorrect or incomplete. - This results in a non-working web-platform. The issue is that it could be an issue in our platform or in the data we load into the system. Currently it takes us to much time to analyse data so we need somebody who can help us with this. - We need somebody to write proper queries to see if data is incorrect/incomplete and discusses issues with the development department. Next we can work towards a solution together with him/her * Since our database is growing (too) fast we need advise and changing the implementation on the way our current database is build and structured * We're like to move to Amazon's AWS or a simlair alternative, the DBA will have an important part in advising us and migrating the databases. Duration We see this as an ongoing job for about 10 to 25 hours a week for the upcoming 3 to 6 months and maybe even for the upcoming year. We need a senior Database Architect and Manager with as much experience as possible to do this job. Are you the right person for this job? Please reply with a simple, non templated, message and state: * 3 Previous projects you did similair to this assigment * 1 short paragraph about yourself and your background * 1 short paragraph about why we should hire you Many thanks in advance kind regards Jerry
Skills: Database Modeling Database Administration Database design database management
Fixed-Price - Entry Level ($) - Est. Budget: $1,000 - Posted
We are collecting the Models and Ad agency database, looking for new lady models database. Willing to pay $5 per record. we are looking for looking model agency or freelancer get the Indian lady portfolios. if interested people please start in the Description "New looks". We are looking for serious candidate or agency for long term work. we are planning to Hire 6 freelancer or Agency.
Skills: Database Modeling Business Modeling Data Modeling Data scraping
Fixed-Price - Expert ($$$) - Est. Budget: $500 - Posted
Looking for an experienced IT consultant to produce a report to scope the development of a web-based application. The purpose of this application is to allow users to design forms to request quantitative and qualitative information from counter-parties and manipulate quantitative information to produce online visuals in the form of high quality graphs. The selected consultant will be tasked with advising on the best application architecture, programming language, advise on security considerations and hosting options. In addition, the selected consultant will be required to research and report on how other similar applications have incorporated these same considerations. This is a essentially a research project and should serve as input for developing a plan to develop the application. The selected consultant should have experience in: database design and manipulation, strong writing abilities, curiosity for research, excellent command of English and ability to carry out forensic research on existing applications. The candidate must have demonstrated experience in developing applications with large databases that allow users to extract and manipulate data to produce graphical outputs. The selected consultant should be able to develop options for bootstrapping the application by using off-the shelf solutions. If research product is of high quality, the selected consultant may be considered for leading the development phase of the project.
Skills: Database Modeling Certified Information Systems Security Professional (CISSP) database programming Graphics Programming
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 Modeling Database design Payment Gateway Integration