Sql Clr Projects
Looking for freelance Sql Clr jobs and project work? PeoplePerHour has you covered.
Selenium-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
2 days ago29 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.
13 days ago5 proposalsRemoteopportunity
Read/write data via GraphQL API to MS Access/Sql Server
"read/write data via GraphQL API to MS Access/Sql Server" We're a children's nursery, in the process of moving to a Nursery management service hosted on web We are a childrens' nursery using a web-based nursery management software called Famly. They use GraphQL for their api. We currently use MS Access DB but planning to move to SQL Server or similar. I need a set up for me to pull various sets of data via their api provided as e.g. row/column data to write/update our database. I also want functionality to write key information to Famly via their API by providing row/column data etc. The work would consist of configuring API access to our data in Famly with functionality to read and write data to/from Famly from our database.
17 days ago28 proposalsRemoteAzure Data Engineer
Requirement Azure Data Engineer Experience 6+ yrs Project Timing 2 PM – 11 PM (2 nd shift) Skills- Databricks, SQL, Pyspark Databricks Certification- Good to have Good comm's and problem solving skills o Relevant experience in Azure data engineering: 4+ years. o Relevant experience in Databricks (PySpark / Scala / SparkSQL): 2+ years. o Relevant experience in Azure Data Factory (ADF): 2+ years. o Relevant experience in SQL: 2+ years. o Experience leading a small team o Required Skills: Azure Synapse, Azure Analysis Services, Azure Data Lake Storage, and Azure SQL databases. o Good to have: Power BI, Azure IAAS services, Python, and Excel
22 days ago11 proposalsRemoteopportunity
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
12 days ago25 proposalsRemoteSoftware Developer
Job description Software development for mobile and web applications Development of applications for smart watches Communication with customers Cooperation with Embedded SW colleagues Participating in the development of new and existing projects from various fields (dry cabinet unit, bus control units, airsoft gun devices, electric golf vagoons) What do we expect? Experience with development in React (JS, HTML, CSS) Experience with Flutter or Swift/Kotlin Node.js, MongoDB or SQL experience preferred Experience with RESTful APIs is an advantage! University degree in IT or Computer Science is an advantage! Independence, sense for team spirit Good communication skills Ability to get things done Diligence, positive work attitude (we are flexible and accommodating, but we expect systematic attitude) Not to be afraid of new challenges Advanced knowledge of English language 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.
14 days ago27 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
6 days ago23 proposalsRemoteSenior 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.
15 days ago52 proposalsRemoteDatabase Design for Fleet Management
Summary: We are looking for an experienced freelance Database Engineer to create a high-performance database tailored for managing operational data from our truck fleet. The role involves collaborating with the Original Equipment Manufacturer (OEM) of the trucks to integrate our internal server with theirs. This integration will facilitate the transfer of real-time operational data. The primary goal is to store this data in our internal database, enabling data analytics to optimize fleet operations. +++ Scope of Work: The project will be executed in four main stages, with the initial contract focusing on the first two stages: 1. Database Design and Development: Design and implement a high-performance database hosted on our internal servers. This database will be linked to real-time data on the servers of the truck's OEM, ensuring seamless synchronization and data integrity. 2. Data Visualization and Reporting: Develop basic visualization and reporting capabilities to allow for easy interpretation and analysis of the collected data. This will include the creation of dashboards or reports that highlight key metrics and trends. (Future Stages to be Scoped Separately) 3. Develop a web portal, hosting data reports developed in stages 1 and 2. 4. Develop a mobile app, hosting data reports developed in stages 1 and 2. +++ Deliverables: 1. Develop and host a database on an internal server that maintains a consistent and complete dataset of real-time operational data. 2. Establish and document automatic synchronization between the internal database and the servers hosted by the OEM. 3. Create a basic dashboard for visualizing the operational data stored in the database, featuring essential metrics and real-time updates. +++ Key Responsibilities: • Analyze and understand the structure of the existing data on the OEM servers. • Design a scalable and secure database architecture. • Implement the database on our internal servers, ensuring real-time data synchronization with the OEM servers. • Develop basic tools or dashboards for data visualization and reporting. +++ Skills and Qualifications: • Proven experience in database design and development, especially with large and complex datasets. • Proficiency in database management systems (e.g., SQL, NoSQL) and data visualization tools. • Excellent analytical and problem-solving skills. • Ability to work independently and in collaboration with cross-functional teams. • Effective communication skills, with the ability to document and explain technical details clearly. +++ Project Timeline: The initial scope of the project (stages 1 and 2) is expected to be completed over the course of eight (8) full time days within a one-month timeframe (April 29th – May 31st). This period allows for actual development, with additional time allocated for necessary engagements with external stakeholders at the OEM. +++ Application Process: Interested candidates are invited to submit a proposal outlining their approach to the project, including a timeline, budget estimate, and a portfolio of relevant work. Shortlisted candidates may be invited for an interview to discuss the project in further detail. +++ About Us: At Bisedge we provide, maintain and operate mainly electric material and cargo handling equipment for companies in Africa.
3 days ago37 proposalsRemote
Past "Sql-clr" Projects
opportunity
Android TO-DO LIST working on LAN (REACT NATIVE / MS SQL SERVER)
I want to create an Android smartphone application that is a to-do list. The application will be installed on my smartphone and on my technicians' smartphone. I, who am the administrator, want to insert a job to be done into the application, for example "the printer in the technical office doesn't work, it needs to be repaired". I also need to be able to insert if it is an urgent job. Technicians who have the application, but are not administrators, should see the note and the time it was published. When each technician opens the note to see it, I have to see at what time they read the note. When a technician starts the job, he must tick it in the application and the start date and time must be recorded. When the technician has finished the work, he must report it in the application and the finishing date and time must be recorded. Only the administrator should be able to insert a job, modify it, or delete it. Technicians can only read the job, and report that they have started it and that they have finished it. The database that holds the application data will need to be on the company's MS SQL server. The application must only work on Android smartphones connected to the company's wireless LAN. No cloud data. The application will have to be developed with React Native. The backend will be developed with NODE.JS I attach a first draft of the screens
opportunity
PBI - Recurring Email (3)
PBI - Recurring Email (3), recurring email for payroll through SQL / Power automate We require a recurring email to be sent out to employees on a weekly basis that includes payroll information. The email should be generated using SQL or Power automate and should include the following information: Employee name Payroll period Salary Deductions Net pay The email should be visually appealing and easy to read, and should be customized with the company's logo and colors. We also require the ability to add or remove employees from the email list as needed. Please provide a proposal for the project, including a timeline and estimated cost.
opportunity
PBI - Recurring Email (2)
PBI - Recurring Email (2), recurring email for payroll through SQL / Power automate We require a recurring email to be sent out to employees on a weekly basis that includes payroll information. The email should be generated using SQL or Power automate and should include the following information: Employee name Payroll period Salary Deductions Net pay The email should be visually appealing and easy to read, and should be customized with the company's logo and colors. We also require the ability to add or remove employees from the email list as needed. Please provide a proposal for the project, including a timeline and estimated cost.
Red Teamer in Fintech Security
Hey there, talented tech wizards! We have an incredible opportunity that's tailor-made for your skills. We're on the lookout for individuals who excel in Local SQL Injection (SQLi) and JWT (JSON Web Token) Bypass techniques. Why This Opportunity is a Game-Changer: High-Stakes Project: Successful completion of these tests opens the door to a project with serious digital security implications. Potential Earnings: Projects awarded after passing these tests will start with compensation ranging from $3000 to $5000, depending on the complexity and scope. What You Need to Do: Prove Your Skills: Demonstrate your prowess in Local SQL Injection and JWT Bypass. Secure the Bag: Upon passing, dive straight into a rewarding project with compensation ranging from $3600 to $5000. Why Choose Us? We value your expertise and commitment to excellence. We offer competitive compensation for your hard work and dedication. Projects with real-world impact await you! Note: The testing period is unpaid, serving as an assessment of your knowledge. The project will only be awarded upon successfully passing the test, ensuring top-notch digital security talent. Test repo :- https://github.com/livingsacrophagus/test-repo Ready to Rise to the Challenge? Deadline for completing 3/16/2024 5:00 PM EET
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
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
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.
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.
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