How to query a cube using sql jobs
I am in need of a skilled PostgreSQL DBA to assist in setting up and configuring a wide range of enterprise tools. The ideal candidate must have expert knowledge in the installation, configuration, and use of the following tools: - EFM (Enterprise Failover Manager) - PEM (Postgres Enterprise Manager) - EDB Migration - pgBackRest - pgBouncer - pgPool In addition to the initial setup, I require some specific expertise to fully leverage these tools. Specifically, it would be great if you have previous experience with: - Backup and restore tasks using pgBackRest - Connection pooling with pgBouncer - Load balancing with pgPool Please, only apply if you have a proven track record with these PostgreSQL tools as I would like to ensure an ...
I need a serious PHP developer to do some work on my SMF 2.0(.17) Forum Software. The URL of the website is If you are not familiar with SMF you can find an unaltered Stock Version to download here: ;filename= But please note: MY SITE IS HEAVILY CUSTOMIZED. That is why I need a seasoned PHP developer. I do not wish to waste your time nor do I wish you to waste mine. Therefore: 1. This project is for expirienced PHP developers only! This software is written in PLAIN PHP. NO FRAMEWORK! If you are a WordPress, Magento etc. developer then this is most likely NOT your cup of tea, you have no clue of how a message board / forum works then this is not your project. 3. No coders from
I am seeking a api excel query editor to convert a Postman API call into a Microsoft Query Editor. you need skills in Excel, API utilisation, and Microsoft Query Editor. YOu can see query working in Postman scripts (we have so you can import).
We are seeking an experienced full-stack Developer to join our dynamic team. The ideal candidate should have a minimum of 8 years of hands-on experience in JavaScript and a strong proficiency in the following technologies: NWJS, NodeJS (backend) JS, TypeScript, HTML, CSS, JQuery, MYSQL, WordPress, and AWS. The candidate should possess excellent communication skills, both written and verbal, and be capable of working with minimal supervision. Responsibilities: -- Develop and maintain robust and scalable SaaS and desktop applications using NWJS, NodeJS, JavaScript, TypeScript, HTML, CSS, and JQuery. -- Ensure the technical feasibility of UI/UX designs and implement them accordingly. -- Work with MYSQL databases to handle data storage, retrieval, and manip...
I'm looking for an expert to design an automated MEXC spot trading bot. It should be equipped with two essential features: - Trading Signals: The bot should be programmed to receive trading signals from a TradingView strategy in the 1 minute timeframe. - Automatic Trading Execution: Once a signal is generated, it should be able to execute trades on its own without any manual inputs. You must provide a time estimate on how long each order will take to execute, from the moment a signal is released on trading view until the moment the bot buys or sells BTC at the market price. Priority will be given to those with the fastest bots. The bot should use the 'Volty Expan' strategy to base its trading sig...
Local SEO.............I am looking for a freelancer who can evaluate and correct issues on my website using diib key performance metrics. I need my site to rank number #1 in my local city. I need my website scanned and all SEO issues fixed so my site rank better and has better domain authority using white hat techniques I prefer that you are experienced with or a similar website to scan for errors
Looking for help with sheets set up, one must know import range, query features, can write custom scripts codes etc. Someone creative in how to get the things done. Will pay well.
I'm looking for someone to improve upon our 12 UI screens that we have in Figma: The current design is very basic and needs a lot of improvement. Possibly a change of colours, buttons, background, tab bar etc. Some examples of much better looking designs: Example 1: Example 2: https://www.freelancer.com/users/l.php?url=https:%2F%%2Ffile%2FxFxEZTiDGVbpYa5L8aBnmO%2FImpacto-Training%3Ftype%3Ddesign%26fuid%3D1335335611708511691&sig=f9f7caa77ebdf67bf71b772c61c2a66276a1d5d5aee9e2cd33247f88654150a8 For the contest, please upload 1-2 screens
I am looking for a capable developer to build a mobile app using Flutter which features Google Maps integration. The app's main functionalities will consist of updating existing customer data or enrolling new customers, and route planning for sales personnel. - **User Authentication**: Users should be able to log into the app using their email and passwords. Experienced in developing secure user authentication is a must (Supervisor/salesperson) - **Route Customization**: Sales personnel should have complete freedom to adjust their daily routes within the app. Hence, proficiency in leveraging Google Maps API for route creation and optimization is a strong plus. - **Detailed Customer Information**: The application needs ...
I need a simple scene that contains two buttons to rotate a cube to the right and left, just like the video I attached below, ... and I need it to be in xcode, and export it to the VISION PRO SIMULATOR since it works , I will pay over $300+ for the next project since this is just the test.
In need of an expert with proficiency in Excel macros to carry out two specific tasks on trading data related to the stock market and cryptocurrencies. TASKS: - Data Analysis: I need to analyze the heavy trading data I have. Therefore, I need someone who can build smart macros that won't just ease the process but would refactor my data into meaningful information. - Data Recording: Alongside analyzing, my macros should also enhance excel to record my trading data meticulously. IDEAL CANDIDATE: Having a good hand at using Excel for data-related tasks is very much expected. However, having experience in dealing with trading data and designing macros for the same will really set you apart. Looking forward to seeing applications from ...
I am seeking a skilled WordPress programmer to incorporate a custom search feature on my website. The functionality should include: - The ability to filter results: Users should be able to narrow down their search based on specific criteria. - Auto-complete suggestions: As users start typing, relevant suggestions should automatically populate to enhance usability. The search functionality should be restricted to post titles and contents only. Only developers with prior experience in custom WordPress search features should bid. Proven expertise in PHP, SQL, and Ajax
...in need of assistance with a MySQL query task; specifically how to make use of a subquery in order to yield accurate results in a Select statement. The main purpose here is to fetch data. **** All SQL files are attached to the files for this project. What I am Seeking: Help with the attached query. The query joins two tables. A header and details table. The intent of the subquery in this statement is to find/match a SINGLE "Invoice Date" value in the inv_details table that matches a "PO Date" from the po_details table in the subquery using the main queries currently matching "item" , "ship to city" and "customer na...
...overlayed to a short clip. The clip is attached and is named 'Clip-7' here: In the clip, I need an arrow and some words that follows part of the video. In the video, there is a person with a parachute flying next to a snow wall that he narrowly misses. The animation should have an arrow pointing to the snow wall with the words 'Narrowly misses snow wall' which moves with the video. Such as this type of animation: for the arrow please use: For the font, please use Bebas Neue Bold: This is a time
I need an animation overlayed to a short clip. The clip is attached and is named 'Clip-4' here: When the person says '53 meters' I would like an arrow showing the height of the water fall to appear with the words '53 meters/173 feet' please make the top of the waterfall arrow animation in this location: For the font, please use Bebas Neue Bold: A similar animation can be seen in this video at 2:16 : This is a time sensitive project, so the earlier the submission the more likely it will be picked. I have a few other projects with similar requirements
I need an animation overlayed to a short clip. The clip is attached and is named 'Clip-3': I would like an arrow to appear pointing at the waterfall with the words: THRILLER 92 For the font, please use Bebas Neue Bold: here is the arrow to use: An example of the arrow animation is like this video at :06 seconds : This is a time sensitive project, so the earlier the submission the more likely it will be picked. I have a few other projects with similar requirements and skills that
...need an animation overlayed to a short clip. The clip is attached and is named 'Clip-2 here: In this clip, we are talking about a long hike to the bottom of a frozen waterfall I need an animation showing a dotted line going up the terrain to the bottom of the waterfall, with a counter showing 2000 feet. The dotted line should follow a path similar to this image: Example of this animation dotted line is: this video: Example of this type of animation is in this video at 2:15 seconds with the numbers: Instead of a plane icon, it should be a hiker icon like this: https://media
I need an expert in PowerBI who is capable of connecting to Excel spreadsheets and SQL databases to create a visually engaging and vibrant dashboard. This dashboard will need to provide: - Detailed analysis of sales performance, enabling a clear understanding of the areas that are working well and those that need improvement. - Thorough customer segmentation that provides deep insights into our customer base to improve marketing effectiveness. - Comprehensive trend analysis that identifies patterns over time to assist in strategic decision making. Ideal candidates should have a strong background in PowerBI dashboard creation and data analysis, as well as a good eye for vibrant and colorful design that can help to...
PRIORITY IS TO HAVE A DEVELOPER ON OUR TEAM (LONG TERM) THAT CAN WORK WEEKENDS!! 1st task (IMMEDIATE): Fix pagination -> our webapp uses an api endpoint to load data from stored procedure that takes 30 seconds to run. Pagination + cache was implemented but the pagination was implements AFTER the api runs (30 second wait) and should be executed inside the stored procedure to start sending data to the front end after it has the first 30-50 records instead of waiting to receive the entire 6000 current records. we implemented cache but would like developer to evaluate the possibility of using redis to improve performance. If you are awarded the task we expect you to accept IMMEDIATELY and if the project is not...
...interesting GIS programing in a database. *** Please no AI responses. *** Experience with snowflake and other big data a plus. Able to advise and write. Able to work TODAY. Please respond by telling me what is a 3-4. **Requirements:** - Proficiency in spatial SQL -> MUST for complex data query and retrieval. The ability to perform spatial analyses and geometric operations is crucial. - Expertise in creating engaging, interactive maps that can visualize spatial data and analyze spatial patterns on a global scale. This would involve dealing effectively with diverse data sets and potentially large volumes of data. - Strong background in PostgreSQL and PostGIS, with proven experience in writing advanced spatia...
...development team to create a custom API that interfaces with our FusionPBX and FreeSWITCH telephony system. The primary goal of this API is to manage telephony features programmatically, including customer management, DID handling, call routing, and call feature configurations. This project requires deep knowledge of FusionPBX, FreeSWITCH, and database management using MariaDB. Key Project Tasks: Customer Management: Create and update customer records, including status management (Active/Inactive). DID Management: Insert, update, delete, and route DIDs within the system. Call Feature Configuration: Enable/disable call recording for specific numbers, and set/modify caller IDs. CDR Synchronization: Develop a mechanism to synchronize Call Detail R...
PRIORITY IS TO HAVE A DEVELOPER ON OUR TEAM (LONG TERM) THAT CAN WORK WEEKENDS!! Tasks: 1st Objective: improve loading time and performance for our web app. Our API endpoint to get data from DB takes about 25-30 seconds, then to download and load the data to our and angular.js front end this is taking another 15-30 seconds. FIX: Use cache or redis and paginate the results from the API so that we can start loading data immediately instead of waiting 1 min to load to start. If you are awarded the task we expect you to accept IMMEDIATELY and if the project is not accepted immediatly we will award it to another developer. This task should be delivered in 1 day and if it is successfully completed we would like to keep t...
Position: Experienced Python Developer (Remote) Salary: Starting at INR 20,000 per month, increments based on experience. About the Role: I am looking for a skilled and experienced Python Developer to join our remote team. The ideal candidate will have a strong background in Python, with expertise in Django and Flask frameworks. You will be responsible for developing and maintaining web applications, ensuring optimal performance and scalability. Key Responsibilities: - Develop and maintain web applications using Django, Flask, and Python. - Integrate frontend technologies such as JavaScript and React JS to create seamless user experiences. - Utilize Axios/AJAX for promise-based HTTP requests and manage state in React applications. - Implement Docker fo...
I'm seeking a highly skilled PHP and Laravel developer for back-end development for my project. The primary responsibilities of the right candidate will majorly involve: - Setting up the server-side logic that powers the user interface of the web application. - Writing efficient, fast and robust code. Although not specified, it would be an advantage if the developer has experience or is comfortable with: - Implementing a user authentication system. - Payment integration. - Developing a data analytics feature. The timeline for project completion hasn't been determined yet, but we will discuss this during the hiring phase. Strong command over PHP, Laravel, SQL and knowledge of AngularJS will be preferred. Prior experience in server-side templat...
'DB query failed: SQLSTATE[HY000] [2002] No such file or directory'. Mariadb stopped - I need someone who knows about mariadb and plesk
we are looking for a senior PHP developer with a minimum of 16-20 years of experience Skills and Experience MUST HAVE: - 16-20+ years of PHP development experience. - Proficient in Laravel framework. - Experience SQL Injection prevention/fixing - Finding and Securing any loop holes in the system - implementing new features , for enhancement of the platform, - must be an INDEPENDENT developer, not an agency! ********** - must be able to work on GITHUB - MUST be able to change FIGMA design to HTML and implement php pages from it. - lastly making sure platform is mobile responsive Must be knowleadble in updating designs as well when needed. DO NOT BID if you are an agency, if you are a marketing person or project manager. We will only giv...
I need a scene fundamentally and strictly for VISION PRO SIMULATOR in Xcode, using SWIFT or composer or other, the goal is deploy to SIMULATOR VISION_PRO IN XCODE SIMULADOR DE VISION PRO. The scene should work with buttons floating in the air, allowing actions such as rotation, display information, display pins, these pins when touched should display text, Tapping another button should expand a cube, and each part should display information on it when touched. the text panel, When I touch another button I need that. an FBX do. its animation, and another button to stop that one. animation, and. a button to reset the entire scene, .... you can. help me with that? Please review this video to confirm if you can implement these fea...
Develop a sophisticated trading strategy utilizing Pine Script, a domain-specific language used for creating custom indicators and strategies on the TradingView platform. This project requires an expert-level understanding of Pine Script, technical analysis, and algorithmic trading concepts.
...their ideas and creations with the world. We're on the lookout for a talented content writer to join our team and help spread the word about what we do. The Role We need someone who can craft engaging, informative articles that resonate with our audience and align with our SEO goals. You'll be writing about topics related to Stomod and how our platform can be a game-changer for content creators, bloggers, and anyone looking to establish an online presence. Responsibilities Write 5 high-quality articles each week, focusing on topics relevant to Stomod and our users. Research and propose new topics that would interest our audience and drive traffic to our site. Optimize content for SEO to improve visibility and ran...
I'm seeking a skilled data analyst to help with tasks including data cleaning and preprocessing, data visualization and reporting, and statistical analysis. The data they will be working with is of medium size, ranging between 1GB to 10GB. Prior experience with Python, SQL, and Excel is crucial for this project. Specifically, proficiency with the Python libraries Pandas and Matplotlib is required for the analytics components of the work. This project requires both strong technical skills and a thorough understanding of data analysis methodologies.
Make ppt presentation for stakeholders using new mpp file and theses requirements: 2. The original plan is the baseline, updating the schedule with actual start and finish dates. 3. Initiate Milestone put 100% complete, what does the variance tells us? Are we ahead or not? 4. Critical Path – what is this telling us as we move to the next stage? 5. Activities with some flexibility / float? What can we shrink or expand the time scale and impact on the budget? 6. What if scenarios 7. Would working on weekends and holidays have a positive impact? Good Friday March 29th so no good 8. Project schedule will change based on resource availability, impact on the budget? 9. Special calendar, will it make the critical tasks before it disappear and what impact will it...
...seeking a skilled .NET Full Stack Developer to build our website on a contract basis. Responsibilities: • Design and develop our website using ASP.NET, WEB API, Develop user-friendly interfaces using HTML, CSS, and Bootstrap • Implement front-end functionality using a JavaScript framework like Angular or React (familiarity with either is preferred) • Experience with relational databases like SQL Server or Oracle is a plus Qualifications: • Proven experience as a .NET Full Stack Developer • Strong understanding of ASP.NET, NET Core, ASP.NET Web API, HTML, CSS, Bootstrap, and a JavaScript framework (Angular or React) • Experience working with relational databases is a plus ...
I'm in need of a proficient app developer who can create an application for both iOS and Android platforms. The main functionality of the app revolves around data entry and front-end displaying capabilities, with the additional feature of exporting the data to an Excel format. Key aspects of the project: - App development for both Android and iOS - Data entry allows manual input by users - Front-end display to present the data inputted - Functionality to export the entered data to Excel The ideal candidate should have robust experience in cross-platform app development, with expertise in .NET, C#, and SQL Server Database. Strong skills in UI/UX design are also preferred to create an intuitive and user-friendly interface. Under...
The home page of your web site gives a brief introduction of your hotel (note the hotel shall be named after your real name or your team’s name) which includes the address, email, phone numbers, and direction to your hotel (can make up these information to protect your privacy) Your hotel website allows user to select check-in and check-out dates; select number of rooms; select number of adults and children. You shall validate user’s selection. For example, checkout date shall be later than check in date. Number of people shall be positive etc. Your website will only show available rooms for the duration of stay of the reservation. If there are no rooms available, then notice the user about that. When these rooms are displayed, make sure also display...
...help me with a custom cryptocurrency portfolio tracker. The user-interface can be very simple and barebones - just a formatted table. Critical Features: - Real-time price updates: This is the heart of this project. The application needs to furnish real-time price updates every 5 seconds (user configurable) - API Integration: Price data will be expected to be sourced from a reliable API. - User will provide mandatory fields you need to call APIs ( contract-address, chain-id). - Most APIs have a rate limit of something like 120 calls/minute so you need to bundle and query multiple crypto into a single call. Most APIs allow upto 30 to be bundled in one call. - There can be any number of cryptocurrencies to...
I am in urgent need of an experienced full stack developer to take on the development of a web application. This individual needs to be adept at handling all aspects of development, from frontend to backend, and even database management. The task requires proficiency in the following: - Backend development, - Frontend development, - Database management Skills and Experience: - Excellent command over HTML/CSS - Adequate knowledge of SQL - Strong background in TypeScript The main objective of the project is the development of a unique and efficient web application.
I am seeking for a professional and experienced Amazon Kindle eBook writer who can write and research for a "how-to" eBook with a focus on restaurant marketing. The eBook should be more than 7,000 words. My budget is set at $70 for the 7,000 words. Please note that the full payment will only be made upon the completion of the project - no upfront fees. The deadline for this work is 14 days after the project's acceptance. I will be using AI Content checker and Plagiarism checker Copyscape to check, before payments. The eBook is intended to cover specific topics on the following: - Social Media Marketing - Online Ordering - Web Marketing - Loyalty Marketing - Community Building The primary target audience for the bo...
I'm looking for a skilled freelancer who can help me with a unique requirement. The main objective is to create a code that will: - Load multiple CSV files into one SQL database. - Furthermore, the code needs to delete all duplicate data in the database. I left a few crucial questions unanswered. - First, the ideal programming language for this code is not specified, therefore I'm open to Python, Java, PHP, or whichever language you believe would be most appropriate for the task. - Second, the location of the CSV files was also left unspecified, meaning they could be located in a specific folder or scattered in different locations. Your solution should be prepared to handle either situation. - Lastly, the ...
...you are willing to complete project for. We are seeking a highly skilled and experienced full stack developer to join our team. This individual must possess proficiency in a variety of technical areas including web development, app development, database management, artificial intelligence (AI), and machine learning (ML). The ideal candidate will be a collaborative team player who is reliable and committed to delivering high-quality solutions. Request access to see project here. Feel free to ask questions: Position Overview: Position Title: Full stack Developer Location: [Remote] Employment Type: [Full-time/Part-time/Contract] Responsibilities: Collaborate with the team to design, develop
I am looking for a web development specialist with the skills and expertise to build a simple website for me. The project is time-sensitive and I would like to have it completed within a week. The ideal freelancer should be well-versed in web design and development, have experience creating simple websites, and ought to be able to complete the task within the given timeframe. A solid grasp of graphic design and illustration would also be beneficial, but not necessary for completing the job. Looking for MsSQL database , React and .Net developer with strong React knowledge. We run our test automation using robot framework for two websites. We need to show all test suites and test cases on the website when clicked on the...
As a content curator, I require someone with a great sense of humor and a knack for spotting funny content to help me out. Your role will involve: - Watching a wide range of comedy and prank videos on YouTube. - Selecting the funniest ones and converting them into bite-sized videos (less than a minute long) using an AI tool I'll provide. - Reviewing the generated short-form videos, cherry-picking the funniest ones, and sending them to me via a Cloud Storage link. Ability to utilize AI tools and experience in content curation are a must. Taste for comedy and strong attention to detail will play to your advantage. Please bid if you're ready to entertain and make people laugh!
I have a video with me eating bananas with a green screen behind me. I want you to change the video so that there are lots of different images of fruit changing behind me. Use capcut to produce and send me the project and video. If you do well at this then you will get my future projects.
I'm on the hunt for a professional who can develop an automated system designed to fill up and send queries to a particular website every time new offers are posted. Care to rise to the challenge? What I'm looking for: - Development of a straightforward automation that can fill up and forward queries automatically to a website when new offers are posted daily. - I'm open to innovative ideas and methods to achieve the expected results. What you need to be successful: - Experience in automation development Note: Specifics regarding the website to be targeted will be shared with the chosen freelancer. So, if you can build this kind of system quickly and efficiently, I want to...
I'm in need of a SQL engineer with specialization in query optimization and extensive knowledge of MySQL. The project will involve fine tuning basic single-table queries for better performance in MySQL database. Ideal skills and experience include: - Expertise in MySQL database management - Proficiency in SQL query optimization - Ability to troubleshoot and debug errors Your responsibility would be to collaboratively review the existing database structure, and optimize the SQL queries in order to improve the performance, reduce the run time and the load on the server. This task requires clear understanding of SQL code, MySQL database design principles and industry best-practices. With your technical expertise, I&...
I am seeking a proficient PHP programmer for the addition of functions to an existing script. The ideal candidate will have expertise in: - PHP programming - Front-end development (HTML, Javascript) - Back-end development - Database integration (SQL) The main purpose of this project is to build upon and enhance our pre-existing system. Your role will be essential in introducing new functionalities to improve our script. Please only apply if you have extensive experience in these areas. I look forward to potentially working together.
We are looking for ETL ODI Developer for long term contract role who can support us 8 hours a day from Mon- Friday Experience 7+ years Long Term Work Hours 10.30 am – 07.30 pm IST Remote Key Skills : • 7 + years’ experience in building function & store procedure using ODI too and 3+ Years in Project Management • Strong in Agile, JIRA • Design Data warehouse table and applicable documentation. • Develop table creation scripts and execute the scripts for the Database Administrator (DBA). • Analyze data sources and determine data relationships to pair with the business requirements documentation (BRD). • Familiarity with data quality issues and Exact, Transform, Load (ETL) processes • Design and develop Extract Load Tra...
We just moved into our new house.. but the room is too small for our stuff and we're stuck. So we're looking for an interior designer to makeover our bedroom using our current furniture/art within 24hrs! They should make 3D designs with a clear plan to make the space work. It's important that the designer pays attention to detail and has a creative touch since our room is small with many windows and doors. They should work with the furniture we already have and make the room more functional and appealing. Notes: - The room measures 2.8m x 4.1m - Queen size bed Excuse the mess, still in the process of moving and we're tired yall!
...networks for maintenance tasks. Key Responsibilities: - Establish a Site to Site Connection between two routers with different ISPs using IPSec, IP Tunnel not use third party VPN. Ideal candidate must have: - Extensive experience in wireless network management and maintenance - Skill in configuring firewalls and site-to-site using IPSec - IP Tunnel. - Knowledge in IPSec protocols - Proven track record of ensuring networks are running smoothly & efficiently. - Both end has Mikrotik (Hex) Routers. - Both end has different ISP's . - Site one has static public address and Site 2 has dynamic public address. - Target to communicate both networks ends so that share the data easily and connect one network to another. Your job will b...
