Migrate sql server mysql data jobs
...issues as they arise, ensuring timely resolution. Stay up-to-date with emerging technologies and trends in software development. Qualifications: 2- 5 years of experience in full stack development, with a strong portfolio showcasing past projects. Proficiency in programming languages such as JavaScript, Python, HTML/CSS, and SQL. Extensive experience with frameworks and libraries such as React, Angular, Node.js, Flask, Django, etc. Strong understanding of databases and data modeling concepts. Demonstrated expertise in AI and ML, including experience with frameworks like TensorFlow, PyTorch, or scikit-learn. Excellent collaboration and communication skills, with the ability to work effectively in a team environment. Proven track record of reliability and commitment to meet...
I'm in need of a SQL engineer with specialization in query optimization and extensive knowledge of MySQL. The project will involve fine tuning basic single-table queries for better performance in MySQL database. Ideal skills and experience include: - Expertise in MySQL database management - Proficiency in SQL query optimization - Ability to troubleshoot and debug errors Your responsibility would be to collaboratively review the existing database structure, and optimize the SQL queries in order to improve the performance, reduce the run time and the load on the server. This task requires clear understanding of SQL code, MySQL database design principles and industry best-practices. With your technical expertise, I'm ...
We are looking to have a simple staff dashboard created that will be expanded as time goes on. This can be in either NextJS or PHP and will use a MySQL database. It doesn't need extensive design work as it's just an internal dashboard, it however should be responsive/mobile ready and a basic layout of a left menu with the various selectable modules and right column for the page content/display is suitable. There is no complicated or extensive work needed for this initial phase. It's primarily a login/authentication with few database tables that need the contents listed, editable and searchable. Future phases will have more indepth functionality and a customer facing dashboard. We are looking for someone experienced that works quickly, provides secure and well ...
I urgently require an adept professional who is experienced in configuring SSL on WHM servers. I am currently operating an Alma Linux server with Cpanel but can't access Cpanel as the SSL cert date is incorrect I need Let's Encrypt SSL set up *correctly* so all domains auto renew (as it has always been in the past) Therefore, I need a sharp and prompt freelancer specialised in the following: - Linux server maintenance and administration. - Efficient in managing WHM servers. - Solid experience and knowledge in SSL certificate procurement and installation. Particularly, Let’s Encrypt would be preferred. - Ability to ensure that all the websites are SSL secure following the correct installation. Candidates with prompt responses and proven track records in sim...
I am seeking a proficient PHP programmer for the addition of functions to an existing script. The ideal candidate will have expertise in: - PHP programming - Front-end development (HTML, Javascript) - Back-end development - Database integration (SQL) The main purpose of this project is to build upon and enhance our pre-existing system. Your role will be essential in introducing new functionalities to improve our script. Please only apply if you have extensive experience in these areas. I look forward to potentially working together.
...Agile, JIRA • Design Data warehouse table and applicable documentation. • Develop table creation scripts and execute the scripts for the Database Administrator (DBA). • Analyze data sources and determine data relationships to pair with the business requirements documentation (BRD). • Familiarity with data quality issues and Exact, Transform, Load (ETL) processes • Design and develop Extract Load Transform (ELT) process and load data from source tables into staging tables and then into target fact and dimension tables utilizing Oracle Data Integrator (ODI). • Validate data loaded into various tables utilizing Structured Query Language (SQL) and other analysis. • Knowledge and understanding of the a...
I'm on the lookout for an adept .NET developer with a strong background in jQuery and SQL server. The end goal is to construct an efficient hospitality software. This is an urgent position, ideally located in Nagpur. Primary Requirements: - System development using .NET and jQuery. - Thorough understanding of SQL server operation. Key Features: - Capable of handling billing and invoicing. - Inventory management capability. Ideal candidates would have considerable experience managing comparable projects and deriving software solutions in the hospitality industry. Proven proficiency in .NET, jQuery, and SQL server is crucial to this role. Your proficiency will be key in delivering a quality solution that aligns with our objectives.
I'm on the hunt for a proficient fullstack Developer who specializes in PHP, Codeigniter, and MySQL. This knowledge should be complimented by a solid background in SaaS-based product development, preferably relating to an Educational ERP. Primarily, the developer should be able to: - Expertly handle PHP, Codeigniter, and MySQL - Seamlessly manage user roles and privileges - Easily handle subscription billing - Effectively integrate multiple APIs Skills and Experience: - Proven experience as a fullstack developer in SaaS-based product development - Substantial experience in PHP, Codeigniter, MySQL - Knowledge in Subscription billing & feature integration - Expertise in API Integration - Understanding of Educational ERP will be an advantage Ideal candidates...
I'm in need of an expert PHP developer to craft a complex data query. The project revolves around extracting specific columns from multiple tables (User data tables, Transaction data tables, Customers data tables and Suppliers data table) into a single query. Key Requirements: - Expertise in PHP - Strong experience with SQL and database interactions Brief: I have created four tables named users, customers and suppliers and transactions. In users I have column named uid, name, email, mobile. Here users register themselves for login purpose. In customers table I have column named id, uid, name, mobile, email (here uid is the uid of user who is adding customers and name, mobile, email are the customer’s details). In suppliers table...
I'm in need of an expert PHP developer to craft a complex data query. The project revolves around extracting specific columns from multiple tables (User data tables, Transaction data tables, Customers data tables and Suppliers data table) into a single query. Key Requirements: - Expertise in PHP - Strong experience with SQL and database interactions Brief: I have created four tables named users, customers and suppliers and transactions. In users I have column named uid, name, email, mobile. Here users register themselves for login purpose. In customers table I have column named id, uid, name, mobile, email (here uid is the uid of user who is adding customers and name, mobile, email are the customer’s details). In suppliers table...
This project requires a skilled AWS migration specialist to transition our PHP/MySQL web application from its current hosting on a T2 instance to a T3 instance on Amazon Web Services. The data and files involved in this migration are relatively modest, totaling less than 1GB and fewer than 10,000 files. Clear communication and attention to detail are essential for this project. I've observed that some freelancers do not thoroughly read requirements or respond to ads without fully understanding them; therefore, I have included two questions in this job post. To be considered for this role, please answer both questions at the BEGINNING of your reply to this ad. Key Tasks: Plan and implement the migration process efficiently. Ensure the security, reliability, and perform...
...issue with my essential Module for Ultimate POS system; a persistent server error 505 that I need help resolving. I'm seeking a skilled professional who can help look into and rectify this problem as quickly as possible. Key Responsibilities: - Diagnose the root cause of the server error 505 in Ultimate POS - Develop and implement a solution to fix the error - Ensure that the solution works effectively without causing any further issues - Should have collection of all module for ultimate pos-- N U L L Ideal Skills and Experience: - Proven record of dealing with server errors, specifically error 505 - Prior experience with Ultimate POS -- essential module and repair module will be an advantage - Sound understanding of server logs interpretation - Str...
...text AS order_total BUT ONLY WHEN = 'ot_total' and i also need AS shipping_method BUT ONLY WHEN = 'ot_shipping' my strategy below failed as it seems i can only use the condition in the normal WHERE clause near the bottom i.e WHERE o.orders_status = s.orders_status_id AND s.language_id = '1' AND = 'ot_total' however this means will return data for the ot_total class but i want it for the ot_shipping class im simply trying to add 2 conditions 1. return AS order_total for the = 'ot_total' 2. return AS shipping_method for the = 'ot_shipping' i dont want for = 'ot_total' so help me ? is this not possible or do i have to execute a completely sepearate query?? that seems a waste of code
In need of a specialist in PHP and MySQL to build a robust web application. The main functionality would be to create, update, and delete tables, with strong emphasis on create/add data. Ideal Skills and Experience: - Proficient in PHP and MySQL. - Familiarity with CRUD operations. - Experience with data validation. - Knowledge in user authentication. Functionalities Required: - Table creation. - Updating existing tables. - Deletion of tables. CRUD Priorities: - Strong orientation towards create/add data functions.
...facing frequent crashes and high CPU usage with my WordPress eCommerce website which is impacting my business negatively. It's unclear whether any recent updates or changes to the server configuration might be contributing to the issue. To mitigate these problems, I need a skilled professional with robust experience with Plesk, nginx and PHP 8.2, who understands the complexities of high-traffic websites. In-depth knowledge of WordPress and specifically with Easy Digital Downloads (which has been customized on my site) is crucial for a successful fix. Required expertise: - Plesk web host management - nginx web server environment - PHP 8.2 - WordPress, including troubleshooting and problem-solving Your task will be to investigate the issues, identify the cause of t...
... This will allow me to adjust the temperature of my cold room from anywhere using a mobile app, even if I am not near my cold room. - Energy Consumption Monitoring: Also, the system should have an energy consumption monitoring feature. This will allow me to more effectively monitor and manage the energy usage of my heating and cooling systems. This project should be connected to a web server with mysql and controlled via computer, it should have its own application for ios and android. special electronic board design will be required for the project The ideal freelancer for this job will have significant experience in designing and implementing industrial automation systems, a solid understanding of climate control systems and strong skills in energy management techno...
I need an experienced Clickfunnels specialist to migrate a landing page from WordPress to Clickfunnels. The landing page in question can be found here: This project specifically involves the transferal of: - Text content - Images In your bid please tell me your favorite color.
I'm in need of an expert to construct SQL statements that will retrieve specific data from a database. I have an SQL Server with multiple databases, with existing SQL query that looks similar to Select * from union all Select * from union all Select * from The select command is a lot more advanced than a simple Select *, but I need to be able to easily extend and included more databases, without having to cut, copy, paste, then perform a find and replace of the database tables. If i was to write in DOS, it would be something like for each %i in ( Database1, Database2, Database 3){ select * from % union all } but just not sure the best way to do this in SQL, and looking quick assistance. thanks
...functionality. Mastery of Python: Vital for backend development, utilizing frameworks such as Django or Flask, to develop a robust and scalable application. Database Management Skills: Knowledge of MySQL, PostgreSQL, or MongoDB for secure and efficient data management. UI/UX Design Acumen: A keen eye for intuitive and attractive interface design to captivate and retain users. API Development Experience: For seamless integration with external services like social media for live draws and secure payment systems. - Web Security Expertise: Understanding best practices and technologies to protect user data and transactions. - Multilingual Support Capabilities: To cater to a global audience, necessitating specific development and localization skills. Our company has alrea...
...Skills: - Proficiency in Kotlin and Android application development - Prior experience with the implementation of geofencing functionality in mobile applications - Comprehensive understanding of location-based services. - Familiarity with different geofencing libraries would be a plus, as I might require guidance on library selection. The admin will create geofence and the geofence will be saved in MySQL database over the API, there are some employee in this system. When the employee will visit the certain places then a API will be call with 2 parameters 1. the employee primary id, 2. geofence primary id. The admin will be able to edit and delete the geofence also. I will provide you all the necessary API. Looking forward to working with a forward-thinking developer who can ...
I'm looking to set up a new AWS server for my business. Currently, my website, email, and database are running on my old GoDaddy server. The size of my website and the amount of data in my database is large, more than 50GB. Key tasks involved: - Setting up a new AWS server - Migrating all data, inclusive of Website, Email, and Database from GoDaddy to AWS - Ensuring the smooth and efficient transfer of data with no data loss Ideal Skills: - Proven expertise in AWS server setup and data migration - Proficient in handling and migrating large data (More than 10GB) - Detailed knowledge about securing the server and its data Please note that the preferred AWS region hasn't been decided yet, so the...
I'm seeking a creative, innovative, and detail-oriented graphic designer who can help to breathe new life into my server's branding. The project involves modernizing the main logo, icon, and banner for my server. Key tasks include: - Remaking the main logo: The logo is pivotal and thus, it needs to be visually appealing yet simple enough to be recognized immediately. - Redesigning the icon: This has to align with the style of the main logo but be distinct enough to stand out in various contexts. - Updating the banner: It also has to be in sync with the revamped logo and icon to hold a cohesive image. I prefer a minimalistic design approach to this, so the designer should have a strong grasp on how to communicate complex ideas through simple design. The ideal freelan...
I'm in need of a technically proficient freelancer who can set up a VPS server for me. The operating system is to be determined - I'm open to professional suggestions regarding the optimal choice based on my project needs. Key Responsibilities: - Setting up a VPS server with an OS recommendation from the freelancer - Linking my existing domain to the set up VPS server - Assisting in hosting a personal blog on the newly setup server Ideal freelancer will possess: - Solid experience in VPS server setup (preferably with both Linux and Windows OS) - Skills in domain linking - Experience in web hosting, specifically with personal blogs. I look forward to partnering with a tech-savvy, communication driven freelancer on this project.
...intuitive and user-friendly interface for data visualization and analysis. Requirements: Proven experience in developing web applications and analytics tools. Strong proficiency in front-end and back-end technologies (JavaScript, React, Node.js, Python, etc.). Experience with database management and data processing (SQL/NoSQL, Big Data technologies). Knowledge of cloud platforms (AWS, Azure, Google Cloud) for hosting and scaling the application. Familiarity with data privacy laws and best practices in data security. Excellent problem-solving skills and ability to work independently. Responsibilities: Collaborate with our team to define the MVP scope and feature set. Design and develop the front-end and back-end architecture of the platform. ...
I need a Simple Project in Flutter (MVC), to show to a list of of records from SQL Db (Name, age, date, etc), when clicked show the same in a detailed view. Add a sort button to sort by Name, age, date. I have PHP APIs to retch records. Enable Mobile, Windows outputs. In mobile, show the Tabview under Details Pane. After project is done, you should help me to deploy it in my hosting through Anydesk. Thats all.
I have an umbraco project 7.5 which I am trying to launch but the visual studio is giving some errors . i need help debugging and make the project run
I have an Azure server. Hyper-V is working. I am making nested VM's using Ubuntu. I can't get the nested VM's to connect to the Internet. Probably a quick fix for an expert Freelancer
I need someone who has experience in: - backend development using python - able to write unit tests - AWS experience - AWS lambda and API gateway experience - Jenkins - Gitbash/ GitHub - Postman - sonarqube - SQL- AuroraPostgres
I am looking for a seasoned MySQL admin to setup a Master-Slave replication on my database system. This job will entail considerable experience and remarkable expertise in this specialized field. Due to sensitivity of data, I need person who can setup Master-slave in front of me using Key Responsibilities: - Setting up Master-Slave replication on my database, therefore, direct experience with this specific setup is required. - Attend to any subsequent adjustment and debugging that might be needed after setup. Qualifications: - Deep understanding of the MySQL as my system is operating on MariaDB/MySQL - Extensive knowledge and experience in setting up Master-Slave replication - Proven experience in MySQL administration, particularly in replication se...
I have flutter app possibly written in SDK 2.10.5. Works at Android and iOS (approved in stores) You must rewrite it to newwest version. It is time tracking app. Uses push messages, geolocation plugin, working at background, etc. 1) Create new project in current Flutter version 2) Rewrite all code to new version (I will deliver old source code) 3) Use current updated plugins if needed 4) Deliver me apk for tests 5) Deliver me iOS version for test 6) Deliver me source code + instruction how to install Flutter environment at my local computer 7) If all works, I will release payment. Max budget is 1000$ Please bid, I will share you source code.
I'm in need of a WordPress expert who can assist me in migrating my blog from one server to another. Given my requirements, you will need: - Expert proficiency in WordPress Although I didn't specify the sizes of the files and databases or my level of access to both servers, your flexibility to deal with diverse scenarios will be greatly valued. At this point, there's no specific timeline that you need to worry about. However, once we agree to work together, we will discuss a reasonable deadline. Please, only bid if you have sufficient experience in these areas and are comfortable working within undefined parameters. I look forward to collaborating with you. Skills/Experience Required: - WordPress expertise - Blog migration experience - Flexibility and problem-so...
Error website wordpress : Warning: mysqli_query(): (HY000/3): Error writing file '/tmp/#sql/fd=257' (Errcode: 28 "No space left on device") in /home/ on line 2349
...the website. The service provider should be proficient in transferring existing content, yet bringing in a refreshing perspective to our new template (Kudus Child) In summary, the essentials needed for this redesign are: - Aesthetic sensitivity and experience in website design, particularly marketing websites - Skill in creating a cohesive and intuitive user experience - Ability to efficiently migrate all existing content to the new design - Proficiency in incorporating an 'About Us' section, detailed services/products, and testimonial sections - Proven track record of creating websites that resonate with the target audience and are SEO-optimized. Your proposal should include samples of past work in a similar vein, showing how your design and aesthetic skills have h...
...Resource to join our team onsite in Delhi NCR. The ideal candidate should have 5-6 years of solid experience in .NET development, focusing on building robust APIs using .NET Core. Requirements: 1. Experience: 5-6 years of .NET development experience. 2. Skills: Proficiency in .NET Core, API design, and development. 3. Technologies: Familiarity with RESTful APIs, JSON, Entity Framework Core, and SQL databases. 4. Location: Candidates must be available to work onsite in Delhi NCR. Responsibilities: 1. Design, develop, and maintain APIs using .NET Core. 2. Collaborate with cross-functional teams. 3. Participate in code reviews and debugging. 4. Ensure code quality, performance, and security. Duration: Long-term, Full-time Location: Delhi NCR, India (Onsite) How to Apply: Intere...
...long time to load (over one minute) where the same page using the SAME API endpoint to access data from the same DB in loads in a few seconds. If you are awarded the task we expect you to accept IMMEDIATELY and if the project is not accepted immediatly we will award it to another developer. This task should be delivered in 1 day and if it is successfully completed we would like to keep the developer long term with 20-40 hours a week working on converting our angular.js to (we have already converted 50-60% to ). Details of our current project STACK can be seen here -> 1) Improve loading time for 1 of our webapp pages and remove a few bugs 2) Transform/migrate our current angular.js to (we have already transfered about 60-70% to ) Prerequisites:
...long time to load (over one minute) where the same page using the SAME API endpoint to access data from the same DB in loads in a few seconds. If you are awarded the task we expect you to accept IMMEDIATELY and if the project is not accepted immediatly we will award it to another developer. This task should be delivered in 1 day and if it is successfully completed we would like to keep the developer long term with 20-40 hours a week working on converting our angular.js to (we have already converted 50-60% to ). Details of our current project STACK can be seen here -> 1) Improve loading time for 1 of our webapp pages and remove a few bugs 2) Transform/migrate our current angular.js to (we have already transfered about 60-70% to ) Prerequisites:
I am seeking a proficient full stack developer with expertise in HTML, CSS, PHP, JavaScript and SQL to support the continued development of our existing application. Our platform supports the software procurement process, by helping our users to identify the right solution based on their specific needs. I'd like interested freelancers to showcase past work with your bid. This will help me gauge your experience and quality of work. Please ensure that these projects align with the requirements outlined above. Your proficiency in PHP/SQL is a must, and experience in creating interactive UI/UX for e-commerce platforms would put you at a distinct advantage. As would experience with WordPress, AWS, API and integration development. I'm looking for someone based in or ...
Hello, I am urgently looking for an AWS veteran who is expert in the below items 1) AWS and AWS Amplified Experience 2) Migrate AWS account services to other AWS account "Freelancers only" Thank you.
I require assistance in generating a complex report from multiple data sources within a custom application. The report necessitates retrieving and aggregating information from various tables using SQL queries. It must pull and consolidate pertinent records from a range of interconnected database assets while preserving data integrity. Specifically, the report will need to extract salient fields like identifiers, values, and timestamps from several intricately related operational stores. It should then compile and organize the extracted segments to provide a holistic view of core business operations over a specified timeframe. The constituent pieces must be intelligently linked and cross-referenced to offer meaningful insights. The underlying database schema may be intr...
...normalization of my MySQL database. This database is primarily used for storing patient information, managing tables. Your tasks would include: - Analyzing the current structure of the database. - Implementing needed changes to reduce redundancy and ensure data integrity. - Documenting the normalization process for future reference. Due to the sensitivity of this data, it is crucial that you have in-depth knowledge of MySQL and the principles of database design, especially normalization techniques. Experience in health databases would be of added advantage since the database is used for patient. Please note that the size of the MySQL database was not specified, so you need to be comfortable and experienced with handling databases of varying sizes....
I'm looking for a freelancer who's great at web scraping to help with a project involving two specific websites initially, with potential for more. I'll give you the specific data fields to extract. It'd be great if you: Are really good at web scraping and or Python. Know your way around MS SQL Server databases, not essential but definately an advantage. Understand how to extract data effectively. Understand the need for security and captcha integration if needed. Can work quickly since this project is a priority and needs to be done ASAP. Ultimately, I want to be able to manage the code with your ongoing help, so this could lead to a long-term partnership. I'll share the full details when needed. You will provide source code,...
...potential areas for optimization. Implement improvements to increase the website's loading speed. Optimize database queries to enhance overall performance. Collaborate with the team to implement new features and enhancements. Test and debug code to ensure system stability and reliability. Requirements: Proven experience with Laravel and a deep understanding of its core concepts. In-depth knowledge of MySQL or other relational database management systems. Demonstrated ability to optimize website performance, with specific experience in speeding up Laravel projects. Excellent problem-solving and analytical skills. Good communication and ability to work effectively in a team. Attention to detail and commitment to quality work. If you are a passionate Laravel expert, eager to t...
5 years of overall IT experience with more than 3+ years of experience in Data Engineering related technologies. Must have understanding Python / Scala / Java and related commonly used packages specially with GCP. Hands on experience on Data migration and data processing on the Google Cloud stack, specifically: Big Query Cloud Dataflow Cloud DataProc Cloud Storage Cloud DataPrep Cloud PubSub Cloud Composer & Airflow Experience designing and deploying large scale distributed data processing systems with few technologies such as PostgreSQL or equivalent databases, SQL, Hadoop, Spark, Tableau Hands on Experience with Python-Json nested data operation. Exposure or Knowledge of API design, REST including versioning, isolation, and micro-services. P...
I am looking for a server optimization expert who possesses the skills and has proven experience in the following areas: - Database Optimization - Network Optimization - Website Caching The project needs to be completed as soon as possible while noting with importance that: - The server resources are quite limited. This aspect requires astute resource management without compromising other tasks. - The optimization effort should not interfere with the compatibility of existing software installed on the server. - Data security considerations are critical - tasks need to be accomplished without compromising the integrity and security of data stored within the server. On-board freelancers need to have an impressive track record working with complex...
...need a programmer who is proficient in Node.js and SQL to support a data segmentation project. Scope of work: - You will be connecting to BigQuery using Node.js - You will fetch the schema of the dataset/tables - the dimensions, fields will be stored in a datastore - you will create a service that allows querying bigquery with optimized SQL given that the user creates segment rules Ideal Skills: • Node.js - You should have extensive experience in this language as this will be the primary tool for the project. • SQL - You should be an experienced SQL coder because you will be writing queries for segmentation. • BigQuery - You must have previous experience with BigQuery for data access and management. • Data Anal...
I am looking to hire a proficient .net core who can help in archiving the below tasks. _**Grouping uploaded data and set calculation on the groups to get results. Logic implementation for the application functionality. - **Real-time data updates:** One crucial feature of the Blazor server app I need is the ability to provide timely and automatic updates to users. Ideally, the freelancer should possess strong knowledge and experience in .net core, Blazor server apps, API development, and real-time updates. In-depth understanding of user interfaces, data schema, and UIX would be of added advantage. Due to the complexity of this project, I'm particularly interested in freelancers who can devote sufficient time and demonstrate a record of deliverin...
***Custom Cover letter Accepted Only*** I need a Senior .Net Software Developer with Angular experience to join our cross-functional team to develop and scale HR, Tax, and compliance software platforms. This role offers a collaborative environment for growth, w...customers. Responsibilities: - Maintain and enhance existing solutions for optimal performance and availability. - Design and deploy innovative, scalable solutions. - Collaborate with team members in an Agile (SCRUM) environment. Requirements: - Bachelor’s in Computer Science or related field. - 4+ years in software development, with expertise in .NET and C#. - Proficiency in Angular (v8+), SQL Server, web services (SOAP, REST, JSON), HTML, CSS, and JavaScript. - Experience with API development and integrati...
