Import database sql jobs

I'm in need of an experienced SQL Server data warehouse designer to help with a project of integrating and consolidating data from different sources. Key requirements: - Expertise in SQL Server: You should be able to design, implement and optimize data warehouse solutions on SQL Server. Understanding data warehouse design principles is essential. - Data Integration: You'll need to work with some of our developers / power users to source data and establish automated integration; experience with integrating relational databases and APIs from web services is crucial. - Data Consolidation: You should be able to create a cohesive, consolidated dataset from these different sources applying appropriate design principles. - Medium-sized project: The data needing in...

...setup -> deploy our existing project to a new VPS using gitlab 2) Woocommerce -> continue long term development work on our existing custom plugin. Transfer the existing production woocommerce to this staging server. 3) ongoing long term development of our CRM app Other components of our stack which are a HUGE ADDED BENEFIT if you can work on them -> .NET ASP, WEB API + MS SQL DETAILS HERE -> PRIORITY IS TO HAVE A DEVELOPER ON OUR TEAM (LONG TERM) THAT CAN FOR NOW ALSO WORK WEEKENDS AS WE HAVE SEVERAL EMERGENCIES TO FINISH URGENTLY. Someone who can efficiently manage Linux VPS and efficiently use GITLAB is critical. Initially we need part of the hours to be worked in the first weeks from 8:00PM- 2:00am UTC -3 (Brazil Time) later you can work on

...gitlab and code in ., .NET ASP, WEB API + MS SQL. We also have woocommerce and have developed and will continue to develop plugins, so PHP and understanding of woocommerce plugins is a plus but not a necessity. Prerequisites: For the long term project the *STARTING* wage will be as stated below. 1) Accept initial hourly rate of U$5.00 2) If awarded, accept and start work IMMEDIATELY 3) Have MINIMUM OF 20+ hours a week for long term ongoing support and development. 4) Work hours: predominantly 20:00 to 02:00 (UTC -3 Brazil TIME) 5) Be available to work on weekends. Our projects use: GITLAB so you need to be proficient and be able to use our existing pipelines and also create your own. Our stack: , ag-grid, C#, .NET API, MS SQL 2017 , WooCommerce digital product s...

Hello, We are F12Design, a platform where customers and designers come together and collaborate on graphic design projects. We would like to build an interactive dashboard to make the workflow simple and effective. Here are a few things on our mind: Languages - (Please free to suggest your own) Backend - PHP, jQuery, and SQL Frontend - HTML, CSS, and JavaScript For Real-time Demo/Example - Please sign up for and check their dashboard ########################################################## Social Login/Create account (Separate customer and Designer Login) ########################################################### Customer Dashboard Order Handling -------------- Past Orders Order Requirements (Quiz* and additional comments) Order Updates Order Delivery Date Order Tracking

I want to design a car wash, and I want to import the goods from China, but I do not know what is the method, the best quality, and the method of communication. I want boxes for electric tanks that are made of carbon fiber, I want washing materials, I want water pumps, vacuum cleaners, all cleaning tools, and some other things. Ideal Skills: - Proficiency in Chinese - Experience with online dispute resolution - Strong communication skills - Understanding of international commerce and refund procedures

I'm searching for a professional who is proficient in SQL coding specifically for MySQL database design. PowerShell scripting or similar would also be beneficial. This is a basic level project taking existing Local government procedures and converting them into SQL based processes. An example of which would be creating a import procedure for traffic count data that is presented in a text format (example attached) Ideal Skills: - Experienced with MySQL Database Design - Well-versed in SQL coding - Ability to simplify complex instructions - PowerShell for anything not possible in SQL This project will demand creativity and intelligence to design procedures that simplify data entry processes. Please only bid if you can offer solut...

I am experiencing slow query processing and management issues with large ...experiencing slow query processing and management issues with large tables in my MySQL database, primarily storing transaction data. I am seeking a DBA specialist to diagnose and resolve these bottlenecks and improve the overall performance of the system. Ideal Skills and Experience: - Proven experience in MySQL database administration and optimization - Knowledge of query execution plans and optimization techniques - Proficiency in managing databases with 10-50 tables - Experience in handling databases primarily housing transaction data Tasks include: - Investigating and diagnosing slow query performance - Optimizing handling of large tables - Implementing necessary changes to enhance overall d...

...program that will retrieve an xls file from an email inbox in order to geocode the addresses present in the file via the Google Maps API and insert the geographic coordinates into an SQL table. You can follow these steps: 1. Retrieve the xls file from the mailbox - cron every hour 2. Normalize the xls file for integration into a MySQL table 3. Configure access to SQL database from JavaScript. 4. Insert data into table via SQL query 5. Retrieve addresses to be geocoded from the SQL table. 6. Use Google Maps API to geocode each address. 7. Insert the geographical coordinates (latitude and longitude) in the SQL table. Each line in the xls file corresponds to a delivery. The file has 15 columns. The column names are, in order: Shipment, Rush or...

...currently in need of a professional who can assist in completing a database for over +14000 companies. The goal of this project is to generate high-quality sales leads. Key Project Details: - You will be required to include accurate and up-to-date contact information including phone numbers and email addresses. - In addition to the contact details, each company's key contact person's name must also be included in the database. The ideal freelancer for this project will have: - Prior experience with database generation and management. - Proficiency in data mining and web scraping techniques. - Exceptional attention to detail to ensure accuracy of information. - Proven track record in generating sales leads through database creation. This project i...

I'm in need of a customizable point-of-sale software tailored for my retail store. The software should offer various features including: - Import/export functionality: The software should support the import and export of products and customer data to enhance efficiency. - Scanning and printing receipts: I need the software to allow for scanning products and printing receipts with thermal printers. - User login for separate staff: It should also have a feature to allow separate logins for different users or staff members. - Inventory management: The software should include inventory management features for tracking stock levels and products. - Customer management: I need a system that can handle customer data and history, to help with marketing and future sales. - Tax ca...

I need assistance with scraping data from a website and delivering it in an Excel file. The specifics of the project are as follows: I am looking for a person who will conduct scraping sessions for our business on a regular basis. Desired skills are knowledge of screen-scraper software, sql, Someone with Python knowledge will be better. Willing to follow instructions. Not cramped up with other jobs or other side hustles. Need to have solid internet connection. Expected work takes 5-10 hours per week, once fully trained. Must be responsible. Able to accept PayPal. - The source of the data is a website. This means the freelancer needs to have experience in web scraping. - The data should be delivered in an Excel file. Proficiency in handling and formatting data into Excel is a mu...

Data Specialist: The Data Specialist is responsible for providing information that is in databases, organizing and assembling the information so that teams can make decisions using data. Responsabilities: > Access database. > Create dashboards and analysis according to the demand of the business areas. > Update and automate dashboards that need frequent updating. > Provide suggestions of improvements in business areas. Requirements: > Mandarim is a must > SQL > Office Package > Database usage At Shein, we believe that diversity is the force that drives innovation. We are committed to creating an environment where all voices are heard, valued and respected. All our vacancies are inclusive for people with disabilities, women, black peo...

I need a skilled professional who's an expert in Azure Data Factory (ADF) development, SQL, Power BI, and ADF monitoring. Key Tasks: - Creating data pipelines - Building data transformation workflows - Integrating with SQL databases Power BI Usage: - Visualizing data through interactive dashboards - Creating data reports and analytics - Real-time monitoring and alerts ADF Monitoring: - Tracking data pipeline performance - Monitoring data integration processes - Setting up alerts and notifications for job failures. Ideal Skills and Experience: - Expertise in Azure Data Factory (ADF) development - Proficiency in SQL, Power BI, and data visualization - Strong background in monitoring ADF performance - Experience setting up real-time alerts and notifications - Pr...

I'm seeking an independent ASP.NET developer based in India with at least 5 years of experience, strong C# programming skills, and familiarity with SQL Server and Asp.net core. Your English skills will be crucial as direct communication with me is required. Key Responsibilities: - Develop a robust business management system leveraging ASP.NET - Implement user authentication and authorization features - Integrate appropriate APIs to enhance system functionality Ideal Candidate: - Minimum 5 years experience in ASP.NET development - Proficient in C# programming and SQL Server - Familiarity with Asp.net core - Experience in developing business management systems preferred - Strong communication skills for client call Please note that this project is only open to Indian-ba...

Villa Silvana Building IFC Model with BlenderBIm Export Ifc and FBX. Ifc File import in UNREAL Engine and setup location map with Cesium plagin.

Riabilia Building IFC Model with BlenderBIm Export Ifc and FBX. Ifc File import in UNREAL Engine and setup location map with Cesium plagin.

I'm looking for a Google Sheets expert to help me automate a process involving day by day data input process I'm seeking a freelancer who can streamline and automate the repetitive task of data import and export in Google Sheets. The ideal candidate should possess the following skills and experience: - Proficient in Google Sheets: You should have in-depth knowledge of Google Sheets and be able to manipulate data effectively. - Automation Skills: Experience in automating processes in Google Sheets is essential. Feel free to ask any questions, and please provide relevant examples of your past work. Thank you.

HRM Modules: This application allows representing the relationships between employees, the groups they belong to, and the training they have attended. 1. "Employee": They are characterized by: name: The employee's last name. first_name: The employee's first name. date_of_birth: The employee's date of birth. position: The position held by the employee. establishment: The establishment where the employee works. hire_date: The date the employee was hired. contract_type: The type of contract. seniority: The seniority. 2. "Group": They are characterized by: group_name: The name of the group. group_selection_criteria: The selection criteria of the group. 3. "Training": Each training is characterized by: name: The name of the training. description: A...

... The role may also involve programming. Key points: - Coaching: I need 1/1 coaching via Teams on Data Analysis & Data Visualization within Azure Analytics - Programming: If the opportunity arises, the candidate could get involved in programming using SQL - Proficiency: I consider myself at an Intermediate level with Azure Analytics Ideal Skills and Experience: - Proficient in Azure Analytics: You should have a strong understanding of Azure Analytics, specifically in Data Analysis and Data Visualization - SQL Programming: Experience with SQL is a must as you may be involved in programming for this project - Teaching or Coaching Experience: Prior experience in teaching or coaching Azure Analytics would be advantageous - Strong Communication: The ability to clear...

...Skills in database design, data security, and data lifecycle management (i.e., gathering, cleansing, publishing, archiving, back-up and recovery, and purging) for large enterprise systems. Familiarity with master data, metadata, reference data, data warehousing, database structure, business intelligence principles and processes, and technical architecture. Knowledge of database management systems, metadata management tools, cloud storage, and associated security considerations. . Combinations of experience and education will be considered on a case-by-case basis. Experience in data warehousing and governance. Practical experience in enabling data usability, availability, and efficiency. Experience in data management, quality, metadata management, and modeling. Knowl...

...involves migrating a medium-sized database (between 1GB and 10GB) to Oracle, and optimizing its performance. The database schema will also need to be designed, as this is not yet finalized. Key responsibilities include: - Migrating existing data: I need an expert who can handle this without losing any data or causing downtime. - Performance optimization: Once the data is migrated, the database needs to be optimized for speed and efficiency. - Designing the database schema: Your ability to design a schema that aligns with our business goals is critical for this project’s success. Ideal candidates should have extensive experience in Oracle database development, with a focus on data migration and performance optimization. A proven track record in ...

I'm in need of a skilled developer who i...insightful reports about warranty returns. - User access control: Improving the control measures for different user permissions within the software. - Ticket creation, Data Import and Export: Aptitude in handling these features are considered a plus. The overriding purpose of this software is to track and manage warranty returns effectively. Ideally, you should have previous experience in software creation and maintenance for tracking and managing products. The purpose of this project would be Bug fixing and improvement of the software tool already existing. Required: Experience with ER Models architecture Experience with MS SQL server 2017 express as DBMS Experience with Python 3.8.3 and Tkinter GUI toolkit Experience wi...

Setting up the quick book, import sales data, invoices and cleaning up to have ready to use

I have an Oracle database configured with WE8ISO8859P1 character set (call it DB1). The database needs to be updated to character set WE8MSWIN1252. I need to preserve the DB1 database, so I've created a new database with WE8MSWIN1252 (call it DB2). I would like someone to do this for me: 1. Export entire DB1 including data 2. Import the DB1 export into DB2 Communication and control will be done with Zoom

I am in need...Access specialist to create a straightforward database. The main aim of this project is the production of a simple database with a focus on data reporting. Key Points: - The database is intended for data reporting purposes. - There will be 1-5 different types of data entries (tables) in this database. - The final database should be equipped for generating various types of reports from the data it contains. - I am looking for a freelancer who can also document the database effectively. Ideal Skills and Experience: - Experience in designing and building Microsoft Access databases, specifically with a focus on reporting. - Strong knowledge of structuring databases for efficient reporting. - Ability to provide clear and concise docume...

You will need to visit and search for the following categories. Drainage Glazing repair Appliance repair Plumber Electrician Roofer Use the postcode W2 4DP After you have the search results You will need to open a google sheet and have the following categories Name of Business Website (you will need to find this either from checkatrade or google if you use google do not put LTD on the end) Companies house link for each business use this link The task is to complete 500 companies - please bid knowing this and only bid if you read the brief and understand it

I need an adept SQL developer proficient in crafting SQL queries for various tables within our database. The task entails generating four queries, each encompassing approximately 20 conditions that must be met. Utilizing ChatGPT, could you assist in devising these queries?

I have a PDF that is meant for email but I'm looking to convert it into HTML so that I can import it into MailChimp. The original PDF has a mixed layout with text and images. I need the resulting HTML to be mobile-friendly, professional-looking, and containing clickable links. Key requirements: - Convert PDF to HTML: The PDF contains a mix of text and images. I need this content to be faithfully translated into HTML. - MailChimp Compatibility: The HTML should be structured in a way that it can be easily imported into MailChimp. - Mobile-friendly: The HTML should be responsive and mobile-friendly to ensure a consistent experience across devices. - Professional Design: The resulting HTML should look professional and sleek, keeping in line with email marketing best practices. - C...

I'm in need of an experienced SQL Server data warehouse designer to help with a project of integrating and consolidating data from different sources. Key requirements: - Expertise in SQL Server: You should be able to design, implement and optimize data warehouse solutions on SQL Server. Understanding data warehouse design principles is essential. - Data Integration: You'll need to work with some of our developers / power users to source data and establish automated integration; experience with integrating relational databases and APIs from web services is crucial. - Data Consolidation: You should be able to create a cohesive, consolidated dataset from these different sources applying appropriate design principles. - Medium-sized project: The data needing in...

Setup of accounting software, import and clear data to have it ready to work.

I'm looking for a logistics sales executive who specializes in air and sea freight in the Chennai region. Main Tasks: - Develop and manage relationships in the manufacturing, export, and import sectors. - Target businesses who could utilize our freight services for their operational needs. - Increase brand visibility and leverage existing networks to generate sales. Key Skills and Experience: - Proven sales experience specifically in air and sea freight logistics. - Strong network within manufacturing, export, and import sectors in the Chennai region. - Excellent interpersonal, negotiation and networking skills. - Proactive with solid business acumen to identify new opportunities. The right candidate will have a sound knowledge of the logistics industry and be able ...

...offering essential functionalities such as AI-driven funding opportunity matching, interactive user profiling through an intelligent quiz, and efficient application assistance. Scope of Work: The project encompasses the following key tasks: Template Customization: Adapting the AI SaaS Dashboard template to fit the unique branding and functional requirements. Database Integration: Configuring and linking an external Airtable database to import and regularly update a directory of funding opportunities. User Authentication and Profile Setup: Developing secure login/logout capabilities and user profile management. AI Chatbot Development: Integrating OpenAI’s ChatGPT API to create an interactive chatbot that conducts a business background quiz and uses respons...

Note: Budget Fix 2000INR and time line 5 Day's I have a project currently in Codeigniter 3, and I'd like it converted to Laravel 10. This pro...will require thorough understanding of both frameworks, and it's crucial that all existing features and functionalities are precisely replicated in the new version. While I don't have specific features to prioritize, I will identify specific elements as the project progresses. Skills and experience required: - Profound knowledge in Codeigniter 3 and Laravel 10 - Expertise in PHP development and SQL databases - Proven experience in similar conversion projects Note: The finalized budget for this project is 2000INR. Please only bid if you can work within this budget. The timeline for project completion can be discussed d...

I'm currently experiencing database connection errors on my Wordpress website. Key Requirements: - Fix database connection errors causing website load problems - Ensure the website is running smoothly and all features are fully functional - Full access to the website's hosting account and database for troubleshooting - Clear and timely communication using instant messaging for updates and feedback Ideal Skills and Experience: - Proven experience in resolving database connection errors on Wordpress websites - Strong understanding of database management and troubleshooting in Wordpress - Excellent problem-solving skills and ability to work efficiently - Previous experience in instant messaging for client communication is a plus Had issues lik...

I'm looking for a professional Flask and Python developer to help me implement a user management system for my website. The user management system should have Social Media login integration. Additionally, I would like the selected developer to set up a payment gateway and a MySQL database. Ideal Skills: - Proficient in Flask and Python - Experience in implementing user management systems with social media login integration - Proficient in setting up payment gateways - Proficient in working with MySQL databases

I'm looking for an expert to engineer an Asana project with a focus on workflow automation. The project should have robust features such as: - Task management: I need a proper setup to facilitate the creation, allocation, and tracking of tasks. - Collaboration tools: The Asana project should enable seam...especially in the field of workflow automation, will be preferred. Your experience in creating an intuitive, professional, and sleek UI will come handy. A solid understanding of efficient task management, collaboration, and tracking tools is also essential. Finally, your ability to understand and translate requirements into action will set you apart. I have attached the CSV file i'm hoping to import and would like suggestions on including templates to use across multipl...

I am in need of a technophile with expertise in Microsoft Access databases. Your task will involve: - Populating my database with customer data which includes names, addresses, phone numbers, organisation affiliations, and details of last interactions. - Inputting sales transactions data which include dates, product names, and prices. The ideal freelancer should demonstrate an adept understanding of database management, particularly Microsoft Access, and be able to accurately input data with keen attention to details. Efficiency, accuracy and attention to detail will be paramount for this project.

...1702545 The design will be provided by me. Requirements: 1. Technical Specifications: - Framework/Technology: Please suggest suitable technologies. - Database: MySQL, PostgreSQL, or another relational database. - Responsiveness: The design must be fully responsive and work flawlessly on all devices (desktop, tablet, smartphone). - SEO: It must be possible to optimize each individual listing for SEO, as well as the overall website. - Security: Implementation of security measures to protect user data. - Performance: The website must load quickly and be highly performant. - Import Functionality: Ability to import an Excel file so that entries are automatically created in the backend. 2. Design and User Interface: - Pixel-Perfect: The ...

...high-complexity T-SQL stored procedure used for data analysis that I need translated into PySpark code. The procedure involves advanced SQL operations, temporary tables, and dynamic SQL. It currently handles over 10GB of data. - Skills Required: - Strong understanding and experience in PySpark and T-SQL languages - Proficiency in transforming high complexity SQL scripts to PySpark - Experience with large volume data processing - Job Scope: - Understand the functionality of the existing T-SQL stored procedure - Rewrite the procedure to return the same results using PySpark - Test the new script with the provided data set The successful freelancer will assure that the new PySpark script can handle a large volume of data and maintai...

Our existing CGI...encountering issues when importing the exam's section breakdown from a .dat file. Due to this, we are unable to import the breakdown of results per section of the exam into the SQL database. We are seeking a proficient developer who can: - Analyze our existing CGI script and identify the cause of the breakdown import issue. - Provide actionable advice and steps to troubleshoot and resolve the problem. - Ensure the script effectively imports the section breakdown from the .dat file as intended. The ideal candidate for this project should have: - Extensive experience in CGI scripting and SQL database management. - Proficiency in handling and troubleshooting data import/export issues. - Ability to work quic...

...been added to an import file. - Improving the style sheet so as to automatically map the new fields from the import file. The ideal candidate for this job should have experience with layout adjustments in XSL style sheets, automatic mapping of new fields and VB coding. Your skills and experience in rearranging content layout, updating fonts & colors, and altering data display formats will be highly appreciated. Don't hesitate to place your bid if you can deliver this effectively and efficiently. This is fairly simple task each year but neither of us have time to do this today and we are in a time crunch. Are you or someone at BDO available to modify this asap. Right now, a couple of us are working until the middle of the night for the past 2-3 weeks. Th...

...HTML, CSS, and JavaScript for the frontend, with frameworks like React or Angular to enhance the user interface. Backend Development: Python with Flask or Django for server-side logic, handling API integrations, and user data management. Machine Learning: Use TensorFlow or PyTorch for building the recommendation engine, and NLTK or similar libraries for sentiment analysis. Data Management: SQL or NoSQL database to store user profiles and their preferences. Version Control: Git for source code management and collaboration. Submission Requirements: Code: Source code with comprehensive comments detailing the functionality of each part of the system. Documentation: A detailed documentation covering the system design, implementation details, and instructions for setting up and ...

I am in need of a skilled freelancer who can help me extract all products from an online shop and import them into my Shopify store. Key Responsibilities: - Extracting all products from an existing online shop - Importing/copying these products into my Shopify store I expect the freelancer to: - Ensure all product information is correctly ported over like variants, prices, ean/gtin, description, collections,... - Maintain the quality of product listings - Ensure the product images are not lost during the import I'm looking to work with someone who has: - Experience with product extraction and import - Proficiency in Shopify - Attention to detail Please provide a timeline for completion when bidding. Please check the size of the shop and the number of products...

...warehousing, ad hoc reporting, complex SQL formation, and more. The primary purpose of the project is to streamline and enhance our data storage capabilities. By integrating new data into our warehouse on a monthly basis, we aim to improve our decision-making and business performance through enhanced data access and analysis. Key responsibilities include: - Reviewing and providing recommendations on the SOW for data warehousing - Offering expertise on ad hoc reporting and complex SQL formation - Helping to streamline data storage and improve decision-making - Ensuring the architecture can support monthly data integrations Ideal candidates should have: - Proven experience as a data architect - Expertise in data warehousing and ad hoc reporting - Strong SQL skills,...

...experienced individual to fill the role of Database Architect/Lead Developer specializing in Netezza and Oracle databases. The ideal candidate will be responsible for designing, implementing, and maintaining database solutions that meet the needs of our organization. This role requires strong technical expertise in both Netezza and Oracle platforms, as well as leadership capabilities to guide a team of developers. Responsibilities  Design and implement efficient database solutions for our organization, leveraging Netezza and Oracle technologies.  Lead a team of developers in the implementation and maintenance of database systems.  Collaborate with other stakeholders to gather requirements and define database architecture to meet business needs.  O...

I have to transfer data and tables from oracle to postgres.

Looking for a Senior BDA with experience in. AZURE SQL SERVER. English mandatory. 1d per week helping to improve and maintain our main DBs.

...CRM: - Create a custom module named "Partners" for financial advisors. - Add financial advisors to the Partners module once they respond to the drip campaign. - Referred leads entered into the Leads module need attributed to the corresponding financial advisor in the Partners module. - Provide a link in the Partners module to a report listing all referrals made by each advisor. Zoho Campaigns: - Import the list of 10,000 financial advisors into Zoho Campaigns. - Ensure campaign emails come from my emails address and not a generic / bulk address. - Basic set up of two email drip campaigns: - A 6-week weekly drip campaign. - A 24-month monthly drip campaign. - Ensure only a select number of advisors are added to the 6-week campaign daily. - Transfer advisors from the 6-w...

I am looking for a proficient C# developer who can build a .Net 8 Console application with in-depth CSV handling capabilities. You will need to be able to: - Import CSV files; - Validate CSV data, specifically focusing on data format and range checks; - Convert validated CSV data to a c# DTO format; - Post the converted data to an API. Responding to errors is a significant part of the project. The application should be able to handle any issues encountered during the import, validation, or conversion processes seamlessly. Proficiency in C# is a core necessity, with previous experience in CSV handling and data validation highly desired.

When designing a logo for the MANZU Company, it's important to capture the essence of the business and its values. Here are some inspiration and ideas for their logo design: 1. Symbolism: Consider incorporating symbols that represent the company's diverse offerings, such as a Chinese symbol or icon for the restaurant aspect, a shipping container or globe for the import trading business, and construction-related symbols for the contracting services. 2. Colors: Utilize colors that evoke a sense of quality, reliability, and professionalism, such as deep reds, golds, or blues. These colors could also represent the company's Chinese roots and the construction industry. 3. Typography: Choose a bold, modern, and easy-to-read typeface that conveys strength and reliability....