How to tune sql query in oracle jobs
I need a small application prototype with the following features: Multi-Employer Job Portal/Admin app (Role Based access) User/applicant App (for Multiple applications to different employers) User Profile Document Upload (Save documents to Db and attachments to Blob Storage ) Send Emails to Employers and applicants back and forth 2 Apps in total ie. admin app and applicant app. job application requirements will be provided. Nodejs, angular, My SQL, ORM, Data Seeding, Migrations should be used.
Seeking a long-term Python Data Scientist and Generative AI expert Your task is to develop a prototype chatbot that is powered by Generative AI and Large Language Model (LLM) to respond to user queries using domain-specific knowledge and RAG implementation. The project will focus on integrating LLM frameworks, managing data preprocessing, and implementing the chatbot's user interactions. ONLY people who respond to below screening questions will be considered: 1) Did you fine-tune an LLM model using LoRA or QLoRA? If so, which model did you fine-tune, and what was the use case? 2) Do you have a GitHub profile? If so, can you share the link? 3) Are you proficient in English, and what is your hourly rate?
I'm in need of a skilled individual who is proficient in blockchain and wallet analysis, specifically on the Arbitrum blockchain. The project involves analyzing transaction patterns and wallet balances and activities. Key Requirements: - Proficiency in blockchain analysis, particularly on the Arbitrum blockchain - Ability to identify patterns and trends in transactions - Proficient in analyzing wallet balances and activities Deliverables: - A comprehensive report that includes methodology, analysis, and conclusion - The report should be presented in a combination of written format and visual presentation (charts and graphs) Please note that I will provide you with access to the necessary pages and data on Arbiscan. Your task ...
I'm a beginner in Oracle Service Bus (OSB) and would like a thorough virtual training session on the topic. I'm looking for a skilled instructor who can guide me through the following areas: - Basic Concepts and Architecture: I need to understand the foundational principles of Oracle Service Bus (OSB). This includes how it works, its key components, and its role in service-oriented architecture. - Service Development and Deployment: I'm interested in learning how to develop services on OSB and deploy them effectively. This includes hands-on exercises and practical examples to reinforce the learning. - Troubleshooting and Optimization: I want to be able to troubleshoot any potential iss...
I have a SQL Server that needs to be accessible over the internet. However, I'm facing connectivity issues, possibly due to closed or blocked ports on my ComCast router model CBR2-T. I need a freelancer to open the necessary ports on the router. The task involves: - Checking the current port status on the router - Identifying the SQL Server port - Opening the port on the router Please bid if you're experienced with network configuration and have dealt with ComCast routers before. Necessary Skills: - Network Configuration - Router Administration - ComCast Router Experience - SQL Server Configuration
I require someone experienced in Linux server management to help optimize the performance of my server. Linux Server Performance Optimization Plesk Obsidian, SQL, PHP Key Responsibilities: - Review the current server setup and performance - Identify areas for improvement - Implement solutions to optimize server performance - Fix the 2 errors. This is not a one-time setup; I may require ongoing management based on the initial optimization results. Your expertise in Linux server management is crucial to this project.
I'm in need of a professional web developer to create a platform that serves as an agent management website. The website should have an elegant interface, account logins, and a simple credit system that can be administered by an admin account. Key Features: - Agent Registration and Login: The website should allow agents to create accounts and log in securely. - Profile Management: Agents should be able to edit and manage their profiles. - Commission Tracking: The system should track and calculate commissions for each agent. The specific functionality of the agent registration and login feature is not fully defined yet. The ideal candidate for this project should have experience in building similar systems, understand user account management...
I am looking for an expert with solid experience in Field Oriented Control (FOC) of Permanent Magnet Synchronous Motors (PMSM) who can help tune my PI controllers for more precise speed control. Here are the specifics: - I have an established model using MATLAB/Simulink, and the PI controllers are already implemented. - The key outcome I want is to enhance the accuracy of the speed response. The ideal candidate will have: - Extensive knowledge and experience with PMSM and FOC. - Proven background in tuning PI controllers. - Strong proficiency in MATLAB/Simulink. Your task will involve analyzing the existing model, suggesting enhancements for the PI controllers, and implementing these changes to achieve a more precise speed response.
In my project, I'm looking to set up ActiveMQ JMS messaging for our system, focusing on synchronous and asynchronous messaging. We anticipate a low scale of message traffic, not exceeding 1,000 messages per day. Key responsibilities will include: - Setting up ActiveMQ for JMS messaging - Configuring it to handle synchronous and asynchronous messaging effectively Furthermore, I plan to utilize SOAPUI Open Source for automated testing of these messages. Your role will be essential in ensuring that the system works seamlessly with this tool. I will be expecting below: Create a framework to publish and subscribe messages to ActiveMQ queues Create queries to make sure data is published into the respective tables and assertions ...
Looking for help in modifying an existing python script and related sql database table The current script - (1) scrapes company financial data from website and populates database (2) scrapes news related to keywords from google news (3)sentiment classification of news items (4)pushes data to sql database The company names and keywords are currently hardcoded in the script Requirement- (1) Company names/urls/keywords (will be provided) to be put in master table in the database (2) The script to loop through and scrape the relevant data and put in database
...freelancer who's great at web scraping to help with a project involving a specific website initially, with potential for more. I'll give you the specific data fields to extract. It'd be great if you: Are really good at web scraping and or Python. Know your way around MS SQL Server databases, not essential but definately an advantage. Understand how to extract data effectively. Understand the need for security and captcha integration if needed. Can work quickly since this project is a priority and needs to be done ASAP. Ultimately, I want to be able to manage the code with your ongoing help, so this could lead to a long-term partnership. I'll share the full details when needed. You will provide source cod...
To create a precise 3D model of a small-sized charging case for the AirPods Pro 2 in Blender, here's a detailed plan based on your specifications. Specifications Recap: PCB and Battery Dimensions: 33 x 40 x 10 mm AirPods Pro 2 Dimensions: Height (H): 30.9 mm Width (W): 21.8 mm Depth (D): 24.0 mm Design Requirements: The case should connect to the top and be formed like a butterfly. The two circular charging metals at the bottom should be positioned to the left and right. The part of the AirPods Pro 2 that goes into the ears should stick up 15 mm above the case. Steps to Create the 3D Model in Blender: Set Up Blender: Open Blender and delete the default cube. Model the Charging Case: Create the Main Body: Press Shift + A to add a new ...
Required a dot net developer. Speacialized in Microservices acrhitecture based solution. Dotnet Core, C#, SQL, Data transformation, API gateway, Auth based security.
...developer to assist me with my project. I'm looking for a PHP expert who can aid in the development of a web application, website, or mobile app. You should be proficient in both front-end and back-end development, capable of crafting user-friendly interfaces and integrating complex functionalities. Your role will involve: - Understanding project requirements and delivering high-quality work - Developing secure, efficient, and scalable code - Implementing user authentication, integrating databases, and possibly setting up payment processing systems - Ensuring timely and reliable completion of the project If you are a skilled PHP developer with experience in full stack development and are passionate about producing high-quality applications, this pro...
...installing python, setting SQL for our applications and Google Sheet. For each country may need API for such as : 1. Historical Data 2. Financial Scrapped Source 3. Financial Summary Scrapped Source 4. Interest rate 5. Some More Required Skill & Experience : 1. Php & SQL 2. Familiar with python installing & setting up environments 3. Experienced in Linux Debian & LNMP server by SSH 4. You need to know on how to run python scripts on debian by ssh, and setup cron task on debian, and debugging etc Personality's Criteria : 1. No toxic working environment 2. Agile, Responsive, and Fast Delivery 3. Collaborative as a team 4. Responsible, Credible, Reliable and Integrity person 5. No agency, only direct hiring ------ I'm...
...fine-tune my photos. Specific Requirements: 1. BA 2024 Graduation Awards Celebration photo - Lighten up areas around eyes. - Maintain a natural look, avoiding an overly processed appearance. - Focus on enhancing three main features: eyes, hair, and skin 2. Gallatin Graduation 2024 - Determine if the photo can be retouched or not. 3. Gallatin Graduation Marquee photo - Adjust the lighting for the marquee photo. Ideal Skills: - Excellent photo retouching skills with a sense of subtlety. - Proven experience in lightening and highlighting specific areas. - Proficient in using professional editing tools. - Keen attention to details, especially eyes, hair, and skin. - An aesthetic eye that aligns with natural-style retouching. Your expertise will provide a ...
I would need a script written in nodejs where a USB NFC reader (specifically the ACR122U or the ACR125U) wait for a NTAG424 DNA tag. Once an NFC tag is tapped write a URL data into the tag as well as encryption keys. Make sure the URL contains query parameters which are mirrored uid, counter, and cmac that are all encrypted. Part of this is to write a nodejs script to validate the above parameters from the URL and decrypt the uid/counter (or some Rust that can do the same)
...talented designer to create a minimalist logo and corresponding intro/outro video clips for my content. - The logo should be minimalistic in style, with a soft and pastel color scheme. - It should feature a specific icon, something to do with camping and/or caravanning, as the main element. I have added some ideas which I am not wedded to. - The intro and outro video clips should reflect the same minimalist aesthetic and soft, pastel color theme, incorporating the logo into a brief, engaging animation with a catchy tune. Outro should include social media links and invite the users to like, subscribe and even message us. The name will be 'A Life Less Ordinary' with a tag line of ' Living life - differently' about a fami...
...I'd like to organize my games by categories using custom taxonomies. Please read the SPECIFICATIONS BEFORE BIDDING - I need assistance with fixing the taxonomy issues and setting up the custom taxonomies to organize my games. - The main objective here is to help me effectively categorize the games on my site. - This will involve back-end work and ensuring that the taxonomies are correctly linked to the relevant content. SPECIFICATIONS (REFERENCE IMAGES PROVIDED): ----------------------------------------------------------------------------------------------------------------------------------------------------------------- I need to remove the Service Number Taxonomy that was added and create a new one called Booking Category. This will need l...
Money and all it takes to make it in easy steps even a 14 y/o can deal with
I'm seeking a skilled freelancer to implement Continuous Integration and Continuous Deployment (CI/CD) using GitHub Actions, set up logging for each service, and configure an HTTPS domain for our web application hosted on Google Cloud Platform (GCP). The ideal candidate should have extensive experience with GCP, CI/CD pipelines, and HTTPS configuration. Scope of Work: 1. CI/CD Implementation: - Set up a CI/CD pipeline using GitHub Actions for automated testing, building, and deployment of both frontend and backend applications. - Integrate the pipeline with our GCP infrastructure, including Compute Engine, Cloud SQL, and Cloud Storage. 2. Logging Setup: - Configure logging for all services: -- Frontend (Nginx, ): Log HTTP requests, errors, and application logs. -- Ba...
use Oracle PL SQL teach me how to install free Oracle DB on my local windows 11 acceptance: I can run your code on my computer ; all code work on my computer when I run it by myself You have 2 days you provide code to simulate input data (both code versions: python and sql)-> transactions data *****you provide SQL code to calculate per day summary for each day for each product for each store for 3 years SIMULATION data for 3 years 100 products 20 stores 5 USA states random dates and prices promotion for 30 promotions per year , each promotion happen for 7 to 15 products, for example promotion at may 10, 2023 happen for product ids: 34, 65, 12, 78, 5, 23, 41. When 34 for 20%; 65 for 30%; 12 for 40%; 78 for...
We are looking for 5-10 years of .Net experienced developer who can also have experienced in React and .Net based web development. Long terms multiple projects development. Using Mainly Azure SQL server database with Visual Studio .Net Core API. Graph QL and EF. Worked on Azure Key Vault, Azure Logic app, Azure function is bonus.
use Oracle PL SQL teach me how to install free Oracle DB on my local windows 11 acceptance: I can run your code on my computer ; all code work on my computer when I run it by myself You have 2 days *****you provide code to simulate input data -> transactions data *****you provide SQL code to calculate per day summary for each day for each product for each store for 3 years SIMULATION data for 3 years 100 products 20 stores 5 USA states randomly 30 to 170 transactions per day for given product for usual price randomly 200 to 600 transactions per day for given product for promotion random dates and prices promotion for 30 promotions per year , each promotion happen for 7 to 15 products, for example pro...
I need a Laravel developer to create a simple, yet effective admin dashboard with user authentication. The template for the dashboard is ready, and the SQL tables have been set up. The main features of this project include: - **Dashboard:** This should display data from the other 3 pages in a list format as well as in a bar chart. - **Page 1 - Callback List:** A simple list of data from the 'callback' table. - **Page 2 - Token List:** A simple list of data from the 'token' table. - **Page 3 - Name List:** A simple list of data from the 'name' table. For the dashboard, I'm looking for a clean, professional design and prefer the use of bar charts for the graphical representation of the data. User authentication should be st...
...over 7 years of experience to work on my existing website. The primary focus is to enhance the user experience by streamlining the site's navigation, introducing push notifications and refining various other UI elements. Key Responsibilities: - Implement push notifications to improve user engagement and interaction with the site. - Analyze and improve the current navigation system, ensuring a seamless and intuitive user experience. - Fine-tune various other UI elements to enhance the overall user engagement and satisfaction. Key Skills and Experience: - Over 7 years of experience with CodeIgniter. - Proficiency in integrating push notifications into web applications. - Strong understanding of UI/UX principles and experience with navigatio...
We have a project developed with VS2022, c#, datatables, SQL database, javascript and similar.... The user experience is not good. We need a professional and nice interface and user experience, but, mantain our actual code and funcionality.
Hi, I am looking for a developer to maintain, make upgrades and fix bugs on my current website and booking system. The system has been done in SQL written in C# by my old developer. He has had a change of career and can no longer work on things but is happy to do a handover to make things easier. This will be an ongoing business relationship and not a one off thing so will need someone with good communication and accurate times of completion. Thanks, Luke.
I am looking for an experienced CodeIgniter developer to upgrade my existing CodeIgniter 3 project to CodeIgniter 4. The project is currently live and needs to maintain the same database structure and functionality. The key tasks include: Upgrade CodeIgniter Version: Migrate the entire project from CodeIgniter 3 to CodeIgniter 4, ensuring all features and functionalities remain intact. Optimize SQL Queries: Review and optimize all SQL queries to handle heavy loads efficiently. The current system experiences performance issues during peak times, and the new version should resolve these. Fix Bugs and Security Issues: Identify and fix any existing bugs and security vulnerabilities in the current project. Ensure the new version adheres...
We have a program on C# written on Visual Studio. We want to modify the current program, which read bar codes on a warehouse, for other sections of the company. On this project we will like it to get information from different Oracle tables. Job is to use the original code that we provide and make modifications to adapt to our new requirements.
...related to an incorrect DATETIME value in your query. This error typically occurs when the format of the date and time being used in the query does not match the expected format in MySQL, or when an empty string is being used where a datetime value is resolve this issue, you should first check the format of the 'date_scheduled' values in your 'banners' table to ensure they are in the correct DATETIME format. You might also need to modify your query to handle cases where 'date_scheduled' might be empty or incorrectly you're not sure how to proceed or need further assistance with checking or adjusting your database, you can manage and review your MySQL dat...
I have a guitar cover video that needs audio enhancement and autotuning. The project involves: - Autotuning the audio to ensure the pitch is accurate and in tune - Enhancing the overall sound quality to make it more professional and engaging - Clearing any background noise that might be present in the recording I'm looking for an experienced audio editor who can work with a 1-3 minute video,Good communication skills and experience with music editing tools like Audacity, Pro Tools or Logic Pro are a huge plus.
I am seeking an audio editor who can enhance and augment my voice in a guitar cover. Key aspects to be worked on include: - Increasing the volume of my vocals - Enhancing the overall clarity to ensure listeners can understand every word - Improving the tone to give a more professional feel In addition to this, I also require vocal tuning using auto-tune. In terms of styling, I am particularly interested in replicating an R&B style, similar to John Legend. Ideal candidates for this job would have prior experience in audio editing, vocal tuning, and be familiar with R&B styles. A strong understanding of auto-tuning and vocal enhancement techniques is essential.
As an artist preparing for the launch of my hip-hop album, I'm looking for a skilled designer to create unique and captivating album art that accentuates the genre. Key Requirements: - Ability to conceptualize and execute abstract designs. - Proficiency in developing artwork which blend both minimalist and complex elements. - Keen understanding of the hip-hop music industry and its artistic nuances would be beneficial. - Strong portfolio of prior work in designing for music, preferably in the hip-hop genre. I am excited to collaborate with a creative and adaptive designer who can tune into my music's vibe and manifest it visually in the album art.
I'm in need of an expert in After Effects to help me customize Template A as soon as possible. Key Responsibilities: - Modify text: The template will need text adjusted to fit my project's requirements. - Visual effects: Adjust and fine-tune visual effects to match the overall aesthetic and mood required. - Color scheme: The color scheme of the template needs to be changed to match my specific needs. The ideal freelancer for this job should have: - Proven experience of working with After Effects, with a portfolio demonstrating successful template customization. - Strong skills in graphic design and video editing. - Excellent attention to detail, as the project requires precision and timely completion. - Abil...
Hi there! I'm seeking an expert in Python and VBA who can develop a real-time data statistical analysis tool for use on Windows. The tool must be able to process financial data. Though the format of my data wasn't specified, please be ready to handle a diverse range of formats, including but not limited to CSV files, SQL databases, and Excel files. Skills and Experience: - Mastery of Python and VBA - Experience with statistical data analysis - Familiarity with financial data - Proficiency in handling diverse data formats. - Skill in working on Windows OS. Ultimately, I require a reliable system for my ongoing financial data analysis needs. Your track record of similar successful tasks will be a plus.
I'm seeking an expert in Python and VBA who can develop a real-time data statistical analysis tool for use on Windows. The tool must be able to process financial data. Though the format of my data wasn't specified, please be ready to handle a diverse range of formats, including but not limited to CSV files, SQL databases, and Excel files. Skills and Experience: - Mastery of Python and VBA - Experience with statistical data analysis - Familiarity with financial data - Proficiency in handling diverse data formats. - Skill in working on Windows OS. Ultimately, I require a reliable system for my ongoing financial data analysis needs. Your track record of similar successful tasks will be a plus.
...specialize in creating text, specifically tailored for use on websites. Key Project Details: - **Text Generation:** The core function of this AI will be to create content for websites. This includes but is not limited to product descriptions, blog posts, and informative content. - **Tone:** The generated content should be in a professional tone. It is crucial for this AI to maintain a high standard of language and tone suitable for business and informative websites. Ideal Skills and Experience: - Profound expertise in AI and text generation - Previous experience in creating Generative AI Solutions for commercial use - A deep understanding of online content creation and its best practices. - Ability to develop and fine-tune...
...satisfactory to me. Key requirements: - Improve transition effects: The current transitions are clunky and amateurish. I want a professional touch added. - Enhance color grading: The video lacks the vibrant and cohesive color grading I desire. I need you to make it visually appealing. - Audio quality: The current sound quality is subpar. Audio needs to be crisp and clear throughout the video. - Song selection: The choice of songs in the audio is not in tune with the video playing. I need more suitable and engaging music. Style preferred: Cinematic. I want the video to have a cinematic touch that captures the beauty and emotions of the event in a professional manner. Ideal skills and experience: - Proven experience in vi...
I'm in need of a proficient expert who can assist me with running queries on DuckDB using data originating from Amazon S3. This task primarily involves: - Interacting with semi-structured data such as XML and JSON - Processing a substantial data volume ranging from 1GB to 1TB The ideal freelancer should have the following capabilities: - Deep understanding and experience with DuckDB and Amazon S3 - Strong skills in handling and querying semi-structured data - Experience in managing and processing large volumes of data Please note: it's critical that the freelancer have experience with managing these sorts of tasks previously and has a solid understanding of large volume data manipulation.
Hi, I am looking for expert to connect SQL database togoogle looker studio so we can analise data and creat reports, it is a long term coopartion. Please provide implementation cost and hourly charge. Best.
I'm in need of an experienced C# desktop programmer who is well-versed in SQL Server 2019. The primary task is to ensure that new columns added to the database are correctly displayed in the Excel report generated by the application also fix some minor areas that will discuss in detail Key Responsibilities: - Troubleshoot and fix the issue of new columns not being displayed in the Excel report - Ensure that all relevant data is correctly fetched from the SQL Server 2019 database - Implement a seamless solution that does not affect the overall functionality of the application Ideal Skills and Experience: - Strong proficiency in C# programming language - Expert knowledge of SQL Server 2019, including stored p...
...experienced freelance developer to design and develop an online service booking platform targeted at legal professionals. The project includes creating both a web application and a mobile application for service providers. Responsibilities:Design and develop an intuitive user interface for three distinct profiles: clients (bailiffs), service providers (drivers, couriers, movers, locksmiths), and administrators. Integrate a real-time booking system with calendar and availability management. Implement secure payment systems and automatic notification features. Ensure compatibility between the web and mobile to best practices for security and data protection. Required Skills:Proven experience in web and mobile in front-end and back-end technologies
...designing, coding, and modifying mobile applications to enhance user experience. This role requires collaboration with cross-functional teams to bring new features to life and ensure our applications are both robust and responsive. **Key Responsibilities:** - Design and build advanced applications for both iOS and Android using frameworks like Flutter. - Work alongside other teams to define, design, and deploy exciting new features. - Focus on application performance and user experience. - Maintain high standards of code quality and push for continuous improvement. **What You Need:** - BS/MS in Computer Science, Engineering, or related field. - 2-3 years of full-stack development experience, with significant focus on mobile apps. - Strong proficiency...
I need a skilled Android app developer with expertise in integrating key functionalities such as user login/signup, in-app messaging, push notifications, photo and file upload. Advanced features should also include GEO Fencing, QRCODE/Barcode scanning and face recognition. The app should be supported by SQL and allow user details to be saved and retrieved from a database. Furthermore, the app needs to integrate with Google services like Maps and Calendar. The design of the app should be minimalistic but seamless for easy user interface. Therefore, a developer with design skills would be perfect for this task. - ESSENTIAL SKILLS: - Android app development - Knowledge of SQL - Minimalistic app design - Experience in GEO Fencing, Q...
I'm in need of a skilled developer with strong experience in NodeJS, React, and Next/NestJS. The project I have in mind is a custom web application that will require: - Search Functionality: The application will have a search feature that allows users to find specific content or items efficiently. This will require robust search algorithms and user-friendly interfaces. - Payment Gateway Integration: The application needs to support payment processing. You'll need to integrate a payment gateway to handle transactions securely and seamlessly. Your experience in SQL will also be valuable to ensure efficient data management and integration with the web application. Please provide examples of your past work that...
... database dump, SQL files, and queries for a library database system. Requirements: - ER Diagram: An ER diagram is required with rationalities similar to the example provided in this link: - Relational Schema: Develop a relational schema that effectively models the database. - Database Dump: Provide a database dump for the system. - SQL Files and Queries: The project should include a set of SQL files and queries that effectively interact with the database. - Managerial Queries: Develop a minimum of 20 managerial queries that will be used to analyze and manage the library database. Deadline: This project must be completed by Monday. Ideal Skills: - Proficiency in database design and SQL - Experience with ER diagram creation - ...
I'm in need of a talented Figma designer who can craft a visually striking single page UI for my crypto project. Key Features: - Real-time market data: This is a crucial aspect of the design. It needs to be easily accessible and comprehensible to users. - Price charts and graphs: These should be clear, visually appealing, and easy to interpret. Style: - Modern: I envision the UI with a modern feel, so it appears up-to-date and in tune with current design trends. The ideal candidate for this job should have: - Proficiency in Figma: As this project involves Figma design, it's important that the designer is comfortable and skilled in working with this software. - Experience in crypto projects: Although it&...
I'm in need of a comprehensive, AI-driven resume web application tailored to job seekers. This application should serve as a one-stop solution for individuals seeking to construct and refine their resumes. Key features include: - AI-Powered Tools: The application must have automated resume building and optimization suggestions, allowing users to generate a robust resume without the hassle, and further fine-tune it for enhanced professionality. - Varied Templates: To cater to a diverse user base, the application should provide a variety of resume templates. Specifically, I am looking for professional, creative, and functional templates that give users the flexibility and range they require. Ideal applicants for this project should hav...
