SQL Jobs

I'm facing data inconsistencies in my ABAP report, specifically affecting the output of financial data. The inconsistencies appear in the output report, and I need a skilled ABAP developer to help fix and debug the report. Ideal Skills: - ABAP programming - SAP knowledge - Debugging skills - Data analysis Experience: - Previous experience with ABAP report debugging is necessary - Financial data handling experience is a plus - Performance optimization skills would be appreciated

I'm seeking a C# developer with expertise in ILGPU to create an application that picks data from MS SQL, processes over 10 million rows. The app will use lookup tables to complete each record before sending the output to a SQL Server database. Key Requirements: - 90% of the data processing must be handled by the GPU for maximum efficiency. - Implement a system for memory optimization to handle extensive lookup tables. - Enhance lookup speed for quick data retrieval. - Ensure all processes are conducted within the GPU. - The final output should be seamlessly entered into a SQL Server database. Ideal candidates should have: - Strong experience in C# programming. - Proven track record in developing applications with ILGPU. - Deep understanding of SQL Server. - Expertise in memory and...

I'm seeking a technically savvy professional to provide support in the realm of software development, specifically with Python. Ideal Skills and Experience: - Proficient in Python programming language - Proficient in Databricks - Extensive experience in software development - Problem-solving and analytical skills - Able to work independently and as part of a team - Excellent communication skills to explain complex technical issues in a simple way

I need an SQL reporting system created in Solidworks PDM. The system should generate daily reports that include user activity logs, file revision history, and project status summaries. Ideal skills and experience for the job include: - Proficiency in SQL - Extensive experience with Solidworks PDM - Familiarity with data analysis and report generation - Ability to understand and track project status The primary goal is to automate the report generation for comprehensive insights into our PDM system. This will facilitate regular updates for stakeholders and ensure we're in tune with user activity and file changes. Below is how I see such reports could be done (just for reference in order to manage expectations), however, I'm open to other proposals for the report structure. Exam...

I need an experienced developer to create a robust database for managing my business's inventory. Key Requirements: - Design and implement a comprehensive database system. - Efficiently track product details and stock levels. - Integrate supplier information and order history into the system. Ideal Skills and Experience: - Proficient in SQL, NoSQL, or Distributed databases. - Strong background in inventory management system development. - Excellent understanding of handling manufacturing-related data.

I'm in need of a seasoned Power BI expert to create an interactive financial dashboard. This dashboard should connect seamlessly to multiple data sources including SQL Databases, Excel Sheets, and various Online APIs. It should provide a clear and comprehensive view of key financial metrics such as Revenue and Expenses, Profit Margins, and Cash Flow. Ideal candidates should: - Have extensive experience with Power BI - Be proficient in connecting diverse data sources - Possess a strong understanding of financial metrics The goal is to create a dynamic and user-friendly dashboard that can provide real-time insights into financial performance. Please include examples of previous similar projects in your bid.

I'm in need of a LookML developer to help maintain my existing data models. The primary focus of this role will be on AWS Redshift. The tasks will include: - Bug fixing: Identifying and resolving issues in the data models. - Regular updates: Ensuring the data models are up-to-date with current data sources and business requirements. - Performance tuning: Optimizing the data models for better performance. Ideal candidates for this project should have experience working with LookML and AWS Redshift. Proficiency in debugging and performance tuning is crucial.

I'm seeking a skilled professional to assist with data transformation tasks in Matillion. Your primary responsibilities will include: - Configuring and optimizing ETL processes to facilitate smooth data transformation. - Employing best practices for data manipulation, ensuring accuracy and efficiency. Ideal candidates should possess substantial experience with Matillion and a strong background in data transformation. Prior work with ETL configuration and integration with other systems is highly desirable. Proficiency in data cleansing, aggregation, and enrichment will be advantageous.

I'm seeking an experienced professional with advanced skills in Microsoft Excel and Business Intelligence (BI). The tasks will primarily involve: - Data Analysis: Focusing on sales data to extract meaningful insights and trends. - Automating Tasks with Macros: The main goal here is to automate complex calculations to improve efficiency and accuracy. - Creating Visual Reports: Designing engaging and informative visual reports to present the data analysis results. Ideal candidates should have a proven track record in handling sales data, as well as extensive experience in using Excel and BI tools. Skills in creating macros and generating visual reports are essential. Please provide examples of your previous work in your bid.

I need a skilled C# developer to convert a SQL stored procedure (SP) into a Lambda function in C#. The main functionality of this stored procedure is data retrieval. The SP involves several joins between multiple tables, specifically inner joins, left joins, and right joins. Ideal Skills: - Proficient in C# - Extensive experience with Entity Framework - Strong understanding of SQL and data manipulation - Familiar with using Lambda functions Experience: - Previous work converting stored procedures to C# is a plus - Proven track record in data retrieval tasks - Experience handling complex joins in SQL Please provide your relevant experience and examples of similar projects you've completed.

I'm in need of an ER diagram primarily to visualize data relationships. The complexity of the relationships between entities is moderate. More instructions upon messaging Ideal Skills: - Proficiency in database design and ER diagram creation - Strong analytical skills to understand and visualize data relationships Experience: - Prior work with creating ER diagrams for moderate complexity systems - Experience in using software tools for ER diagram creation

I am looking for a enthusiastic, hard working individual who wants to learn 1 piece of software and troubleshoot this 1 piece of company software. This role requires someone with a technical support at at least a 1st line level, who knows there way around Windows server and basic SQL server commands like SELECT, FROM, WHO, WHERE. Ideally they will have a technical support background and enjoys problem solving. As part of the job, you will be given training material to understand the intricacies of this custom software and provide effective solutions to any issues that arise. The ideal candidate should have experience with troubleshooting software (e.g. event viewer, logs, task manager) and be able to grasp where the problem could be. Attention to detail and the ability to work independentl...

I'm seeking an experienced developer or consultant to provide guidance on upgrading my C# Windows Application ms sql to both web and mobile platforms. Key areas for consultation: - Web & Mobile Technologies: Recommending the best technologies for a seamless upgrade. - Database Setup: Advising on the optimal database configuration, whether a single or multiple databases would be most efficient. - Upgrading Existing Customers: Strategies for transitioning current users to the upgraded application. - Developer Management: Ensuring development is conducted without code duplication. The ideal candidate would have: - Extensive experience with C# Windows Applications. - In-depth knowledge of web and mobile technologies. - Proven track record in database management and setup. - Excelle...

I'm planning to add S4 Hana systems to SAP LiveCompare to perform analysis Ideal skills for this project include: - Proficiency in Tricentis LiveCompare - Experience im SAP I am looking for a freelancer who can provide comprehensive analysis and facilitate a smooth upgrade process. Please share your relevant experience and how you can help with this project.

I'm looking for a professional who can assist me with the installation of Oracle SQL Developer on my Windows system. I have any desk on my computer so we can use that or I can share screen on skype

I need a skilled professional to set up Tableau for me, primarily for creating user-friendly data dashboards for the general staff. Key Requirements: - Connect Tableau to our SQL databases. - Design intuitive dashboards that can be easily navigated by non-technical users. - Experience with Tableau is a must, prior work with SQL databases is highly preferred. The purpose of this project is to enable our staff to visualize and interact with our data in a meaningful way. We have the data available - our data is from We have a document stating the dashboards we'd like to create from our data (attached) happy to talk more and answer questions.

I'm looking for a VB.Net application that reads from a SQL server table and sends out a weekly automated email summary report. The report should be well-structured and include appropriate charts illustrating the data. Key Aspects: - The specific data points to be included in the report are still to be decided, but it could potentially cover areas like sales and revenue, user activity and engagement, or inventory and stock levels. - The types of charts to be included in the report are also yet to be specified, but they may include bar charts, line charts, and pie charts. - The formatting of the email report is also open for discussion, with options including plain text with attached charts, an HTML email with embedded charts, or a PDF attached to the email. Ideal candidates for this...

I'm seeking a skilled full-stack developer with expertise in both React and Node.js to create a comprehensive web and mobile application. The app will incorporate a data analytics/dashboard functionality, and will be hosted on AWS. Key Responsibilities: - Develop a seamless, interactive web and mobile application using React for the front-end and Node.js for the back-end. - Implement a robust data analytics/dashboard feature within the application. - Ensure optimal performance and responsiveness of the application across both web and mobile platforms. Ideal Qualifications: - Proficient in HTML5, CSS, and JavaScript, with a strong grasp of Bootstrap or other CSS libraries. - Prior experience in mobile development, specifically with React Native, is highly preferred. - Familiarity wit...

I need an SQL reporting system created in Solidworks PDM. The system should generate daily reports that include user activity logs, file revision history, and project status summaries. Ideal skills and experience for the job include: - Proficiency in SQL - Extensive experience with Solidworks PDM - Familiarity with data analysis and report generation - Ability to understand and track project status The primary goal is to automate the report generation for comprehensive insights into our PDM system. This will facilitate regular updates for stakeholders and ensure we're in tune with user activity and file changes. Below is how I see such reports could be done (just for reference in order to manage expectations), however, I'm open to other proposals for the report structure. Exam...

I'm in need of a skilled database professional to help me transition from Microsoft SQL to MongoDB. Here are some key details about the project: - **Current Database Size:** My MS SQL database is less than 1GB, thus the migration should be manageable in scale. - **Experience with Azure CosmosDB:** I'm specifically looking for an expert who already has a solid understanding of Azure CosmosDB as I've already decided to move forward with this NoSQL option. - **Schema Design Assistance:** I'm also looking for the selected freelancer to handle the complete schema design for Azure CosmosDB as part of the project. Ideal candidates should have: - Proven experience with both MS SQL and Azure CosmosDB - Excellent understanding of database schema design - Strong communication sk...

I'm looking for a Microsoft Fabric expert, specifically a data engineer, to assist with my project. The main focus will be on creating data pipelines and integrating APIs as data sources. Key Responsibilities: - Design and implement efficient data pipelines - Integrate various APIs into Microsoft Fabric Ideal Skills: - Extensive experience with Microsoft Fabric - Strong background in data engineering - Proficient in working with APIs - Expertise in data pipeline creation Please note, the majority of the tasks will revolve around API integration, so experience with various APIs will be a significant advantage.

I'm in need of an experienced C++ developer who specializes in creating REST APIs. The primary function of the API will be data retrieval, specifically product data from an SQL database. Key Responsibilities: - Design and implement a C++ REST API using the POCO libraries. - Ensure efficient retrieval of product data from the SQL database. Ideal Skills and Experience: - Proven experience in C++ and REST API development. - Familiarity with POCO libraries. - Strong understanding of SQL databases. - Experience in optimizing data retrieval processes. Please bid if you can deliver a high-performance and scalable solution.

I'm looking for a web developer to create a small project on contact information collection website for businesses. The site should be designed to collect the following data: - Business name and address - Contact information Key features needed: - Contact forms: The website should have integrated contact forms to facilitate the collection of contact information from various businesses. Some of the contact field can be auto fill by scanning QR code. Programming Language: C# Database: MSSQL Web Server: IIS Manager Data interchange format :Json Ideal Skills: - Proficient in web development and design - Experienced in creating data collection websites - Knowledgeable in database management MSSQL - Skills in implementing secure and efficient data storage solutions - Competent in inco...

I need support with XML documents. Now I have an xsd file, from which I can generate C# classes. However, they have some headers, they do not have the required id, accessors {get; set;} and what is worse, there are no relations between tables. The goal of this task: From given xsd I want to generate classes for Entity Framework and tables for MS SQL. I have to do it on a computer at work, so I expect the solution to contain a step-by-step description of all the actions so that I can generate a table for sql with relations. Everything must work automatically without manual intervention. I can do this myself: I have classes generated from xsd in c#, but I do not know how to make classes for EF, I do not want to do it manually. If I have EF classes, I will generate a script for the datab...

I'm looking to add some new features to my ASP.NET MVC & SQL Server-based tennis website. The key areas of enhancement involve organizing users and forming teams. Key Requirements: - Team Creation and Management: Users should be able to create and manage their own teams. - Automated Team Assignment: A feature that automatically assigns users to teams based on certain criteria. - Team Statistics and Performance Tracking: This will involve tracking different teams' performances and statistics over time. Ideal Skills and Experience: - Proficient in ASP.NET MVC and SQL Server. - Previous experience with developing team-based features in web applications. - Understanding of statistical tracking and performance analysis systems in web platforms.

I'm looking for a software developer to create a fully functional Windows-compatible software for auditing purposes. The software should allow the user to upload controls and automatically populate a report. Key Requirements: - Develop a Windows-based software for auditing - Implement an upload feature for controls - Ensure the software can automatically populate a Word Document report - User authentication features are not necessary Ideal Skills: - Proficiency in Windows software development - Experience in creating auditing software - Ability to implement document generation features - Knowledge in developing user-friendly interfaces

I'm in need of a seasoned SQL Server professional with over 5 years of experience to assist with writing dynamic SQL queries. The primary focus of these queries will be data cleanup. Key Responsibilities: - Writing Select, Update, and Delete queries - Ensuring the queries are efficient and effective for data cleanup Ideal Skills and Experience: - Over 5 years of extensive experience with SQL Server - Proven track record of writing dynamic SQL queries - Strong understanding and experience with data cleanup processes - Ability to write and optimize Select, Update, and Delete queries - Excellent problem-solving skills and attention to detail

I'm seeking an experienced VB.NET developer to assist with my fully developed project. The tasks at hand include: - Bug Fixes: Identifying and resolving existing issues within the codebase. - Feature Enhancements: Improving current features and possibly adding new ones based on project specifications. - Performance Improvements: Optimizing the code to enhance project efficiency and speed. I have comprehensive and detailed documentation available for this project. This will provide you with all the necessary specifications and guidance. Ideal Skills and Experience: - Proficiency in VB.NET and SQL - Experience working with similar projects - Strong problem-solving skills for bug fixing - Ability to improve and enhance software features - Knowledge in code optimization for performance...

I'm in need of a comprehensive homeowner database for my Florida property. The primary purpose of this database is to manage service requests effectively. Key requirements: - The database must store contact details and addresses for each homeowner. - It should have specific features for handling service requests, which include: - Automated request assignment - Notifications and alerts - Service request history tracking. Ideal skills for the job include experience in database management and development, particularly for service handling. Knowledge of automated systems and alert mechanisms would be beneficial. Previous work in real estate or property management databases is a plus.

Analog 1:1 , trust wallet , exodus , meta mask, oracle.

I want to work with developers who are good at communication and make sure you really understand WordPress n SQL databases. The problem I experienced was quite strange and sudden, because previously it was normal but after working with the developer (I also don't want to accuse), suddenly this problem occurred. So what I mean is, you can first suspect and get the root of the problem. The problem that occurs is that the customer_id is not synchronized, which should be 13 to 10 and it takes 5 minutes for the wp_wc_order_product_lookup and wp_wc_order_stats tables to be updated. While the other tables are updated immediately after payment.

I'm looking to create a MetroMoney website tailored for my organization. The primary focus of the site will be managing memberships efficiently. Key Requirements: - The website should facilitate easy Member Registration and Login through a secure Email and Password system. - It should have a user-friendly interface for both new and existing members. - The site must ensure robust security measures to protect member information and maintain privacy. Ideal Skills: - Proven experience in developing membership management websites. - Strong knowledge in website security protocols. - Proficiency in creating user-friendly interfaces. - Excellent understanding of secure email and password systems. I am looking for a freelancer who can deliver a high-quality, secure, and user-friendly websi...

I'm seeking a legal expert well-versed in the laws pertaining to KORO.

We're facing issues with data accuracy, on time updates and general troubleshooting on our Power BI platform, primarily related to complex data sources including SQL databases and excel input. I need a Power BI expert who can ensure data integrity is maintained, investigate and resolve user complaints, optimise performance, and help us produce reliable reports. Ideal skills and experience for this project include: - Proficiency in Power BI and SQL databases - Experience with Excel data integration - Strong troubleshooting and problem-solving skills - Ability to optimise system performance - Expertise in generating detailed and accurate reports. - provide user training for common solves

I'm experiencing some syntax errors with my SQL queries and need assistance. These errors are causing problems with the database and I need help getting everything back on track. Ideal Skills and Experience: - Proficient in SQL - Experience with database troubleshooting - Able to identify and fix syntax errors in SQL queries.

I need a web app dedicated to selling my course. It will feature video lectures, written articles, interactive quizzes, and interactive games. Key Requirements: - Expert in web app development - Experience in e-commerce and course selling platforms - Ability to integrate diverse content delivery formats - Understanding of user-friendly design and navigation Please ping me to discuss this project further.

I'm in need of a skilled technical writer to create comprehensive technical reports primarily focused on the Information Technology sector. Technical writer should be proficient in coding as well as have experience with APA and Harvard style referencing. Technical reports will be on following domains - Feature engineering Data cleaning AWS (AWS glue, data, etc) Orange visualisation and Exploratory. PHP Python SQL PL/SQL Business Analytics Data Analysis. If the work is excellent, further tasks will be given on variable pay basis.

I'm looking for a VB.net 2008 application that operates in the background. The app should handle data replication and synchronization across MSSQL 2000, 2005, and 2019 servers, with a focus on merge replication. It should also incorporate error handling and logging functionalities to ensure smooth operation and easy troubleshooting. Key Features: - Data Replication: The app should be able to replicate data across different servers seamlessly. - Data Synchronization: Ensuring that all servers maintain the same data. - Error Handling and Logging: The app should be able to log any errors that occur during operation and handle them appropriately. Ideal Skills: - Proficiency in VB.net 2008 - Extensive experience with MSSQL servers, particularly 2000, 2005, and 2019. - Understanding of me...

I'm looking for a Power BI and SQL expert to create a dashboard focused on my pizza sales. Key Requirements: - Integrate SQL data seamlessly into Power BI - Visualize monthly sales trends - Display current stock levels, inventory turnover rates, and order restocking alerts - Deliver the project on time Please share your portfolio and outline your approach for this project.

mainly just to provide an idea of how to automate the contract based on approvals with buttons

I need an expert in ETL operations to process a 500GB SQL database and successfully import the data into our Supabase instance. Up to date proposal: Key Requirements: - ETL: Extract the necessary data, transform it as required, load to Supabase - CSV/SQL Database: The data is currently in an SQL database & CSV files - Data Processing: Extract only specified data and enrich it with simple keywords (like adding 'petrol' to fuel_type to all cars models) Ideal Skills: - Proficiency in SQL and ETL tools - Experience with Supabase - Data cleaning and validation - Simple data enrichment This project requires meticulous attention to detail and a solid understanding of data processing and SQL databases. Your expertise will ensure our data is accurately transformed and integrated...

I'm looking for a Power BI and SQL expert to create a dashboard focused on my pizza sales. Key Requirements: - Integrate SQL data seamlessly into Power BI - Visualize monthly sales trends - Display current stock levels, inventory turnover rates, and order restocking alerts - Deliver the project on time Please share your portfolio and outline your approach for this project.

I'm in need of a dedicated appointment setter who can assist with setting up property viewings for my real estate business. Currently, I generate my leads through cold calling, but I require someone who can help convert those leads into viewings. Key Responsibilities: - Setting appointments for property viewings - Assisting with follow-up calls Ideal Skills and Experience: - Previous experience in appointment setting, particularly in the real estate sector - Strong communication and cold calling skills - Proven track record of converting leads into appointments - Availability for flexible working hours to accommodate potential clients' schedules Please note that the primary focus of this role will be coordinating property viewings. Responsibilities may expand to include consu...

I'm looking for a professional who can build a comprehensive database for my camp. The database should efficiently handle various aspects including: - Camper Information: Personal details, emergency contacts, camping dates, vehicle information, and sleeping arrangements. - Activity Schedules: Names of activities, their time slots, and the staff assigned to each. - Financial Management: Keeping track of our budget and camper dues/fees. Ideal candidates for this project should have experience with database development, preferably in a camp or similar environment. They should also possess a good understanding of both financial and logistical management.

Failed to connect with database ! SQLSTATE[HY000] [2002] No such file or directory

I need an experienced professional to deploy my fully developed Angular+Node+SQL application to cPanel on Hostinger. Note, this isn't a standard setup - specific configurations are required. Key Requirements: - Proven experience with deploying applications on Hostinger's hPanel and cPanel. - Proficient in Angular, Node.js, and SQL. - Capable of implementing specific environment configurations and dependencies. - Able to troubleshoot and resolve potential deployment issues. Please ensure to bid only if you meet these criteria.

I'm looking for a Python programmer to develop an automated trading program using the and IBKR TWS API. The primary goal of this program is to execute trades based on pre-defined day trading strategies. Key functionalities of the program should include: - Daily market scanning to identify trading opportunities - Automatically placing and managing trades - Generating daily trading reports - collecting and storing data and genrates signal - trading type "STK" and "OPT" Ideal skills for this project include: - Proficient in Python, with experience in automated trading systems - Familiar with and IBKR TWS API - Understanding of day trading strategies - Able to design and implement a program that is efficient, reliable and user-friendly.

I'm encountering a deployment issue on Vercel with my business showcase website, www.av-inspec.com. The error message states: "Error: Found invalid Node.js Version: "14.x". Please set Node.js Version to 18.x in your Project Settings to use Node.js 18." - The site is primarily a business showcase. - It includes a contact form, which is a key feature. Your task will be to resolve the Node.js version issue so that the site can be deployed successfully. Experience with Vercel, Node.js, and troubleshooting deployment issues is essential.

I need someone to extract the complete Tecdoc database from the latest DVD catalog (by ODBC connection) and save it on my PC in SQL format for my Sales Program. The extraction should encompass the entire database structure and tables, focusing specifically on product information. There should be no filtering or processing of the data; I require a raw, unfiltered extraction. Ideal Skills and Experience: - Proficiency in SQL and data extraction - Experience with Tecdoc databases - Familiarity with DVD catalog data - Knowledge in handling and transferring large databases - Excellent attention to detail to ensure complete data extraction.

I'm seeking a professional to assist with the setup of my Microsoft Dynamics 365 CRM. This project involves migrating various data, primarily sales data and customer service records, from our existing systems into the CRM. Key Responsibilities: - Migrate historical and current sales data and customer service records into Dynamics 365 - Configure the CRM to suit our business needs - custom project management dashboards - customer request and tracking integration - Provide insights on potential integrations with other systems, such as ERP or marketing tools Ideal Skills: - Prior experience with Microsoft Dynamics 365 CRM - Strong data migration skills - Ability to evaluate and suggest relevant system integrations - Excellent understanding of sales and customer service d...