SQL Jobs

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

I'm in need of a comprehensive business owner database specifically in Tamilnadu, Chennai. The database should include detailed information of business owners Contact number, Email ID from various industries like GST Filling Database, Distributors, Industries, Dealership and more

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

I'm in need of an Oracle expert with extensive knowledge in Exadata infrastructure. Coming into this project without any experience in the field, I am eagerly searching for someone who can guide me and transfer their knowledge, so I can gain a deeper understanding. - SKILLS REQUIRED: Extensive experience in Oracle Exadata Infrastructure, excellent communication skills, teaching/mentoring experience would be a bonus. - EXPECTED OUTCOMES: Teaching me the technicalities of Oracle Exadata Infrastructure, and making me feel at ease with managing and understanding this field. Specific topics to be covered would be discussed in further detail with the chosen freelancer. Ideally, these would cover resource management, operational tasks and data warehousing, but I am open to learning abou...

I'm seeking an experienced Google Script specialist to automate tasks and manage data for my project. Here are the specifics: Automating tasks: Your main responsibility will be to automate data import/export processes using Google Script. I need to take the data attahed to a daily email in excel format, upload this data (and historic) to a data base and then allow to consult that data from different spreadsheet in google with a query. Ideal skills and experience include: - Proficiency in Google Scripts and automation - Experience in data management - Google spreadsheet analisis reports If you have the needed expertise, I'm excited to work with you!

I'm in need of a skilled .NET developer to create a functional web application that mainly handles user registration, login, and database management. Key Requirements: - User Registration and Login: The application should have a robust system for users to sign up, log in, and manage their accounts securely. - Database Management: Proficient database management within the application is a must. This includes data storage, retrieval, and manipulation. Additional Information: - External Integrations: There is a possibility that additional integrations may be required in the future. Experience with integrating external systems and APIs would be beneficial. - User Roles and Permissions: The application may need to support multiple user roles and permissions. While this is currently marke...

I'm looking for a skilled MS Access developer to create a billing and accounting database with a modern, minimalist interface. Key Requirements: - Customizable Reporting: The system should be able to generate a variety of reports on different aspects of the business, such as sales, expenses, and profit margins. These reports should be adaptable for future needs and allow for different levels of detail. - Integration with Existing Systems: The database will need to interact seamlessly with other existing systems and software used by the company, ensuring data consistency and accuracy. - User Permissions and Access Control: The system should have a robust user management system that allows for different access levels and permissions. This will ensure that sensitive financial informatio...

Hi I will share the details with the shortlisted candidates. Thanks

We are currently facing an urgent requirement for the implementation of Oracle SCM/demand planning modules. We are in search of SCP experts or IT consultancy partner companies with proven experience in SCM/demand planning module implementation in Oracle EBS R12. The scope of work will cover the following aspects within Oracle SCM EB R12: Predictive Analysis based on MRP Demand forecasting for peak and off seasons Demand Sensing Multi-Dimensional Analysis: Analyze demand by product, customer, region, channel, and other relevant dimensions for deeper insights and better decision-making Supply chain integration Forecast accuracy tracking Reporting and Analytics

Abstract: This white paper presents the concept of a secure iPhone application designed to assist users in organizing their financial life. The application allows users to allocate a specific amount of money, which is then distributed on a daily basis. The application charges a 4% fee for facilitating these transactions. This white paper provides an in-depth understanding of the application's architecture, functionality, and its potential impact on the community. It also highlights the importance of security measures to protect user data and ensure the integrity of financial transactions. 1. Introduction: The purpose of this white paper is to introduce a secure iPhone application that aims to empower users in managing their financial life. By providing a platform for organizing a...

Arabic & English marketplace e-commerce on both website and mobile Strengths: Clear identification of technologies used (Widgets, JavaScript frameworks, Font scripts, Miscellaneous, Web servers, Programming languages, CDN, Maps, Development, Live chat, JavaScript libraries, UI frameworks). Potential use of Module Federation (50% sure) and Webpack (50% sure). Areas for Improvement: Technology Modernization: Consider upgrading libraries (jQuery, jQuery UI, Modernizr, Slick) to their latest versions or exploring modern alternatives (React, Angular, Vue.js) for better performance and maintainability. Component-Based Architecture: Refactor code into reusable components for improved maintainability and scalability, especially with React or Angular. Performance Optimization: Implement code...

I'm looking for a proficient SQL professional with notable expertise in SQL Server 2019. Key tasks will involve: - Query optimization - Database design - Data migration The ideal candidate should have a solid understanding of SQL Server tools and a proven track record in handling similar projects. Your previous experience and knowledge of SQL Server 2019 will be pivotal in this role. Your task will be primarily centered around maximizing the efficiency and effectiveness of the SQL Server. Preference will be given to professionals with certifications in SQL Server 2019 or related fields. Solid written and verbal communication skills are desirable.

Cerchiamo un developer fullstack per training on the job per lo sviluppo di una web application MERN con Node.js e React, possibilmente Typescript, Vite, Redux, per 3D. Conoscenza per lo store da definire preferibilemnte in Mongo o MySQL con Mongose o Sequelizer. Gestione autenticazione, ' Italia o in italiano fluente.

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

I have a need for a comprehensive listing of Oracle EBS customers within the manufacturing sector in USA. This is a sizable task as it requires the creation of a list featuring more than 500 companies. In the details you collect for each organization, I'd like to see the following: - Company Name - Contact Person Name - Contact Person Email. The ideal candidate for this task would be someone who is proficient in data mining and possesses broad knowledge of Oracle EBS customers in the manufacturing, retail, automotive industry. Prior experience in CRM database creation would be an added advantage. It's essential that all information gathered adheres to privacy and data protection laws, ensuring a legally compliant list. So, a freelancer with a keen understanding of these laws...

I'm looking for an expert with exceptional Sequel database administration skills on a Windows environment. Your main task will be to handle executing regular exports from our Sequel Database to Excel, performing updates in Excel, and subsequently updating the Sequel Database with the altered data. Skills and Tasks; - Mastery in handling Sequel Database on Windows - Familiarity with Data Modeling and Design - Proficiency in exporting and updating database information via Excel - Being responsive and flexible as the frequency of this task may change. Initially, I will need it done daily for a week. Afterwards, it will be an as-needed basis for remote support. Experience in Performance monitoring, tuning, and database backup would be a bonus. The role demands strong organizational sk...

I've devised a dummy website primary for understanding log analysis which is a major concern in today's advanced technology world. To test its vulnerabilities, I require a well-rounded professional equipped with proficiency in PHP and Node.js. - Focus Area: Your tasks will encompass SQL injection techniques over my website's user login systems, data retrieving systems, and contact forms. - Skill Set: An experience with SQL injection tests is crucial. Knowledge of web technologies such as PHP and Node.js is essential. Understanding of website log analysis will also be advantageous. Your comprehensive reports on the performed tests and findings will enhance the robustness of my website and will aid in my understanding of the log analysis for future development and troubles...

I'm looking for an experienced SQL Developer with a strong background in MS SQL and data warehousing. You'll be responsible for designing and optimizing a new database system. The project involves working with Microsoft SQL Server Analysis Services in an Azure SQL environment. Key Responsibilities: - Designing a new database system - Optimizing queries for better performance - Utilizing Microsoft SQL Server Analysis Services - Ideal Candidate: - Strong experience in database design and optimization - Proficiency in SQL, specifically with Microsoft SQL Server - Familiarity with data warehousing concepts - Experience with Microsoft SQL Server Analysis Services - Experience working in an Azure SQL environment - Expert coding skills in SQL coding - E,perince in Data warehouse lik...

I require a proficient database administrator to import large XML file dumps (3gb, 20gb, and potentially larger sizes) into a MySQL database. The purpose of this task is database migration. The task will involve: - Handling entire data of moderately complex XML files, including several nested tags. - Ensuring the conversion captures all data comprehensively and accurately for smooth database operation. Ideal Skills and Experience: - Strong proficiency in MySQL and XML - Robust experience with database migration - Background in handling complex file structures - Demonstrated ability to manage large datasets.

I'm in need of an experienced PostgreSQL Database Administrator to assist with a few key tasks. - Connecting to Database: I need assistance in establishing a connection to the database. This is a crucial task that requires a skilled professional who can set up the necessary configurations and ensure seamless communication between the database and applications. Your expertise in PostgreSQL is paramount, especially having worked with different versions (9.6, 10, 11,16). A deep understanding of database management and connectivity is essential, as well as experience in working with Windows as the operating system of the database. I need remotely to connect to database. Locally its working. is not properly set.

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

I urgently need to create manual backups for my Remote Microsoft SQL Server database using VB.Net. This project requires an experienced VB.Net developer who has in-depth knowledge of SQL database operations, particularly in the area of Remote backup and recovery. The right candidate should be proficient in: - VB.Net programming - Microsoft SQL Server database management The timeline is of utmost importance as we need this running as soon as possible. Please provide evidence of comparable projects you've completed. Looking forward to a reliable and efficient solution.

My MySQL server is facing issues like high CPU usage and slow queries due to an incorrect configuration. I need a professional who can help me optimize my MySQL server by fixing the file and optimizing all bad queries to reduce the high CPU usage and improve the query speed. Key Responsibilities: - Review and modify the file to optimize the server configuration - Identify and optimize all bad queries to improve query speed - Reduce high CPU usage by fine-tuning the server - Provide a detailed report on the changes made and their impact Access: - You will be provided with AnyDesk access to the server for optimization. Ideal Skills and Experience: - Proven experience in MySQL server optimization - Strong knowledge of query optimization techniques - Familiarity with the file and server ...

My MySQL server is facing issues like high CPU usage and slow queries due to an incorrect configuration. I need a professional who can help me optimize my MySQL server by fixing the file and optimizing all bad queries to reduce the high CPU usage and improve the query speed. Key Responsibilities: - Review and modify the file to optimize the server configuration - Identify and optimize all bad queries to improve query speed - Reduce high CPU usage by fine-tuning the server - Provide a detailed report on the changes made and their impact Access: - You will be provided with AnyDesk access to the server for optimization. Ideal Skills and Experience: - Proven experience in MySQL server optimization - Strong knowledge of query optimization techniques - Familiarity with the file and server ...

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

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

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

Somos una empresa de desarrollo de Software de producto propio () y estamos buscando perfiles para reforzar de manera remota nuestra capacidad de desarrollo. 1. PERFILES BUSCADOS: En este momento estamos interesados en perfiles JAVA2EE con experiencia demostrada y excluyente en: a- Trabajo en equipo colaborativo, español nativo. b - JAVA2EE con experiencia superior a 2 años c- Conocimientos en programación Java Swing d- Experiencia en programación previa demostrable de al menos 1 año en programas de gestión tipo ERP, SGA, POS, CRM, facturación, contabilidad, etc. e- Entorno de trabajo sobre GITHUB, JIRA, ECLIPSE f- Conocimientos de programación SQL sólidos 2.- CERT...