SQL Jobs

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

Without specific details from the client about the main goal of the data engineering project, the types of data sources to be integrated, and the level of data processing required, it's still clear that an accomplished Data Engineer with a vast range of skills and experience is needed for this project. Ideal Skills: - Knowledgeable about data integration, warehousing and building pipelines - Competency in working with various types of data sources including databases, APIs, and files - Proficiency in data transformation, aggregation, and cleaning -Bachelor's degree in Computer Science, Engineering, or related field. -2+ years of experience as a Data Engineer or similar role. -Hands-on experience with PySpark, Scala, and Azure Databricks is required. -Experience with data modeli...

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 currently encountering difficulties while creating a multidimensional cube in Visual Studio 2022. It seems I'm being plagued by some recurring run-time errors, and I need an experienced hand to help troubleshoot and resolve these issues. In detail, the task will involve: - Understanding the run-time error messages I'm receiving - Debugging to solve these errors for successful creation of a multidimensional cube Ideal candidates should: - Be proficient with Visual Studio, preferably with the 2022 version - Have strong experience in debugging run-time errors - Have a solid understanding of creating and handling multidimensional cubes I look forward to working with someone who can help rectify this problem promptly. Thanks in advance for your bids.

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.

Description: I am seeking an experienced data analyst with expertise in SQL and R to conduct a thorough review and testing of a recently completed data analysis project. The successful candidate will be responsible for evaluating the accuracy and completeness of the work, ensuring all requirements are met, and identifying any potential issues or opportunities for improvement. Responsibilities: Review the SQL queries and R scripts used in the project for accuracy and efficiency. Test the data outputs to ensure they align with the project requirements. Verify that all analysis reports are complete and adhere to the specified guidelines. Provide a detailed report outlining any issues found, confirming requirement fulfillment, and suggesting any potential upgrades or improvements. Requirem...

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

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

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

I need a Python code to perform data analysis on text data sourced from tables. This project emphasizes the importance of being highly familiar with Python and its data analysis and text processing libraries. Key tasks: - Extract text data from tables - Perform comprehensive text data analysis Ideal skills: - Proficient in Python - Extensive experience with data analysis and text processing libraries - Familiarity with table data extraction - Strong understanding of text data analysis techniques and methodologies. I look forward to hearing from experts in Python data analysis. This is a chance to demonstrate your ability to solve complex data processes.

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

I'm looking for an experienced .NET developer to assist with a project. This project requires someone who has a strong background in .NET technology, particularly in C# programming, ASP.NET development, and SQL database management. Ideal candidates should have experience in developing web applications, creating software solutions, and improving existing systems. The key functionalities to be implemented by the .NET developer in this project include user authentication, data encryption, and payment integration. If you're a .NET developer with a solid understanding of the above technologies and functionalities, please reach out to discuss the project further.

I want to develop a website similar to and https://www.abasteo.mx. The goal is to automate daily updates of the website's database. Key Requirements: - Daily database updates: The website should automatically update its database every day. - Products and prices: The database should include technology products, such as electronics and computer hardware. - Design and layout: The website should be visually appealing and user-friendly. - Database type: The database can be either SQL or MySQL. Ideal Skills: - Proficiency in SQL or MySQL - Experience in e-commerce website development - Strong understanding of front-end design - Ability to automate database updates - Expertise in handling technology products Your proposal should include: - Your experience in similar projects - Your appro...

I'm seeking a proficient developer to construct a robust, elegant and classic eCommerce website on Shopify. The website should comfortably accommodate a product catalog of over 4000 products. Key Features Required: - A comprehensive product catalog that is easy to navigate. - Seamless shopping cart functionality. - A secure, reliable and user-friendly payment gateway. Preferred candidate should have extensive experience in developing high-performing eCommerce websites on Shopify, have a keen eye for classic design aesthetics, and a proven track record of integrating large product catalogs, shopping cart and payment gateways. Experts in User Experience (UX) and User Interface (UI) are highly desirable. Quick turnaround without compromising quality is a must.

Looking for a skilled developer to fill in for a team member on vacation. The ideal candidate should have: - Strong experience in C# and ASP.net - Good knowledge of SQL Server The role involves: - Troubleshooting and fixing bugs in our existing applications - Enhancing and adding new features to our applications The projected timeframe for this position is less than a month, but the role could potentially be extended. You're being hired for not only your skills but also your problem-solving abilities - an essential trait when dealing with application bugs/issues. The key objectives for this role are: - Improving the performance and stability of our applications - Enhancing the user experience and application functionality Note: We skipped the outcome due to the job's short-term ...

I'm seeking an experienced Azure Data Engineer to step in and effectively collaborate with my remote team. Given the lack of a specific task or main goal, your expertise, adaptiveness, and versatility will come in handy. Key responsibilities may likely include: - • Ideal candidates should have strong experience with Azure Databricks and Data factory. • Conducting data analysis - Data integration - Data processing - Possibly executing ETL processes - Maybe venturing into data modelling, optimization, and pipeline development. • Efficient communication and collaboration capabilities are needed for this remote role. • I look forward to working with an adaptable professional who can confidently handle diverse tasks in Azure data engineering. • Design, deve...

As a client, I am looking for a professional and experienced full stack developer with a strong background in to build a new microservices architecture from scratch. The project will involve the following key components: - User Authentication and Authorization: The microservices should have robust user authentication and authorization functionalities to ensure data security and privacy. - Real-time Communication with WebSockets: The developer should be able to implement real-time communication using WebSockets, allowing for instant updates and notifications. - Integration with Third-party APIs: The microservices need to seamlessly integrate with various third-party APIs, ensuring smooth data exchange and interoperability with external systems. The ideal candidate should have: - Extensiv...

SQL Injection을 이용해서 web site 사용자 접속 URL 수집(검색경로, 쿠키 , 로그인세션, 검색키워드) 프로그램 개발 건.

Hola! Comentarles quisiera una app sencilla que sea un control de inventario que tenga 2 tipos de usuarios que seria el usuario normal y el administrador, que tenga 4 imágenes cada producto, que lleve una breve descripción, que se muestre la marca del producto, y que en el panel de administrador se pueda modificar precios, que desde el panel de administrador se puedan poner porcentajes de descuento y que en la vista de usuarios aparezca el precio original y después con el descuento aplicado, existencia de productos, fecha de caducidad y numero de lote también que la base de datos sea en sql server y que la app se pueda usar con internet y sin el osea si no se tiene conexión a internet que de igual manera se pueda ver los productos que hay sin importar no ...

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

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.