SQL Jobs

I'm looking for a CRM dashboard for my small company. I'm considering platforms like Hubspot, Monday, or Pipedrive, but I'm open to other options as well. The key requirement is that it should allow for custom reporting capabilities without incurring a hefty monthly software cost. I need your guidance on the appropriate platform once we've discussed my requirements. Work does not include data entry, in need of the Dashboard and Reporting shells with a limited number of scrubbed client data records for development and testing. Actual production clients will be entered by my company post release. Key Focus Areas: - Customer activity tracking - Team productivity - An interactive, insightful dashboard Given that my team has an intermediate level of technical expertise,...

I need a C# program that uses forms to manage product records in SQL Server. The program should allow users to insert, update, and delete records, as well as search for products. Key Requirements: - Proficiency in C# and experience with Windows Forms - Extensive knowledge of SQL Server - Ability to create user-friendly interfaces Please only bid if you can deliver a high-quality, efficient program. The work will be through AnyDesk.

I need a skilled PHP/SQL programmer to help me troubleshoot and fix issues in my existing code. I'm currently facing a couple of challenges that need immediate attention. 1) PDF Files Preview Issue: I have PDF files that are not previewing properly on three different pages and a 'save to PDF' page. Some PDFs are displaying while others aren't. All these files are stored in a database table. 2) Setting Up New Database Fields: I need assistance in creating three new fields in my database. This will involve integrating these fields in the front-end and back-end of my existing system. Ideally, I would like to complete these tasks within three hours, though I anticipate we could finish sooner. If you're available now and ready to work with me, please respond with you...

School Fees Management System (SFMS) Project goal Develop a system to manage and collect university fees. Scope of work - Software Development: Create a comprehensive system for managing school fee processes. - User Interface: Develop an intuitive user interface for ease of use by college administrators and students. - Database Integration: Set up a secure database to handle student financial details and transactions. Technical requirements - Secure Payment Gateway through School Fees Collection/Payment Sources (Banks, Payment Gateway, OTC) - Integrate reliable and secure payment methods for fee processing. - Multi-User Support: System should support multiple user roles such as administrators and students. - Scalability: Ensure the software is scalable to handle potential future incre...

I'm looking for a skilled professional who can help integrate my payroll software with an internal CSV database. The goal is to generate specific payroll reports which meet the requirements of New Jersey and New York City certified payrolls. Key Responsibilities: - Integrate payroll software with an internal CSV database - Generate New Jersey Certified payroll report - Generate New York City Comptroller Certified payroll report Ideal Skills: - Strong experience with payroll software - Proficiency in handling and integrating CSV files - Prior experience with generating certified payroll reports Please note: The ability to understand and meet the requirements of certified payroll reports for New Jersey and New York City is crucial for this project. This report if easier can also be ...

I need a skilled bug hunter or vulnerability tester for my custom-built PHP website. Your task will primarily be to identify SQL injection vulnerabilities on the site and its APIs. Key details: - The website is custom-built using PHP - Potential for a high payout, as I am willing to pay $300 for each SQL injection vulnerability identified Ideal Skills & Experience: - Extensive experience in vulnerability testing and bug hunting - Proficiency in identifying SQL injection vulnerabilities - Prior experience with PHP-based websites is a plus - Familiarity with API testing Please note, the question regarding specific areas of the website where vulnerabilities might exist was skipped, so a thorough examination of the entire site and its APIs will be required.

I'm looking for an experienced Power BI and Microsoft SQL Server professional who can help me visualize data through charts, graphs, tables and matrices. Key Responsibilities: - Connect Microsoft SQL Server database to Power BI. - Create and implement interactive visualizations using charts, graphs, tables and matrices. - Ensure accurate representation and interpretation of data in visualizations. Ideal Skills and Experience: - Proficiency in Microsoft SQL Server and Power BI. - Strong analytical skills with attention to detail. - Experience in data visualization and creating interactive dashboards. - Excellent communication skills to explain visualizations and insights. Filter certain data thru This is goings to be an intensive work please rea

I'm seeking a competent professional to create a comprehensive database for my cargo service. This database should be accessible from tablets, desktops, and mobile phones. It needs to capture sender and receiver details, items, charged amounts, terms and conditions, and provide the option for customer signatures. just we required to replace the paper receipts and manual entries Key Features: - Fully functional database capable of handling all cargo service details - Accessible from tablets, desktops, and mobile phones - Option for customer signatures - Secure with Two-factor authentication I'm not certain about the best type of Database Management System to use, so I would appreciate your recommendations. Skills in SQL-based systems like MySQL or PostgreSQL, or NoSQL-based sys...

I'm looking for an expert in data analysis to help me identify trends within my transactional data sourced from our CRM system. The main focus will be on understanding patterns, customer behaviors, and overall business trends. Ideal Skills: - Proficient in data analysis tools (e.g., Python, R, Excel) - Experienced in working with CRM data - Strong understanding of transactional data - Excellent at identifying trends and patterns Please provide examples of previous similar projects you have completed.

I need an experienced WordPress developer to create a customer portal. Key Features: - Self-registration and login for customers - Secure display of inventory based on customer accounts - Connection to our Microsoft SQL database - Dynamic Inventory Display: Each customer can only view inventory data relevant to their account. - Real-Time Updates: Display real-time or near-real-time inventory updates from the Microsoft SQL database. Customer Specifics: - Customers should have access to view product descriptions and stock levels. This includes part number, description, QTY on hand, Bin, User Lot, and Exp date. - Customers should be able to search and filter inventory by part number, expiration date, and bin location. Ideal Skills: - Proficiency in WordPress - Experience with Microsoft ...

I need assistance in accessing and extracting inventory details from three Oracle .dmp files and five other files with no extension that I have. The data needs to be compiled into an Excel file, and preferable to access the files themselves via a google drive or similar Ideal skills for this project include: - Proficiency in Oracle database - Data extraction and manipulation experience - Excel data formatting skills Please note, I only have the export files and do not have direct access to the Oracle database.

I'm looking for a skilled backend developer with proficiency in Go and SQL. The primary goal of the project is to build and maintain high-performance web services and APIs. Key Responsibilities: Design, develop, and implement robust web services and APIs. Ensure the system is high-performance and can handle significant data processing. Maintain and improve existing systems for optimal performance. Manage and optimize SQL databases for efficient data storage and retrieval. Troubleshoot and resolve backend issues to ensure system stability. Ideal Skills and Experience: Strong expertise in Go and SQL. Proven experience in building web services and APIs. Familiarity with REST API protocols and cloud services (AWS/GCP). Prior experience with high-performance system development. Excellent...

I'm experiencing logical errors in the business logic of my SQL Server stored procedure. These errors occur during specific queries. I need an expert to diagnose and fix the issue.

DotNet developers required for '#Improvement work and Errors removal' 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- userany303@gmail.c Password- kaspersky Technology - .Net Languages - C# Video link of 'Improvement work and Errors removal' which needs to be done is below-

I'm looking for an experienced developer to help complete my heavily documented site and move it from rough MVP to an evantually a launched site. The primary goal of the site is to enable easy access to data through visualizations and dashboards. This project involves completing a basic freemium model membership site that lists service offerings. Key Responsibilities: - Develop a freemium model membership site - Integrate role based auth system using 3rd party db auth system - Integrate listing scraping system using 3rd party scraper - Create a document generation feature - Establish a process management system (calendaring, scheduling) - Implement data processing and taggging system Ideal Skills: - Experience in developing membership sites, particularly freemium models - Proficienc...

I need someone who can edit the lee mac block counter that it automatically updates when edits are made to the blocks after the legend has been placed and that the legend does not need to be regenerated everytime edits are made. Thanks

I need a Tableau project that visualizes an organizational hierarchy. Requirements: - Create a comprehensive 'top office' table that includes the Manager, Supervisor, and CIO roles, detailing their responsibilities. - Design a three-level structure where the top office can see under their Supervisor and Manager, while the Supervisor and Manager can see under their employee ID and Name. - Ensure that the Supervisor and Manager are also recognized as employees under the top office. - All employees should see who their direct boss is. Ideal Skills: - Proficient in Tableau with prior experience in creating hierarchical visualizations. - Strong attention to detail to ensure accurate representation of the organizational structure. - Ability to understand and represent complex respon...

I'm looking for an experienced Full-Stack Developer with a strong background in .NET technologies (both .NET Core and .NET Framework) for my web application project. This project will involve working with Azure, Data Factory, Azure Service Bus, and microservices. Key Requirements: - Deep understanding and practical experience with .NET Core and .NET Framework - Proficient in full-stack development, with a clear focus on web application development - Familiarity with Azure services, Data Factory, and Azure Service Bus - Experience with microservices architecture - Skills in Angular for front-end development Ideal Skills: - Full-Stack Development - .NET Technologies - Azure Services - Microservices Architecture - Angular Please provide examples of similar projects you've complet...

I'm seeking a professional who can help design a structured questionnaire consisting of 16 multiple-choice questions, with one correct answer per question. Key Requirements: - Each question should be presented on a separate page, enhancing user focus and engagement. - Users should navigate through the questionnaire using both 'Next' and 'Previous' buttons, allowing for flexible pacing. Ideal Skills: - Experience with questionnaire design and user interface (UI) principles - Proficiency in relevant software/tools - Ability to deliver a seamless and interactive user experience. Description of the Excel Attachment: - The text in BLACK are the questions - The text in RED are the possible answers on that particular page - The text in GREEN is a bar that shows the per...

DotNet Tester required to test and create videos explaining existing errors DotNet Tester required to test and create videos explaining existing errors in '. Website Address - User emailid- userany444@gmail.c Password- kaspersky Basic functionalities of explained in below link- The work given to previous developer explained in below link videos- Sample video links explaining errors in developer's done-work is below-

I need assistance with manual data entry into an SQL database. The project involves working with database entries, so experience with SQL and data handling is essential. Ideal Skills: - Proficient in SQL - Manual data entry experience - Attention to detail - Data handling skills - Able to work independently and meet deadlines

I need a knowledgeable individual to spend a few hours guiding me on how to create a real-time data dashboard using Grafana with data from an InfluxDB database. Key Focus Areas: - Crafting queries to extract the necessary data from InfluxDB - Formatting the dashboard panels to display this data - Understanding the process of publishing the dashboard to the internet I'm particularly interested in visualizing the data as both graphs and tables. Ideal candidates for this project should have extensive experience with Grafana, InfluxDB and real-time data visualization, with the ability to explain complex concepts in a simple and understandable way.

We are seeking a versatile Data Analyst to support multiple companies across different industries. The ideal candidate will excel in transforming raw data into actionable insights using various visualization tools and will be adept at managing and querying databases.

We have 2 SQL databases. A source database and a target database that have completely different structures (tables, field names/types and relations). We're doing some migration planning from source to target and need some consulting advice on how to best map tables and fields for ETL migration. We are looking for a solution that uses AI and/or ML to avoid doing this all manually the schema mapping. Please put "SCHEMA123" at the start of your proposal so we can filter out automated responses. Please list any details of your experience in doing a project like this. Thanks!

I'm looking for a seasoned professional with advanced knowledge in SQL database architecture. The primary task will be designing a new database. Ideal Skills and Experience: - Extensive experience with SQL - Proven track record in database design - Ability to understand and meet project-specific requirements - Strong problem-solving skills - Excellent attention to detail

I'm looking for an experienced SQL Server professional to set up log shipping for disaster recovery purposes. This will primarily involve transactional data, and log backups need to be taken and shipped every 5 minutes. Ideal skills and experience: - Extensive knowledge of SQL Server - Proven experience with log shipping - Strong understanding of disaster recovery strategies - Familiarity with handling transactional data - Ability to set up frequent log backups (every 5 minutes)

I'm in need of a skilled freelancer with extensive experience in Zoho CRM and database management to synchronize our Zoho CRM with our database. Key Responsibilities: 1. Data Update & Cleanup: - Align our CRM with the database by adding missing fields, such as 'Subscription', 'Rating'. - Identify and clean duplicate and dead records, i.e. blocked email addresses. 2. Database Synchronization: - Develop a Python script for fetching data from our database and updating or adding records in Zoho CRM. - Ensure the script is capable of handling incremental updates and can operate on a set schedule. 3. Documentation & Automation: - Create clear and concise documentation detailing the cleanup and synchronization processes. - Automate the sync ...

We are migrating data from our current ERP system (that is stored in an SQL database) to Microsoft Dynamics Business Central Cloud. The source database structures is different than Business Central. We have been able to reverse engineer both the databases and create ERD models and DDL scripts. Also we know how to create Dynamics APIs and use AL to interact with Dynamics. We are looking some consulting advice on how best migrate the data into dynamics. For example looking for ideas how to best table and field match, what software tools to use, best proccess etc for this ETL project. Please describe any experience you have with ETL/migrating data between different systems. Please add the word DYMANICS123 to the start of your proposal so we can weed out automated responses. Thanks!

I am in need of a professional who can assist in registering my already established business and setting up a comprehensive database for global news distribution. Key Responsibilities: - Register my business with relevant authorities. - Create a database that caters for news distribution, both in the USA and globally. Ideal Skills: - Experience with business registration processes. - Proficiency in various types of databases, including SQL-based, NoSQL-based, and Cloud-based. - Prior involvement in setting up a news distribution system.

we need a Data architect with following requirements for 2-3 months assignment( 1 position ) Required Skills & Experience Required Profile 7+ years of experience on Database warehouse / lake house programming Experience in implementing at least 2 end-to-end data warehouse / data lake projects Experience in implementing at least 1 Azure Data warehouse / lake house project end-to-end Converted business requirements to concept / technical specification Worked along with source system experts in finalizing ETL and analytics design Support data modeler developer in design and development of ETLs Creation of activity plan as per the agreed concept with timelines Technical Expertise: Strong experience with Microsoft Azure components, including Azure Data Factory, Azure Synapse, Azure SQL Da...

I need to migrate my MS Access data to NuBuilder Forte. The specific data types to be migrated include customer data and sales records. The new system should be accessible from both desktop and mobile platforms. In addition to the migration, I require the implementation of reporting tools that are not currently present in my MS Access application. Ideal skills for this project include: - Extensive experience with MS Access and NuBuilder Forte - Proficiency in data migration - Ability to implement additional functionalities - Experience in developing platforms compatible with both desktop and mobile - Expertise in creating reporting tools.

I'm seeking an experienced C# developer with strong expertise in IIS, concurrency, ASP.NET MVC, C#, and the Entity Framework. The ideal candidate should have a deep understanding of LINQ query generation and be able to optimize a specific method for reducing execution time. Key Details: - The method in question is working with relational database data, specifically on SQL Server. - The primary goal is to reduce the execution time of this method. - You will be required to assess the load via concurrent requests. Additional Notes: - This is a remote job. No code sharing will occur. Therefore, you must be comfortable working via a remote connection and using any necessary tool. - The task is a quick fix and shouldn't take more than an hour. Please don't overquote, as I will p...

I'm looking for a programmer with high knowledge of SQL, Access, and ChatGPT to automate our document management processes using n8n. This involves organizing all of our company's documentation into folders automatically based on labels. Key Requirements: - Proficient in n8n for process automation - High level of expertise in SQL and Access - Familiarity with ChatGPT for potential integration - Experience in document management systems - Capable of creating a system for organizing documents by department (Sales and Marketing, HR and Administration, IT and Operations)

I have an existing ERP system utilizing MS SQL as the database engine and Microsoft Access as the frontend. We're looking to transition this to a web application built on ASP.NET. This will be a phased migration, implementing functionalities from the old frontend to the new one step by step. The first task in this migration is to rebuild the picking system, which is responsible for preparing orders from the warehouse. The current picking system includes: - Inventory Management: Keeping track of stock levels and warehouse layout. - Barcode Scanning: Utilizing barcodes for tracking items and improving efficiency. In terms of user authentication, we prefer a standard Username and Password system for the new application. As for user roles and permissions, we will require: - Custom Rol...

I am looking for an expert in Elastic Search or TypeSense to improve the search functionality within my database. The primary goal of this project is to enhance the way we search through our database records. Key Requirements: - Deep knowledge and experience with Elastic Search or TypeSense. - Proven track record of improving search functionality within databases. - Ability to understand and work with database records. - Strong problem-solving skills and attention to detail. Ideal Skills: - Elastic Search - TypeSense - SQL - Database Management - Search Functionality Improvement Your expertise will play a key role in making our database search more efficient and effective. Looking forward to your insightful proposals.

Hello, I am seeking a skilled freelancer to assist with the repair and import of a corrupted SQL Server file. Here's the situation: I accidentally deleted both the MDF and BAK files from our disk, and unfortunately, the file structure cannot be recreated. Using a hexadecimal editor, I managed to locate four MDF files, but I am uncertain which one contains the correct data. After some repairs, I believe one file might have the data I need. My primary interest is in recovering data from a specific period, which I couldn't retrieve using automated repair methods. Due to the size of the file, I require you to work directly on our system remotely.

I'm seeking a skilled SQL developer with a deep understanding of manufacturing business logic, specifically in production scheduling within the chip industry. Your role will involve: - Assisting in the creation of a production scheduling system aimed at optimizing resource usage, primarily raw materials and machinery. - Providing guidance based on your knowledge of the chip manufacturing business. Ideal candidates will have substantial experience in SQL development and a strong background in the manufacturing sector, particularly with chip production. Your expertise will be pivotal in enhancing the efficiency of our operations.

I'm looking for a proficient freelancer who can convert a PDF containing text only into a neatly organized Excel file. The main purpose of this conversion is for data manipulation, so the data will need to be structured in a way that facilitates this. Ideal skills for this job include: - Proficiency in Excel - Experience with data manipulation - Attention to detail The data should be organized in a single sheet. Freelancers with experience in similar projects would be preferred.

I'm in need of a Power BI dashboard designed specifically for monitoring operational efficiency, with a focus on resource utilization. The dashboard needs to connect to a SQL database for data retrieval and analysis. Key Requirements: - Design a Power BI dashboard tailored for operational efficiency monitoring - Focus on tracking resource utilization metrics - Connect and retrieve data from a SQL database Ideal Skills and Experience: - Proficient in Power BI - Experience in designing operational efficiency dashboards - Familiarity with SQL database Please provide examples of similar projects you've completed, along with your proposed timeline for delivering this dashboard.

I'm in need of a seasoned SQL DBA to help with my MySQL database. The primary focus will be on optimizing the database for efficient queries, ensuring top-notch security measures are in place, and overseeing data backup and restoration processes. Ideal Skills: - Extensive experience with MySQL - Strong understanding of database optimization techniques - Expertise in database security protocols - Proficiency in data backup and restoration procedures - Excellent skills in query optimization

I'm looking for an expert in Microsoft Access who can create a tailored database for managing customer information. The primary focus of this database is capturing and organizing individual customer contact details and their service history. Key Requirements: - Create a user-friendly Microsoft Access database - Capture individual customer contact details - Track and manage customer service history Skills & Experience: - Proficient in Microsoft Access - Experienced in database design and development - Knowledge in customer information management systems - Attention to detail and strong organizational skills

I need a professional data analyst to extract monthly inventory data from SAP into a refreshable Excel sheet. Key Requirements: - Pull stock levels and pricing data from SAP - Create an Excel sheet that can be easily refreshed with new data each month Ideal Skills and Experience: - Proficiency in SAP - Advanced Excel skills - Previous experience with inventory data extraction - Strong attention to detail

I'm in need of a database. Specifics have not been finalized, and I'm open to suggestions. Your expertise in the field will be invaluable in determining the best approach. Skills and Experience Required: - Proficient in various database management systems (DBMS) - Strong understanding of both relational (SQL) and NoSQL databases - Experience in creating databases for diverse applications - Excellent problem-solving skills to determine optimal database structure - Able to communicate complex technical concepts in simple terms

We are seeking a talented Full-Stack Developer to design and implement a standalone flashcard system. The system will be built in isolation and later integrated into our existing application. The ideal candidate is a self-starter with expertise in modern web development technologies, passionate about building intuitive and scalable solutions. Key Responsibilities Frontend Development: Develop a responsive, user-friendly interface using plain React without additional UI frameworks. Implement features like card creation, editing, and study modes with a focus on usability and accessibility. Backend Development: Design and build a robust backend using Prisma for database management and tRPC for efficient API communication. Ensure the backend supports all CRUD operations and is scalable for fu...

Customized Form in PHP with Secure SQL Database including online deployment We are seeking to develop a aesthetically pleasing, and secure web-based form integrated with a SQL database. This form will facilitate and receive applications for a monthly token draw for 10,000 lucky users, each winning 1,000 tokens(Max application per month 1 Million). Selection of winners will be taken care separately and is not part of the project. The project requirements are as follows: User Authentication and Entry Implement Telegram API integration for user login, ensuring unique entries. Display the current draw month prominently after login, e.g. Heading, " Draw for the month of January 2025." Prevent multiple entries: Check if the user has already submitted an entry for the current mont...

I'm in need of a professional with expertise in Oracle ERP and ZATCA integration, specifically for e-invoicing. The integration should focus on the following key elements: - Incorporating ZATCA's e-invoicing functionalities into Oracle ERP. - Ensuring that e-invoices include critical data elements such as the invoice date and amount. The ideal candidate for this project should have: - Proven experience with Oracle ERP. - In-depth knowledge of ZATCA's e-invoicing requirements. - Strong skills in system integration and data management. I look forward to your proposals.

I need a seasoned Python developer who can modify an existing script for me. The script currently updates a MySQL database and needs to be changed to update a Microsoft SQL Server (MSSQL) database instead. The challenge is that the column names in these two databases are different, so the freelancer will need to implement data transformation as part of this task. Key Requirements: - Update the database connection in the script to point to an MSSQL server - Implement necessary data transformations to accommodate different column names - Ensure that the script can handle potential errors during the data transfer process - fix one or 2 existing updating error Ideal Skills: - Proficiency in Python - Strong understanding of MySQL and MSSQL - Experience with data transformation and error handl...

I'm looking for an expert in Zatca integration with Oracle, specifically tailored towards automatic invoice generation triggered by payment receipts. Key components of the project include: - Developing a seamless integration with Zatca to ensure compliance and proper handling of invoices. - Creating a system within Oracle that automatically generates invoices upon receipt of payment. Ideal candidates for this project should have: - Extensive experience with Oracle and Zatca integration. - A strong understanding of invoice generation systems. - Excellent problem-solving skills to ensure seamless system synchronization and data exchange.

I'm currently facing connection errors with my Scylla database and need expert help. Key Responsibilities: - Troubleshoot and resolve configuration problems - Help with accessing the Scylla server - Ensure optimal connection settings to prevent future issues Ideal Skills and Experience: - Extensive experience with Scylla database - Proficiency in database configuration and troubleshooting - Strong understanding of server access protocols - Excellent problem-solving skills

1. Introduction SOLUTION NEEDED IS MVP 1.1 General Project Description The project aims to develop advanced software for an AI-powered self-service kiosk designed for outdoor environments. It is optimized for challenging conditions such as ambient noise and direct sunlight. This kiosk enables seamless and personalized customer interaction via voice commands or a touchscreen, ensuring an efficient and optimized shopping experience. Technologies to be used change with the developer skillset. Operational Conditions: Every interaction (proposals, promotions, etc.) must include a Yes/No confirmation message. Responses must be immediate. Offline performance is required. Text descriptions of the BOT's speech should be displayed on-screen. Clear visualization of UI components. The shopping...