Auto suggestion ajax mysql jobs

i have one php script which used to load in a few seconds now takes 4 minutes not sure why it suddenly lags need optimised - the mysql query hittin some bottleneck somewhere by looks of it

I'm looking for a skilled graphic designer to create a logo for an insurance company that specializes in commercial business, home, auto, and life insurance. Name of company is Build 2 Suit Insurance Advisors Key Project Details: - Color Scheme: The logo should incorporate shades of blue and orange. - Emotion & Message: The design needs to reflect a sense of professionalism and modernity. Ideal Skill Set: • Proven experience in logo design • Strong understanding of color theory • Ability to convey complex messages through simple designs. Please include similar previous work samples in your proposal.

I'm looking for an Electrical Engineer who is experienced with Raycus Laser systems and its associated components such as Raytools BM110 Auto Focus, Raytools Software, and leadshine servo drives. The main role involves configuring these elements to integrate seamlessly. Key Requirements: - Proficiency in configuring Raycus Laser hardware, Raytools BM110 Auto Focus, Raytools Software, and leadshine servo drives. - Experience with CNC Gantry Function Software. The ideal freelancer should: - Have demonstrated experience in machinery and software configuration. - Be located near Reno, NV for potential onsite work. - Prioritize accuracy in their work, as ensuring the correct configuration is my primary focus.

Hi there. I'm running XCode 15.3 and I need a few pages done with simple, clean storyboards and View Controllers. I use Alamo Fire and Swift, so if you could use that to pull my data via my API links and display it in several pages that would be great. Categories > Collections > Items > Item Details You select one and it shows a list - Item Details is one record from a MySQL db I need each selected item to be a variable in the code of the ViewController so if I use the print function, I can see it at the bottom of XCode. I'll give you the 3 or 4 API webservice links. I can give you a super simple app to put it in too...

[NO AUTO GENERATED APPLICATIONS… WILL BE DELETED] I need someone familiar with affiliate marketing programs and sites. Someone that can find me some good affiliate products for me to ask. I'm hoping you can find impressive products that have potential to go viral. Tell me some good affiliate products into Instagram. You will search programs like Clickbank, Sharesale, etc. In your application tell me about some products that you have found for clients. Have you ever sold affiliate products through Instagram?

...The ecommerce is up and running and fully operational and we need a FULL STACK developer that can code in ALL AREAS of the webapp. - Frontend: React (JavaScript) - Backend: Node.js - Services: Python - Database: MySQL RESPONSIBILITIES: - Integration of new B2B APIs - New payment gateway integration - - Implementation of bug fixes and performance improvements. - Regular software updates and security patches. - Feature additions and enhancements. Skills and Experience: - Proven experience in maintaining e-commerce solutions. - Proficiency in React, Node.js, Python, and MySQL. - Strong problem-solving skills. - Excellent understanding of software best practices and design patterns. - Ability to work independently and meet deadlines. - .NET and are a plus but not a requir...

Please Sign Up or Login to see details.

...serve as lookup tables (see access file attached) If more tables needed to be created you can do it. Not all relationships are created in MS Access file. You have to make them as needed. Reports, queries etc. will be created from administrator locally only. No need to view them online (reports and queries). We will give you access to a cpanel for the database and web interface We are open to any suggestion as far as the outcome will be the same. Ideal Skills and Experience: - Proficiency in database development, particularly web databases and Microsoft Access. - Strong skills in designing and implementing data visualization features. - Understanding of user interface design and experience with creating customer-facing interfaces. Must be completed in 2-4 days...

We need an experienced Magento developer to assist with updating third-party extensions when conflicts arise due to newer php/mysql versions. Timeline: Start on the first project on 20th May using remote desktop tools like UltraViewer or AnyDesk for real-time collaboration. Bidders must be highly proficient in Magento 2.4x.

I need a desktop application that can carefully monitor a MySQL database on my Windows system. The app should be able to perform the following functions: - **Monitoring MySQL Database**: The application should constantly monitor my MySQL database and detect when a new record is created. - **WYSIWYG Template Management**: There should be a feature that allows me to manage various WYSIWYG templates. These templates would be used to generate dynamic PDFs based on the new records in the database. - **PDF Generation**: Upon detecting a new record, the application should automatically generate a PDF based on a selected WYSIWYG template. Naming convention based on filed in processing record. Option Password added to pdf. I would like the application to be user-friendl...

We are in search of a skilled software integrator to help me integrate my personal deployment system with a...and attention to detail Details - Upload Excel file containing Expediente Codes - Use automation and OpenCV to solve Captcha and download files - Upload files to s3 bucket - Integration with existing system - use google to authenticate to the system (maybe change to office 365) Requirements: - REMOTE SERVER: Existing server - Access to S3 Bucket - Access to chatgpt api - Access mysql aws instance We need access to final git repository Project Completion: 2 weeks This project is an exciting opportunity to work on a cutting-edge software integration and development. If you have the right skills and enjoy a challenging, innovative project, I'd love to...

I'm seeking a skilled developer to create the back-end of an auto-caption platform. Your responsibilities will include developing the caption editor, system templates, and additional necessary functionalities. Key Features: - Real-time captioning: The platform should have the capability to provide real-time captions. - Language translation: Incorporating language translation services is imperative. - Caption customization: The platform should allow users to customize captions as needed. - Workspaces for teams/agencies: The system should support collaborative workspaces, ideal for both individuals and enterprises. Ideal Skills: - Proficiency in Python, Java, and C# is a must. - Experience in developing similar platforms. - Strong understanding of back-end development. - Famili...

I am looking for a proficient full stack developer to help with a personal project. Using NodeJs and NextJs with MYSQL DB, your skills will include: - Expertise in utilizing NodeJs and NextJs - Develop a user-friendly platform - The ability to brainstorm and bring creative digital solutions - Strong problem-solving skills - Understand project requirements and deliver high-quality work - Should be proficient in using Github with AWS and coordinate with infra team member for coordinated push - Understands and knows the importance of proactive communication Expectations: - Your primary responsibility will be to design and develop the application, and to coordinate with the rest of the team working on different layers of the project. - Daily commitment for a minimum of 4 hours f...

I have two websites that need to be merged with a main focus on consolidating information. The current websites are different in design and themes, and I'm looking for a professional who can successfully merge them into a cohesive, user-friendly site. Key requirements: - Cons...seamlessly Please let me know your experience with similar projects and your approach to this particular task. Your input on the best ways to consolidate the information and prioritize content is highly appreciated. Website language is: - Linux AMI > OS - PHP > web and back-end - NodeJS > ICS - > ICS & Warehouse App - Ionic v1 > Warehouse App - Apache > web server - Database: MySQL Aurora - AWS hosted, leveraging EC2, RDS and S3 - Front-end is custom framework mix of ...

Automatic Backtest with given parameters

...several years old. For example Node JS 7.10.0 and MySQL 5.7.0. Everything needs to be updated to highest stable version that offers support and packages. For Node.Js that will likely be version 18 or 20 Moreover, this project offers an excellent opportunity for more development. **QUOTE: UPGRADE** -Please provide a quote for upgrade of website, iOS & Android apps, and admin panel. -The Framework described below. -Specify team size and roles. -Time frame for completion. **PLATFORM FRAMEWORK & DETAILS** Framework: React, Node, Express, React Native Frontend: React (website), Node + Express (APIs on server), React Native (mobile apps on iOS & Android), Bootstrap (making UI web responsive) Backend: Node.js (latest version), Express, MySQL Deployment:...

I'm in need of an expert to help me build and implement an automated trading bot specifically for the Binance exchange. The Bot should: - Open position at the opening of specific bar based on EMA: The rules are simple, when bar closes above/below EMA it is counted as a first bar, any other candle after the first bar which do not close again above/below EMA is counted along. When 5th candle is still above/below EMA the bot should open position at opening price of 6th candle. If any candle again closes above/below EMA, counting is restarted. - SL will always be placed at High or Low of one bar back from the candle when position was opened depending on If it is short or long; - TP will always be equal to price difference betwen Open Price and SL price multipied by 6. TP = (SL Pr...

I urgently need a skilled professional to set up a E-commerce website on AWS. Website is already hosted in AWS instance but due to some error website is stop, We need to start website Tools : php Mysql

I'm seeking an expert in Failure Mode and Effects Analysis (FMEA) and Process Failure Mode and Effects Analysis (PFMEA) to help in refining ...Process Failure Mode and Effects Analysis (PFMEA) to help in refining our manufacturing processes, primarily concerning Product A, Product B, and Process C. The ultimate goal is to improve the product quality, enhance efficiency, and bolster safety. Expectations: - Thorough inspection and analysis of current processes - Identification and rectifications of potential failure points - Suggestion of practical changes to enhance product quality, efficiency, and safety. Ideal skills & experience: - Proficiency in FMEA and PFMEA - Background in the manufacturing industry - Previous work with similar products and processes w...

I require an experienced Web Developer to undertake a project we have. The website we need is a comparison website for Coach hire. This will entail a booking system where Coach companies (Operators) will bid/tender for work etc. Below are the features. User Registration and...Users can rate and review operators. • Reviews influence operator rankings. Admin Dashboard: • Admins manage users, operators, bookings, memberships, and more. • Monitor platform activities and resolve disputes. This kind of platform requires a combination of front-end technologies (HTML, CSS, JavaScript), back-end technologies (server frameworks like Node.js/Express or Django, databases like MySQL or MongoDB), and potentially third-party APIs for features like payment processing and Googl...

I'm seeking a skilled Android app developer who can design an app wit...that plays Carrom Pool, offering a fun and competitive user experience. The AI should have a unique functionality - auto play. The main elements of this project include: - Incorporating user registration/login feature - Implementing more features - Integrating AI to play the game The freelancer for this project needs to have a strong experience in gaming app development and AI integration. Expertise in creating AI's that can auto-play within a game design is crucial. It will be an added advantage if you've had specific experience with Carrom or similar ball-and-striker games. Your task will be to create an app where the user can play against an AI, with the AI capable of auto-play...

I am currently in need of an experienced Django developer to assist me in deploying my Django web application on a VPS hosting provider. To bid on this project, you should: - Have intermediate to advanced level experience with Django and its related technologies. - Be proficient in MySQL, as this is the specific database system that my Django application is built with. - Understand VPS hosting thoroughly. Your role will be to guide me through the deployment process, ensuring that the application runs smoothly and functions as expected on the VPS host. Please show proof of similar projects handled in the past. Your time commitment should be immediate and full-time until completion of deployment. Your proposal should include a plan of action detailing how you intend to carry out ...

...primary goal is to automate data entry processes. The current application contains manual data entry. I am attaching a screenshot of how it is entered manually and a picture of the paper from which it is typed. OCR should be done automatically. We can take pictures with a mobile phone in a few seconds so that everything is finished. The application is in spring boot and angular. The database is mysql. Functionality for Taking Photos Using HTML5 and JavaScript, you can use an input element with the type file and the attribute accept="image/*" to allow users to take pictures of documents directly from the browser on a mobile device. Uploading the Image to the Server When a user takes a picture and clicks the save button, the image is sent to the backend server via an ...

...particularly focusing on Financial Management and Supply Chain Management. - **Power Platform Integrations**: Require your support in: * Data integration: Ensuring seamless data exchange between the two systems. * Workflow automation: Developing and implementing automated workflows for various business processes. - **Vendor Invoice Creation**: The vendor invoice creation process should include: * Auto-population of vendor details: Ensure vendor information is correctly filled in. Ideal Skills and Experience: - Strong background in Microsoft Dynamics 365 F&O, particularly in Financial and Supply Chain Management modules. - Proven experience in developing and implementing integration solutions using Power Platform, including data integration and workflow automation. - ...

I am hiring for a Full Stack Web3 developer for my team. Tech Stack: Blockchain: Blast (EVM) Frontend: Typescript + NextJS + Tailwind + Vercel + WAGMI + Ethers V5 + Typechain Backend: Typescript + Vercel Lambda + tRPC + AWS + Prisma ORM + Ethers V5 + Typechain + Upstash Redis Database: MySQL (Planet Scale) + AWS S3 Storage Randomization: Gelato VRF Static File Hosting: AWS S3, Pinata Smart Contracts: Foundry, Hardhat Monorepo. Here you go: Objective: Design and implement a scalable backend and frontend system for tracking and displaying NFT transactions similar to the "Activity" feature on OpenSea The system should handle varying loads seamlessly, from 500 to 50,000 users. Tasks: System Architecture Design: Task: Design the overall architecture for the activity

I'm seeking a Business Development Representative to expand our presence in the Venezuelan auto industry. As a part of our team, you will be responsible for both B2B and B2C sales, with considerable focus on the former. Key Requirements: - A bachelor's degree, ideally in a relevant field such as Business or International Relations. - Fluency in both English and Spanish. - Previous experience in sales, particularly in the automotive industry, is a plus but not mandatory. Your primary responsibilities will include: - Developing and implementing strategic sales plans to expand our market in Venezuela, targeting both business and consumer segments. - Building and maintaining strong relationships with potential clients. - Representing our interests in a professional and effe...

I am looking for someone that has listened to the Drake vs Kendrick Diss tracks many times. I need someone that is very active with the culture & knows almost everything thats going on in this beef. I need someone that has seen all the memes around the beef. And knows the history of the beef. I'm looking to put together some conte...the beef. And knows the history of the beef. I'm looking to put together some content around this beef. And I need someone that can guide me. 1. How old are you? 2. Where do you live? 3. Who do you think won the battle and why? 4. If I needed you to defend the loser, could you do so? 5. Tell me something interesting about this beef? 6. What social media platforms are you active on? 7. Did you auto generate this application you sent me,...

Build an AI based tool that has auto voice dubbing and auto voice separation for my videos and Auto dubbing for over foreign 80 languages with close captioning text and an AI-based tool that automatically animates, lights and composes CG characters into a live-action MP4 video scene in AI and Machine learning. Build AI based tool for auto dubbing, close captioning text, Create Professional custom 3D Character animates, lights, and composes CG Robot and Alien and creates custom Voices for the video 3D Robot & Alien characters. You will need to help me create any needed AI access and License accounts. I am seeking a proficient developer to create an AI-based tool that automatically animates, lights and composes CG characters into a live-action scene ...

I'm looking for a skilled freelancer to integrate MailChimp with my WordPress website. The main objective of this integration is to set up and automate email campaigns. Key aspects of this integration will include: - Setting up MailChimp on my WordPress website - Designing email templates in MailChimp - Configuring automated email campaigns To ensure the campaigns are effective and engaging, it's crucial that the emails are: - Scheduled at optimal times - Personalized to each user's preferences and interactions Ideal Skills and Experience: - Proficient in MailChimp and WordPress - Experience in setting up automated email campaigns - Strong understanding of user engagement strategies

...full time developers. This platform will reside on the AWS network, preferably using MySql and Linux. We will be recreating a PHP/MySQL platform to a JavaScript/MySQL platform with approximately 200 features. This new platform will require a significant upgraded user experience, integration of animated graphics and faster reports processing. Our current platform has some components that are 10 to 20 years old. You will be creating from scratch and not using ANY of the current code. Key Developer Requirements: - Extensive experience in JavaScript platform development. - Access to skilled User Experience programmers - Knowledge in Google Mapping - Knowledge with AWS and setting up Linux servers and MySql databases Your team will be replicating our current s...

Looking for an experienced HTML5 developer to create a customizable video player to be embedded on a website. This video player should be able to handle a playlist function and advances to the next video automatically after a video has ended. Key Features: • Playlist Management: Auto-play next video feature is crucial. • Subtitles Support: Built-in support for video subtitles. Ideal Candidate: • Proven experience in HTML5 and JS. • Familiar with video player development. • Understands user interface and experience design.

...experienced in Apache NiFi to create a workflow pipeline. This will involve converting and integrating data into MySQL. Key Requirements: - Proficiency in Apache NiFi: You must have a solid understanding of the platform to develop efficient and reliable data conversion workflows. - MySQL Integration: Experience in integrating data with MySQL is essential. - Data Conversion: You will be responsible for converting the data - previous experience in this area is highly desirable. Please note the following: - The type and source of data to be converted is not yet defined. - The triggering mechanism and frequency of workflow runs are also pending. Ideal Skills: - Proficient in Apache NiFi - Strong MySQL Integration skills - Previous experience in data conversion...

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 basic complex...

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 am looking for a skilled website developer who can help me revamp my current website which is a EUROPE tour operator, for planning European AUTO tours!!!!! / This is what I aspire to: - **Design and layout:** My site's current design could use a new look. I would like to improve the user interface and overall aesthetics to make it more attractive and modern. - **Functionality and features:** I am looking to add new features to my site. The main goal is to make it more interactive and user-friendly, including adding profiles and user accounts. - **Performance and speed:** I would also like to improve the performance and speed of the website, ensuring it is fast and responsive for all users. - **Determine a solid

Main task: The DFG team currently has a large backlog of cases, both children and adult, that needs to be dealt and processed promptly and efficiently. We will be undertaking a process review to enable us to achieve eliminating the backlog. What suggestion would you have to update the process, the service, ensure HBC compliance, and ultimately customer satisfaction I've got a comprehensive pdf presentation on health and wellness and my goal is to transform it into an impressive, high-quality presentation suitable for a corporate setting. Key Points: - I need a professional, polished style, similar to what would be expected in a boardroom presentation. - The presentation is targeted towards executives, so it needs to be visually engaging and informative. - It's crucial ...

I need assistance to effectively integrate a post form into my project. The form should be skillfully designed to send data to a MySQL database, and to handle CRUD operations. Key Requirements: - Collaborate with me to understand the form's workflow and user interaction. - Skillfully implement the form to effectively send user data to a MySQL database. - Ensure the form is able to perform Create, Read, Update and Delete operations, where necessary. Ideal Skills: - Proficiency in form implementation. - Strong experience with MySQL databases. - Good understanding of web project workflows. Your bid should demonstrate your understanding of the requirements and provide a clear strategy for how you intend to approach this project.

...structure, directories, and templating system (Liquid). Experience manipulating orders, grabbing data from the database, and crafting custom views using Liquid shortcodes. Proven ability to develop custom Shopify plugins to achieve complex functionalities. Technical Skills: Proficiency in Shopify development languages (Liquid, JavaScript, HTML, CSS). Experience with database manipulation (likely MySQL). Communication & Collaboration: Excellent written and verbal communication skills in English. Ability to clearly explain technical concepts to non-technical stakeholders. Comfortable participating in regular video calls to discuss project progress. This is a long-term project for a passionate developer who thrives on pushing boundaries. Are you ready to take Shopify to the ne...

I'm looking to integrate Optical Character Recognition (OCR) into my web application. The primary goal is to automate data entry processes. The current application contains manual data entry. I am attaching a screenshot of how it is entered manually and a picture of the paper from which it is typed. OCR should be done automatically. We can take pictures with a mobile phone in a few seconds...primary goal is to automate data entry processes. The current application contains manual data entry. I am attaching a screenshot of how it is entered manually and a picture of the paper from which it is typed. OCR should be done automatically. We can take pictures with a mobile phone in a few seconds so that everything is finished. The application is in spring boot and angular. The database ...

The aim of the project is to create a nodeJS 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, ...

...scalable backend infrastructure that can handle high volumes of bookings while ensuring a smooth user experience. I need a skilled Core PHP Developer to build a custom web application with database management capabilities, using MySQL as the preferred database management system. The application should be well-structured and efficient with an emphasis on data handling. Key Requirements: - Extensive experience working with Core PHP. - Proven track record of developing dynamic, secure, and efficient web applications. - Strong understanding and experience with MySQL database management. - Ability to ensure the application is well-structured and follows best practices for data handling. - Strong problem-solving skills and the ability to work independently. ?️ Key Responsibi...

We have a firebase collection which we need to listen in flutter web project, and whenever a new document is added we want to print the details automatically. We are looking for experience flutter web developer who can finish the task.

Hello, I need someone to update a logo with a TM icon and change the tagline to “Auto Implicación-Extrema” Logo file is attached

I have an existing Laravel-based ecommerce application that requires a series of modifications and additions. Key Tasks: - **New Tables & Conditions**: I'm looking to add several new tables and conditions to the application. Skills & Experience: - **Laravel Proficiency**: I'm seeking a seasoned Laravel programmer who has extensive experience ...Proficiency**: I'm seeking a seasoned Laravel programmer who has extensive experience with ecommerce applications. The ideal candidate should be highly proficient in Laravel framework and comfortable creating new tables and conditions within the application. - **Database Management**: A solid grasp on database management is crucial to successfully add and integrate these new tables. Experience with MySQL or other r...

I'm looking for an experienced PHP developer who is well-versed with MySQL to help me with editing the search module of my website. The primary focus of this project is on modifying the way images are retrieved then displayed in the search results. Key Requirements: - Modify the retrieval of images in the search results to use URLs for specific sizes as opposed to the current methodology of storing images locally and then displaying. - No specific enhancements are needed for the image thumbnails, just an adjustment in the retrieval and subsequent display methodology. Ideal Skills: - Proficiency in PHP and MySQL - Experience with implementing search modules in web development - Familiarity with retrieving and displaying images in various sizes - Strong problem-solving ...

I need software to automate the login proces...either a consultant that can recommend/evaluate existing soft- and hardware, or a skilled developer to create a software/script for the task. The desired operation is as follows: User scans a finger. Based on the result, the username/PW fields are auto-filled and submitted. A UI to add/edit/delete users is obviously needed. Ideal Skills and Experience: - Proficiency in Windows application development and/or Windows scripting. - Experience with biometric fingerprint devices. - Experience in software automation. A proof of concept for the auto-fill part has already been tested and can be provided. A fingerprint scanner is already existing, if a solution needs a specific model (eg. a scanner that does on-device comparison), that&...

Hi, I need a VPN application with V2Ray protocol. It should support VMESS and VLESS methods. The project can be developed in Swift or Objective-C or Flutter. UI Is attached to the project. Api is ready and all information and payloads related with api will provided by me. Main features: * User will connect to...activation code (Like: 23wsfio3592 (include digit and char)) * User can see the remain days and traffic (Like: 25 Days left, 55 GB remaining) * User can change the server to connect to different locations (Simple combo box to select server) * Server list can show the online percentage (Api will return percentage of total traffic on server) * Api will provided best server to connect (Auto connect) that will choose server automatically by fastest one. Thanks...

NO AUTO BIDS - ONLY ZENDESK PRO! 'm in search of an experienced developer skilled in Zendesk API integration for a project related to airline claim forms. I will provide you parts of the template and you will add the form, calculations, API integration and ticket creations. The website should be built in Laravel or secure platform. If you know about EC261 claims it makes it way easier to choose you. You will do the following: - Create a form which is predefined through parameters and questions. - Add airline and airport database and organize the data with live search preview. - Calculations based on airport distance and claim form. - Zendesk ticket creation along with correct ticket numer and relevant information. - Multilingual form and site (Swedish and English). Need som...

...and allow them to manage their account details. - Smart Report Generation: The application should have a button for generating smart reports based on the patient's lab check-ups data. - Visualization Tools: The system should be able to visualize raw patient data(patient's lab check-ups data) using appropriate visualization tools and generate a smart report in color coded format. -Smart Report also auto recommend what to eat and what to avoid same recommendation for exercise also. Reference website:- 1. 2. Reference images:- Ideal skills and experience for the job include: