Database Modeling Jobs

26 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
We are in need of an expert of customized data scorecard modeling and descriptive analysis. We are a sports & entertainment marketing agency and are in the process of developing a scoring model based on key performance indicators and data points to provide detailed and scalable decision making framework for sponsorships. This would include descriptive analysis and creation of deliverable visualization that share key observations, findings and recommendations taken from the model. We would like to stay up-to-date and continually enhance the model, so we see this working relationship as long-term.
Skills: Database Modeling Algorithms Data Analytics Data Modeling
Fixed-Price - Expert ($$$) - Est. Budget: $75 - Posted
Looking for an experienced database administrator that will help us optimise our database infrastructure for fast querying. The database has only one big table containing five columns: - A: Varchar(20) - B: Varchar(20) - C: Integer - D: Timestamp - E: Varchar(1) There are 100s millions of rows for a total size of 50GB. The DB is updated daily (new data coming in) and is integrated within our analytical framework. It is queried by only one client at the same time, mainly through SELECT, using filter on A, B, C, D, E or any combinations of these columns. The main constraint is the RAM of the computer (16GB) and we are using PostgreSQL at the moment. We are open to another framework if it is justified. Deliverable: bring down the process time of each query down to an acceptable level (below 1s).
Skills: Database Modeling Database Administration Database design Database testing
Fixed-Price - Intermediate ($$) - Est. Budget: $650 - Posted
Candidate: Experience in database design. The successful candidate will be given access to an inventory management software to analyse and from there create the following: 1st - Database design is connected with application design. The requirements and the collection analysis phase produce both data requirements and functional requirements. The data requirements are used as a source of database design. The data requirements should be specified in as detailed and complete form as possible. 2nd - Conceptual Design Once all the requirements have been collected and analyzed, the next step is to create a conceptual shema for the database, using a high level conceptual data model. This phase is called conceptual design. The result of this phase is an Entity-Relationship (ER) diagram or UML class diagram. It is a high-level data model of the specific application area. It describes how different entities (objects, items) are related to each other 3rd - Logical Design The result of the logical design phase (or data model mapping phase) is a set of relation shcemas. The ER diagram or class diagram is the basis for these relation schemas. 4th - Normalization Normalization is the last part of the logical design. The goal of normalization is to eliminate redundancy and potential update anomalies. Redundancy means that the same data is saved more than once in a database. Update anomaly is a consequence of redundancy. If a piece of data is saved in more than one place, the same data must be updated in more than one place. Designs Conceptual, Logical and Physical data models for scalability/flexibility/Extensibility. Performs Data analysis/Profiling to evaluate data and underlying data structures. Documents and publishes the data dictionaries/Metadata, data models to ensure their correct implementation Competencies: Communication Proficiency. Technical Capacity. Time Management.
Skills: Database Modeling Agile software development Database design PHP
Fixed-Price - Intermediate ($$) - Est. Budget: $2,600 - Posted
Duties: - Working very closely with delivery leads to prepare test plans, sample test data and maintain release notes - Deploying components and maintain environment in a continuous running state - Scheduling Control M batch jobs and run batch simulation cycles based on test plan - Tracking & trouble shooting defects, build and maintain testing automation scripts - Publishing summary reports at end of each cycle - Developing tools to build and automate high quality unit test cases and work toward reducing number of defects caught in Function/UAT - Providing support and help oversee batch cycle simulations in other Dev-managed environments, e.g. Performance Test environment Requirements: We are looking for an independent and proactive ETL Application Developer who has 5+ years of experience at the same or related position. What do we expect? - 5+ years of experience as Software Developer - Extensive knowledge of Informatica - Experience in running batches via job scheduler (e.g. Control M) - Deep expertise in writing PL SQLs in Oracle and ETL tools - Strong knowledge of UNIX, shell and perl scripts - University degree level (preferably in IT or Finance) Nice to have: - Good knowledge of DB modeling - Knowledge of JIRA/Quality Center - Experience with Agile development methodology - Excellent written and verbal communication skills - Ability to work independently and collaboratively We offer: - Stable and long-term work among professionals on the basis of contract of employment, B2B contract, contract of mandate or contract of specific work - Real influence on progress of your career path - Work in a team for which your opinion matters - Support of Business Assistant dedicated to the Specialist throughout the entire period of cooperation - Integration events, sport events e.g. IT run, cycling tours, football and basketball matches - Benefits matched to your needs
Skills: Database Modeling "Extract, Transform and Load (ETL)" Informatica Oracle PL/SQL
Hourly - Intermediate ($$) - Est. Time: Less than 1 week, Less than 10 hrs/week - Posted
This project is to set up a database on AWS to support a mobile app. The database should be a classic rational database (i.e. not no SQL). Part of the task is to suggest what database to use. The database will contain content used in the app, including translations for all text used in the app. The system will be localized to many different languages. At first to English, Simplified Chinese and Traditional Chinese, but over time to other languages, including Arabic. The app will have a database, where the AWS one is the master. Part of the task is to work with the app developer to figure out how best to synchronize the databases. The client database will gather some user data that should be copied back to the AWS one. The first client is an Android app on a customized IOT device. Later we will add mobile apps on Android and iOS, and then a web site, that uses the data as well. We will be using Json here. The first market is China, though we will initially be hosting on AWS Singapore (probably) and later on AWS Beijing. A follow up project to this is to develop a web form to update the database. The markup will be provided, but if you are good at this, then you can offer to do that as well. The database is small to begin with, including only a few thousand rows of code. We will have around 15-20 tables.
Skills: Database Modeling AWS Lambda Database design
Fixed-Price - Expert ($$$) - Est. Budget: $1,000 - Posted
Looking for an experienced native iOS and Android app developer for a fast track project. Passionate to work within given timeline and responsive to client's queries. Preferably someone with native iOS and Android programming language knowledge. And experience working using Swift, Objective-C, Android SDK, Javascript, HTML, PHP, API development, database management, SQL, Braintree and AWS.
Skills: Database Modeling Amazon S3 Amazon Web Services Android
Fixed-Price - Expert ($$$) - Est. Budget: $200 - Posted
Database will be created to assist the Roads and Highways construction industry. Services: Overlays, Demolition & Removal, Asphalt Repairs, Sealcoating, and Marking & Striping. The database needs to be able to calculate cost to do a job with a user-friendly experience. 1. Auto filter. 2. Drop down menu. 3. Show related items only in drop down menu. 4. Create template documents, (Quote and Invoices) 5. Create Reports Easily 6. Easy to update. 7. Intuitive, well thought out. 8. Efficient 9. Pleasant, easy-to-navigate GUI.
Skills: Database Modeling Database Administration Database design database management