Sql server query optimizer jobs
I have a PostgreSQL database hosted on AWS. When trying to connect to my database server from my web application, I'm consistently receiving a TCP/IP error. Key Project Points: - The issue is specifically related to the TCP/IP connection between the web application and the AWS PostgreSQL database server. - The PostgreSQL database is hosted on AWS; it's not a local instance. - The web application is the only service experiencing this issue with the server. Ideal Freelancer: - Proficient in AWS services, particularly Amazon RDS for PostgreSQL. - Strong background in dealing with network errors, particularly TCP/IP. - Experience in troubleshooting web application and database connectivity issues.
Looking for a Senior BDA with experience in. AZURE SQL SERVER. English mandatory. 1d per week helping to improve and maintain our main DBs.
Hello After a reboot of a server our cpanel not working anymore, need urgent helpwith IMMEDIATE availability
...experienced course creator to develop a comprehensive video tutorial focused on Microsoft Power Query. Key Features: - User-friendly interface - Capabilities to import data from various sources - Customizable course structure The ideal candidate should have the ability to break down complex concepts and make them easily understandable. The course content should cater to beginners and intermediate level learners. Course Duration: Each video course module should be crafted with the target of a total duration amounting to 3-4 hours. This could be composed of several shorter lessons or modules, for easy consumption and better learning experience. Required Skills: - Strong knowledge of Microsoft Power Query - Proven experience in creating video courses - Excellent communi...
...developer. To qualify you must be full stack and conde in . , .NET ASP WEB API + MS SQL Details of our current project STACK can be seen here -> Prerequisites: For this optimization task you can bid your normal hourly rate but for the long term project the starting wage will be as stated below. 1) Accept initial hourly rate of U$5.00 2) Accept and start work immediatly 3) Have MINIMUM OF 20+ hours a week for long term ongoing support and development. 4) If you are awarded the project accept IMMEDIATELY 5) Work hours: predominantly 20:00 to 02:00 (UTC -3 Brazil TIME) 6) Be available to work on weekends. Our projects use: GITLAB -> , ag-grid, C#, .NET API, MS SQL 2017 , WooCommerce digital product sales This is for ongoing long term development and we
I am looking for a cloud engineer who can assist with deploying an ASP.NET Web Form application on a Windows Server 2022 on VPS. Key Requirements: - The SQL Server DB and ASP.NET Forms have already been set up on the VPS Windows Server 2022. The main task is to ensure the successful deployment of the ASP.NET Web Form application. Additional Details: - The cloud provider I am currently using is WABYNE. Ideal Skills and Experience: - Proficiency in cloud engineering and deployment processes. - Experience with ASP.NET Web Form applications. - Familiarity with Windows Server 2022 on VPS. - Knowledge of SSL certificate installation, database configuration, and firewall settings is a plus. Please provide your relevant experience, certifications, and portf...
...data analyst with proficiency in SQL and R for a comprehensive evaluation of a recently completed data analysis project. This project requires a review of SQL queries, R scripts, and database connections as detailed in a provided PDF. If you're ready to start right away and can deliver within 24 to 48 hours, please get in touch. Responsibilities: Conduct a thorough review of project requirements as specified in the PDF. Evaluate the accuracy and efficiency of SQL queries and R script implementations. Verify database connections and the effectiveness of data visualizations. Identify any discrepancies or areas for improvement. Deliver a comprehensive report detailing findings, issues, and potential improvements. Requirements: Demonstrated expertise in SQL...
I'm looking for a server administrator with intermediate Drupal experience to handle ongoing maintenance. Key responsibilities include: - Monitoring the server's performance and troubleshooting any issues that arise. - Ensuring the server remains secure and up-to-date with the latest patches. - Regularly backing up the server's data to prevent loss in case of failure. - Updating and maintaining the Drupal installation, ensuring compatibility with the server setup. Ideal skills and experience: - Proficiency in Linux server administration and management. - Intermediate level of experience with Drupal, including installation and configuration. - Strong troubleshooting and problem-solving skills. - Understanding of best security practices for server...
...seeking a skilled full stack developer to help with a web application project that I'm working on. The ideal candidate should be proficient in JavaScript and .NET, with specific experience in Angular and SQL Server. Key Skills and Experience: - Proficiency in JavaScript and .NET. - Strong knowledge of Angular and SQL Server. - Previous experience in developing web applications. - Ability to work collaboratively in a team setting. Responsibilities: - Develop the front-end using Angular. - Design and maintain the back-end of the application using .NET. - Ensure seamless integration of SQL Server for database management. - Conduct thorough testing to guarantee the application's functionality. This is a great opportunity for a skilled f...
Bought a react eCommerce template (front-end & back-end) from theme-forest. Provided documentation is not enough for server side installation. I need professional assist to install the project on server side and install the theme on server side.
...facilitate data literacy within the organization. Continuous Improvement: Stay updated with the latest Power BI features and healthcare industry trends. Continuously seek ways to improve reporting processes and tools. Qualifications: Proven experience as a Power BI Specialist, preferably in the healthcare industry. Strong proficiency in Microsoft Power BI, including DAX and Power Query. Experience with healthcare data and understanding of healthcare metrics and terminology. Excellent analytical and problem-solving skills. Strong communication skills, with the ability to explain complex data concepts to non-technical stakeholders. Experience with data integration from various sources such as EHR systems, practice management software, and patient feedb...
I'm in need of a professional to optimize my PL/SQL code for better performance. The primary focus of this project is to enhance the overall efficiency of the code. Key Responsibilities: - Perform PL/SQL performance tuning to improve the execution speed of queries. - Implement bulk collect operations to enhance data retrieval efficiency. - Optimize the compilation of procedures for better code execution. I'm seeking someone with extensive experience in PL/SQL, particularly with performance tuning and bulk collect operations. Proficiency in procedure compilation optimization will be a bonus. Your expertise will play a crucial role in achieving the project's goals.
I'm searching for a proficient Go coder to develop a software application tailored for the Linux platform. Key requirements include: - Proficiency in the Go programming language - Proven experience in s...requirements include: - Proficiency in the Go programming language - Proven experience in software development - Keen understanding of the Linux operating system - Network programming - Geneve encapsulation - CoreDNS development Looking for Go programmers with strong networking background to write a DNS handler plugin for CoreDNS which can receive Geneve packet from client, decap the underlying DNS query in UDP or TCP or DoH preform DNS resolution as normal through the built in forward plugin. On the response side the plugin must be able to encap back to Geneve and res...
I'm seeking a skilled C# developer to create a software solution aimed at processing data from a Winsock for a wifi connected Weight Scale and get the reading and put in a Microsoft SQL database.
I'm seeking a skilled REDM game developer, who takes a particular interest in creating a Roleplay server on the REDM network. Expertise in developing game mechanics are key for this project. The primary task involves: - Developing a Roleplay server game. - Incorporating customizable characters, multiplayer functionality, and an in-game economy system. A successful freelancer will have a good understanding of how to create immersive and engaging Roleplay environments, and experience in implementing character customization options, multiplayer functions and economy system into such a game. Candidate should possess expertise in REDM server game development and game design principles. A proven track record in similar projects will be advantageous.
I need a concise and informative PowerPoint presentation done on the Disabled Facilities Grant (DFG) in the UK. This will be presented in PPT and should run for 8 minutes, no AI: MAIN QUERY OF TASK: "The DFG team currently has a large backlog of cases, both children and adults, that need to be dealt with and processed promptly and efficiently. We will be undertaking a process review to enable us to achieve eliminate the backlog. What suggestion would you have to update the process, and the service, ensure HBC compliance, and ultimately customer satisfaction? Key Task: - Conduct Research: The main focus of this presentation will be the process review of the DFG application process in the UK. The ideal candidate should have a strong background in thorough research and experienc...
I'm looking for a skilled AWS expert to help me set up a highly performant proxy server that can support multiple protocols. Key requirements include: - Setting up the proxy server in AWS - Configuring elastic IPs for the proxy server - Ensuring it runs at an optimal performance level - Supporting multiple protocols The proxy server should be designed to accommodate a high volume of traffic and provide a seamless, fast browsing experience. Ideal candidates should have: - Extensive experience with AWS services - Proficiency in configuring and managing proxy servers - A strong understanding of networking and server optimization Please bid with a clear outline of how you plan to approach this project, including any relevant experience you have that...
I am in need of an expert React Native developer to upgrade my existing app running v0.59.9 and bring it up to date with the latest version of React Native v7.0+ In addition to the platform upgrade also need to: - Upgrade Facebook SDK for FB login to continue working - Adjust query in 'My Activities' to only show activities created in the past, while 'Latest Activities' should only show future activities from all users within radius Skills and Experience: - Proficient in React Native - Experienced in upgrading apps to support multiple platforms - Familiar with the latest version of React Native
I require a skilled Linux administrator to assist setting up a server on my local machine. I currently have a domain, cloudflare, WSL, ubuntu, ollama and ollama webui. I'm getting stuck on connecting my domain through cloudflare tunnel to my linux server so that I can access ollama's webui remotely. Key Responsibilities: - Install and configure Linux server for accessing the Cloudflare tunnel website - Ensure the server is optimally configured for devices outside the network Ideal Skills: - Proficient in Linux server setup and administration - Experience with Cloudflare tunnel configurations - Knowledgeable about server configuration for network accessibility - Background in IT security to ensure secure network access. -Experience with...
I'm looking for an experienced and knowledgeable SQL Server professional who can help me resolve a connection issue I'm experiencing. - **Connection Method**: I'm currently using Windows Authentication to connect to the SQL Server. - **SQL Server Version**: I'm using SQL Server Management Studio 20. - **Error Message**: When trying to connect, I receive an error message indicating that the connection has failed. Ideal candidates for this project should have: - Extensive experience with SQL Server, particularly with the version I'm using. - Proficiency in troubleshooting connection issues. - Strong communication skills to guide me through the resolution process.
As an individual making use of Google Maps for specific personal applications, I am in need of a freelance developer adept at using VB.Net and SQL database to develop a program that will post activities on Google Maps. This software will be particularly handy in marking and recording various personal activities. The Successful Freelancer: - Should provide evidence of experience in VB.Net coding and SQL database management. Showcasing past work that is similar to this project will be beneficial. - They should also understand the implementation of access levels in software development as the map posting feature will be restricted to admin use only. Main Activities: - Create a software application using VB.Net. - Link the application to Google Maps. - Develop a feat...
I'm seeking a professional to help set up a Windows-based server using virtual machines for the purpose of managing remote profiles. Key requirements: - Proficiency in setting up and configuring Windows Operating Systems - Experience in creating and managing Virtual Machines, particularly in a VPS environment - Prior work in server configurations and network management The ideal candidate will be able to work efficiently, communicate effectively, and provide guidance on scalability and security for the server setup.
...my project. Key Responsibilities: - Enhancing the existing backend system: Your primary responsibility is to enhance the functionality of the current system and optimize its performance. - Integrating SQL/NoSQL Databases: Your expertise in SQL/NoSQL databases is crucial to ensure smooth integration and efficient data handling. - Experience with Python and Minio: If you're familiar with Minio that's a big plus, but Python is the key language you'll be working with on this project. Ideal Candidate: - Proven experience in enhancing existing backend systems. - Proficient in working with SQL/NoSQL Databases and designing queries. - Strong Python skills are a must. - Experience with Minio is an advantage, but not a necessity. This is a great opportunity...
I'm in need of a professional photoshop artist who can help me create a stunning, detailed and realistic mosaic design. This design will be used for decorative purposes and printed on large surfaces. Use the attached trading card photos to create a mosaic. Background should be black.. You do not need to use all photos. Examples of Mosaics i would like to create...trading card photos to create a mosaic. Background should be black.. You do not need to use all photos. Examples of Mosaics i would like to create similar to below. https://www.freelancer.com/fileservice/v4/download/cb963d3b-3f2a-429a-8131-ee3f5a5b0fc1?signature=7qdboU5oJyHfPSEJfJBaLxwmxma1R_W1388q8yceWZs%3D&issued=1715693657&expires=1715780057&disposition=attachment&signature_version=2&image-optimizer...
Hello, I would like to hire someone who can create a complete discord server, with bot design, channels, etc.
As someone who values efficient and cost-effective operations, I'm intent on leveraging the full potential of my Microsoft SQL Server database. The core of this project involves enhancing performance and decreasing cost. To enrich the function of my database, I'll need an expert who can: - Improve overall performance, guaranteeing smoother, faster operations - Implement strategies for cost reduction without compromising quality and performance The ideal freelancer will be someone with extensive experience in Microsoft SQL Server, superb knowledge in database performance enhancement, and proven strategies for cost-reduction. If you can deliver this, you'd be the perfect fit.
We using o365, copilot studio, Azure ai applied. We need to create a chatbot in teams and webpage using copilot studio which can be use azure ai feature and able to seach the internal SharePoint site documents. 1,Azure ai chat bot(suppot continue query), 2,documents lookup and learning from SharePoint documents, 3,can be acces from website (sso login required), 4,can integrate in team chatbot
Perfect english is needed. You need to be able to teach and tutor me in relational data bases and sql. You must be able to share screen and communicate quickly and fast. You must be available from today till 24th of May. I'm looking for an experienced database professional to assist with a relational SQL database project. You will need to assist me to answer questions about the following: The required tasks include: - Relational data bases ( administration, normalisation, sql workbench, my sql, data modelling) - Writing SQL queries - Designing the database schema - Optimizing query performance This project specifically involves MySQL, sql workbench, so proficiency in this database system is a must. The complexity level of the ...
I'm looking for a professional who can support me in my Azure Data Factory project. My primary goal is to transform structured data and then load it into Azure SQL Database and visualize it in Power BI. Deal with incremental load, create table relation and contextual data. Skills and Experience: - Proficient in Azure Data Factory - Experience in working with structured data - Expertise in data transformation - Knowledge in loading data into Azure SQL Database - Ability to visualize data in Power BI
App Developers Query - Template Hi, We're currently seeking a talented app developer who shares our vision and passion for creating a platform helping users improve productivity to achieve their hobbies. If you have experience in start up app development and interested in collaborating with us bringing Hobbi to life, we would love to hear from you! About Hobbi: Hobbi's an innovative solution designed to assist time management enabling maximum productivity to achieve desired goals of hobbies. Our app aims to revolutionise the way our customers interact with their hobbies and self-development. We believe that there is a gap in the market for a comprehensive, user-friendly application that offers a way of planning, tracking and sharing achievements of your hobbies. Key Fe...
We are the largest and fastest growing UK charity community delivering support through multiple services via our website. Our website and AI machine learning and GPT are handled by others. We need dev support for the core SQL system and 2 small SQL directories, plus running reports and system admin. We need full stack Microsoft .NET development experience, strong SQL knowledge and exposure to Azure Microsoft services. We require a range of services. We’ll begin with the ad hoc work to begin to build a working relationship and then build that up to the following on an ongoing basis. • Ad hoc tasks for minor tweaks and changes on an ongoing basis. • Larger pieces of work, such as creating a moving from a free to a free and premium versions, with up...
We are seeking a Business Data Analyst for our team who is willing to work with new ...Responsibilities: - Collect and analyze data from various sources - Identify patterns, trends, and correlations in datasets - Create reports and dashboards to present findings - Collaborate with cross-functional teams to understand business requirements Required skills: - Strong analytical and problem-solving skills - Proficiency in data analysis tools such as Excel, SQL, or Python - Experience with data visualization tools such as Tableau or Power BI - Excellent communication and presentation skills This is a great opportunity for individuals who are new to the field of business data analysis and are looking to gain practical experience in a supportive en...
I'm in need of an experienced individual to migrate my current Moodle site from a shared server to a dedicated server. This move is primarily to prepare for an expected increase in traffic, and I'm looking for someone who can not only handle the technical aspects of this migration but can also help with optimizing the server for improved performance. Key Requirements: - Expertise in server migration, specifically Moodle - Ability to create a custom configuration for performance optimization - Prior experience in handling increased traffic on a dedicated server Please only apply if you have experience with Moodle and can guarantee a smooth migration process.
...experienced Netapp server hardware engineer to help me with troubleshooting, configuring, and installing server components. Key Tasks: - Troubleshoot hardware issues: The server is experiencing hard disk and motherboard failure, leading to performance issues and potential data loss. The ideal candidate will be proficient in diagnosing and resolving these hardware problems promptly. - Configuring Netapp server: I require assistance with configuring the server to ensure optimal performance and security. Proficiency with Netapp server setup and configuration is a must. - Installing server components: The successful candidate will also be responsible for installing new hardware components to replace those that have failed. Ideal Candidate:...
I'm in immediate need of a DNS server implementation using UDP sockets in Go. The primary purpose of this server is to resolve domain names to IP addresses within the shortest possible time frame. Key Requirements: - Implementation of a DNS server in Go - Utilization of UDP sockets for communication - Support for resolving domain names to IP addresses - Ability to run on multiple platforms, including Windows, Linux, and macOS Ideally, I'm looking for a freelancer with: - Proven experience in developing DNS servers - Proficiency in Go programming language - Strong understanding of UDP sockets - Ability to ensure cross-platform compatibility - Immediate availability to complete the project ASAP Please provide a brief overview of your relevant experience, you...
...for the pre and post development area for the roof of 205sqm. 3. Please include calculations demonstrating how the stormwater discharge will be restricted to pre development rates for the 205sqm. Note: The pre development roof area of the existing building is 90sqm pre renovation Engineering for the area has been submitted and was thought to be finalised though they came back with the further query above. Happy to supply all existing calculations and stormwater management plans Thanks for your help!...
Velocity alert analysis and provide actionable insights. Key requirements include: - Proficient in analyzing velocity alerts using SQL or SPL or Python - Capable of translating data from a word file into actionable insights - Experienced in the field of identity analytics, risk engine, authentication channel for the digital banking platforms - Understanding of Account Takeover (ATO) or digital identity compromise - Leverage known data as it relates to the digital customer identity and risk decisioning. - Analyze data logs from customer authentication channels and digital banking applications for malicious use and bad actors. - Create long-term solutions and automation to processes that can be improved when digital member identity is being utilized. Refer to attached document for b...
I'm going to build auth login page using the react , tailwind css, express Mysql DB. Also we have to join with google acc , facebook acc, apple acc.
...hours for £10, rent for 3 hours for £15, rent for 4 hours for £20, rent for 5 hours for £25, or rent for 6 hours for £30. Instead, could this be a dropdown. Instead, I would like to replace this with a tick box that users tick to bring their own rifle or leave unticked if they would like to rent a rifle. The system should calculate the price automatically. I will give you a wp-content folder and sql file you can import and work with to make these changes. Simply import these folders in the zip to WP Local, which can be downloaded at or use any other software you choose. The maximum deadline where all files should be handed back by is Friday 24th May 2024 at 23:59 BST....
...recognition and natural language processing - Experience in developing software compatible with Windows and Mac - Strong understanding of calendar integration and email automation On-Prem Client: Quivr Agent * Installation * Install Quivr Agent on Windows or macOS * Configure Quivr Agent to connect to local database and file system * Local Database * Use Azure Storage or Microsoft SQL Server as local database * Store indexed data and search results in local database * File System * Use Windows File System or macOS File System * Index local files and folders * Search * Search local database and file system for relevant results * Display search results in user interface * User Interface * Develop user interface for Quivr Agent * Inclu...
We are seeking a skilled freelancer to develop an OIDC (OpenID Connect) server capable of delegating authentication to a CAS (Central Authentication Service) server. The OIDC implementation will be based on IdentityServer4. The primary objective is to establish a secure and efficient authentication mechanism within our system, leveraging the capabilities of both OIDC and CAS protocols. The ideal candidate should possess expertise in IdentityServer4 and have experience in integrating it with external authentication providers such as CAS. Additionally, familiarity with authentication protocols and best practices in web security is highly desirable.
A. give users interfaces that would allow them to do the following: 1. Build unlimited number of customized questionnaires, by adding all common form elements, plus Conditional fields. 2 build unlimited customized search/ query screens by adding same common form elements as their questionnaire. 3. Build customized output/ report screens to present search results. B. All of the above are build on a 100% normalized MySql database, which will become the centralized database for all future data collection, search, and report generation for third party or custom made plugins/apps.
I'm in need of a web-based job card system that will allow the creation and editing of digital job cards. Both employees and managers will need access to the system, with an admin login section for authorization of completed job cards. We would like the system to link with Quickbooks Online seamlessly, either through Zapier or an SQL database connection. This will allow completed job cards to be sent to Quickbooks for automatic invoice creation. Managers can then authorize on Quickbooks before sending. Key Functionalities: - Creation and Editing of Job Cards: The system should enable the easy creation and editing of job cards through a user-friendly web form by both employees and managers. Employees can then select their name from a drop-down combo box if they have worked on...
...APIs, web scraping, and web page reengineering processes to extract information and structure it in the expected format. The system should generate a record of each query made, indicating whether results were obtained, no results were obtained, or if the source was not available. A document detailing all the sources of information from which data should be extracted will be provided. Main Features: 1. Automatic Querying of External Sources: Perform queries to multiple external sources according to the provided specifications. 2. Data Structuring: Process the obtained information and structure it in the required format. 3. Query Log Generation: Create a detailed log of all queries made and their results. 4. Response Handling: Identify and record whether results were obtain...
AI Chatbot Saas of existing with only rebranding (colors, logos, fonts etc.) The existing can be found at 7 Days support included after delivery for any query . Duration 5-7 days.
I'm looking for an experienced system administrator who can help with setting up an SSL certificate on my Ubuntu Apache web server. This task will require a good understanding of web server security, Apache, and Ubuntu operating systems. Key tasks will involve: - Validating the pre-existing SSL certificate - Configuring Apache to work with SSL - Testing the certificate to ensure it's working perfectly Users should have: - Extensive experience with Linux, specifically Ubuntu - Experience in web server security - Proficiency with Apache server setup - Familiarity with SSL installation and configuration
...Demonstrated ability to create visually appealing and informative charts and dashboards using tools like Tableau, Power BI, or similar. • Cloud Platforms: In depth experience with major cloud platforms (AWS, Google Cloud, Azure) and database automation. • Bachelor's degree in Computer Science, Data Science, Geography, or related field. • Familiarity with programming languages such as Python, R, or SQL. • Experience with API integrations and data manipulation techniques. • Strong understanding of machine learning and AI concepts, and the ability to integrate predictive models into software applications • Stay up-to-date with the latest industry trends, technologies, and best practices in data engineering, analytics, and AI Additional Desirable S...
I'm looking for a web scraping expert to help me gather personal profiles, email, and phone numbers from LinkedIn. The data I need should be based on broad search queries. Key Requirements: - Extract specific data: personal profiles, email and phone numbers - Data source: LinkedIn - Search type: Broad search query - Search criteria: Job title or role, Geographic location Ideal Skills: - Proficient in web scraping - Experience extracting data from LinkedIn - Ability to create custom search queries - Prior experience in gathering personal contact information
This project focuses on configuring an existing high-performance computer to process and query large datasets using the Llama3 (70b) language model. The objective is to enable efficient data handling and querying capabilities on the local system. Configure the existing computer with the following specifications for optimal performance: CPU: Intel Core i7-12700F GPU: Nvidia RTX 3070 Memory: 32GB DDR5 RAM Storage: 1TB SSD Operating System: Windows 11 or Linux Set up and optimize the Llama3 (70b) language model on the local system. Process 2,300MB of data to be optimized for use with the Llama3 model. Develop a user interface or command line utility to facilitate local data queries using the Llama3 model. Deliverables: Con...
