• Hourly
  • Intermediate
  • Est. time: Less than 1 month, Hours to be determined

Need a database utilizing the Google Suite (I think using AppSheets?) to capture all components of a Total Quality Management (TQM) system using the Plan-Do-Check-Act (PDCA) methodology. I should included the fields that facilitate the comprehensive data collection, analysis, and action planning in addition to general fields like Organization/department, Project/Initiative, Process or Tool, Status, Comments/Notes, results/outcomes, documentation, results/outcomes, timeline/status, reporting and analysis, etc. As with any db, we need the ability to export the data into nice reports. I've attached a word doc that spells it out in more detail in 3 various ways to ensure I don't miss anything. :-)

Email DeliverabilityJavaScriptMap IntegrationAWS LambdaGISAppSheetMobile App DevelopmentGoogle Apps ScriptDatabase ModelingGoogle Chrome ExtensionMobile App DesignAPI IntegrationOffline FunctionalityUser AuthenticationDatabase Design
Posted 8 hours ago
  • Hourly
  • Expert
  • Est. time: Less than 1 month, Less than 30 hrs/week

I need some help troubleshooting 2 storage related issues with a Redshift database. The storage capacity is 320gb and the AWS cloud console shows that I am using ~90% of that (295gb). 1) When I look at the sum of the storage of all my tables in the redshift DB, the total is only about 220gb. So there is an unexplained 75gb that I would like to figure out. 2) There was also an unexplained 45gb spike in storage used several days ago that I would like to figure out. While these 2 issues are my top priority at the moment, there may be an opportunity for more work in this area.

Database DesignDatabase AdministrationDatabase OptimizationAmazon Redshift
  • Hourly: $25.00 - $45.00
  • Intermediate
  • Est. time: 1 to 3 months, Not sure

We need an IT tech/software technician that can program and set up web type technology similar to APIs to a server that's using some type of recovery server. Must understand how to work with SQL and PHP because a lot of this stuff does not have front ends, so you'll have to understand how to add and understand scripting within the network, pretty much basic communication between devices and pull from SQL so it communicates through a controller and takes that information from the server, the actual physical stuff that it's doing the main thing. Must understand IP addresses, not fix IP addresses, within a network to communicate with fixed devices. It is important to know pretty much anybody that's an IT person has at least three to four years trouble shooting, somebody that understands the network. This is just a Wi-Fi enabled Intranet Internet with hidden addresses inside a workstation and controllers and Wi-Fi routers not connected to the Internet. Everything is internal so must work with devices very similar to routers and a GUI that have vision files on Sim cards. Must understand the right configuration files. Skills required: - MySQL - Database management - SQL - Troubleshooting - Web development - PHP - JavaScript

MySQLSQLLinuxDatabase DesignMySQL Programming
  • Hourly: $50.00 - $100.00
  • Expert
  • Est. time: More than 6 months, Less than 30 hrs/week

We are seeking a dedicated professional to take over the maintenance and development of our Microsoft Access program. The ideal candidate should have a solid background in Excel and relevant experience in the construction industry. We use Sage Accounting and Estimating Software, which integrates with the Access Database Application. This role involves troubleshooting, enhancing existing features, and implementing new functionalities based on user requirements. The successful candidate will collaborate closely with our team to ensure the program meets our evolving needs. If you have a keen eye for detail, excellent problem-solving skills, and a strong understanding of Access and Excel, we'd love to hear from you. Skills required: - Microsoft Access - Excel - Construction industry knowledge - Microsoft SQL - ASP Net

Microsoft Access ProgrammingMicrosoft AccessMicrosoft SQL ServerSQLDatabase Design
  • Hourly
  • Expert
  • Est. time: 1 to 3 months, Hours to be determined

We are currently seeking a highly skilled and motivated app developer to join our team. As an app developer, you will be responsible for building an innovative app that will revolutionize our sports marketplace platform and software management needs. This is an exciting opportunity to showcase your valuable expertise and contribute to the growth of our startup company. In this role, you will be tasked with developing an app with a user-friendly interface that seamlessly integrates with our existing platform. The app will be the cornerstone of our marketplace, providing our users with an enhanced and streamlined experience. Your main focus will be on creating a robust app that incorporates essential features such as product listing and search, secure payment processing, software management, user progress / session tracking, calendar management, etc. We also are looking to integrate AI/adaptive AI at a later stage in the development. In addition to these core features, we also envision the app to a marketplace for both sides to meet, as well as the ability to support multiple languages to cater to our diverse user base. Your expertise in app development, UI/UX design, and API integration will be crucial in bringing these features to life. To excel in this role, attention to detail is key. You must possess strong problem-solving skills and have the ability to think critically/creatively to overcome any obstacles that may arise during the development process. Additionally, you should be able to work effectively within deadlines, delivering high-quality work without compromising on efficiency. We are also potentially looking for a long-term partner who is willing to join the team and help iterate as we begin to test the product with an initial market subset. As a member of our team, you will have the opportunity to collaborate with a diverse group of professionals who are passionate about what they do and are eager to disrupt the industry. This collaborative environment will allow you to learn from others, share your knowledge, and contribute to the overall success of our app development efforts. Qualifications: - Proven experience in app development, with a strong portfolio showcasing successful projects - Proficiency in programming languages such as Java, Swift, Katlin, etc. - Experience in UI/UX design, with a keen eye for aesthetics and user experience - Familiarity with API integration and working with third-party libraries - Strong problem-solving skills and attention to detail - Creativity and willingness to share new ideas - Familiarity with AI/Adaptive AI - Passion for software development and building products/startups - Ability to work effectively within deadlines If you are a talented and driven app developer looking for a challenging and rewarding opportunity, we encourage you to apply. Join our team and be a part of creating an innovative app that will shape the future of our sports marketplace platform and software management needs. We look forward to reviewing your application and discussing how you can contribute to our success.

AI DevelopmentAI Model IntegrationDatabase ManagementJavaScriptWeb ApplicationPHPAPI IntegrationDatabase ArchitectureAPIPlatform PluginCustomer Relationship ManagementApp DevelopmentUser Profile CreationUser AuthenticationCustomer Support PluginWeb DevelopmentAnalytics PluginMobile App DesignBug FixAndroid App DevelopmentApp MarketplaceUser Experience DesignUser Interface DesignSoftware DesignCalendar ManagementAdaptive AlgorithmMachine Learning AlgorithmMobile Payment FunctionalityDatabase DesignProfile CreationBack-End DevelopmentFront-End DevelopmentPlugin Installation
  • Hourly: $155.00 - $325.00
  • Intermediate
  • Est. time: 3 to 6 months, Less than 30 hrs/week

I need to now you project plan with all of it's goals where I can ask questions before starting the work. I excel in the data layer and am excited to help businesses.

Data IntegrationData MigrationData EngineeringQuery TuningData TransformationDatabase DesignETL PipelineKubernetesData ScienceData Analysis
  • Hourly
  • Intermediate
  • Est. time: 3 to 6 months, 30+ hrs/week

Scope of work: A growing AI startup in the healthcare sector feeds of relatively uniform data from many clients. Over time we have built multiple client-facing products and internal-facing tools based on these input data. It is time for us to re-organize the way we lay out the data we ourselves produce daily in support of our products and tools, in order to accelerate additional company growth. We have formed a dedicated task force. We seek an experienced data engineer to provide professional guidance to our re-organization effort, while we continue daily delivery of our products and services. Project length: Flexible, anything from a several months contract (to help re-organize current data) to partial/full time employment (to also help design & support our new line of products and tools). Background: Strong data engineering skills, an ability to analyze, propose and communicate data engineering changes and a track record to support it. Please explain yours in your cover letter or CV. Budget: Negotiable.

Database ArchitectureDatabase DesignData EngineeringApache AirflowDockerSQLPythonGit
  • Hourly: $41.00 - $70.00
  • Intermediate
  • Est. time: Less than 1 month, Less than 30 hrs/week

Build an inbound and outbound inventory application to run on iPhone or iPad. The application would track inbound and outbound shipments of hay, assign a lot number to the inbound or outbound shipment, allow the ability to upload images of weight or scales tickets from our scales, ability to upload images of the hay, will track lot number, date, vendor, customer, price per ton, trucking per ton, fixed trucking cost, price per bale, weight per bale, number of bales, type of hay, cut of hay, quality of hay. This is a general description, I can put a workflow together for successful candidate.

Web ApplicationDatabase Design
  • Hourly
  • Expert
  • Est. time: 1 to 3 months, Less than 30 hrs/week

Project Description: We are seeking a skilled data scientist or data engineer to help us build a comprehensive database of companies in a specific industry. The goal of this project is to gather, process, and analyze data from various sources to create a unified database that will enable us to understand the competitive landscape and identify potential investment opportunities. Key Responsibilities: -- Design and implement a scalable data architecture using MySQL as the primary database. -- Collect and integrate data from multiple sources, including public records, financial datasets, and other relevant sources. -- Develop data cleaning, matching, and reconciliation processes to ensure data accuracy and consistency, handling challenges such as data deduplication and fuzzy matching. -- Enrich the database with additional information using APIs and data enrichment techniques. -- Implement incremental data loading processes to accommodate the continuous addition of new data sources and ensure the database remains up to date. -- Collaborate with our team to identify and incorporate relevant alternative datasets that can enhance our understanding of the industry and target companies. -- Develop data visualization and reporting solutions to present key insights and metrics to stakeholders. -- Provide recommendations for future data architecture enhancements to support advanced analytics and decision-making. Required Skills and Experience: -- Strong expertise in SQL (MySQL) -- Proficiency in data manipulation, cleaning, and transformation using Python (pandas, NumPy) -- Experience with data matching, deduplication, and reconciliation techniques -- Knowledge of data integration best practices and ETL processes -- Familiarity with APIs and data enrichment techniques -- Understanding of data modeling and database design principles -- Excellent problem-solving and communication skills -- Ability to work independently and collaborate effectively with a team Preferred Skills: -- Experience with data visualization tools like Tableau or PowerBI -- Knowledge of data warehousing concepts and platforms -- Familiarity with advanced analytics and machine learning techniques -- Experience working with large datasets and optimizing query performance If you are a skilled data scientist or data engineer with a passion for turning data into actionable insights, we'd love to hear from you. Please submit your proposal, including your experience with similar projects, proposed approach, and estimated timeline. We look forward to working with you to build a robust database that will drive our investment decisions and help us identify promising opportunities in the target industry.

Database ArchitectureDatabase DesignPythonData ScienceData AnalysisData MiningBusiness Intelligence
Posted last week
  • Hourly
  • Expert
  • Est. time: 1 to 3 months, 30+ hrs/week

We are seeking a highly skilled PostgreSQL Data Architect to design our database infrastructure on AWS. You will be responsible for ensuring data integrity, performance, and security across multiple systems. Your role will involve creating efficient data models and design scalable solutions. For this phase of the project, you will be asked to create a data pipeline between salesforce and an Amazon RDS Postgres instance. It will connect the client journey from various Salesforce reports, including connecting Lead and Opportunity data. The database needs to be updated whenever a new lead or opportunity is created in salesforce, either real-time or in batch processes. It will use client MRN (medical record number) as the primary key, so that the data can be matched and cross-referenced with our EHR data. More details will be provided over the phone during the introductory call and once the job is accepted. Relevant skills: - Database design - Data modeling - Performance optimization - Database security - PostgreSQL - ETL

Database ArchitectureDatabase DesignPostgreSQL ProgrammingPostgreSQLSQLPythonETL Pipeline
Jobs Per Page: Â