SQL Jobs

I need an adept SQL developer proficient in crafting SQL queries for various tables within our database. The task entails generating four queries, each encompassing approximately 20 conditions that must be met. Utilizing ChatGPT, could you assist in devising these queries?

I'm in need of an experienced SQL Server data warehouse designer to help with a project of integrating and consolidating data from different sources. Key requirements: - Expertise in SQL Server: You should be able to design, implement and optimize data warehouse solutions on SQL Server. Understanding data warehouse design principles is essential. - Data Integration: You'll need to work with some of our developers / power users to source data and establish automated integration; experience with integrating relational databases and APIs from web services is crucial. - Data Consolidation: You should be able to create a cohesive, consolidated dataset from these different sources applying appropriate design principles. - Medium-sized project: The data needing integration and consoli...

This should be simple for an experienced dev. Need portfolio of flutter dev to apply. Existing code base in place. I am currently in search of a proficient Flutter developer to incorporate a series of changes, mainly focusing on my existing project's UI. Key tasks include: - Updating the color scheme: A primary focus would be to shift the interface to a darker theme. Besides, I am interested in integrating elements of a custom color scheme, which I will provide. - Rearranging the layout: The current layout needs some reorganization. It may involve adding/removing sections based on our requirements. The positioning of various elements within the interface also needs tweaking. This is not just about modification; the potential candidate needs to evaluate the backend code to ensur...

I have a high-complexity T-SQL stored procedure used for data analysis that I need translated into PySpark code. The procedure involves advanced SQL operations, temporary tables, and dynamic SQL. It currently handles over 10GB of data. - Skills Required: - Strong understanding and experience in PySpark and T-SQL languages - Proficiency in transforming high complexity SQL scripts to PySpark - Experience with large volume data processing - Job Scope: - Understand the functionality of the existing T-SQL stored procedure - Rewrite the procedure to return the same results using PySpark - Test the new script with the provided data set The successful freelancer will assure that the new PySpark script can handle a large volume of data and maintain the same output as the present T-S...

Our existing CGI script is encountering issues when importing the exam's section breakdown from a .dat file. Due to this, we are unable to import the breakdown of results per section of the exam into the SQL database. We are seeking a proficient developer who can: - Analyze our existing CGI script and identify the cause of the breakdown import issue. - Provide actionable advice and steps to troubleshoot and resolve the problem. - Ensure the script effectively imports the section breakdown from the .dat file as intended. The ideal candidate for this project should have: - Extensive experience in CGI scripting and SQL database management. - Proficiency in handling and troubleshooting data import/export issues. - Ability to work quickly and efficiently, as we need this problem solved ...

I'm seeking a skilled data architect for providing consultation and recommendations on a Statement of Work (SOW) that involves data warehousing, ad hoc reporting, complex SQL formation, and more. The primary purpose of the project is to streamline and enhance our data storage capabilities. By integrating new data into our warehouse on a monthly basis, we aim to improve our decision-making and business performance through enhanced data access and analysis. Key responsibilities include: - Reviewing and providing recommendations on the SOW for data warehousing - Offering expertise on ad hoc reporting and complex SQL formation - Helping to streamline data storage and improve decision-making - Ensuring the architecture can support monthly data integrations Ideal candidates should have: ...

 We are seeking a highly skilled and experienced individual to fill the role of Database Architect/Lead Developer specializing in Netezza and Oracle databases. The ideal candidate will be responsible for designing, implementing, and maintaining database solutions that meet the needs of our organization. This role requires strong technical expertise in both Netezza and Oracle platforms, as well as leadership capabilities to guide a team of developers. Responsibilities  Design and implement efficient database solutions for our organization, leveraging Netezza and Oracle technologies.  Lead a team of developers in the implementation and maintenance of database systems.  Collaborate with other stakeholders to gather requirements and define database architecture to meet business needs.  O...

I am looking for an expert in SSRS to set up a solution to track our daily financial transactions. The primary goal for this solution is to provide us with a simple, user-friendly way to access and track these transactions on a daily basis. Key requirements include: - Set up and customize the SSRS solution to track daily financial transactions - Ensure the solution is optimized for daily use and can handle the volume of transactions - Implement a system that would automatically send the daily reports to a specified email address Ideal skills and experience: - Proven experience with SSRS and setting up similar solutions - Strong understanding of financial data and tracking requirements - Ability to create automated reporting and email functionality I am open to suggestions and recommend...

I have to transfer data and tables from oracle to postgres.

I'm searching for a developer who can build an automated document verification system to simplify the document management procedure in educational institutions. The system must include the following features: - Database Integration: Integrate with MySQL, our preferred database management system, to make document retrieval and management easier. - User Authentication: I want the system to authenticate users via Single Sign-On (SSO) using existing authentication platforms like Google and Facebook. This is to ensure a secure, seamless and user-friendly sign-in process. Proficiency in MySQL, SSO Integration, and system development is required. Prior experience in document management system creation will be preferable. The ideal candidate should understand the intricacies of data secur...

About the Role: We are currently seeking a highly skilled Senior Python Developer & Data Engineer to join our dynamic team on a full-time or part-time basis. This role offers remote flexibility, allowing you to leverage your talent, skills, and extensive experience to drive our growth and surpass current limitations. The ideal candidate will thrive in a collaborative environment, inspire innovation, and demonstrate a self-motivated attitude toward excellence. Why Join Us: Joining our team presents an exciting opportunity to advance your career in the IT industry amid the remarkable growth of the US job market. As part of our prominent company, you'll contribute to cutting-edge projects that shape the future, positioning yourself at the forefront of innovation. With comprehensive ...

Looking for a Senior BDA with experience in. AZURE SQL SERVER. English mandatory. 1d per week helping to improve and maintain our main DBs.

Description: Seeking a detail-oriented and expert 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: Demonst...

I'm in search of a PHP Developer with a proven track record of developing comprehensive ERP Solutions for the construction industry. We will looking for a ready application something more or less similar to our requirement. A existing pre developed application. Wherein customization can be done. Key Modules Required: - Quotation - Purchase - Project Management - Materials Management - Stock/Inventory - Billing - Accounts - Reports - Project Management - Cost Estimation - Procurement Specific Features for Project Management: - Task Management: The system should allow for easy task assignment and monitoring. - Resource Allocation: It should have a robust system for allocating and tracking resources. Specific Requirements for Cost Estimation: - Integrated Cost Database: The system sh...

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.

VeriCO2 is seeking an experienced developer to create a global scope 1, 2, and 3 emissions database as part of our automated quantification of scope 3 emissions project. The selected developer will be responsible for setting up the database, developing a user contribution system, and implementing security measures to ensure data integrity. Responsibilities: 1. Database Setup - Set up a database to store scope 1, 2, and 3 emissions data for global listed companies. 2. User Contribution System - Develop a system for users to contribute data via LinkedIn by signing up and providing their company's scope 1, 2, and/or 3 emissions. - Implement a security check to ensure the user's email domain matches the company name and send a verification email. - Allow users to download ...

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 assistance in incorporating 2D Data Matrix barcodes within both BI Publisher and Oracle EBS. The primary goal of this integration is to enhance our current inventory tracking systems by printing the Labels with 2D barcode and business users can scan the barcode by using the RF scanner in the inventory. This project should be relatively straightforward for someone who is proficient with BI Publisher, Oracle EBS, and barcode implementation technologies. Key requirements and considerations include: - Proficiency in both BI Publisher and Oracle EBS - Strong understanding of 2D Data Matrix barcodes - Proven experience in integrating barcodes into inventory management systems The successful candidate will be able to not only implement the barcode system but also provide us wit...

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 feature for postin...

I'm in search of a PHP Developer with a proven track record of developing comprehensive ERP Solutions for the construction industry. Key Modules Required: - Project Management - Cost Estimation - Procurement Specific Features for Project Management: - Task Management: The system should allow for easy task assignment and monitoring. - Resource Allocation: It should have a robust system for allocating and tracking resources. Specific Requirements for Cost Estimation: - Integrated Cost Database: The system should have a vast and well-organized cost database. - Calculation Formulas: It should accommodate complex estimation formulas. - Reporting and Analytics: The ability to generate detailed reports and analytics is crucial. Ideal Candidate: - Should have a strong background in PHP ...

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.

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 project is intermediate, focusing on tasks like j...

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

I'm seeking a skilled developer who can create a customized Grafana dashboard that will display real-time data on both water levels and contour land. This project is specifically aimed at monitoring water levels Key Responsibilities: - Develop a functional Grafana dashboard that can display both water level and contour land data. - Ensure the dashboard is updated in real-time, as this data will be used for flood monitoring and prevention. - Implement a user-friendly and intuitive design for easy data interpretation. Ideal Skills and Experience: - Proficiency in Grafana or similar data visualization tools. - Experience with real-time data visualization. - Proven track record of developing dashboards with a focus on monitoring and prevention. This project has the potential to signifi...

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 upgrading our Help Find...

I am in need of a professional QlikView developer capable of seamlessly integrating and modeling our substantial sales data. This project revolves around: - Data Integration and Modeling: Your primary task is manipulating our vast trove of sales records - more than 10,000 - for incorporation into QlikView. - Sales Data Expertise: A solid track record in handling sales data is crucial. Yours should include previous experience with large datasets. The success of this project hinges on your ability to model our data precisely, thereby facilitating informed decision-making on future sales strategies. Excellent knowledge of QlikView, along with a strong background in data integration, will prove invaluable.

My bakery is now in it's fourth generation of ownership. My Dad started using a database program called Formula Coster on his Apple IIc to figure out how to correctly price our baked goods based on ingredient costs, labor costs, overhead, etc. The program also allows us to store the formulas and makeup instructions for all our products based on the dough batch and individual pieces from the dough. It's a simple program that we still use today, but are afraid it may not continue to work very long. Other programs exist, but are all cloud based and require subscriptions with features we do not need. I am seeking an adept database developer to either continue work on an in-progress database or commence anew based on existing requirements. This database is intended for exclusive us...

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 better u...

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 the jo...

I'd like an experienced developer to build a web application using C#. This application should have a functional interface interaction and efficient database management capabilities. I also need the implementation of an API for authentication and authorization purposes, ensuring secure access. Key expertise necessary: - Proficient in C#, ASP.NET - Strong skills in database management - Experience in UI design and interaction - Expansive knowledge in API integration, specifically for authorization and authentication.

I'm seeking an adept vb.net coder to design a desktop-based GST billing software that primarily integrates with SQL Server. While there aren't any specific features I've outlined, I'm hoping to work with someone who's knowledgeable about the typical functionalities of GST billing software. This expertise will be critical in shaping the software's development. Critical skills and experience required: - Strong proficiency in vb.net - Familiarity with SQL Server - Previous experience designing billing software - Understanding of GST's impact on invoice generation, tax calculation, and inventory management

I'm in urgent need of an expert Kotlin developer. Ideal Skills: - Exceptional Kotlin programming knowledge If you are versatile, adaptable, and have a strong understanding of Kotlin development across various aspects, please bid on this project.

I'm looking for a skilled developer who can create a Custom Milestone Alarm Manager for our existing security system. Key Features: - Real-time alarm notifications: The system should be able to notify our operators as soon as an alarm is triggered. - Centralized alarm management: I want all the alarms to be managed under a single interface for easier monitoring and control. The current security system is built on the Milestone platform, so experience with this software is a must. Develop an automated alarm management system that minimizes manual intervention. Deliver a user-friendly interface for efficient alarm handling and response. Deliverables: Fully functional Custom Milestone Alarm Manager integrated into existing systems. Complete documentation on system architecture, impl...

DotNet developers required for "'Errors removal and Improvement work"' in thenafter Host on server. Developers should also have knowledge about Merger of sourcecode and database of his done-work with other developer's done-work on GitHub. Website Address - User emailid- @gmail.c Password- kaspersky Errors removal and Improvement work which has to be done is explained in below link-

My project requires an experienced Java SpringBoot developer with a strong understanding of Kafka for asynchronous communication. The ideal candidate should also have: - Proficiency in building and managing REST APIs, focusing on CRUD operations - Ability to integrate with external APIs and service data repository calls - Expertise in crafting and handling SQL queries, preparing for moderate traffic and frequent daily queries - Competence in setting up batch schedulers - Proficiency in sending email notifications This project offers an excellent opportunity to apply and enhance your Java SpringBoot and Kafka skills.

I need a skilled Power BI developer to support me with key aspects of my project. Your tasks will include: - Data modeling and visualization - Creating insightful dashboards - Generating detailed reports You'll need to connect and work with data from Excel spreadsheets and SQL databases. So, competency and experience with these data sources is crucial for this project. I'm looking for an intermediate Power BI developer. You should have a solid understanding of Power BI functionalities and the ability to translate data into clear visual insights.

I am seeking a skilled individual for data entry into an SQL Database. This project involves: - Converting digital non-structured data into SQL format - Inputting the converted information into an SQL Database accurately The ideal freelancer will: - Have SQL Database knowledge and expertise - Show proficiency in handling non-structured data - Demonstrate attention to detail and accuracy Experience in data entry, particularly into SQL Databases, would be greatly beneficial for this role. Your responsibilities will not only include converting and entering data but also ensuring its accuracy and consistency. I expect a high degree of meticulousness and precision from you.

I'm looking for a professional with a deep understanding of SQL injection to help me identify vulnerabilities in a MySQL database. If you're experienced in this area, I'd be glad to work with you. Key Expectations: - Identify vulnerabilities: Your primary task will be to thoroughly test the database for potential vulnerabilities, considering various injection techniques. - No access: Since I don't have any access to this database, I'm looking for someone who can perform this task remotely. You'll be expected to provide a detailed report on the vulnerabilities identified, so I can address them with my database administrator. - Change database values: Additionally, I'd like you to demonstrate the ability to change database values, as a proof of concept. T...

Google big query - for writing sql queries for the complex data

Hi, we require an SQL macro that we need to be able to delete EAN codes that have less than 8 numbers from the import. So EAN codes that have between 1 and 7 digits must be removed from the import. We use a software called StoreManager that uses SQL. The formulas entered in the software look like this IF([CSV_COL(16)]=0 OR[CSV_COL(16)]=‘’ OR[CSV_COL(16)]<0,‘’,[CSV_COL(16)]) Payment and/or Milestone after the problem has been solved.

I need a talented SQL developer to create a stored procedure that will automate the process of marking certain items as 'picked up' in our Microsoft SQL Server database. This script should essentially replicate the functionality of our existing Windows application, performing the necessary changes in the database to reflect this status. Key Requirements: - Strong command of SQL and experience in Microsoft SQL Server is essential. - Familiarity with Windows application development is a plus, as this script should mirror the behavior of our existing front-end tool. - Previous experience in creating SQL stored procedures for automating database actions is highly preferred. - Attention to detail and the ability to trace SQL commands accurately is crucial. Access & Support: - I ...

I am using QuickBooks Enterprise and wish to connect it with QuickBooks Connector but need guidance. - Expertise Needed: 1. Knowledge of QuickBooks Desktop, particularly the Enterprise version. 2. Experience with QuickBooks Connector. 3. Familiarity with connecting QuickBooks Desktop with QuickBooks Connector. - Responsibilities: The freelancer should provide step-by-step assistance on how to establish the connection. - Desired Information in Applications: Despite not providing specific details, I appreciate applications with comprehensive experience overviews, along with a detailed proposal outlining how you plan to complete this task. Mention similar projects you've worked on in the past as well. Looking forward to your help!

We've developed an MS Access database front end with a SQL Server back end. Now we need to install both of these with government agencies in South America whose IT people only speak Spanish. We provide written installation instructions in English. Our clients can only meet the contractor online for server installations during business hours in American time zones. This is periodic work, installing databases whenever clients request them. At present we have six clients in the queue. The applicant must guide and troubleshoot each installation online in fluent Spanish. The successful applicant will have a record of relevant database work. We're a university-based not-for-profit.

I'm on the hunt for a skilled Data Analyst who will work closely with our customer data, primarily formatted in Excel/CSV. The primary goal of this analysis is to identify trends and patterns that could aid our business processes. Key Responsibilities: - Deep analysis of customer data to identify patterns and trends - Create visually engaging and understandable reports Ideal Skills and Experience: - Proven track record as a Data Analyst - Comprehensive understanding of data analysis methodologies - Superior skills in Excel/CSV data processing - Ability to present complex information in an engaging and understandable manner. Your contribution will hugely impact our business decisions. I look forward to viewing your proposals. Please include samples of your previous data analysis...

Tengo un ERP desarrollado en Vbasic 6.0, necesito un desarrollo complementario que permita tomar el xml generado por el ERP y que termine el proceso. Ademas necesito que la aplicacion pueda ser accesada por un movil android y generar Guias de Despacho, las cuales deben llegar al ERP con base de datos en MYSQL

I am seeking a skilled .NET developer to create a Windows application with the following features: - User Authentication and Authorization: The application should ensure secure user access and have roles-based permissions. - Database Integration and Management: Experience with handling complex data and ensuring its security is essential. - API Integration: The application needs to communicate with external systems through APIs. My primary concern is scalability. The application must be designed to grow and handle an increasing number of users without compromising performance. Hence, I am looking for a developer who can plan and implement a scalable architecture from the very beginning. The ideal candidate should have: - Proficiency in .NET framework, particularly for Windows application...

Tengo un Insert que proviene de una tabla que esta consumiendo mucho CPU al momento de ejecutarse, es un SP simple pero requiere de índices o validar que los que ya están creados no estén causando conflicto y aumenten el consumo del CPU

Se debe mantener un sistema hecho en .Net el cual esta vinculado a una base de datos SQL Server de Microsoft. El postulante debe manejar a la perfeccion el idioma Español.

I am in need of a freelance MIS Executive with strong skills in data analysis and database management. Responsibilities: - Conducting detailed data analysis using the provided tools - Proficiently manage and maintain a database Ideal Candidate: - Proficient in Microsoft Excel and SQL Server - Experience in database management and data analysis - Strong analytical skills - Excellent attention to detail This project requires someone who can work independently, has a good eye for detail, and can deliver high-quality results. A background in MIS or similar field would be a big plus.

I am looking for a talented and experienced web development team to create a unique, fully functional social media platform. Key Features: - User Profiles: A robust user profile system that allows users to create and customize their profiles. - Messaging System: A secure and interactive messaging feature that enables users to communicate seamlessly. Ideal Skills and Experience: - Proven experience in developing and deploying web applications, preferably in the social media domain. - Proficiency in programming languages and frameworks suitable for developing a dynamic web application. - Strong understanding and implementation of user experience and interface design. - Ability to create scalable, secure, and maintainable code. - Excellent teamwork and communication skills, as this project ...