SQL Jobs

Tiempo total o parcial Estoy buscando un programador de habla hispana con experiencia en AWS y GCP para un proyecto crucial que involucra la migración de mi base de datos SQL a la nube. Requisitos clave del proyecto: - Migración de Datos: Transferencia de mi base de datos SQL a un entorno de nube. - Plataformas: Utilizando principalmente AWS y GCP para esta migración. - Idioma: Dominio del español para facilitar una comunicación clara. Si tiene un historial comprobado con servicios en la nube, particularmente en migración de datos y manejo de bases de datos SQL, me encantaría saber de usted.

Descripción: “Donde salimos” va a generarle a los usuarios varias opciones de lugares posibles para salir ya sea por ranking proporcionados por los mismos usuarios, por tipo de gastronomía, música, o género del lugar. Los beneficios van a ser tanto para los usuarios como para los dueños de los bares y boliches. Por el lado de los usuarios podrán elegir la mejor opción ya sea por precio, horarios, ranking, Etc. Por el otro lado tenemos a los dueños de los bares y boliches quienes podrán promocionar sus locales y generará una competencia sana entre ellos para mejorar sus lugares y proporcionar un mejor servicio. Categoría: Programación y Tecnología Subcategoría: Programación ...

A Microsoft Access database has been specifically configured for our needs on our behalf. Now there are certain adjustments and extensions that we want to integrate step by step. Among other things, we want to redesign forms so that they visually match existing paper forms to avoid conversion errors.

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.

I'm facing some database errors with my MySQL. I suspect it may be related to security settings, as I've noticed potential SQL injection attempts. I'm in need of a Linux specialist or system administrator to diagnose this issue. Key Responsibilities: - Diagnose and troubleshoot the MySQL database errors - Review and adjust security settings as necessary - Identify any potential threats or vulnerabilities - Recommend and implement necessary solutions Ideal Skills and Experience: - Extensive experience with MySQL and Linux - Strong background in system administration - Proficient in database security and troubleshooting - Prior experience handling SQL injection issues - Excellent problem-solving skills

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

queria um site simular a este com as mesmas funcionalidades.

I'm looking for a skilled database programmer to create a stored procedure for data retrieval across five tables. This procedure should handle complex joins and maintain foreign key relationships. Key Requirements: - Design a stored procedure primarily for data retrieval. - Proficient in managing joins across multiple tables. - Understands and can maintain foreign key relationships. Ideal Skills: - Proficiency in SQL and experience with stored procedures. - Strong understanding of database management and relational databases. - Excellent problem-solving skills to handle complex data retrieval tasks.

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 need help with explore an Oracle database on my Windows 11 machine, this project will be conducted remotely for security purposes. Please note, this project will be conducted remotely for security purposes, so a reliable and secure remote connection is essential. Your understanding and expertise in these areas will ensure the successful completion of this project.

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.

Integrate Zatca to my oracle project

I need a proof of concept (PoC) on Microsoft Fabric data ingestion/engineering. The PoC should be visually represented through slides and Visio diagrams. The project involves ingesting data from Snowflake and Azure SQL Server into MS Fabric, performing transformations, and provisioning data for end users. Key Aspects to Cover: - Data Ingestion: Demonstrating how data is sourced and imported into the system. - Data Transformation: Illustrating the processes and techniques used to manipulate the data. - Data Provisioning: Showcasing how the processed data is made available to end users. Visual Elements: The proof of concept slides should include: - Data Flow Diagrams: Depicting the journey of data throughout the system. - Process Flowcharts: Outlining the sequence of processes involved in ...

I'm looking for a seasoned developer to create a simple and clean web application using C# and Blazor, integrated with an existing Azure SQL database via ASP.NET and Entity Framework. Key Requirements: - The web application should primarily handle data entry and management. - A straightforward user interface that is simple and clean. Essential Skills: - Proficiency in C#, Blazor, ASP.NET, and Entity Framework. - Experience with Azure SQL databases. - Ability to create simple and clean user interfaces. The project does not require advanced data validation or error handling, just basic validation. We have a working design (rough) to use as a design brief.