SQL Jobs

I am looking for a freelancer to assist me with specific data cleaning and transformation tasks in Microsoft Power BI. Skills and Experience: - Strong proficiency in Microsoft Power BI - Experience in data cleaning and transformation techniques - Ability to work with large datasets Data Output: - The preferred format for the data output is data sets Data Collection: - I already have the data, so the freelancer will not need to collect it.

Hi, Job Title: Senior Developer - SQL Server Analysis Services Experience : 5+ Mandatory Skillset:Seeking a skilled SSAS Developer to contribute to our team's success. Responsibilities include designing, developing, and maintaining SQL Server Analysis Services solutions for business intelligence and data analytics requirements. Tasks involve creating data models and developing multidimensional cubes. Key skills required: expertise in MS SQL Server Analysis Services (SSAS) Tabular and Multidimensional. Proficiency in TSQL for writing performant queries is essential. Experience with data visualization and reporting tools is highly valued. Additional knowledge of Excel and .Net development is advantageous. Strong problem-solving abilities, excellent communication skills, and a collabor...

Project Description: Customer Data Integration and Personalized Marketing System Introduction: In the contemporary business landscape, understanding and catering to the needs of customers is paramount for organizational success. To achieve this, businesses must gather, organize, and analyze data about their potential and existing customers. This project focuses on developing a comprehensive system to streamline the process of collecting, integrating, and leveraging customer data to create personalized marketing campaigns. Objective: The primary objective of this project is to establish a dynamic and continuously updated database that empowers personalized marketing strategies. By gathering, cleaning, integrating, and analyzing customer data, the system aims to provide insights into custom...

I am seeking a database expert who can successfully migrate mixed structured and unstructured product data from Oracle to SQL. This project requires a comprehensive understanding of database architecture, data migration best practices, and extensive knowledge of Oracle and SQL. Key Tasks: - Analyze and understand the structure of existing Oracle database - Prepare a thorough plan for data migration ensuring minimal downtime - Coherently migrate mixed structured and unstructured product data to SQL Ideal Skills and Experience: - Previous experience with Oracle to SQL data migration - Understanding of both structured and unstructured data - Deep knowledge of database architecture and design - Ability to troubleshoot any issues that arise during migration - Excellent attention to detail a...

Here is a list of zip files on a US Govt website. You must write a Python program that uses a network library to download each zip file on this site, then find each .csv file in the zip archive, and copy each .csv file in each zip archive to a hard drive directory on the local windows machine. The directory will be "C:/MedicareDownloadFiles". The files cover the years 2017 to 2024. You may not hardcode file names ... you must extract the filenames from the above https URL. The fee for this will be $30. You must have it done within 60 minutes. Thanks for participating!

I'm experiencing performance issues within my IoT-based platform, mostly coming from slow query response times, excessive storage consumption, and challenges with insert operations after compression. I'm looking for an experienced TimescaleDB expert to optimize this. - Optimize slow query response time - Reduce excessive storage consumption - Fix insert operations after compression The ideal freelancer for this project is someone who has extensive experience in TimescaleDB, particularly in query optimization and compression features. Unfortunately, I'm unable to provide the number of tables in the platform, but I need someone who is capable of handling extensive data and complex structures. If you've dealt with this before, you're the right fit.

I'm looking for a skilled developer who can create a Springboot application that connects to our Oracle 19c database through JDBC. The primary goal of this project is to incorporate essential data operations into the application, mainly including reading, writing, and updating data in the database. Key Responsibilities: - Establishing a secure connection to an Oracle 19c database using JDBC. - Implementing CRUD operations (Create, Read, Update, Delete) features within the application. - Ensuring the application is optimized for efficient data handling and processing. Security Requirement: - The application must be able to securely access the database using username/password authentication. Ideal Candidate: - Proficient in Java and Springboot framework development. - Experienced wi...

I'm currently seeking an Oracle SQL developer with exceptional proficiency in creating logics. This task requires: - Writing an SQL code for data extraction purposes. - The code needs to be written as quickly as possible, with a time frame of 1-2 hours. - The solution should deal with the joining of multiple tables and creating doing some further order by, group by codes Decent knowledge of Oracle and experience in handling similar tasks would be ideal for success in this project. Your ability to deliver accurately and timely will be greatly valued. The code should be written using simple statements. I am not sure how to set up a connection to our datapool though. I can show couple of other related codes that can help

Our manufacturing company is seeking a proficient app developer who can take our existing work orders onto a tablet platform. The application will function as a means for our employees to access, update and input additional information into work orders. A direct connection to our SQL server is essential. The app should have the following key features: - Access and view work orders: Our employees should be able to easily browse and access the work orders. - Update work orders: A functionality to update the status of work orders is pivotal. - Add additional information: The app must also enable employees to input further necessary information into the work orders. Minimum qualifications include: - Proficient in app development. - Familiarity with SQL for direct server connection. - ...

I am in need of a professional with experience in SQL Server, ODBC and Quickbase pipeline to assist me with data integration. Job Duties: - Connect my SQL server via ODBC - Utilize Quickbase Pipeline and on-prem gateway for seamless integration Preferable Skills and Experience: - Strong understanding of SQL Server and ODBC - Experience with Quickbase pipeline and on-prem gateway - A history of successful data integration projects, particularly with transaction data Credentials: -I have all the necessary access rights and credentials to my SQL server. I require your expertise to navigate the technical process. Your responsibility would be solely the technical integration. No data management or further SQL Server maintenance would be required. I am only looking for professionals who h...

As an experienced PL/SQL user, I am looking to collaborate with a seasoned developer to help further scale my project. The role primarily involves: - Building novel PL/SQL procedures - Innovative database architecture and design You would be perfect for this job if you can demonstrate: - Extensive background in PL/SQL - Expertise in database architecture - Experience in crafting innovative procedures The tasks will encompass: - Data manipulation - inserting, updating, and deleting data - Data retrieval using the 'select' function - Implementation of integrated business logic I am excited to see how we could improve database structure and efficiency together.

Having an integral project already in place, I'm in need of a skilled SQL Developer to contribute towards its further development. Specifically, the tasks I require assistance with include: - Query Optimization: Tailoring and enhancing the performance of our current queries is a significant aspect of this role. - Database Maintenance: Maintaining the overall health and efficiency of our SQL Server is also a necessity. Ideal candidate must have a comprehensive understanding of SQL Server, as well as notable expertise in query optimization and database maintenance. I prefer someone with a proven track record of successfully managing and enhancing existing projects. I look forward to seeing your bids.

I'm seeking an individual with a decent understanding of investment accounts to guide me in setting up an investment account on an online platform. Key Requirements: - I need assistance with setting up an investment account with Dana Epep, with an initial deposit of 100K. - It is essential that the freelancer understands the investment environment, but I only require a beginner level of expertise. - We'll mainly be communicating through instant messaging, so the freelancer should be comfortable with this mode of communication. Ideal Freelancer: - A beginner or someone with a basic understanding of investment accounts. - Someone who has experience with Dana Epep or other similar investment platforms. - A good communicator, as we'll be mainly using instant messaging for ...

I'm in need of a proficient full-stack developer well versed in .NetCore C#, aiming to perform critical bug fixing and maintenance services on my existing software. The preferred candidate is expected to have: - Extensive knowledge and expertise in .NetCore C# - Proven experience in troubleshooting and resolving issues in a timely manner - Ability to effectively maintain and improve the existing software system - Strong comprehension of full-stack development processes - Commitment to delivering high-quality, efficient, and clean coding solutions If you're a driven, resourceful, and .NetCore C# professional, you're just who I'm seeking. I look forward to productive and beneficial collaborations.

I’m in need of an advanced-level professional who can skillfully put together content regarding SQL and Data Science libraries, specifically pandas, numpy, scikit-learn, and matplotlib. Key Topics: - Thorough insight into SQL commands and functions - Comprehensive knowledge on data cleaning with pandas - Expertise in Machine learning with scikit-learn Purpose of The Content: - Strive to educate, serving as a tutorial guide - Adequate for usage in documentation Ideal skills: - Advanced expertise in SQL and Data Science libraries - Exceptional writing skills with the ability to communicate complex ideas simply - Proven experience in creating educational, tutorial, and documentation content. Please ensure your bid reflects your understanding of these requirements and your past e...

I require a seasoned full-stack developer with a knack for Django web application development. This project revolves around creating a web app for data analysis, specifically user behavior data. Key WebApp Features: - User registration and login: The platform should facilitate user signups and secure login functionality for 3 types of profiles. - User Dashboard: Users need to manage their information effectively on a personal dashboard. - API Integration: The application must integrate with an 7/8 APIs. - Payment Acceptance: The platform should accept payments and automatically generate profile reports. - SMS Integration: An SMS acceptance feature for privacy is vital. - Email and Phone Verification: email and phone number to be confirmed through OTP. - PDF Generation: Generate c...