Sql server etl jobs
We are looking for an experienced freelance web developer to build a dynamic and interactive online learning platform. The application will include special functions that can interact with a SQL database to extract questions, solutions and other data. ### Key Features to Implement The following will be main functions that the application will need: - The ability to display a maths multiple quiz to students. Students will then complete the quiz and submit to be automatically marked by the application. Then, the solutions will be displayed to the student for them to read - A backend admin account that is able to add and edit math questions in these quizzes. This will include images and latex code (rich text editor). The admin account will also be able to edit users - The ability t...
Wordpress / Pretix / Debian server PLEASE READ THIS JOB POST BEFORE BIDDING! I had a freelancer setup a wordpress site and also a installation of pretix. This site is currently running directly from its IP address as the domain name is in use with a live site whilst this is built behind the scenes. They have setup wordpress on port 81 and pretix on port 80. Currently pretix isn’t working it just throwing up a 500 error. Firstly is it possible to run them both from port 80? If so I need that to be done. Secondly I need pretix to work, this site isn’t currently live so I’m happy for just a fresh working installation of pretix if that’s what it takes. Finally I know very little about Debian, I need an FTP user account setting up for myself with full read/w...
We've coded our own Websocket server in python3 which is over 700 lines and it works really well. Its job is to accept and verify clients through our mysql database, accept and respond to Websocket messages and so on. Each client is considered a new thread so it won't "block" execution for other clients. The problem is that the threads are not reused nor closed when the client disconnects. Instead, all of the threads are stacking up and this is very bad resource-wise. (Although we use thread pooling) All we need is a professional python3 engineer to fix the stacking threads problem without changing anything else in the program. It works fine but it eats resources like crazy. Meanwhile, due to the nature of our project, the engineer who we'll pick, will wo...
...understanding of stock levels, turnover rates, and restocking needs. - Customer analytics to track buying habits, preferences, and loyalty, allowing for personalized marketing and sales strategies. **Ideal Skills and Experience:** - Proficient in WordPress and WooCommerce development. - Experienced in creating custom plugins with inventory and sales functionality. - Proficient in PHP, JavaScript, and SQL database management. - Strong understanding of eCommerce analytics and the ability to implement these in user-friendly dashboards. - Knowledge in creating secure, scalable, and efficient code that integrates seamlessly with existing systems. This plugin is essential for optimizing our inventory management and sales processes, requiring a developer with a proven track recor...
I'm seeking a skilled SQL developer who can assist with query optimization and database administration tasks. The ideal candidate would have: - Proven experience in database design and performance optimization - Proficiency in both MySQL and SQL Server systems Main responsibilities will include: - Optimizing the performance of SQL queries - Administering database operations If you've worked on similar projects and have the required skills, do not hesitate to bid. I'm looking forward to a successful collaboration.
I have a database with 24 tables in a bak file . I need to extra in excel all the 24 tables
...experienced freelancer to assist in deploying a React and Node.js project on my server. The project is already developed, but I need help with the deployment process to ensure it runs smoothly. **Requirements:** - Deep understanding of server environments - Proficient in deploying Node.js applications, specifically using the latest Node.js version - Experience in deploying React applications - Ability to work without the need for setting up environment variables, as this has been taken care of - Excellent problem-solving skills to address any deployment challenges **Ideal Skills and Experience:** - Prior experience with Server deployment - Strong knowledge of Node.js and React frameworks - Familiarity with server management and deployment protocols - Abil...
In this project, I am seeking help with my Microsoft Access .mdb visual basic database. Key Tasks: - Separate the database into a front-end and back-end - Modify existing tables and fields - Set up new tables along with ...and dependencies that need to be taken into consideration when modifying or building tables. Previous experience working with Microsoft Access databases specifically will be highly advantageous. Additionally, good problem-solving skills and attention to detail are needed to understand the relationships or dependencies among the current tables. This project does not require SQL understanding, hence if you are less SQL wise but stronger in VB, that is perfectly fine. I value your expertise and look forward to achieving improved database functionality with...
we are looking for a senior PHP developer with a minimum of 16-20 years of experience Skills and Experience MUST HAVE: - 16-20+ years of PHP development experience. - Proficient in Laravel framework. - Experience SQL Injection prevention/fixing - Finding and Securing any loop holes in the system - implementing new features , for enhancement of the platform, - making sure all pages are secured - must be an independent developer, not an agency! - must be able to work on github - lastly making sure platform is mobile responsive Must have experience in social media or multi-user platform, chat system, ecommerce platform Must be knowleadble in updating designs as well when needed.
I'm seeking a skilled freelancer to help with setup of App Server Notifications in the App Store Connect for our Flutter-based mobile app. Main requirement is to configure Apple Subscriptions, ensuring our existing server in Google Cloud communicates effectively with Apple's platform to manage subscription (new purchases, cancels, renewals, promotions, intro offers etc.) events seamlessly. **Key Responsibilities:** - Implement and test the setup for App Server Notifications related to Apple Subscriptions on our existing server in Google Cloud. This includes handling subscription purchases, renewals, expirations, cancellations, promotions and Introductory offer events. - Explain the process to our team, so any future basic maintenance can be handled as...
I need an adept JavaScript coder capable of handling SQL server and Google Sheets tasks. You'll be developing a script that performs the following functionalities: Task Descriptions: - Populate Google Sheets with data fetched directly from a SQL server. - Retrieve data from Google Sheets and update the SQL server respectively. - Execute these tasks in real-time. Ideal Candidate: - Proficient in JavaScript - Familiar with Google Sheets and SQL Server integration - Has experience interfacing databases directly - Knowledgeable in real-time data processing setups. Your understanding of real-time data manipulation and strong JavaScript and SQL skills will equip you to undertake this task well. A good understanding of Google ...
...Python, JavaScript, or Swift for mobile app development. - Experience with React Native or Flutter for cross-platform development. - Knowledge of natural language processing (NLP) and machine learning (ML) concepts. - Familiarity with AR development tools (ARKit, ARCore). - Creative puzzle design skills and understanding of game design principles. - Database management expertise (SQL or NoSQL). - Strong collaboration skills for effective teamwork. 4. Security Measures: - Implement robust security measures to safeguard user data and ensure privacy. - Prioritize data protection throughout the development process. 5. Effective Communication: - Strong communication skills for seamless collaboration within the development team. - Ability to lead and coo...
We are seeking 15-20 + years of experienced CORE PHP, Laravel developer. **Requirements:** - **Strong Proficiency in Laravel/ core php:** . - **Experience in fixing SQL Injections and security of php files: ** Demonstrable experience in fixing SQL injections and making sure the website is hack-proof - **Experience in Project Upgrades: ** Demonstrable experience in upgrading existing projects, making them more efficient, and integrating new functionalities seamlessly. **Ideal Skills and Experience:** - In-depth knowledge of PHP and Laravel framework. - Proficient in problem-solving and debugging. - Experience in performance tuning. - Ability to handle feature development from conceptualization to deployment. - Strong communication skills in ENGLISH - MUST be available...
...with a SQL database (either MySQL or PostgreSQL) for robust data management. **Key Features:** - **User Authentication:** The system must authenticate users efficiently to grant or deny access based on RFID tags. - **Database Integration:** Seamless integration with a SQL database is crucial. This will involve storing and retrieving access logs, user information, and access credentials. - **Single RFID Reader Support:** The software should be designed to work with a single RFID reader. However, it must be built with high reliability to manage access control smoothly. **Ideal Skills and Experience:** - Proficiency in Python, with a strong portfolio showcasing relevant projects. - Experience with RFID technology, specifically in developing access control systems. - In-dept...
I'm seeking a dedicated IT professional to configure a virtual active directory with two servers utilizing Microsoft 365 technology. The selected candidate should be proficient in: - User and group management in Azure and Microsoft 365 - Implementing virtualization in SQL Server and IIS - Utilizing SQL Server Integration Services and Power BI On-Premises Data Gateway - Creating and managing an active directory Additionally, the ideal freelancer should know how to deploy a directory that meets basic security requirements. Proven experience in creating and maintaining secure directories is a must. This is a critical project, and we are looking for experienced freelancers who can provide solutions with quick turnarounds. Enclosed the reference to the expect...
...processing to ensure a more efficient, seamless operation. This project requires precision and a deep understanding of both SAP B1 and e-commerce platforms to create a reliable, automated system for handling orders. **Ideal Skills and Experience:** - Proven experience with SAP Business One integration projects. - Strong understanding of e-commerce platforms - Expertise in Service Layer - Knowledge of SQL and HANA query writing - Ability to design and implement seamless data flow between SAP B1 and the e-commerce platform to ensure real-time order processing. - Proficiency in programming languages or tools typically used for SAP B1 integrations. - Excellent problem-solving skills and the ability to foresee potential challenges in the integration process. **Project Requirements:*...
I'm seeking an experienced IT professional to configure a Proxmox server using a Windows operating system. The tasks include: - Setting up the server for various functions - to act as a virtualization host, a storage unit, and a network services provider. - Customizing the configuration to meet the requisites of running 1-5 virtual machines. The ideal candidate must possess a strong familiarity with Proxmox software and a deeper understanding of virtual machine operations. Proficiency with Windows OS is a must. Experience in network services provision will be advantageous.
I'm currently facing some issues with my Express server and I'm in need of a Node expert to solve them. The selected candidate will be assigned with the following tasks: - Express server setup and configuration. - Database integration. - API development. - Correcting routing issues, specifically incorrect routing paths on the server. Ideal candidates will have prior experience in server configurations, API development and database integrations. Proficiency in troubleshooting and solving routing issues is essential. I need these problems fixed as soon as possible, hence experience and efficiency in Node is key to this project.
implement a vector store in AWS, best no SQL, DynamoDB or Open Source DB, handling at least 10,000 embeddings, for fast answering queries sent from a aws lambda python script. we need code, integration/setup and walkthrough. the leanest architecture possible, no need for bedrock or sagemaker,
Looking for an SQL expert to fix an issue am having while doing restore of db. This is a very simple work for someone that is knowledgeable on this sort of work
...translate natural language queries into SQL commands, specifically tailored for Oracle databases. The objective is to simplify database interactions for users who lack SQL expertise, enabling them to execute complex data retrieval tasks through simple language prompts. This conversion process involves sophisticated language understanding algorithms to ensure accurate interpretation of user intents into precise database queries. To complement this functionality, the project will also develop a web interface using the MERN stack—MongoDB for the database, and Node.js for the backend, and React for the frontend. This interface is designed to be intuitive, allowing users to input queries in natural language and receive immediate feedback in the form of SQL transl...
A while back my wordpress websites were hacked Some files got renamed every few hours. I had put a cron to rename the files automatically but after trying to fix it, something went worse. I would like for someone to secure my site and fix the wordpress site. You will be given ssh access
...The app, originally created by a beginner, currently facilitates the fetching and management of product category descriptions from an e-commerce platform's API. The project's goal is to expand this application with additional functionalities and turn it into an intuitive, web-based SaaS platform. Key functionalities of the existing application: Login settings module for the e-commerce platform. SQL database management system for storing category information. Feature to download category data (name, ID, meta tags) and save it as CSV/XLSX files, with filtering options (e.g., categories with/without descriptions). Module for loading CSV/XLSX files for preview and sending data back to the e-commerce platform via API. Advanced AI module utilizing OpenAI to generate new cat...
...which might include surveys, web scrapes, databases, and more. The goal is to refine and cleanse this data for further analysis and usage in a data-driven project I'm working on. **Requirements:** - Experience in data cleaning, particularly with mixed datasets (text and numeric). - Proficiency in data processing tools and programming languages suitable for data cleaning tasks (e.g., Python, R, SQL). - Ability to identify and correct errors, inconsistencies, and redundancies in the data. - Strong understanding of techniques for dealing with missing or incomplete data. - Excellent problem-solving skills and attention to detail. **Ideal Skills:** - Familiarity with data scraping and database management is a plus. - Experience working with large datasets and conducting preli...
...simultaneously. Ideal Candidate Skills: - **Web Development Expertise**: Proficiency in front-end and back-end web development. Experience with languages and frameworks suitable for dynamic website creation (e.g., HTML, CSS, JavaScript, PHP, Ruby on Rails, or Django). - **Database Management**: Strong skills in database design and management, especially with separate hosting solutions. Familiarity with SQL or NoSQL databases is preferred. - **UI/UX Design**: Ability to create an intuitive and engaging user interface that provides an excellent user experience for a diverse audience. - **SEO and Performance Optimization**: Knowledge in optimizing website performance for quick loading times and implementing SEO best practices to increase visibility. By integrating these elements s...
...seamless database integration - Develop and integrate APIs for mobile app communication - Reskinning for the Flutter template - Upload to google and Apple store Ideal Experience: - Proven track record with Flutter and Laravel projects - Deep understanding of RESTful API conventions - Experience in OAuth and JWT for secure authentication - Ability to write clean, maintainable code - Familiarity with SQL databases The Project Scope: - Collaborate to refine a specified Flutter template - Implement backend solutions tailored to the template's features - Test thoroughly to ensure reliability and performance I'm excited to see your approach and how your skills can drive my project’s success. Please include examples of similar projects you've worked on, particu...
...afternoon. Just stay where you are, where you are comfortable, and get paid for your creativity and hard work. You will need: a computer of course (Windows, OS X, Linux - whatever you like) Internet connection your favorite editor or IDE Requirements: creative thinking problem solving / analytical skills fluent in English (read, write, speak) very good knowledge of PHP HTML / CSS Javascript / Ajax SQL (MySQL, PostrgeSQL) ability to work independently and with a team ability to demonstrate at least one working application written in PHP We offer: competitive compensation flexible working hours work from your own desk set your own working schedule Before contacting us you should have at least a general idea of what we do. Therefore you should complete the following steps:...
I'm seeking an experienced Java developer to craft an unforgettable private server for a classic MMORPG—RuneScape. This server will be a haven for both hardcore PvP combat enthusiasts and players who revel in PvE, skilling, and intricate economies. With an estimated player base of 100-500 users, the server needs to be robust, engaging, and endlessly entertaining. **Features I Need:** - Integration of **PvP Combat**: A dynamic and fair PvP combat system that keeps players on their toes. - **PvE Elements**: Engaging PvE content that offers challenges and rewards to solo players and groups. - **Skilling and Economy**: A balanced skilling system and a player-driven economy that mirrors the complexity and engagement of the original game. **Ideal Skills and Expe...
...our team and contribute significantly to the improvement of our existing project. With an emphasis on elevating performance, squashing bugs, and introducing new features, the successful candidate will play a key role in steering our project towards excellence. **Requirements:** - **Strong Proficiency in Laravel/ core php:** . - **Experience in fixing SQL Injections and security of php files:** Demonstrable experience in fixing SQL injections and making sure the website is hack-proof - **Experience in Project Upgrades:** Demonstrable experience in upgrading existing projects, making them more efficient, and integrating new functionalities seamlessly. **Scope of Work:** **Ideal Skills and Experience:** - In-depth knowledge of PHP and Laravel framework. - Proficient ...
...kind of expertise I am seeking: **Scope of Research:** - My primary focus is on conducting comprehensive research within three critical areas: technology trends, market analysis, and competitor analysis. The outcome of this research is pivotal for updating our database accurately and strategically. **Database Context:** - Contrary to a typical reliance on robust database systems like MySQL or SQL Server, my project utilizes Excel. This unconventional choice stems from specific project requirements and convenience for stakeholders involved. **Data Status:** - The data currently residing within our Excel database is raw and unrefined. It requires extensive cleaning and organizing to make it usable for our objectives. This involves not only structuring the data effectively...
Devops person with skills set of windows azure powershell, Ansible scripting, .net framework, up dating dependencies, server migration gitlab Jenkins, SSO installation.
Devops person with skills set of windows azure powershell, Ansible scripting, .net framework, up dating dependencies, server migration gitlab Jenkins, SSO installation.
...who can work on customizing WordPress. We use wpDATATABLE and have conncted it to our MSSQL via the endpoint function, but now we want to have full access and connect to our MSSQL directly using a tool like Please create a plugin and or a installation script that will install all the necessary prerequisites for the and to permit wp to access MS SQL and use this connection to populate wpDATATABLE We are a MVNO (Virtual mobile phone company) and our core business is selling SIMs/eSIMs to people in Brazil and people around the world that travel to Brazil as well as to Brazilians that
...conversion of scanned documents into a structured database format. This task highlights the importance of accuracy, attention to detail, and the capability to handle image data effectively. **Key Requirements:** - **Data Type Handling:** Skilled in recognizing and accurately inputting image data derived from scanned documents. - **Software Proficiency:** Familiarity with database software (e.g., SQL, Oracle) or any relevant technology that facilitates the organization of image data into a database structure. - **Attention to Detail:** Must meticulously ensure all data from scans is captured correctly, minimizing errors. - **Time Management:** Capable of adhering to project deadlines, effectively managing workloads to fulfill project requirements timely. **Ideal Skills and Exper...
I am in need of an experienced PostGIS developer, well-versed in geospatial data analysis, query optimization, and spatial database design. The main goal of this project is to des...spatial database for a specific GIS project I am currently working on. While no specific tools or software were selected, Your tasks will include: - Conducting a comprehensive geospatial data analysis - Implementing query optimization methods to enhance performance - Designing an efficient spatial database for the GIS project - help the team under the concepts of PostGIS so that they can write SQL queries using geospatial data. A proven track record in geospatial data projects and advanced knowledge of query optimization and spatial database design will be vital for successful completion of thi...
I am looking for a PHP programmer to help with various tasks for my website. The project, **-quote the word-** includes the following requirements: Email sending: - Currently, the website uses PHPMailer for sending emails from tables. - I am open to suggestions for -as first word in your answer-alternative platforms or tools, as I am not familiar with the worthiness of PHPMailer. Ideal skills and experience: - Proficiency in PHP programming. - Knowledge of different email sending -to prove you are not auto meited response- platforms and tools. - Ability to suggest and implement improvements for website functionality. Please provide examples of previous work and your proposed approach for this project.
...specializes in Ubuntu servers. My primary goal is to optimize my server for web hosting, ensuring it runs smoothly and securely. Here's what I need help with: - **Server Setup and Configuration:** Configure the server for optimal performance in hosting web applications, including Apache or Nginx setup, PHP configurations, and any other necessary software installations. - **User Management and Permissions:** Establish a secure and efficient user management system. This includes setting up different users for different tasks, assigning appropriate permissions, and ensuring that only authorized users can access certain files and directories. - **Security and Firewall Management:** Implement robust security measures to protect the server from unauthorized...
I am looking for a skilled freelancer with a passion for game development and specific experience in modding who can elevate my Wurm Unlimited server to the next level. My project involves two main components: 1. **Modding the Game**: - I need modifications to existing gameplay mechanics to enhance the player experience. This will require deep knowledge of the game's structure and the ability to implement changes that are stable and well-integrated into the existing system. 2. **Customizing Server Settings**: - The centerpiece of these customizations will be modifying the Player vs Player (PvP) settings. The objective is to create a more engaging, balanced, and competitive PvP environment. This might involve tweaking damage ratios, adjusting cooldowns, or any num...
I am seeking a highly skilled Java developer with proficiency in both SQL and NoSQL databases to work on the backend of my application. The perfect candidate will have experience handling real-time data efficiently and effectively. **Key Requirements:** - **Strong Java Skills:** You should have a solid grasp of Java programming, with the ability to write clean, efficient, and scalable code. - **Database Expertise:** Knowledge of both SQL and NoSQL databases is required. You should be comfortable designing, implementing, and managing databases that can handle complex data structures and relationships. - **Real-Time Data Handling:** The core functionality of this project involves managing and processing real-time data. Experience with web sockets or similar technologies...
More details: What specific features or functionalities do you need in your QGIS server development project? Geospatial data management, Map rendering and visualization, Web-based geoportal integration What information should successful freelancers include in their application? Detailed project proposals Do you have any specific preferences or requirements for the freelancer's past work in the field of QGIS server development?
I am looking for an experienced data scraper, capable of accessing and efficiently retrieving specific data from Businesses' website. The data to be scraped includes names, addresses, email addresses and phone ...phone numbers. Key Details: - The target businesses are businesses with a (company name). or web addresses. - The regions to be targeted in this scrape are businesses located in the United States. Qualifications: Ideal candidates should have excellent programming skills with experience in data mining, data scraping, and data analysis. Knowledge of Python, SQL, or R would also be highly beneficial to the execution of this project. Please make sure you have similar experience and your proposal also show the evidence of your similar experience.
...minimalistic design while ensuring full functionality from the ground up. With expertise in Angular 17 for the front end, .NET 8 API for the backend, and proficiency in Microsoft SQL, the ideal candidate will craft a responsive, user-friendly platform. **Key Requirements:** - **Design**: A minimalistic, yet engaging user interface that adapts flawlessly across devices. - **Frontend Development**: Implementation using Angular 17, creating a seamless experience for users. - **Backend Development**: Build a robust .NET 8 C# API backend to handle operations efficiently. - **Database Management**: Utilize Microsoft SQL for secure and scalable data storage. **Crucial Functionalities:** - **User Registration and Login**: Secure and straightforward access for users. - **Real...
I am in need of a dedicated DevOps Engineer with ...monitoring and troubleshooting. Responsibilities: - Automating and sustaining the infrastructure - Facilitating consistent integration and deployment - Proactive monitoring and troubleshooting of systems Ideally, our DevOps Engineer should have the following skills: - Proficiency in operating systems such as VMWare Tanzu, Windows Servers and Linux Servers - Experience with databases including SQL Server, MySQL, MongoDB, and REDIS - Comfortability with programming languages and environments such as Python, .NET Core, and NodeJS. This position requires a keen sense of attention to detail and the ability to adapt to changes quickly and efficiently. If you possess these qualities, then you might just be the professional we&...
...Building the backbone of our eLearning platform, ensuring robust performance and security. Proficiency in Java frameworks such as Spring Boot is a must. Experience with RESTful APIs and microservices architecture would also be highly regarded. - **Database Integration:** Implementing a scalable database solution that can efficiently manage user data, courses, and various interactions. Knowledge of SQL or NoSQL databases is essential. **Key Features to Implement:** - **User Registration and Login:** Crafting a secure and straightforward process for users to register and access their accounts. - **Course Management:** Developing a comprehensive system for creating, managing, and delivering course content. This includes facilitating multimedia resources and possibly integrating ...
...de Prestashop, por lo que hay que crear disponer de una tienda de Prestashop para hacer pruebas locales e incluir en el código la siguiente línea, que permita poder acceder a los recursos de Prestashop: include(dirname(__FILE__).'/config/'); + Para la consulta a la base de datos, no es necesario inicializar una conexión, se hará con una llamada al método Db::getInstance()->execute($sql) de Prestashop. + Consultar los parámetros del contexto para id de moneda e idioma incluyendo el contexto de Prestashop en el código, de la siguiente forma: $context = Context::getContext(); $id_lang = $context->language->id; $id_currency = $context->currency->id; + Con el resultado de las consultas anteriores, buscar en u...
I need a skilled SQL Database Manager to assist in merging my ZenCart databases. This task, which is critical for improving inventory management, requires top-notch data management skills, particularly in handling Zencart SQL databases. I have one store running on Zencart v1.5.7 with 3000 products, and I need to import/integrate around 4000 new products from another 2 databases from 2 other zencart stores that I have. Those 4000 products have different attributes that should also be integrated in the merged database.
Having been extensively engaged in Microsoft Business Intelligence (MS BI) technologies for over 8 years, we're in search of a consultant who has a strong background in Power BI and particularly in SQL Server Integration Services (SSIS,SSRS,SSAS). While expertise in other MS BI areas is appreciated, SSIS should be your main strength. Tasks will revolve around data modeling and visualization, report creation and customization, as well as data integration and ETL processes depending upon the demand of the projects on hand. Please note, however, that all the mentioned tasks are equally important in this role. Ideal candidate should: - Have proven experience with Power BI and SSIS,SSRS - Be comfortable tackling both the big picture and diving into the details - Pro...
PER ITALIANI Salve, chiedo di configurare da remoto la applicazione Windows Server 2016 in modo da poter accedere 5 utenti in RDP e RDP WEB Server virtualizzato con Windows Server già installato Licenza Winsows Server 2016 disponibile + 50 USER CAL + 50 RDP CAL
"Hello! I'm embarking on an exciting project to develop a custom in-memory database and need a talented developer to bring it to life. This involves creating Query and Index Classes to handle basic SQL-like operations and optimize data retrieval, all within a unique system we're building from the ground up. Your task will include integrating these components with our existing framework, conducting tests, and ensuring everything runs smoothly. Skills Required: Proficiency in Python Strong understanding of database concepts and in-memory storage Experience with SQL-like operations Familiarity with GitHub for version control and collaboration Ability to write clean, well-documented code I'm looking for someone who can dive deep into this project, offeri...
