SQL Jobs

Urgent SQL Expert needed Develop, optimize, and maintain complex SQL queries to retrieve and manipulate data efficiently. Design and implement database solutions to support business applications. Collaborate with cross-functional teams to understand data requirements and propose optimal database structures. Perform database performance tuning and optimization. Ensure data integrity, security, and compliance with best practices. Troubleshoot and resolve database-related issues in a timely manner. I am looking for an SQL expert who can assist me with query optimization in SQL Server. Skills and Experience: - Strong expertise in SQL Server and query optimization techniques - Experience in database design and data migration - Ability to work under tight deadlines and deliver within 24 hour...

I am looking for a freelancer who can help me resolve an issue with installing a SQL Server certificate. I am specifically experiencing the problem of being unable to install the certificate. Error Message: The error message that I am receiving is "The certificate, asymmetric key, or private key file is not valid or does not exist; or you do not have permissions for it." Note: The "" and "" files both exist and have been used successfully before, so my hunch is that this is a possible user permissions problem on a newly installed SQL2019 instance, but it has me stuck. I can provide more details and screen prints upon request. SQL Server Version: I am using SQL Server 2019. Skills and Experience Required: - Strong knowledge and experience with SQL Ser...

Project Description: Implement forget password feature for a website - Platform: Website - Current password recovery method: Yes - Desired security measure: Send a link to user to reset password from a (work or school email) Skills and Experience: - Proficiency in web development languages such as HTML, CSS, and JavaScript - Experience with back-end development using languages like PHP or Python - Familiarity with database management systems - Understanding of user authentication and security protocols - Knowledge of email integration and verification processes

Project Title: Ruby on Rails - Social Media Integration for Existing Application We are looking for a skilled Ruby on Rails developer to integrate social media functionality into our existing application. Specific features and functionalities needed for this project include: - Social media login and registration integration - Sharing and posting to social media platforms - Social media analytics and tracking Ideal Skills and Experience: - Strong knowledge and experience in Ruby on Rails development - Expertise in integrating social media APIs and SDKs - Familiarity with OAuth and authentication protocols - Experience in working with popular social media platforms such as Facebook, Twitter, and Instagram Timeline: - The project timeline is more than 3 months, allowing for thorough i...

I am looking for a freelancer to create a database using either MS Access or Excel. I am open to either option, depending on which software is most suitable for my needs. Although I do not have a specific structure in mind, I have a general idea of how I want the database to be organized. I anticipate needing 1-3 tables in my database. The Database will contain approx 4-6 columns with the option of adding more if required The db should contain a filter and a search option (User friendly) !!! After creating the DB must be filled with already existing data, approx 300-400 pdf-pages, with approx 30-40lines per page. !!! Regarding the huge amount of data a Database an sql e.g. MS Access base would be a better choise Skills and Experience: - Proficiency in MS Access and/or Excel - Experie...

I am looking for a freelancer who can assist me with my MS SQL 2008 cursor code. I am currently experiencing unexpected results and need someone with expertise in SQL to help resolve this issue. I have a table with ~400 rows with RGB values. For each record, I want to scan the rest of the rows and find the closest RGB record using the Euclidean Distance - BUT not for the same Brand column. I started a cursor to do this but I don't want to have to execute with hard coded RGB values. Database Environment: - My database environment is local, so the freelancer should be familiar with working in a local database environment. Deadline: - I have a flexible deadline of 1 week or more for the resolution of this issue. Ideal Skills and Experience: - Strong knowledge and experience in M...

I am looking for a skilled professional to assist me with specific tasks in SQL Server. The main requirements for this project include accessing and searching a .bak file. Skills and Experience: - Strong knowledge and experience in SQL Server - Proficiency in database design, query optimization, and performance tuning - Familiarity with .bak file management Timeline: - The project does not have a specific deadline, as I am flexible with the timeline. However, I would prefer to have it completed within a month. If you have the necessary skills and experience in SQL Server and are available to work on this project within the specified timeline, please submit your proposal. Thank you.

I am looking for a skilled Metabase report and dashboard developer who is an expert in SQL queries. Data Analysis: - The project involves analyzing sales data, customer data, and website traffic data using Metabase. Dashboard Creation: - I need a dashboard created on Metabase that will display the analyzed data. Specific Metrics: - I have a list of specific metrics and KPIs that I want to track on the dashboard. Data Updates: - The dashboard should be updated with new data on a daily basis. Ideal Skills and Experience: - Proficiency in Metabase and SQL queries - Experience in creating dashboards and visualizations - Strong analytical skills to analyze and interpret data - Attention to detail to accurately represent the metrics on the dashboard.

Seeking assistance with application development of projects in both C# and VB.NET with or with out Sql server database. The ideal candidate should have experience in developing applications using these programming languages. The projects involve working with databases and may require bug fixes.

I am looking for a developer to create a web and mobile application that will primarily focus on e-commerce functionality. The application should be developed for both web and mobile platforms. Key Requirements: - User registration and login functionality - Seamless e-commerce integration - Ability to analyze and generate reports based on data collected Design: - While I do not have a design already created, I have some ideas in mind that I would like the developer to incorporate into the application. Ideal Skills and Experience: - Strong proficiency in web and mobile application development - Experience with e-commerce functionality and integration - Ability to create intuitive and user-friendly interfaces - Knowledge of data analysis and reporting techniques If you are a skilled de...

I am looking for a C# expert to help me with a Windows form GUI project. The ideal freelancer will have the following skills and experience: Functionality: - Data entry and validation - File management and manipulation - User authentication and security Aesthetic design: - Modern and minimalist - Classic and traditional - Colorful and vibrant Forms: - The number of forms needed for the Windows form GUI is yet to be determined.

We are looking for a Full-time Data Engineering Experts ( experience 5-15 years) with the following skills and experience: Skills: - Proficiency in Python - Strong knowledge of SQL - Familiarity with Big Data technologies - Snowflake experience is a plus Ideal candidate: - Has experience in building data pipelines - Can efficiently clean and process large datasets - Can create a robust data infrastructure Scope of the project: - Data cleaning and processing

I am in need of a SQL developer who can assist me with query optimization tasks on a SQL Server database. The ideal candidate should have experience in optimizing SQL queries for improved performance. Specific requirements for the project: - Experience in SQL Server database platform - Strong knowledge of query optimization techniques - Ability to analyze and identify performance bottlenecks - Proficiency in writing efficient SQL queries - Familiarity with indexing strategies and query execution plans The deadline for this project is less than a week, so the candidate should be able to work efficiently and deliver results within the given timeframe.

I am looking for a skilled SQL developer to create a script that will mark certain items as picked up in my database. Here are the details of the project: Specific Condition for Marking Items as Picked Up: - The items will be marked as picked up based on their status in the database. Script Requirements: - The script should be able to identify items with a specific status and update their corresponding field to indicate that they have been picked up. Additional Requirements: - There is no need for the script to mark items as not picked up based on any conditions. - The preferred programming language for the SQL script is SQL Server. Ideal Skills and Experience: - Strong proficiency in SQL Server and database management. - Experience in writing SQL scripts to update database records bas...

HI guys one source code is used in that video file attached please see the video carefully and please create that darlene pro source code for me.....I am looking for a freelancer who has experience with Oracle and can assist with padding the file. Specific Version of Oracle: Oracle 11g, Oracle 12c, or Oracle 19c. Purpose of Padding: The main goal is to enhance security. Deadline: There is no specific deadline for this task. Ideal Skills and Experience: - Strong knowledge of Oracle database systems, specifically the chosen version (11g, 12c, or 19c). - Experience with file manipulation and padding techniques. - Familiarity with security measures and best practices in Oracle databases. - Attention to detail and ability to follow instructions accurately. - Effective communication skil...

I am looking for a skilled freelancer who can write a database query for me using the Cypher language. The project requirements are as follows: Database Type: Graph Function: Data Manipulation Complexity Level: Advanced Skills and Experience: - Proficiency in Cypher language and Graph databases - Strong understanding of data manipulation techniques and best practices - Experience with complex query writing and optimization - Knowledge of database design and schema modeling - Attention to detail and ability to deliver high-quality work within the specified timeframe If you have the necessary skills and experience in Cypher language, please submit your proposal.

i need ios and android app there talk with my website and sql database

Oracle EPM Project Description I am seeking assistance with the Oracle EPM module for Planning and Budgeting Cloud Service (PBCS). Goals and Objectives: - I need help defining my specific goals and objectives for this Oracle EPM implementation. Timeline: - The expected timeline for this project is less than 1 month. Ideal Skills and Experience: - Strong knowledge and experience in Oracle EPM, specifically with Planning and Budgeting Cloud Service (PBCS). - Ability to assist in defining goals and objectives for the implementation. - Efficient project management skills to meet the tight timeline. If you have expertise in Oracle EPM and can help define goals while meeting a short timeline, please submit your proposal for this project.

I am looking for a skilled developer to help me connect my MS Access database to a SQL Server and ensure that any changes made in Access tables are automatically updated in the SQL DB. Multiple users should be able to change the Access tables. Skills and Experience: - Proficiency in MS Access and SQL Server - Experience with database connectivity and synchronization - Knowledge of data transformation techniques (if required)

I am looking for a freelancer who can help me fetch the queries used to deliver the report on MSSQL among 676 tables. Specific requirements for the project include: - Retrieving specific columns or fields from the queries - Focusing on all tables equally, without any particular tables or relationships - write queries on databox for visualization Ideal skills and experience for the job: - Strong knowledge and experience in MSSQL - Proficiency in writing efficient and readable queries - Ability to work with a large number of tables and retrieve specific data If you have the necessary skills and experience, please submit your proposal.

I am looking for a skilled developer to create a web-based time entry tool with a backend for our company's employees. Number of employees: 100-150 Main features required: - Time entry for specific task of specific project - Role-based login - Sync Outlook calendar - Reporting of summaries Additional requirements: - Mobile-friendly design Ideal skills and experience: - Strong proficiency in web development - Experience with time tracking and reporting systems - Familiarity with mobile-friendly and responsive design - Please provide examples of similar projects you have worked on and your proposed timeline for completion.

I am looking for a data analyst with expertise in Power BI, SQL Server, and Excel to assist me with a one-time project. The specific tasks that I need assistance with are data analysis and visualization. Ideal Skills and Experience: - Proficiency in Power BI, SQL Server, and Excel - Strong analytical and problem-solving skills - Experience in data analysis and visualization techniques - Knowledge of SQL server management and Excel data manipulation The project needs to be completed within 1 week, so the ideal candidate should be able to work efficiently and meet tight deadlines. If you have the necessary skills and experience, please reach out to me with your portfolio and relevant work samples.

Project Description: - I am looking for a skilled developer to make a small patch in my application. - The application was developed using [programming language]. - The patch is required to fix a specific bug where the function in the app is not displaying the value t. - I have access to the source code of the application. - The ideal candidate should have experience in [programming language] and be familiar with debugging and patching applications. - Attention to detail and the ability to work efficiently are essential for this project. - The patch should be implemented in a timely manner to ensure the smooth functioning of the application. - Please provide examples of previous work or relevant experience in your proposal.

I am looking for a skilled developer to create a customer information database. The main purpose of this project is to store and manage customer purchase history. The developer would enter an NDA before proceeding to access our data. On completion of the database configuration, current information will be provided for electronic import into the database. Requirements: - Experience in Web API integration - Experience in developing secure online databases - Knowledge of database management systems and best practices - Familiarity with generating reports from the database If you have the necessary skills and experience, please reach out to me with your portfolio and estimated timeline for completing the project. Thank you!

I am looking for a skilled Visual C# developer to create a data management application with medium complexity. The purpose of the application is to efficiently manage and retrieve data. Skills and Experience: - Proficiency in Visual C# programming - Strong knowledge of database technologies (SQL Server, MySQL) - Experience in designing user interfaces - Familiarity with data management tasks, including relationships between data - Ability to handle medium complexity tasks, such as data entry, retrieval, and implementing relationships between data - Understanding of transactions and concurrency in data management If you have the necessary skills and experience, please submit your proposal.

I am looking for a freelancer who can create a real-time report dashboard that displays website traffic data from MYSQL. I am open to suggestions for the preferred platform or technology to use for the dashboard. The data should be updated in real-time. Ideal skills and experience for this job include: - Proficiency in MYSQL - Experience in designing and developing real-time report dashboards - Familiarity with various dashboard platforms such as Tableau and Power BI - Strong understanding of website traffic data and analytics - Ability to suggest and implement appropriate technologies for the project Please refer your portfolio also. *On image only example, what I want is more simple.

Need customization for Acumatica ERP. If you never worked with AC DO NOT BID. Im gonna report your profile.

Years ago (Office 2013) we developed a customized Access DB which we had hired a programmer to customize with links to Outlook to sync contact information from one to the other. We upgraded to Office 2019 a few years back and need the links reestablished. We also need to have some reports repaired, and ongoing updates / maintenance provided. A confidentiality agreement will be required of the person chosen.

I am in need of a skilled database coder who has experience with MySQL. I have specific tasks in mind for this database and I require the project to be completed within a week. Skills and Experience: - Proficient in MySQL database coding - Strong understanding of database design and optimization - Experience in creating and modifying database tables, queries, and stored procedures - Knowledge of data migration and integration - Ability to troubleshoot and resolve database issues - Familiarity with security and data privacy principles in database management Tasks: - Design and implement a MySQL database based on specified requirements - Create and modify tables, queries, and stored procedures to meet project needs - Perform data migration and integration tasks as necessary - Optimize dat...

I am looking for a freelancer who can help me convert a large Excel file (more than 5MB) into an Access database. Presently the file is used as an invoicing system to generate invoices and save information. This is it's primary function. There is additional recording with each invoice showing manufacturing details. Requirements: - The data should be updated in both Excel and Access after conversion. - I need the Access database to have reporting and analysis features. -The file has a few macros which are used to generate PDF invoices and save them to a folder. -I want to ensure I can see the information and use filters in the same way as I can in excel - so we don't need a special form to display the data. Ideal skills and experience: - Strong knowledge and experience in Ex...

I am seeking a SQL query expert with experience in MySQL for assistance with an advanced level database design project. There are 4 tasks in total. You can solve them in any order. There's no option to pause. Make sure you will not be interrupted for 135 minutes. Your solution(s) should consider all possible corner cases and handle large input efficiently. If you accidentally close your browser, use the invitation link to get back to your test. Assessment and hiring policies: For testing purposes, we'd consider using copied code, code from opensource websites, Generative AI (GAI) responses, or anything but your own code, as not meeting the requirements of this test. We are hoping to see how you create your own code, and your unique approach to the challenges set. Responses tha...

I am looking for a skilled developer to create a web-based student attendance management system using Java. The project needs to be completed within a month. The system should have the following features: - Attendance tracking: The system should be able to track and record student attendance. - Report generation: It should be able to generate attendance reports for individual students or for the entire class. - Integration with student database: The system should be able to integrate with a student database, allowing for easy access to student information. -It should contain three modules:- : An admin has complete access over the entire software system. They must have valid username and password to log in to the system. The admin can view, add, delete, update student/faculty. : Like the a...

Working in an agile environment with modern headless techstack and the option to work fully remote in Europe? Here you go: As Freelance Web Developer (m/f/x), you will drive the development of our B2B shop by developing, extending and maintaining web applications with our international dev team in a thriving eCommerce environment. Note: This position is intended to be a project-based position and can be fulfilled fully remote within Europe. Software Development: Active participation in the software development life cycle by developing, extending and maintaining new features and Shopware 6 plugins for our B2B shop. Integration: Part of the responsibility will be the integration of Shopware 6 with third parties services and APIs. Stakeholder Management: Collaborate closely and effect...

We are looking for a Techno-Functional Expert for ZKT Bio Time Attendance System Techno-Functional Expert.

I have a Powerbuilder application where I need to print data from my database into an employee ID card both front and back. I need help to achieve this. I'm using Powerbuilder 12.6 and SQL Anywhere 16.

website [php} social site just add shopping system complete in it Q&Answe page Resume in profile and job section

Database for Small Business Inventory Management - Preferred Database System: Open to either SQL or NoSQL - Primary Purpose: Inventory Management - Anticipated Data Storage: Less than 1GB Skills and Experience: - Proficiency in SQL and/or NoSQL database systems - Experience in designing and implementing database solutions for inventory management - Knowledge of data storage optimization techniques for small-scale databases - Familiarity with data backup and recovery procedures - Understanding of data security measures for protecting sensitive business information Business logic description: Preparation of Shelves and Racks Labeling of Shelves and Racks: Create unique barcodes for each shelf and rack. This will allow for quick identification of the location of each item. Coding System:...

Offline Library Database I am looking for a freelancer to create an offline library database for a public library. The ideal candidate should have experience in creating databases using MySQL. Requirements: - Create a database management system using MySQL - The database should be able to hold less than 1,000 books/items - Design a user-friendly interface for easy navigation and searching within the database - Implement a system for organizing and categorizing books/items - Allow for adding, editing, and deleting book/item records - Include features for tracking book/item availability and borrowing history Skills and Experience: - Proficiency in MySQL and database management - Knowledge of library systems and book/item organization - Experience in designing user-friendly interfaces - At...

Objective: The goal of this project is to develop a robust algorithm for trading in trendy markets, enhancing the existing capabilities for identifying and capitalizing on trends. Additionally, we aim to implement a mechanism within the algorithm to intelligently detect sideways market conditions and abstain from executing trades during such periods. Components: Trend Identification: Employ advanced technical indicators such as moving averages, MACD, and ADX to accurately identify the presence and strength of market trends. Volatility Measurement: Integrate volatility indicators, such as Bollinger Bands and Average True Range, to gauge market volatility, a key factor in distinguishing trending from sideways markets. Pattern Recognition: Develop algorithms for pattern recognition to id...

Seeking an Appsheet developer to complete a simple app today. I will provide a flowchart and SQL database and some very rough wireframes. Start immediately and finish within 48hr

I am looking for a freelancer who can assist me with database design using ERD and SQL. Purpose: - The main purpose of this project is database design. Specific Entities and Relationships: - I have a detailed list of specific entities and relationships that must be included in the ERD. Scale: - The scale of the database is small, with less than 50 records. Ideal Skills and Experience: - Strong knowledge and experience in ERD and SQL - Proficiency in database design - Attention to detail in following specific requirements - Ability to handle small-scale databases efficiently

I am looking for a skilled SQL query writer who is experienced with big query. The ideal candidate should have expertise in writing complex queries. Requirements: - Proficiency in MySQL, Oracle, or SQL Server - Ability to understand and execute complex query requirements - Strong problem-solving skills to optimize query performance - Experience in working with large datasets and handling complex data structures Responsibilities: - Collaborate with our team to understand the specific query requirements - Write complex SQL queries to extract and manipulate data from our big query database - Optimize query performance for efficient data retrieval - Troubleshoot and resolve any issues related to query execution Skills and Experience: - Strong knowledge of SQL and different database systems...

Project Description: I am looking for a skilled Jira expert to help migrate our normal software project to a service desk project. This project is for an existing job on my team and our desired outcome is to have service desk functionality in place. We need this project completed within a month or 45 days. Ideal Skills and Experience: - Strong proficiency in Jira Service Desk (Data Center) and experience with Jira project migration - Knowledge of Jira service desk functionality and best practice by analysing existing software project. - Reports to show specific metrics and key performance indicators (KPIs) 
 - Collect & Analyze Customer Satisfaction. Satisfaction rates (Out of 5) - Service Level Agreements: With Location of the user & holiday info : ability to set and track SLA...

Project Description: - I am looking for a skilled developer to make a small patch in my application. - The application was developed using [programming language]. - The patch is required to fix a specific bug where the function in the app is not displaying the value t. - I have access to the source code of the application. - The ideal candidate should have experience in [programming language] and be familiar with debugging and patching applications. - Attention to detail and the ability to work efficiently are essential for this project. - The patch should be implemented in a timely manner to ensure the smooth functioning of the application. - Please provide examples of previous work or relevant experience in your proposal.

Project Title: App for a Networking App Description: I am looking for a skilled developer to create a networking app that connects local businesses with local people. The app should be available on both iOS and Android platforms. App for the Business, App for the local people and analytics dashboard. Key Requirements: - Experience in developing apps for both iOS and Android platforms - Ability to create a user-friendly interface for seamless networking experience - Strong understanding of social networking functionalities - Knowledge of professional networking features - Familiarity with event networking capabilities - Proficient in integrating location-based services for connecting local businesses with local people Timeline: The desired timeline for completing the app development is ...

Largest Excel database you most likely have seen: 1. 10 millions indivdual records with 6 fields 2. Each file represents the 50 USA States 3. Some files (States) may have 500 records 4. Some States may have 1 million records 5. Need to export each State (50) into individual (50) Excel reports 6. Evaluate each State (50) records to determine how data may be extracted into Excel 7. After evaluating the Excel Data recommend Data export options for searching ease Successful appiicant(s) will review Excel Data via a DropBox connection.

Project Title: O365 SQL DBA I am seeking assistance with database administration tasks as an O365 SQL DBA. Specifically, I need help with the following: - Database administration - Performance tuning - Backup and recovery I require this service on a regular basis and my expected timeline for this project is within 1 year. Ideal skills and experience for the job include: - Strong knowledge and experience in O365 SQL DBA - Proficiency in database administration, performance tuning, and backup and recovery - Ability to work on a regular basis and meet project deadlines

Job Title: Database Developer with Snowflake and MDM Location: HYD/Remote Duration: Full Time Required Skills: • At least 7plus years of experience in Snowflake development which includes creating Stored Procedures, Tasks, Stages, Views and Tables. • Experience working with SQL Query optimization and Cost optimization of Snowflake resources. • implement security measures to protect sensitive data such as, Role-Based Access (RBAC), Data Encryption and Data Masking. • Proficiency in building ELT/ETL pipelines with focus on Change Data Capture (CDC), History Snapshots, Audit logging and other best practices. • Working experience with any of the ETL tools such Five trans, Informatica, etc., • Perf...

We have 2 vps running on same datacenter which share local IP We have master / slave running good already on 1 server (1 master sql and 1 slave sql) We use mariadb as database system Now we want to setup 1/ 2nd VPS same with 1st vps 2/ make a group of master for 2 vps 3/ setup a connection url to 2 masters 4/ setup a connection url to all slaves node Example : tcp:// We need you to build complete 2 dockerfiles for slave and master servers Output : dockerfiles running well with docker compose We can connect to mariadb at 3306 (master) 3307 (slave) 3308 (slave) with sql tool If we write on master - slave automatic replica it we run it on our environments (all vps running ưubuntu 20.04), we share vps ssh with you and we check together too. Our budget is 75$, please dont bid if its ...

Project Title: CloudOneX Customization and Bug Fixing Description: We are seeking a skilled developer to customize and fix bugs in our CloudOneX platform. The ideal candidate should have experience in web development and be familiar with the CloudOneX system. Unfortunately we tried to communicate with the original developers on more than 1 case but support is none-existent, so we're looking for long-term developer relationship. Additional Information: - If you have experience with CloudOneX or similar cloud-based platforms, it would be highly advantageous. - We are open to suggestions for additional features or functionalities that could enhance the platform, and we are willing to discuss these further. If you are a detail-oriented developer with experience in customization and bug...