Filter sql query jobs

Hello, We are F12Design, a platform where customers and designers come together and collaborate on graphic design projects. We would like to build an interactive dashboard to make the workflow simple and effective. Here are a few things on our mind: Languages - (Please free to suggest your own) Backend - PHP, jQuery, and SQL Frontend - HTML, CSS, and JavaScript For Real-time Demo/Example - Please sign up for and check their dashboard ########################################################## Social Login/Create account (Separate customer and Designer Login) ########################################################### Customer Dashboard Order Handling -------------- Past Orders Order Requirements (Quiz* and additional comments) Order Updates Order Delivery Date Order Tracking

...the following features: - User Registration and Login: Users should be able to register, create an account, and log in securely. - Item Listing for Sale: Registered users should be able to list items they want to sell. - Online Purchasing: A system that allows users to purchase items online, similar to Amazon's process. The website should also have: - Search and Filter Functionality: Users should be able to search and filter the items listed for sale. - Seller Rating System: A rating system for sellers to help users evaluate and choose trustworthy sellers. Ideal skills for this project include web development, e-commerce platform experience, user authentication and transaction systems, and good understanding of UI/UX design. Experience in developing similar e-com...

I am in need of expert help to get a standard definition video recording cleaned up so that the voices can be heard more clearly. The recording is marred by background music and ambient noises such as wind and traffic. Ideal Skills: - Audio Editing Experti...in need of expert help to get a standard definition video recording cleaned up so that the voices can be heard more clearly. The recording is marred by background music and ambient noises such as wind and traffic. Ideal Skills: - Audio Editing Expertise - Previous work in noise reduction and audio enhancement. - Experience working with video recordings. Expectations: - The final output should filter out the background music and wind/traffic noise but not affect the clarity of the voices. - Please handle the recordings confi...

I'm searching for a professional who is proficient in SQL coding specifically for MySQL database design. PowerShell scripting or similar would also be beneficial. This is a basic level project taking existing Local government procedures and converting them into SQL based processes. An example of which would be creating a import procedure for traffic count data that is presented in a text format (example attached) Ideal Skills: - Experienced with MySQL Database Design - Well-versed in SQL coding - Ability to simplify complex instructions - PowerShell for anything not possible in SQL This project will demand creativity and intelligence to design procedures that simplify data entry processes. Please only bid if you can offer solutions according to the...

I am experiencing slow query processing and management issues with large tables in my MySQL database, primarily storing transaction data. I am seeking a DBA specialist to diagnose and resolve these bottlenecks and improve the overall performance of the system. Ideal Skills and Experience: - Proven experience in MySQL database administration and optimization - Knowledge of query execution plans and optimization techniques - Proficiency in managing databases with 10-50 tables - Experience in handling databases primarily housing transaction data Tasks include: - Investigating and diagnosing slow query performance - Optimizing handling of large tables - Implementing necessary changes to enhance overall database performance.

I'm in need of an experienced web app developer to create a Food Finder application. This app aims to help users discover nearby food spots and make informed decisions based on peer reviews. Key Features: - Location-Based Search: The app should enable users to search for food options based on their current location or a specified area. The system should provide accurate results and filter distant options. - User Reviews and Ratings: Users should be able to rate and review the restaurants they've visited. The overall rating and individual reviews should be openly accessible to other users. Compatibility: The app should be optimized for web browsers to ensure universal access. Ideal Skills: - Proficient in web app development - Experience in creating location-based servi...

I'm in need of an experienced WooCommerce developer who can help me integrate a selective product feed from into my WooCommerce website, deripet...animale" category on and exclude other categories such as Furniture, Home Decor, and Garden & Outdoor. Ideal Skills and Experience: - Proficient in WooCommerce and experienced in working with product feeds. - Familiarity with 's product structure and data. - Attention to detail to ensure all product information is accurately integrated. - Ability to effectively categorize and filter products to include only those from the "Pets" category. If you have the necessary skills and experience for this project, I'd love to hear from you. Please provide examples of similar WooCommerce integrations you've ...

...fresh, modern, and appealing to visitors. We will provide the HTML design for all the pages. - Improve User Experience - Incorporate New Branding Elements - Upgrade the CI/ PHP version to the latest version - The site has a sub login area where the profiles of users are listed. - The users submit their listing info from the front end which creates the profiles. - There is a search function to filter profiles - Ensure the contact forms and all the functions of the site are functional Skills and Experience: - Proficient in PHP - Strong background in web development - Skilled in UI/UX design - Experience in incorporating branding elements into web design Please provide a quote along with your proposal, as I have a specific budget in mind for this project. Your previous work in...

I am in need of an experienced Chrome extension developer to create some chrome extensions Key Tasks: - Develop a user-friendly Chrome extension - Implement data extraction techniques to collect and organize information from various web sources. The ability to filter and manage this data is crucial. - Set up the extension for browser automation tasks. It should be able to perform repetitive actions on a webpage without manual intervention. Communication: I prefer to manage communication with the selected freelancer through the messaging feature available on Freelancer.com. Ideal Candidate: The ideal candidate for this project should have a proven track record in developing Chrome extensions, particularly those involving web scraping and data extraction. Experience in browser ...

...program that will retrieve an xls file from an email inbox in order to geocode the addresses present in the file via the Google Maps API and insert the geographic coordinates into an SQL table. You can follow these steps: 1. Retrieve the xls file from the mailbox - cron every hour 2. Normalize the xls file for integration into a MySQL table 3. Configure access to SQL database from JavaScript. 4. Insert data into table via SQL query 5. Retrieve addresses to be geocoded from the SQL table. 6. Use Google Maps API to geocode each address. 7. Insert the geographical coordinates (latitude and longitude) in the SQL table. Each line in the xls file corresponds to a delivery. The file has 15 columns. The column names are, in order: Shipment, Rush or...

I need assistance with scraping data from a website and delivering it in an Excel file. The specifics of the project are as follows: I am looking for a person who will conduct scraping sessions for our business on a regular basis. Desired skills are knowledge of screen-scraper software, sql, Someone with Python knowledge will be better. Willing to follow instructions. Not cramped up with other jobs or other side hustles. Need to have solid internet connection. Expected work takes 5-10 hours per week, once fully trained. Must be responsible. Able to accept PayPal. - The source of the data is a website. This means the freelancer needs to have experience in web scraping. - The data should be delivered in an Excel file. Proficiency in handling and formatting data into Excel is a mu...

...other criteria. You will need to use sales navigator and other tools to conduct effective data research. • Profile research: You will need to analyze and evaluate the profiles of the prospects you find and determine their level of interest, need, and fit for my business. You will need to use sales navigator and other tools to conduct thorough profile research. • Data filtering: You will need to filter and sort the data you collect based on the most relevant and important criteria. You will need to use sales navigator and other tools to perform accurate data filtering. • Data collecting: You will need to collect and organize the data you find in a spreadsheet or a database. You will need to use sales navigator and other tools to ensure data quality and consist...

Data Specialist: The Data Specialist is responsible for pr...information that is in databases, organizing and assembling the information so that teams can make decisions using data. Responsabilities: > Access database. > Create dashboards and analysis according to the demand of the business areas. > Update and automate dashboards that need frequent updating. > Provide suggestions of improvements in business areas. Requirements: > Mandarim is a must > SQL > Office Package > Database usage At Shein, we believe that diversity is the force that drives innovation. We are committed to creating an environment where all voices are heard, valued and respected. All our vacancies are inclusive for people with disabilities, women, black people, LGBTQIAPN+ com...

I need a skilled professional who's an expert in Azure Data Factory (ADF) development, SQL, Power BI, and ADF monitoring. Key Tasks: - Creating data pipelines - Building data transformation workflows - Integrating with SQL databases Power BI Usage: - Visualizing data through interactive dashboards - Creating data reports and analytics - Real-time monitoring and alerts ADF Monitoring: - Tracking data pipeline performance - Monitoring data integration processes - Setting up alerts and notifications for job failures. Ideal Skills and Experience: - Expertise in Azure Data Factory (ADF) development - Proficiency in SQL, Power BI, and data visualization - Strong background in monitoring ADF performance - Experience setting up real-time alerts and notifications - Pr...

I'm seeking a skilled WordPress website developer to create a multifunctional estate agency website for me. Key Features Required: - Property search and listing feature: A core aspect of my site will involve users being able to search and browse property listings. An effective search filter is essential. - Agent profile pages: The website will also need designated pages for agent profiles, allowing our real estate agents to connect with potential buyers and renters. Development Specifications: - The site will need to be large, consisting of more than 10 pages, each fulfilling a specific role. Ideal Skills and Experiences: - Proven experience in WordPress site design and implementation - Strong understanding of functionality requirements for estate agency websites - Detail-or...

I'm seeking an independent ASP.NET developer based in India with at least 5 years of experience, strong C# programming skills, and familiarity with SQL Server and Asp.net core. Your English skills will be crucial as direct communication with me is required. Key Responsibilities: - Develop a robust business management system leveraging ASP.NET - Implement user authentication and authorization features - Integrate appropriate APIs to enhance system functionality Ideal Candidate: - Minimum 5 years experience in ASP.NET development - Proficient in C# programming and SQL Server - Familiarity with Asp.net core - Experience in developing business management systems preferred - Strong communication skills for client call Please note that this project is only open to Indian-ba...

Hello i need to promote my glass filter for smoking website is www smooky dot tips. I'm looking for someone who can manage the whole ads thing (approval, managing etc) for at least 1 month. we want to target italy only with the ads. looking forward to hear from you!

...description of the website for managing employees, groups, and training: 1. Home Page: General presentation of the site and the features offered. Links to the different sections of the site: Employees, Groups, Training. 2. Employees Section: 2.1. Employee List: Display of all employees with their basic information (name, first name, position, establishment, hire date). Possibility to search, filter, and sort employees according to different criteria (by name, position, establishment, hire date, etc.). 2.2. Add/Modify/Delete Employees: Form to add, modify, or delete an employee with all their details. N.B: Adding or modifying an employee must include them in the already created groups. 2.3. Employee Details: Detailed page presenting all the information about a specific emplo...

... The role may also involve programming. Key points: - Coaching: I need 1/1 coaching via Teams on Data Analysis & Data Visualization within Azure Analytics - Programming: If the opportunity arises, the candidate could get involved in programming using SQL - Proficiency: I consider myself at an Intermediate level with Azure Analytics Ideal Skills and Experience: - Proficient in Azure Analytics: You should have a strong understanding of Azure Analytics, specifically in Data Analysis and Data Visualization - SQL Programming: Experience with SQL is a must as you may be involved in programming for this project - Teaching or Coaching Experience: Prior experience in teaching or coaching Azure Analytics would be advantageous - Strong Communication: The ability to clear...

...included in the job listing, such as job title, company name, location, job description, requirements, etc. # Web Interface: A user-friendly web interface where users can enter the URL of the job listings page and initiate the scraping process. # Downloadable in .csv Format: The scraped job data should be downloadable in .csv format for easy analysis and storage. # Filtering Options: Ability to filter job listings based on old vs. new jobs for specific job verticals (e.g., technology, finance, healthcare) and support for Middle East/GCC countries. # Scalability: The scraper should be able to handle a large volume of job listings from multiple sources without performance issues. # Scheduled Scraping: Optional feature to schedule regular job scraping tasks to keep the data up-...

...information in the legal field. Assist legal professionals in their analytical work to form stronger legal arguments. Application Features: Text-based Search: Enables users to perform text-based searches within legal documents. AI-powered Search: Allows users to conduct more specific and comprehensive searches through integration with OpenAI's GPT model. Filtering and Sorting: Provides the ability to filter and sort search results by criteria such as date, file type, and court name. User Profile: Allows users to access their past searches and save favorite documents. Semantic Analysis: Capable of performing semantic analysis on texts to find similar decisions and content. Timeliness and Reliability: Provides users with access to the most current and reliable information thr...

A business-centric, data-oriented, and analytical mindset. Comprehensive knowledge of data science concepts and disciplines. Knowledge of enterprise information management processes and methodologies. Skills in database design, data security, and data lifecycle ...considerations. . Combinations of experience and education will be considered on a case-by-case basis. Experience in data warehousing and governance. Practical experience in enabling data usability, availability, and efficiency. Experience in data management, quality, metadata management, and modeling. Knowledge of database systems: MS SQL Server, Oracle, or another commercial RDBMS required, Snowflake, or other non-relational database desired. Knowledge of SQL. Experience with scripting languages, especially Python...

..."International Chinese Education Demand Monitoring, Prediction and Countermeasures Research based on Big Data", and create a website that can query the real-time popularity of Chinese learning language in all countries, the following is a website layout and function plan: ### Web Site name: Global Chinese Learning monitoring platform ### Website Layout: 1. * * Home page * * -Top navigation bar: contains the site name, search box, and user login / registration options. -Global map: 1. Identify the popularity of Chinese learning in different colors.2, Click each country, can feedback heat data, etc., you can jump to the second plate 2. * * National heat query * * -List of countries: arranged alphabetically for user search. -Search function: enter the name of the c...

I'm in need of a skilled developer who is experienced with inventory management systems, report production, analytics, user access control, and Windows-based applications. This job involves maintenance of a warranty return tracking software, with specific attention to: -...considered a plus. The overriding purpose of this software is to track and manage warranty returns effectively. Ideally, you should have previous experience in software creation and maintenance for tracking and managing products. The purpose of this project would be Bug fixing and improvement of the software tool already existing. Required: Experience with ER Models architecture Experience with MS SQL server 2017 express as DBMS Experience with Python 3.8.3 and Tkinter GUI toolkit Experience with Powe...

...positivity or negativity. • Provide insights to employers regarding the sentiment conveyed in job postings and candidate applications to improve communication and candidate experience. 7.4 Automated Candidate Screening: • Implement AI-driven screening mechanisms to automatically evaluate candidate applications based on predefined criteria and job requirements. • Use machine learning classifiers to filter and rank candidates, reducing manual effort and time spent by recruiters in the initial screening process. 8. Data Security and Privacy: • Implement robust data security measures to protect user data and ensure compliance with data protection regulations such as GDPR. • Utilize encryption techniques for securing sensitive information such as user creden...

I'm seeking a skilled Adobe Lightroom expert to create vintage themed presets. My primary focus is on product photography and I need presets that can effectively enhance this. Key Requirements: - Proficient understanding of Adobe Lightroom. - Experience with creating tailored presets. - Specific knowledge in creating vintage-style filters. - Experience in product photography enhancement would be advantageous. The final presets should allow easy, one-click edits and significantly speed up my editing process. I expect the presets to result in vibrant and stylish promotional product visuals.

I'm looking for a skilled app developer to create a comprehensive Grocery Delivery App for both iOS and Android, with a particular focus on user experience. Key Features: - User Registration and Login: The app should allow users to create accounts, login securely, and manage their profiles. - Search and Filter Products: Users must be able to easily search for products, filter by category or brand, and add items to their cart. - Order Tracking: It's crucial that the app includes a feature to track orders in real-time. This should provide customers with an estimated delivery time and status updates. Payment Integration: - The app must feature a secure and seamless payment gateway. This is essential for processing transactions and ensuring a smooth user experience. ...

I need an adept SQL developer proficient in crafting SQL queries for various tables within our database. The task entails generating four queries, each encompassing approximately 20 conditions that must be met. Utilizing ChatGPT, could you assist in devising these queries?

I'm in need of an experienced SQL Server data warehouse designer to help with a project of integrating and consolidating data from different sources. Key requirements: - Expertise in SQL Server: You should be able to design, implement and optimize data warehouse solutions on SQL Server. Understanding data warehouse design principles is essential. - Data Integration: You'll need to work with some of our developers / power users to source data and establish automated integration; experience with integrating relational databases and APIs from web services is crucial. - Data Consolidation: You should be able to create a cohesive, consolidated dataset from these different sources applying appropriate design principles. - Medium-sized project: The data needing in...

Hello everyone. I need a query for prestashop version 1.7.8.10. I need to run 2 times a day a check script on products that have quantity 0. When I have quantity 0, I need to disable the product. I need a script that performs this operation 2 times a day.

I'm looking for a skilled developer to create a user-friendly platform that will serve as a comprehensive search tool for ...skills for this job include: The ideal candidate should have relevant experience with frontend and backend development, a solid understanding of React.js, Java, PostgreSQL and an eye for UI/UX designing. - Proficiency in web development, particularly in creating user-friendly interfaces. - Experience with database management and system design. - Ability to integrate a search mechanism that can filter dormitories based on the desired criteria. - Knowledge of security protocols, as sensitive information will be handled. This project is crucial for the student housing sector and has the potential to greatly ease the process of finding suitable accommodation...

Note: Budget Fix 2000INR and time line 5 Day's I have a project currently in Codeigniter 3, and I'd like it converted to Laravel 10. This pro...will require thorough understanding of both frameworks, and it's crucial that all existing features and functionalities are precisely replicated in the new version. While I don't have specific features to prioritize, I will identify specific elements as the project progresses. Skills and experience required: - Profound knowledge in Codeigniter 3 and Laravel 10 - Expertise in PHP development and SQL databases - Proven experience in similar conversion projects Note: The finalized budget for this project is 2000INR. Please only bid if you can work within this budget. The timeline for project completion can be discussed d...

I am looking for Website for B2B and B2C. Data will be reflect to the Admin portal from both B2B and B2C pages. Need to create 5 pages for Website B2B Page Tasks Need to create Query request form on B2B Need to create registration form on B2B Need to create Inventory management page on B2B B2C Pages Need to create registration page using whatsapp, social media and phone Customer can search for the desired result which will be based on the B2B inventory management page In the result page our recommendation will be listed at the top Need to create app for B2B and B2C for android/IOS

I am in need of a skilled prog...skilled programmer to create a bot, effectively able to filter out vehicle listings and send them directly to me on whatsapp , twillio etc (any) Key Responsibilities: - The bot should primarily use Craigslist, OfferUp, and Facebook Marketplace platforms for sourcing listings. - The bot should filter vehicle category listings exclusively. Vehicle Filtering Criteria: - Vehicle make and model - Year range - Price range - Distance Ideal Skills: - Experience with bot programming and development - Familiarity with Craigslist, OfferUp, and Facebook Marketplace APIs - Understanding of the automobile market, specifically characteristics and identifiers - Proven track record of creating bots that can quickly and effectively f...

...high-complexity T-SQL stored procedure used for data analysis that I need translated into PySpark code. The procedure involves advanced SQL operations, temporary tables, and dynamic SQL. It currently handles over 10GB of data. - Skills Required: - Strong understanding and experience in PySpark and T-SQL languages - Proficiency in transforming high complexity SQL scripts to PySpark - Experience with large volume data processing - Job Scope: - Understand the functionality of the existing T-SQL stored procedure - Rewrite the procedure to return the same results using PySpark - Test the new script with the provided data set The successful freelancer will assure that the new PySpark script can handle a large volume of data and maintai...

...a OneDrive folder. The OneDrive folder will have subfolders for each month containing our company’s purchasing and selling invoices. The GPT should be capable of answering questions related to these invoices. For example: "Sum all subtotals of invoices in folder April2024invoices." Integration with Excel: From within Excel, I want to be able to call the custom GPT "GPT-Invoices" by writing a query in a cell. For example, in cell A1, I should be able to write: =GPT-Invoices("sum all Subtotal values of invoices of April 2024"). The output answer should be returned in the same cell (A1). Deliverables: A fully functional GPT-Invoices model that can analyze invoices from OneDrive folders and answer queries as described. A VBA (or other appropriat...

We are looking for a developer to create a Bootstrap filter table with advanced filtering functionality. The table should be responsive and able to handle multiple columns. Here are the specific requirements for the project: *** DO NOT BID ON THIS PROJECT IF YOU HAVE NO UNDERSATNDING OF BOOTSTRAP OR SOME IDEA OF THIS PROJECT. A TEMPORAY SKETCH LAYOUT WITH A SAMPLE WITH BE APPRICATED TO HELP US IN MAKING A DECISON WHO TO AWARD THE PROJECT TO. *** Functionality: - Advanced filtering: The table should allow users to filter data based on multiple columns. - Custom filtering: Users should be able to specify criteria for filtering. Responsiveness: - The Bootstrap table should be responsive, ensuring optimal user experience across different devices and screen sizes. Columns: - ...

App Requirements - **User Management:** Account creation and login via email or Google account, admin panel for managing user accounts. - **User Profile:** Profile completion with name, photo, description, and payment information. - **Geolocation and Filters:** Find nearby services using geolocation, filter services by category, distance, etc. - **Service Posting:** Service providers can publish services with details, photos, and prices, users can view service details. - **Messaging:** Integrated messaging system for users and service providers. - **Payment System:** Secure payments for services, admin management of transactions and commissions. - **Admin Panel and Statistics:** Dashboard for managing users, services, and transactions, view usage statistics and reports. - **Testing ...

Our ex...script is encountering issues when importing the exam's section breakdown from a .dat file. Due to this, we are unable to import the breakdown of results per section of the exam into the SQL database. We are seeking a proficient developer who can: - Analyze our existing CGI script and identify the cause of the breakdown import issue. - Provide actionable advice and steps to troubleshoot and resolve the problem. - Ensure the script effectively imports the section breakdown from the .dat file as intended. The ideal candidate for this project should have: - Extensive experience in CGI scripting and SQL database management. - Proficiency in handling and troubleshooting data import/export issues. - Ability to work quickly and efficiently, as we need thi...

I'm looking for a skilled developer to create a modern, vibrant website using CorePHP. The design should be bold and colorful, catering to a business professional audience. Key Requirements: - Frontend: The site should offer a minimalistic yet engaging design that is appealing to the eye. - Backe...incorporate interactive product displays to make the user experience more engaging and dynamic. Ideal Skills: - Strong proficiency in CorePHP to develop and maintain a dynamic website. - Prior experience with designing websites with bold and colorful themes. - A good understanding of user experience (UX) and the ability to create interactive elements on the site. - Familiarity with product search and filter functionality is a plus. If you believe you have the skills to create th...

I'm looking for a skilled developer to update...controllers in my Laravel backend for my React Native application. Specifically, I need help with a single task to start, and if that goes well will task additional items thereafter: 1. Laravel Backend has a 'ProviderController' which sends 'Provider' results to app based on distance within radius. There is a 'Mobile Only' option that when checked is not limiting results to within that radius. The query is a bit messy, but is likely where the change needs to be made (see attached). App is published to TestFlight already and should not need to modify React Native source to address this, but can provide if needed. Ideally looking for a developer who can fix this bug fairly quickly, then will have on...

...give you access to the source site if needed, but you then ideally will be able to make sense of the setup and put things in place as intended to achieve this functionality without recreating the wheel. As an example, there is a Styles page for which a screenshot of the hero section is attached, showing Portfolio Items as well as Artists related to that style. The Artists are shown via a Query Builder query that uses a "Grandchild/Grandparent" relation, looking at the Portfolio Items related to the style, then checking the Artist that is related to those. So, the setup has no need to associate Artists to Styles, since Artists are Related to Portfolio Items that themselves are Related to Styles. This may sound complex, but you need not understand it from this&md...

...Development: Use HTML, CSS, and JavaScript for the frontend, with frameworks like React or Angular to enhance the user interface. Backend Development: Python with Flask or Django for server-side logic, handling API integrations, and user data management. Machine Learning: Use TensorFlow or PyTorch for building the recommendation engine, and NLTK or similar libraries for sentiment analysis. Data Management: SQL or NoSQL database to store user profiles and their preferences. Version Control: Git for source code management and collaboration. Submission Requirements: Code: Source code with comprehensive comments detailing the functionality of each part of the system. Documentation: A detailed documentation covering the system design, implementation details, and instructions for setti...

...a clean and minimalist interface, making it easy for users to navigate without any confusion. The design prioritizes simplicity, with clearly labeled buttons and intuitive menus. Smart Search Functionality: The app features a robust search function that allows users to quickly find restaurants based on various parameters such as cuisine type, location, price range, and ratings. Users can also filter their search results to narrow down their options. Visual Menus: Dine0ut provides users with visually appealing menus that showcase each restaurant's dishes with high-quality images and detailed descriptions. This helps users make informed decisions about their orders, enticing them with mouth-watering visuals. Customization Options: The app allows users to customize their ord...

...clear transcription of everything that is said in the audio file, including any noises or sounds that are part of the recording. You will need to have excellent listening skills and attention to detail to accurately transcribe this audio. Additionally, it would be helpful if you have experience in audio editing to filter out any background noises that could make the transcription process difficult. Key requirements: - Transcribe a 33:05-minute audio file accurately. - Filter audio to ensure clear transcription. - Include all sounds and noises in the transcription. - No time stamps are needed, just the audio in text form. Ideal Skills and Experience: - Proficient listening skills. - Attention to detail. - Experience in audio transcription. - Audio editing skills. Ple...

...reporting, complex SQL formation, and more. The primary purpose of the project is to streamline and enhance our data storage capabilities. By integrating new data into our warehouse on a monthly basis, we aim to improve our decision-making and business performance through enhanced data access and analysis. Key responsibilities include: - Reviewing and providing recommendations on the SOW for data warehousing - Offering expertise on ad hoc reporting and complex SQL formation - Helping to streamline data storage and improve decision-making - Ensuring the architecture can support monthly data integrations Ideal candidates should have: - Proven experience as a data architect - Expertise in data warehousing and ad hoc reporting - Strong SQL skills, including complex ...

...Integration: Fetch device statistics from a backend API. Modern UI: Clean, intuitive, and well-designed user interface. Key Features: Device List Display: A dashboard-like interface showing all IoT devices. Dynamic Graphs: Display statistics and data in a graphical format (around 10 different graphs). Data Tables: Tables with pagination to display detailed data. Filtering and Time Ranges: UI elements to filter data by different criteria, including time ranges. API Integration: Seamless integration with backend APIs to fetch and display data. Skills Required: Proficiency in Svelte and SvelteKit Experience with Skeleton UI or similar CSS frameworks Strong understanding of modern web development practices Experience with API integration Ability to create clean and user-friendly in...

...give you access to the source site if needed, but you then ideally will be able to make sense of the setup and put things in place as intended to achieve this functionality without recreating the wheel. As an example, there is a Styles page for which a screenshot of the hero section is attached, showing Portfolio Items as well as Artists related to that style. The Artists are shown via a Query Builder query that uses a "Grandchild/Grandparent" relation, looking at the Portfolio Items related to the style, then checking the Artist that is related to those. So, the setup has no need to associate Artists to Styles, since Artists are Related to Portfolio Items that themselves are Related to Styles. This may sound complex, but you need not understand it from this&md...

I need a skilled professional to add (2) Adjustable analog input noise filters to an existing ( Kinco builder) program. The filter intensity needs to be adjustable In the settings screen on the HMI.(Kinco D tools)

...Optimize database performance through indexing, query optimization, and other performance tuning techniques.  Develop and enforce data standards and best practices to ensure data integrity and security.  Provide technical guidance and mentorship to junior developers.  Troubleshoot database issues and provide timely resolution.  Stay up-to-date with the latest trends and technologies in database management and architecture. Skills and Qualifications  Bachelor's degree in Computer Science, Information Technology, or a related field. Master's degree preferred.  8+ years of total experience.  Minimum of 5 years of experience in database architecture and development, with a focus on Netezza and Oracle.  Proficiency in SQL and PL/SQL programming l...