Sql Clr Projects
Looking for freelance Sql Clr jobs and project work? PeoplePerHour has you covered.
opportunity
Creating a SQL database on Google
We are a marketing agency that has built our own custom software. in the course of the upgrade, we are looking to update the location of the database from zapier tables to Google SQL database. We have 12 tables of information that we would like to be newly formatted on Google SQL. You don't need to help with the transfer of data, this would just be about making sure that the SQL database is properly set up. We need a setup of the Google SQL to be able to properly store the 12 tables worth of information, with each field having formatting rules that they would follow. What's more, we will be having AI read from this, so if the data is not properly formatted we would need a rule to revert the data to something that won't confuse the AI.
4 days ago23 proposalsRemoteWordPress Plugin Developer
We are seeking a skilled WordPress Plugin Developer to continue the development of a basic WordPress plugin. The ideal candidate should have experience with PHP, jQuery, HTML, CSS, JavaScript, and SQL. As a WordPress Plugin Developer, you will be responsible for enhancing the functionality of the existing plugin, implementing new features, and ensuring compatibility with the latest WordPress updates. This is a great opportunity to showcase your expertise in WordPress development and contribute to the growth of our plugin. Skills required: - PHP - jQuery - HTML - CSS - JavaScript - SQL
3 days ago30 proposalsRemoteSelenium-based data scrape of targeted LI profiles
The creation of a SQL database by scraping data from ~345,000 records from LinkedIn. - Selenium scripts to capture multiple fields from LI profiles (including Summary, Role Descriptions, Dates in Roles) - The storing of the data in an SQL database - Detailed technical documentation about each script
17 days ago28 proposalsRemoteopportunity
Python / Machine Learning / Selenium Scrap
We need help with python. Would you want to work for us? If so, when can you start working ? If you are interested, so there would be 2 contract fix rate $50/country flow, $10/script for easier works (like scrap-data transferring between GS&SQL),
11 days ago24 proposalsRemoteWordPress developer needed to resolve some issues
I am having trouble with the media library on my WordPress website. Sometimes I receive an error when trying to delete an image from the library. Also, in certain categories - new featured thumbnails are showing as "unattached," even though they are showing up in the post fine. I believe something went wrong when I was cleaning up the SQL database months ago. I didn't notice the issue until quite a bit after the fact, making a backup restoration nearly impossible.
15 days ago66 proposalsRemoteWeb Application Deployment in the Azure Cloud
(Microsoft Azure) Web application deployment in the Azure cloud using different service (IaaS, PaaS and FaaS) models 1.1 IaaS service model: Deploying an ASP.NET web application on Azure virtual machines. 1.2 PaaS Service Model: Deploying an ASP.NET web application to Azure App Service using Azure SQL Database. 1.3 FaaS Service Model: Deploy serverless APIs with Azure Functions, Logic Apps, and Azure SQL Database Objective: To test and compare the implementation of a web application in the Azure cloud using IaaS and PaaS service models.
a month ago5 proposalsRemoteopportunitypre-fundedurgent
Webhook to sync Dropbox 'Team folder' changes to OneDrive
Prefer C# as the language. Summary - Using an Azure Web App as the platform; Two (2) Web Apps. One for the Webhook receiver, the second for the 'worker process pool'. They will NOT run on the same Web App service in production and will be isolated from each other. 1 - Dropbox file change Webhook receiver that will queue file sync to the corresponding OneDrive (match 'Team folder') requests for the worker process pool. If there is an existing outstanding sync request for the same file skip additional sync request. Process will refresh Dropbox user watch list, refresh Dropbox Team folder -> OneDrive mapping hourly. 2 - A worker process pool that will perform the queued file download from Dropbox & upload the file to the corresponding OneDrive location. The worker process pool must be configurable of how many simultaneous downloads. Requirement of a 5-worker process pool for the deliverable. Worker process pool will operate on file sync queue in a FIFO manner. Will provide Azure Web App service, access to MS Dataverse & SQL Server. Dropbox Webhooks reference URL below https://www.dropbox.com/developers/reference/webhooks OneDrive API reference URL below - please use REST API beta not 1.0 version https://learn.microsoft.com/en-us/graph/api/resources/onedrive?view=graph-rest-beta Azure Web App reference URL below https://azure.microsoft.com/en-us/pricing/details/app-service/windows/
3 days ago22 proposalsRemoteExpires in 26opportunity
Create CRUD endpoints for our UI components in .NET Core Web API
We've our Admin angular project and it requires API endpoints (CRUD) to manage the data flow. You can start with our existing project and follow the same pattern. Additionally require you to create CacheRepository pattern to manage the cache for CRUD ops. Our Database is NoSQL but the queries are written in SQL. These are quite simple and Ill provide json document and you'll need to create endpoint to manage it. (We follow flat structure and doesn't require complex joins). 1. Blog APIs 2. Home Page API's 2.1. Trending Products API's 2.2. Deal API's 2.3. Ads API's 2.4. Brands API's 2.5. Trending categories API's 3. Category Page API's 3.1. Ads 3.2. Sub-categories 4. Sale API's 5. AWS S3 bucket Image management
a month ago26 proposalsRemotePower BI Developer
Key Responsibilities: Develop functional & operational reports & dashboards. Build automated reports and dashboards with the help of Power BI and other reporting tools. Understand business requirements to set functional specifications for reporting applications. Be experienced in tools and systems on MS SQL Server BI Stack, including SSRS and TSQL, Power Query, MDX, Power BI, and DAX Be able to quickly shape data into meaningful reports and analytics solutions. Have knowledge of database fundamentals such as multidimensional database design, relational database design, and more. Analyse data sources and ensure data quality and integrity. Design and develop efficient data models in Power BI, ensuring optimal performance and scalability. Transform raw data into meaningful insights by implementing appropriate data transformations. Develop visually appealing and user-friendly dashboards, reports, and interactive visualizations in Power BI. Implement complex calculations and custom measures to meet business requirements. Leverage DAX (Data Analysis Expressions) to create advanced calculations. Integrate data from various sources into Power BI, ensuring seamless connectivity and data refresh. Utilize Power Query to clean, transform, and shape data for reporting purposes. Collaborate with cross-functional teams, including business analysts, data engineers, and IT teams, to ensure alignment with overall business goals. Conduct regular stakeholder meetings to gather feedback and make necessary adjustments to BI solutions. Provide training and documentation for end-users to ensure effective use of Power BI reports and dashboards. Monitor and optimize the performance of Power BI reports and dashboards. Ability of learning new tools to enhance the data quality and visualizations. Qualifications and Skills: Bachelor’s degree in computer science, Information Systems, or a related field. Proven experience as a Power BI Developer or similar role. Strong knowledge on Azure Data Lake, Data Factory and other data services Strong proficiency in Power BI, including data modelling, DAX, and Power Query. Solid understanding of relational databases and SQL. Experience in ETL processes and data integration. Excellent analytical and problem-solving skills. Strong communication and collaboration skills. Ability to work independently and as part of a team. Preferred Qualifications: Microsoft Power BI certification. Experience with other BI tools (Tableau, QlikView, etc.). Knowledge of data warehousing concepts. Familiarity with cloud platforms (Azure, AWS) for BI solutions.
12 days ago20 proposalsRemoteWebsite Testing
Comprehensive Website Testing Services 1. Introduction: We are seeking proposals from qualified vendors to conduct comprehensive testing of our website. The purpose of this testing is to ensure the functionality, usability, compatibility, security, performance, and content accuracy of the website. The selected vendor will be responsible for executing various testing types and providing detailed reports with findings and recommendations. 2. Scope of Work: The scope of this project includes conducting comprehensive testing of the Medha Immigration Consultants website to assess its functionality, usability, compatibility, security, and performance. The testing should cover all aspects of the website, including but not limited to: Functionality testing to verify links, forms, navigation menus, search functionality, interactive elements, and dynamic content. Usability testing to evaluate ease of navigation, layout, design consistency, readability, accessibility, and responsiveness across different devices and screen sizes. Compatibility testing to ensure compatibility with various browsers, operating systems, screen resolutions, and assistive technologies. Security testing to identify and address potential vulnerabilities such as SQL injection, XSS, authentication, authorization, SSL certificate installation, secure transmission of data, error handling, and logging mechanisms. Performance testing to determine website capacity, response times under heavy load conditions, server and database performance, image and media optimization, caching mechanisms, and monitoring of performance metrics. 3. Deliverables: The testing service provider is expected to deliver the following: Detailed test plan outlining the testing approach, methodologies, tools, and schedule. Test cases and scenarios covering all aspects of the website. Test reports with findings, recommendations, and prioritized action items. Documentation of identified issues, including severity levels and sugge
22 days ago30 proposalsRemote
Past "Sql-clr" Projects
SQL Optimization
I am presently encountering performance issues with a certain SQL query, relying heavily on joins. The complexity of understanding the query also adds to it, taking away precious time and productivity. My performance measurement indicator is query execution time. The quicker the execution, the better the performance. Therefore, my project involves reconstructing this query to use Common Table Expressions (CTE) instead of joins. I would also need you to create views based on this newly optimized query. The database management system in use is PostgreSQL. Corresponding experience and knowledge in this system, along with skill in CTE implementation and optimizing SQL queries are pertinent. Skills and Experience: - PostgreSQL expertise - Proficient in SQL and CTE - Familiar with performance metrics like execution time - Experience in building SQL views The goal of this project is to have a more streamlined and efficient SQL query that uses less execution time. Your prime responsibility would be to restructure and simplify the query without disturbing its functionality.
Replicate an existing Access interactive database in SQL
I need an experienced UK based SQL programmer to build what is quite a complex and interactive database. Contract and remuneration conditional upon 1) Level of experience and qualifications of selected candidate and 2) Initial evaluation and assessment of project by selected candidate
Senior PHP/WordPress Developer
The PHP/WordPress Developer we are seeking will be the cornerstone of our development team, responsible for creating and implementing a range of database-driven web applications with a focus on delivering innovative and user-centric solutions. Your technical expertise will drive the design, development, and deployment of projects that stand out for their quality and functionality. Your Main Responsibilities Will Include: Execute the full website design and development life cycle, from the initial concept to deployment and beyond. Seamlessly integrate third-party APIs to extend the capabilities of our web applications. Develop and manage efficient, secure databases that support the functionality of our applications. Customize WordPress installations, crafting bespoke themes and plugins tailored to project requirements. Vigilantly address, diagnose, and rectify any issues in the application, prioritizing a bug-free user experience. Conduct thorough unit testing of code to ensure robustness, usability, and general reliability under various conditions. Manage and maintain domain registrations and configurations, ensuring optimal performance and reliability. Qualifications: Degree in Computer Science, IT, or a related field, with a minimum of 5 years of relevant work experience. Proficiency in PHP and SQL, with extensive experience in WordPress, HTML, CSS, JavaScript, and Bootstrap. Familiarity with C# will be considered a valuable asset. Solid understanding of MySQL databases and UI/UX design principles. High proficiency in English, both written and spoken; knowledge of additional languages is a bonus. Exceptional attention to detail, ensuring precision in coding and design. Strong organizational skills, including effective time management, prioritization of tasks, and the ability to multitask in a dynamic work environment. If you believe that your skills and expertise align with the requirements of this position, please send us your CV for review. Additionally, if you have a portfolio or examples of previous work, we would be interested in seeing them. We are eager to assess your qualifications and establish a cooperative relationship as soon as possible. We look forward to hearing from you.
Pardot - Sales Funnels & Campaign Implementation
Project Overview: Seeking a Salesforce professional, who’s proficient in implementing comprehensive sales funnels within Pardot, aligning with our company's Sales Qualified Leads (SQL) and Marketing Qualified Leads (MQL) activities and scores. Our goal is to develop tailored campaigns across various stages of the sales funnel, including awareness, nurture, and retention campaigns. Knowledge of Pardot is crucial for this project. Objectives: Develop top, middle, and bottom-of-funnel sales funnels within Pardot to effectively nurture leads and drive conversions. Align sales funnel stages with our company's SQL and MQL activities and scores to ensure accurate lead qualification and segmentation. Create awareness campaigns to attract and engage potential leads, showcasing the value proposition of our products or services. Implement nurture campaigns to educate and build relationships with leads, guiding them through the decision-making process. Develop retention campaigns targeting existing customers, aimed at fostering loyalty, increasing retention rates, and driving upsell opportunities. Key Requirements: Expertise in Pardot: expertise in working with Pardot, including proficiency in setting up automated campaigns, lead scoring, and segmentation. Understanding of SQL and MQL Activities: posses a deep understanding of Sales Qualified Leads (SQL) and Marketing Qualified Leads (MQL) activities and scores, and be able to translate this knowledge into effective campaign strategies. Ability to Develop Tailored Campaigns: demonstrate the ability to develop customized campaigns tailored to different stages of the sales funnel, incorporating personalized messaging and content. Track Record of Success: We seek an agency with a proven track record of successfully executing similar projects and delivering measurable results in lead generation, nurturing. Collaboration and Communication: Strong communication and collaboration skills are essential for seamless coordination between our internal team throughout the project. Deliverables: Detailed sales funnel strategies and plans for top, middle, and bottom-of-funnel campaigns. Implementation of automated campaigns within Pardot, including setup of lead scoring and segmentation rules. Training and knowledge transfer to our internal team on managing and maintaining campaigns within Pardot. Timeline: The project is expected to commence ASAP and be completed by 18th March (includes timelines for strategy development, campaign setup, testing, and optimization). Budget: Please provide a breakdown of your proposed costs for strategy development and campaign setup. Next Steps: Pls submit a proposal outlining your approach, capabilities, and pricing for this project. Please include relevant case studies or examples of past work demonstrating your expertise in Pardot campaign management and lead nurturing. Thank you for considering this opportunity. We look forward to reviewing your proposal and potentially collaborating on this exciting project.
opportunity
Mobile App with React Native / Expo / CSV file (or SQL Server)
I need a Mobile App working on an Android Phone that reads barcodes and stores them inside the cell phone (connected to a LAN) After the operator has read each barcode, he must be able to enter a quantity. When the operator has finished reading the barcodes, he must press a button and the App must send the barcodes and the quantity in a CSV file to a shared folder on a computer on the LAN (or, if it is easier, write the data on a SQL Server table, in this case, I need also the code for the server if needed) The App must be developed with React Native / Expo
Web Scraping Data in to SQL database
I'm seeking a skilled freelancer to assist with a web scraping project on a specific website and leading up to a number of websites. The specific data fields that need to be extracted will be provided. Ideally, you'll have: - Advanced skills in web scraping and python -- Knowledge of MS SQL Server databases. - A demonstrable understanding of data extraction - A fast turnaround rate as this project is high-priority and needs completing as soon as possible. Experience in extracting both structured and unstructured data would be beneficial, as it's likely our sought-after fields will vary. The end goal is for me to eventually take over the code with your ongoing support and will most likely be a long term relationship. I can provide a full specification when needed. Please place your bids following this detailed outline.
Python Expert
We need to get this information about the prices of bond securities We need the info inside the first pdf in the top left from page 3 without their corporate info (this list us updated every day) and we would like to upload it into our database sql server Can you review it and let me know if you can easily do it so it is automatic and how much time it would take you more or less? Thanks Khadimul
Skilled SQL Developer for Database Design
I need a proficient SQL developer who can focus on database design and creation. You will be working on a relational database project. There will be an emphasis on creating tables. Ideal freelancers will have: - Strong skills in SQL and relational database operations - Experience in database design, particularly creating tables - Knowledge of query optimization and data migration - A thorough understanding of data normalization, indexing, and data integrity constraints. Your role will involve creating a user-friendly, efficient, and robust database model. If you have the skills and experience to deliver on this, please bid
Stored Procedure setup on MY SQL
we need an automated daily process that moves data from SQL Server to MySQL using stored procedures, ensuring that the MySQL database stays synchronized with the SQL Server database The SQL server is hosted at clients location and our SQL server is hosted on AWS We have created a script that synchronises the data from the remote DB to our DB but it fails after synching about 1000 records out of 5000 Need someone who experience in stored procedures
C# Developer
We are developing a LIMS platform using ABP.io in C#. We are seeking software developers to join our team and help develop new features. Requirements: - Excellent C# knowledge - Able to create high performing and clean code - Can take part in code reviews - Produce a full suite of tests for each new function - Microsoft SQL server - Working knowledge of Jira - Work within a remote team - Able to join regularly scheduled standups - Excellent knoweldge of working with Angular and writing front-end tests - UK Based. Nice to haves: - Experience working with abp.io framework Please apply with your experience, availability and location.