Sql database example jobs
...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...
...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...
Our existing CGI ...script is 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 quickly and efficiently, ...
...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 ...
...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,...
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.
I have a significant amount of text data from physical documents which I need entered into a database. The ideal candidate will have experience with both data entry and database management. Key Project Requirements: - Data Entry: You will be responsible for accurately transcribing text data from physical documents into a digital format. - Database Management: The entered data needs to be organized correctly in the database. Prior experience in managing databases is essential. Ideal Skills and Experience: - Proficiency in data entry - Strong attention to detail - Experience in database management - Familiarity with data organization techniques I'm looking for someone who can complete this efficiently and accurately.
...developer. To qualify you must be full stack and conde in . , .NET ASP WEB API + MS SQL Details of our current project STACK can be seen here -> Prerequisites: For this optimization task you can bid your normal hourly rate but for the long term project the starting wage will be as stated below. 1) Accept initial hourly rate of U$5.00 2) Accept and start work immediatly 3) Have MINIMUM OF 20+ hours a week for long term ongoing support and development. 4) If you are awarded the project accept IMMEDIATELY 5) Work hours: predominantly 20:00 to 02:00 (UTC -3 Brazil TIME) 6) Be available to work on weekends. Our projects use: GITLAB -> , ag-grid, C#, .NET API, MS SQL 2017 , WooCommerce digital product sales This is for ongoing long term development and we
...am looking for a cloud engineer who can assist with deploying an ASP.NET Web Form application on a Windows Server 2022 on VPS. Key Requirements: - The SQL Server DB and ASP.NET Forms have already been set up on the VPS Windows Server 2022. The main task is to ensure the successful deployment of the ASP.NET Web Form application. Additional Details: - The cloud provider I am currently using is WABYNE. Ideal Skills and Experience: - Proficiency in cloud engineering and deployment processes. - Experience with ASP.NET Web Form applications. - Familiarity with Windows Server 2022 on VPS. - Knowledge of SSL certificate installation, database configuration, and firewall settings is a plus. Please provide your relevant experience, certifications, and portfolio when applying. ...
...data analyst with proficiency in SQL and R for a comprehensive evaluation of a recently completed data analysis project. This project requires a review of SQL queries, R scripts, and database connections as detailed in a provided PDF. If you're ready to start right away and can deliver within 24 to 48 hours, please get in touch. Responsibilities: Conduct a thorough review of project requirements as specified in the PDF. Evaluate the accuracy and efficiency of SQL queries and R script implementations. Verify database connections and the effectiveness of data visualizations. Identify any discrepancies or areas for improvement. Deliver a comprehensive report detailing findings, issues, and potential improvements. Requirements: Demonstrated experti...
...skilled full stack developer to help with a web application project that I'm working on. The ideal candidate should be proficient in JavaScript and .NET, with specific experience in Angular and SQL Server. Key Skills and Experience: - Proficiency in JavaScript and .NET. - Strong knowledge of Angular and SQL Server. - Previous experience in developing web applications. - Ability to work collaboratively in a team setting. Responsibilities: - Develop the front-end using Angular. - Design and maintain the back-end of the application using .NET. - Ensure seamless integration of SQL Server for database management. - Conduct thorough testing to guarantee the application's functionality. This is a great opportunity for a skilled full stack developer to c...
I need a professional to create an ER diagram for a moderately complex database I'm designing. - This is specifically for database design purposes, using Chen notation. - The database structure I have in mind falls between 10-20 entities, so the ER diagram will need to reflect this level of complexity. - You should have in-depth experience with database design and ER diagramming, particularly using Chen notation. - The ER diagram should be clear, well-structured and accurately represent the relationships and entities within the database. - Previous experience with similar projects is a plus.
I'm seeking a FileMaker Pro expert to modify the existing project database for our small architecture firm. Your main tasks include: - Rectifying existing bugs - Enhancing reporting capacity - Introducing new mapping features, if possible. Some issues have been detected in the current system with features not working properly, particularly in the reporting capacity. A new mapping feature is optional and can be discussed further. There isn't a strict time frame for project completion, but I'm hoping to get it done as soon as possible. Ideally, the applicant should have a strong background in FileMaker, bug fixing and data mapping.
I am in need of a Laravel Developer to work on my website. The changes involve backend functionality and database modifications. Ideal Skills: - Strong experience with Laravel - Expertise in backend development - Proven track record of database modifications Tasks Include: - Implementing API integration, specifically e-commerce APIs - Database modification to accommodate new functionalities I need someone with a high level of expertise in Laravel and backend development. Your ability to integrate e-commerce APIs and modify the database accordingly is crucial for the success of this project. Your focus will be on enhancing the backend functionality, ensuring it's robust and efficient. Your attention to detail and ability to work independently will be high...
...can help me create a movie database website that is connected to a Telegram bot. Key Features: - Movie Database Website: The core of the project is to build a movie database that's user-friendly and comprehensive. - Telegram Bot Integration: I need a Telegram bot that can seamlessly connect to my movie database. The bot should be able to handle user queries and provide relevant movie recommendations. Telegram Bot Functionalities: - Movie Search & Recommendation: Users should be able to search for movies based on different criteria and receive tailored recommendations. - URL Shortener: The bot should be able to generate a shortened URL for the movie being recommended. Ideal Skills and Experience: - Proficiency in web development, particularly in ...
I'm in need of a professional to optimize my PL/SQL code for better performance. The primary focus of this project is to enhance the overall efficiency of the code. Key Responsibilities: - Perform PL/SQL performance tuning to improve the execution speed of queries. - Implement bulk collect operations to enhance data retrieval efficiency. - Optimize the compilation of procedures for better code execution. I'm seeking someone with extensive experience in PL/SQL, particularly with performance tuning and bulk collect operations. Proficiency in procedure compilation optimization will be a bonus. Your expertise will play a crucial role in achieving the project's goals.
...1, 2, and 3 emissions database through web scraping and data moderation. The selected developer will be responsible for scraping emissions data from global listed companies, implementing a moderation system, and enhancing our current offering by providing a database of published emissions data for ASX companies. Responsibilities: 1. Web Scraping - Web scrape scope 1, 2, and 3 data points from global listed companies to populate the VeriCO2 emissions database initially. - Develop scripts or tools to automate the web scraping process and ensure efficient data collection. 2. Data Moderation - Implement a moderation check to review and update data points based on user feedback and VeriCO2's own data collection. - Develop a system for users to report errors in the...
VeriCO2 is seeking an experienced developer to create a global scope 1, 2, and 3 emissions database as part of our automated quantification of scope 3 emissions project. The selected developer will be responsible for setting up the database, developing a user contribution system, and implementing security measures to ensure data integrity. Responsibilities: 1. Database Setup - Set up a database to store scope 1, 2, and 3 emissions data for global listed companies. 2. User Contribution System - Develop a system for users to contribute data via LinkedIn by signing up and providing their company's scope 1, 2, and/or 3 emissions. - Implement a security check to ensure the user's email domain matches the company name and send a verification email....
...conducting a thorough code review and integrating an emissions factor database into the existing codebase. Responsibilities: 1. Code Review and Functionality Check - Review the existing code to ensure there are no backdoors from the previous developer. - Verify that the code is functional and all equations for each method within the 15 scope 3 categories under the GHG protocol are correct. 2. Emissions Factor Database Integration - Finish coding the scraping mechanism to extract emissions factors from the Intergovernmental Panel on Climate Change's (IPCC) emissions factors database (). - Integrate the scraping mechanism with the IPCC's lookup section to ensure the database is dynamically updated. Requirements: - Strong experience
I'm in need of a reliable colleague who can assist me with data entry. The main task at hand is database creation. Key Responsibilities: - Data Entry: Your main responsibility will be to input data into a database. - Database Creation: You will be actively involved in the creation of a new database from scratch. Ideal Skills and Experience: - Proficiency in Data Entry: I need someone who is both fast and accurate in data entry. - Familiarity with Databases: Experience in creating and managing databases will be a great advantage. - Attention to Detail: The data involved in this project could potentially be complex, so attention to detail is crucial. I appreciate someone who is detail-oriented, reliable, and can work efficiently with minimal supervision....
I'm seeking a skilled C# developer to create a software solution aimed at processing data from a Winsock for a wifi connected Weight Scale and get the reading and put in a Microsoft SQL database.
I'm looking to commission the creation of a comprehensive database of IT working professionals. The main purpose of the database will be for recruitment purposes. Key Requirements: - The database should focus on IT professionals, covering a wide range of roles and expertise within the industry. - The data collected should be accurate, up-to-date and well-organized to facilitate efficient recruitment processes. Ideal Skills and Experience: - Prior experience in database creation for recruitment purposes, ideally within the IT sector. - Knowledge of the IT industry and the different roles and specializations within it. - Attention to detail and the ability to collect and organize large sets of data accurately. Please note that I have not specified the m...
I'm seeking a skilled data professional to provide a database of general consumer email addresses. The reach of the database should be international, encompassing various demographics and regions. I'll need the database to be delivered in an Excel file. Required Expertise: - Proficient in data collection - Proven experience in the field of emails dataset - Adept in Excel - Comprehensive understanding of data privacy guidelines Deliverable: - Database of general consumer emails in a well-structured Excel file.
I am in need of a USA email database for my email marketing campaigns. The primary focus of the database should be on consumers rather than businesses or non-profit organizations. An understanding of how to gather consumer-oriented data would be essential for this project. Your role would also include ensuring that the data adheres to privacy regulations and ethical data collection standards. Key skills and experience: - Database creation and management - USA consumer market knowledge - Understanding of privacy laws and ethical data gathering - Previous work with email marketing. Please note that details about target consumer segments such as age range, geographical location, or specific interests or hobbies are not necessary for this project.
I'm looking for a skilled freelancer to help me in creating a database of entry-level IT working professionals. The database is intended for recruitment purposes and should focus on professionals within our country. Key responsibilities will include: - Identifying and collecting database of entry-level IT professionals. - Categorizing the database based on different IT fields like software development, cyber security, network engineering, etc. Ideal candidates for this project should have experience in: - Database creation and management - IT recruitment - Strong knowledge of the local IT job market Your work will be critical to our hiring processes and future IT recruitment strategies.
I'm in need of an expert to help me create a database of entry-level candidates from Naukri portal. This database should include their names, contact information, and job experience. Key Project Requirements: - The database should primarily focus on entry-level candidates. - The database should categorize candidates based on their location. Ideal Skills: - Proficiency in data mining and database management. - Understanding of Naukri portal or similar job platforms. - Experience in creating and categorizing databases. The project will enable me to efficiently recruit and engage with suitable entry-level candidates
I'm in need of a database designed to organaize companies for Italian regions the data are not well organized, there are 927 companies with different address and region and they need to be divided by north west, north , north east etc - - Customer Information Management: The database should be structured in such a way that it allows categorizing companies according to their respective regions. Ideal freelancers for this job should possess robust skills in database design and management. A keen understanding of categorizing/mapping data based on geographical regions will be considered a huge advantage. Efficient, accurate, and secure data manipulation and storage is essential for this project.
I'm looking for an experienced and knowledgeable SQL Server professional who can help me resolve a connection issue I'm experiencing. - **Connection Method**: I'm currently using Windows Authentication to connect to the SQL Server. - **SQL Server Version**: I'm using SQL Server Management Studio 20. - **Error Message**: When trying to connect, I receive an error message indicating that the connection has failed. Ideal candidates for this project should have: - Extensive experience with SQL Server, particularly with the version I'm using. - Proficiency in troubleshooting connection issues. - Strong communication skills to guide me through the resolution process.
As an individual making use of Google Maps for specific personal applications, I am in need of a freelance developer adept at using VB.Net and SQL database to develop a program that will post activities on Google Maps. This software will be particularly handy in marking and recording various personal activities. The Successful Freelancer: - Should provide evidence of experience in VB.Net coding and SQL database management. Showcasing past work that is similar to this project will be beneficial. - They should also understand the implementation of access levels in software development as the map posting feature will be restricted to admin use only. Main Activities: - Create a software application using VB.Net. - Link the application to Google Maps. - ...
...my project. Key Responsibilities: - Enhancing the existing backend system: Your primary responsibility is to enhance the functionality of the current system and optimize its performance. - Integrating SQL/NoSQL Databases: Your expertise in SQL/NoSQL databases is crucial to ensure smooth integration and efficient data handling. - Experience with Python and Minio: If you're familiar with Minio that's a big plus, but Python is the key language you'll be working with on this project. Ideal Candidate: - Proven experience in enhancing existing backend systems. - Proficient in working with SQL/NoSQL Databases and designing queries. - Strong Python skills are a must. - Experience with Minio is an advantage, but not a necessity. This is a great opportunity...
...who can integrate a cloud-based database into my project. Ideal Skills: - Strong proficiency in Java - Prior experience with database integration - Specifically, experience with cloud-based databases, Microsoft Azure in particular, is a big plus The Project: - Your primary task will be to integrate Microsoft Azure, a cloud-based database, into an existing Java project. - The project already has a well-defined structure and the database will serve as a key component. - The database integration should be secure, efficient, and scalable, meeting the highest standards. - There will be no need for user authentication or API integration, as this project is solely focused on database integration. Please only apply if you have good experience with...
I'm requiring a proficient Java developer for a college project. The main task will be building a web application along with database integration. I'll need you to implement vital functionalities, such as: - A user registration panel - A user login page - Fee structure - Contact us section - Admin as well as user registration option - Subjects and courses - Basic website navigation functions For the front end, HTML and CSS skills are necessary to render a clean and minimalist design. It's vital you're experienced in these domains and can provide examples of your past work. Looking forward to your proposals.
As someone who values efficient and cost-effective operations, I'm intent on leveraging the full potential of my Microsoft SQL Server database. The core of this project involves enhancing performance and decreasing cost. To enrich the function of my database, I'll need an expert who can: - Improve overall performance, guaranteeing smoother, faster operations - Implement strategies for cost reduction without compromising quality and performance The ideal freelancer will be someone with extensive experience in Microsoft SQL Server, superb knowledge in database performance enhancement, and proven strategies for cost-reduction. If you can deliver this, you'd be the perfect fit.
Perfect english is needed. You need to be able to teach and tutor me in relational data bases and sql. You must be able to share screen and communicate quickly and fast. You must be available from today till 24th of May. I'm looking for an experienced database professional to assist with a relational SQL database project. You will need to assist me to answer questions about the following: The required tasks include: - Relational data bases ( administration, normalisation, sql workbench, my sql, data modelling) - Writing SQL queries - Designing the database schema - Optimizing query performance This project specifically involves MySQL, sql workbench, so proficiency in this database system is a must. The com...
I'm looking for a professional who can support me in my Azure Data Factory project. My primary goal is to transform structured data and then load it into Azure SQL Database and visualize it in Power BI. Deal with incremental load, create table relation and contextual data. Skills and Experience: - Proficient in Azure Data Factory - Experience in working with structured data - Expertise in data transformation - Knowledge in loading data into Azure SQL Database - Ability to visualize data in Power BI
I am in need of a one-time service to clean out my email database of invalid email addresses that generates too much soft bounce and hard bounce (and spam trap emails). Key Points: - **Objective**: The main goal of this project is to remove outdated or incorrect email addresses from the email database. - **Frequency**: This is a one-time project, not requiring ongoing maintenance. - **Current Platform**: I use Brevo as my email platform Ideal Freelancer Skills: - Experience with email marketing and database management - Familiarity with Brevo or similar email platforms - Proficient in identifying and removing invalid email addresses - Proven track record of improving email deliverability and marketing campaign results. I supply email addresses in CSV or XLS files
We are the largest and fastest growing UK charity community delivering support through multiple services via our website. Our website and AI machine learning and GPT are handled by others. We need dev support for the core SQL system and 2 small SQL directories, plus running reports and system admin. We need full stack Microsoft .NET development experience, strong SQL knowledge and exposure to Azure Microsoft services. We require a range of services. We’ll begin with the ad hoc work to begin to build a working relationship and then build that up to the following on an ongoing basis. • Ad hoc tasks for minor tweaks and changes on an ongoing basis. • Larger pieces of work, such as creating a moving from a free to a free and premium versions, with up...
We are seeking a Business Data Analyst for our team who is willing to work with new ...Responsibilities: - Collect and analyze data from various sources - Identify patterns, trends, and correlations in datasets - Create reports and dashboards to present findings - Collaborate with cross-functional teams to understand business requirements Required skills: - Strong analytical and problem-solving skills - Proficiency in data analysis tools such as Excel, SQL, or Python - Experience with data visualization tools such as Tableau or Power BI - Excellent communication and presentation skills This is a great opportunity for individuals who are new to the field of business data analysis and are looking to gain practical experience in a supportive en...
Hello! I need to build a module or functionality to the ServiceGo - Multi Vendor On-Demand Service & Handyman Booking Marketplace system for vendors. The module (functionality) should be the following, subscription model for vendors. In this subscription model, there should be a limit on how many listings (job services) a given vendor can publish and how many customers it can respond to. P.S. The above mentioned functionality is important to us, but even if you can't offer us such a solution we are also looking for the functionality of only registering as a vendor to pay a fee again, which should be per subscription. Link to the system:
I'm seeking a data-savvy freelancer with a deep understanding of Instagram, to create a well-organized spreadsheet of micro influencers. There are three crucial components needed for each influencer: I AM NOT LOOKING TO CREATE FAKE SOCIAL ACCOUNTS - I WANT EMAIL ADDRESSES TO CONTACT THEM TO HELP CREATE CONTENT> 1. Instagram Handle 2. Number of followers 3. Their Email Search Criteria - total of 2000 records acrsoss - Dieticians and Nutritionists - Pregnancy and infertility - Mums / Working Mums 500 - 5000 followers only. Australian-Based Accounts
I'm in need of an experienced Talend Studio developer to assist with a database migration project. Key Project Details: - **Data Sources**: The project entails integrating data from various databases. - **Primary Goal**: The primary focus of the project is to migrate the data accurately and efficiently. - **Data Processing**: The data migration will primarily be through batch processing, therefore real-time processing is not required. Desired Skills: - **Talend Studio Proficiency**: A strong understanding of Talend Studio and its capabilities is essential for successful project completion. - **Database Integration Skills**: Experience working with database integration is a must. - **Data Migration Experience**: Previous experience with data migration projects w...
...it's fourth generation of ownership. My Dad started using a database program called Formula Coster on his Apple IIc to figure out how to correctly price our baked goods based on ingredient costs, labor costs, overhead, etc. The program also allows us to store the formulas and makeup instructions for all our products based on the dough batch and individual pieces from the dough. It's a simple program that we still use today, but are afraid it may not continue to work very long. Other programs exist, but are all cloud based and require subscriptions with features we do not need. I am seeking an adept database developer to either continue work on an in-progress database or commence anew based on existing requirements. This database is intended for e...
Our development team just wrapped up front end development for a large-scale website. At this critical juncture, we're seeking advice to ensure that our back-end databases - PostgreSQL and Cassandra - will be optimally performing and highly available. Key areas of consultation include: - Performance optimizat...optimization strategies - Replication and high availability options - Ideal design of databases to accommodate the scale of our website Ideal professionals would bear extensive experience with both PostgreSQL and Cassandra databases, as well as a keen understanding of integrating front-ends to back-end databases. Your prior work with large-scale website infrastructures will greatly benefit our project. Database optimization and design aptitude is a crucial requirement...
Velocity alert analysis and provide actionable insights. Key requirements include: - Proficient in analyzing velocity alerts using SQL or SPL or Python - Capable of translating data from a word file into actionable insights - Experienced in the field of identity analytics, risk engine, authentication channel for the digital banking platforms - Understanding of Account Takeover (ATO) or digital identity compromise - Leverage known data as it relates to the digital customer identity and risk decisioning. - Analyze data logs from customer authentication channels and digital banking applications for malicious use and bad actors. - Create long-term solutions and automation to processes that can be improved when digital member identity is being utilized. Refer to attached document for b...
I'm going to build auth login page using the react , tailwind css, express Mysql DB. Also we have to join with google acc , facebook acc, apple acc.
As a company, we have a keen interest in developing partnerships with influencers on Instagram to boost our brand visibility. Our main goal with this project is to create a comprehensive database of potential influencers on this platform. Key Responsibilities: - The primary responsibility of the freelancer will be to search, collect, and organize relevant data about potential Instagram influencers. This will include their follower count, engagement rate, niche, and other relevant information that will help us evaluate their suitability for a partnership. - The database should be easily accessible and user-friendly, with the ability to filter and sort based on different criteria. Ideal Skill Set: - Extensive experience in social media research and data collection, with a fo...
...hours for £10, rent for 3 hours for £15, rent for 4 hours for £20, rent for 5 hours for £25, or rent for 6 hours for £30. Instead, could this be a dropdown. Instead, I would like to replace this with a tick box that users tick to bring their own rifle or leave unticked if they would like to rent a rifle. The system should calculate the price automatically. I will give you a wp-content folder and sql file you can import and work with to make these changes. Simply import these folders in the zip to WP Local, which can be downloaded at or use any other software you choose. The maximum deadline where all files should be handed back by is Friday 24th May 2024 at 23:59 BST....
...software compatible with Windows and Mac - Strong understanding of calendar integration and email automation On-Prem Client: Quivr Agent * Installation * Install Quivr Agent on Windows or macOS * Configure Quivr Agent to connect to local database and file system * Local Database * Use Azure Storage or Microsoft SQL Server as local database * Store indexed data and search results in local database * File System * Use Windows File System or macOS File System * Index local files and folders * Search * Search local database and file system for relevant results * Display search results in user interface * User Interface * Develop user interface for Quivr Agent * Include search bar, search results, and settings...
