Sql Server Canada Projects
Looking for freelance Sql Server Canada jobs and project work? PeoplePerHour has you covered.
Power 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.
15 days ago22 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/
6 days ago22 proposalsRemoteExpires in 23Website 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
25 days ago30 proposalsRemoteopportunity
Need a specialist in Kartris, WordPress and Microsoft Access
I have a website with an intranet where customer can order their goods. The website is currently moved and change to a WordPress website (website already done). When moved, I need to copy/move the Kartris ecommerce into the WordPress platform (no payment required). kartris ecommerce synchronise every night with Microsoft access database, and this database is on a physical server in my office. I am trying to put everything back onto a WordPress website so i need a specialist in all these area or I need someone with a solution I expect to do it step by step to keep the service running at all time. Please come back to me with some solution Also I want to work with the person on PPH don't sub contract this work
25 days ago23 proposalsRemoteFull-Stack Developer with React.js and Node.js Expertise
Job Description: We are seeking a highly skilled and experienced Full-Stack Developer to join our team on a large-scale project. The ideal candidate will have a strong background in both front-end and back-end development, with specific expertise in React.js for front-end and Node.js for back-end services. This project involves building a robust, scalable, and high-performance web application that will be used by a wide range of users. Responsibilities: ● Develop and maintain the front-end of the application using React.js, ensuring high performance and responsiveness. ● Build and maintain back-end services and APIs using Node.js that will support the functionality of the web application. ● Collaborate with designers and other team members to convert designs and wireframes into high-quality code. ● Design and implementation of data storage solutions, including databases and server-side logic. ● Ensure the entire stack is designed and built for speed and scalability. ● Integrate various third-party services and APIs such as payment gateways, social media, geolocation, etc. ● Write clean, maintainable, and efficient code. ● Perform code reviews and enhance the performance of existing applications. ● Stay plugged into emerging technologies/industry trends and apply them into operations and activities. ● Provide detailed updates to project managers and stakeholders regarding development progress. Skills and Qualifications: ● Strong proficiency in JavaScript, including DOM manipulation and the JavaScript object model. ● Thorough understanding of React.js and its core principles, along with popular React.js workflows (such as Flux or Redux). ● Proficiency in Node.js and frameworks available for it (such as Express, StrongLoop, etc). ● Familiarity with RESTful APIs and experience in API design and development. ● Understanding of front-end technologies, such as HTML5 and CSS3. ● Experience with user authentication and authorization between multiple systems, servers, and environments. ● Integration of multiple data sources and databases into one system. ● Understanding of database systems such as MySQL, MongoDB, Oracle, and/or PostgreSQL. ● Knowledge of code versioning tools such as Git. ● Excellent problem-solving skills and ability to perform well in a team-oriented environment. Additional Requirements: ● Bachelor’s or master’s degree in Computer Science, Engineering, or a related subject. ● Proven track record of delivering large-scale projects successfully. ● Excellent communication skills and fluency in English. Project Details: ● Duration: 6+ months ● Hourly Rate: Negotiable based on experience ● Commitment: Full-time preferred, minimum 40 hours per week How to Apply: Interested candidates should submit a proposal detailing their qualifications, a portfolio of relevant projects, and at least two references. Please include your expected hourly rate and availability. This is a fantastic opportunity to work on a project that will be utilized globally and to expand your skills in a dynamic and supportive environment. We look forward to your applications!
8 days ago27 proposalsRemotepre-funded
Marketing/Outreach assistance needed for research project
I have a small, unusual research project I'm working on that requires borrowing Amazon Prime gaming benefits. My project requires borrowing these benefits for a 12 month window (although the scope of this work contract is 2-3 months.) Most people who have Amazon Prime subscriptions for shopping / video don't use the gaming parts of their subscription. I've developed a safe, effective system for borrowing these benefits that does not put either the people loaning the benefits or the people collecting them at risk in any way. No personal account info is collected or asked for at any point, the process is entirely anonymized, and does not violate any Terms of Use clauses. I need people who can go around and use my method to borrow these prime benefits from people who aren't using them and willing to share. The contract is restricted to the US, Canada, Puerto Rico, or Australia Amazon Prime subscriptions. Total estimated work hours on your part is likely anywhere from 2-4 hours. I have a working process/pay schedule for how to do this from a previous iteration of this project, but I am also open to discussion on alternative methods of advertising/outreach to achieve the same outcome with similar cost structures. The rates I am using are $110 for a total of 5 borrowed gaming benefits, but negotiation is available for more or less benefits. —----> Specifics of Contract: The research project I'm running requires the monthly gaming benefits that are included with Amazon Prime subscriptions, specifically, the monthly twitch subscription. That monthly twitch subscription has a real world cash value of approximately $2-2.50 per month. People who use Amazon Prime for shopping but don't have any interest in video games let their benefit go to waste each month. The project is to see if it is viable to borrow these benefits from a statistically significant number of people (target number of 100 users) and see how long people continue their prime subscriptions over the course of 1 year. The job is essentially to go around and see if people wouldn’t mind letting you borrow the gaming benefits that they are not using, then linking the unused Amazon Prime benefits to blank twitch accounts (1 amazon prime benefit linked to 1 blank twitch account.) I need you to collect and link 5 accounts, for a project-complete total of $110 ( at a rate of $20 per account + $10 overhead stipend), although the total number of accounts is negotiable and scalable up or down. The process of borrowing the benefits is safe and easy to do. I have a collection of blank twitch accounts which are each ready to receive a single Amazon Prime gaming benefit link. Allocating gaming benefits is a one-way link; the twitch account has NO ACCESS to the parent Amazon account. We also do not ask for any of the Amazon Account information at any time. When you find people who are 1) paying for Amazon Prime, 2) aren't using their free monthly twitch subscription, and 3) are willing to share, you can allocate their benefits to one of the blank twitch accounts. The process takes about 2-3 minutes. Once you’ve collected the agreed upon amount, I will confirm each account is live and able to collect the monthly twitch benefits, then we will wait an additional 2 month to ensure the borrowed benefit accounts remain active before paying out the contract. This is to ensure the borrowed benefits are in fact from paid Amazon Prime subscriptions from the correct countries. After the 2nd phase is complete, you agree to leave the accounts linked for at least another 10 months regardless of whether the Amazon Prime accounts remain active. NOTES: - I have verified that this is not against the Terms of Use for Amazon Prime or Twitch. The process of benefit allocation is also completely safe for all parties involved. -The prime subscriptions must be from the U.S., Puerto Rico, Canada, or Australia. This will be confirmed during the 1 month waiting period. If any accounts are found to be from other unacceptable countries, they will need to be replaced, or the contract payment schedule restructured proportionally to the reduced value of the accounts. The expected value of the monthly benefits per account should be no less than $2.15 per month per account (all of the above countries meet this criteria.) -If accounts are found to be trial accounts, they will need to be replaced, payment refunded, or the payment schedule will have to be scaled down proportionally.
17 days ago6 proposalsRemoteurgent
Technical Architecture Contributions
Damyant software looking to build a solution architecture documentation Project Description: Dive into a cutting-edge infrastructure project designed for businesses looking to optimize their API management and enhance system reliability. We specialize in configuring and managing complex network setups involving Azure Load Balancers and Windows Failover Clusters. Our project aims to streamline operations and boost performance by effectively segregating API traffic and enhancing client-server interactions. Key Services Offered: API Traffic Isolation: Implementing advanced load balancer configurations to ensure API traffic is efficiently managed, avoiding unnecessary routing through Reporting Services. Direct Connection Setup for Clients: Facilitating direct connections for Rapid OA and GUI clients to a single PASOE instance, bypassing the load balancer for optimized performance. Failover Cluster Management: Utilizing Windows failover cluster for a robust active/passive deployment of critical services, ensuring high availability and system resilience. Custom Configuration: Tailoring interface patterns and endpoint configurations to meet specific client needs, with detailed planning and iterative enhancements. Project Highlights: Aligning with the latest technological standards, including updates to OpenEdge v12.8.2. Collaborating closely with industry experts and integrating feedback to refine our solutions. Preparing detailed designs for Azure Load Balancer settings, including necessary protocols and port configurations. Ideal for: Businesses in need of high-level API management solutions and failover strategies that require minimal downtime and offer maximum efficiency. Outcome: By partnering with us, you gain access to specialized knowledge and a tailored approach to managing your IT infrastructure. Expect improved system reliability, streamlined API traffic, and enhanced overall performance, aligning with the latest industry standards. Next Steps: Ready to optimize your API management and ensure your systems are failproof? Contact us today on PeoplePerHour to discuss your project needs and how we can achieve outstanding results together.
3 days ago14 proposalsRemoteExpires in 26Experienced Rsync Specialist Needed for Android Development
**Description:** We are looking for an Rsync specialist with proficient experience in managing and executing file synchronization tasks specifically relating to Android development projects. This is a long-term position extending over six months, ideal for a person dedicated to ensuring safe, secure, and speedy file handling using the Rsync tool. **Roles and Responsibilities:** - Set up and manage Rsync protocols to ensure efficient data synchronization between local environments and remote servers. - Customize Rsync scripts to optimize performance and meet specific Android development workflow needs. - Monitor, update, and troubleshoot Rsync operations to handle different scales of data transactions. - Ensure data integrity and security during transfers compliant with best practices. - Collaborate with the development team to integrate Rsync into the overall project workflow, promoting a smooth CI/CD pipeline. - Document the Rsync setup and provide clear instructions for team members unfamiliar with the process. **Pre-Qualification Test:** To qualify for this position, you will first need to demonstrate your proficiency with Rsync. **Your initial task will be simple: share a file from a simulated local development environment (Android emulator / Real Android device) to our designated test server using the Rsync method.** **Criteria for Evaluation:** - Accuracy of the implemented Rsync command. - Efficiency and speed of the file transfer. - Ability to effectively log and report the task outcomes. **Further Collaboration:** Upon successful completion and review of the initial task, we will proceed with a detailed discussion about the project, expected deliverables, and the contract terms. We are keen on establishing a robust working relationship to contribute significantly to our Android development efforts. **Application Process:** Please submit cover letter outlining your experience with Rsync, and if possible, specifics of previous projects where you've implemented Rsync in a professional context. Confirm your availability for the initial task when sending your application. We look forward to welcoming an adept and precise Rsync specialist to our team and hope you will join us for this exciting and challenging journey!
a month ago13 proposalsRemoteopportunity
Full-Time 8:30am-4:30pm Recruitment Resourcer
As a Recruitment Resourcer, you will be responsible for finding teachers and teaching assistants who are interested in working in schools in central London, UK. You will need to be confident building relationships with potential candidates by phone, using social media and job boards to find candidates, and consistently using our candidate CRM system to maintain records. In this full-time contract role, you will have the option to take UK school holiday periods off. Your hours will be 8:30am to 4:30pm remotely, allowing you to work from the comfort of your own home in South Africa. This role is Full-time and pays 207,000 RAN Annually or 17,250 monthly. To be successful in this role, you will need to be confident using social media and job boards to find candidates. You will also need to be able to communicate effectively with candidates from all over the world, including the UK, Australia, South Africa, New Zealand, USA, Canada, and Europe, among many other places. We are looking for someone who is passionate about education and recruitment, with a bubbly and enthusiastic personality. You will need to be a self-starter who is able to work independently and remotely. If you have previous experience in recruitment, sales, customer contact centres or a related field, excellent communication and interpersonal skills, and strong organizational and time management skills, then we want to hear from you. Knowledge of primary school education and the UK education system is a plus but not required. Join our team as a Recruitment Resourcer and help us find the best teachers and teaching assistants for schools in central London, UK. Apply now and make a difference in the lives of children. Requirements Interpersonal Skills: Exceptional communication to engage candidates and school staff positively. Outreach Experience: Proven ability in candidate outreach via social media and platforms like Reed and Indeed. Bubbly Personality: Vibrant and friendly demeanour to create a positive impression. Compliance Knowledge: Understanding or willingness to learn of UK education sector regulations for candidate compliance. Database Management: Proficiency in securely managing recruitment or customer databases. Attention to Detail: Ability to thoroughly review candidate applications for suitability and create their profiles and marketing assets to a high standard. Problem-Solving: Quick resolution of recruitment challenges. Adaptability: Flexibility to meet evolving recruitment needs. Team Collaboration: Willingness to work collaboratively and remotely with recruitment and school teams. Passion for Education: Genuine enthusiasm for contributing positively to the school community. Benefits Opportunity for Travel: The agency offers the possibility to travel to the UK, providing a unique chance to experience different regions and cultures while supporting primary school recruitment efforts. Flexible Work Arrangements: Resourcers have the option to take school holidays off or reduce their working hours during these periods, allowing for a better work-life balance and accommodating personal commitments. Self-Employment Option: Resourcers can choose to work on a self-employed basis, providing greater autonomy and control over their schedule and workload. This option may appeal to individuals seeking flexibility and independence in their work. Professional Development: The agency prioritizes professional development opportunities, offering training and support to enhance resourcers' skills and knowledge in recruitment, compliance, and education sector practices, fostering career growth and advancement.
12 days ago19 proposalsRemoteopportunity
Magento 2 issues - ajax 404 and indexing problem with two sites
Do you thrive on tackling intricate eCommerce challenges? We're seeking a highly skilled Magento 2 developer to diagnose and resolve two critical issues impacting our store's functionality. The Challenge: Issue 1: Defective Configurable Product Swatch Functionality Clicking a configurable product swatch on the catalog page results in a blank product image instead of an updated photo, as expected. Browser console reveals a 404 AJAX error. Importantly, this issue is isolated to the catalog page and does not occur on the individual product page. Issue 2: Conflicting Reindexing Between Separate Magento Installations We maintain two independent Magento 2 installations on the same server with distinct databases. A critical problem arises when reindexing one site: products mysteriously disappear from the catalog of the other site, and vice versa. Your Role: You'll meticulously investigate the root cause of both issues using your in-depth knowledge of Magento 2 architecture and debugging techniques. Develop and implement a robust solution to ensure proper configurable product swatch functionality on the catalog page, eliminating the 404 error. Formulate a sustainable strategy to address the reindexing conflict, guaranteeing seamless reindexing for each Magento installation without impacting the other. Maintain clear and concise documentation throughout the troubleshooting and resolution process. The Ideal Candidate: Proven experience as a Magento 2 developer (2+ years) with a solid understanding of core functionalities and best practices. A keen eye for detail and a methodical approach to problem-solving. Proficiency in PHP, MySQL, and debugging tools. Excellent communication and collaboration skills.
19 days ago32 proposalsRemoteModification of v2ray/xray client, to run via command line
***Please read carefully before you submit proposal, don't submit 1. if you do not have time to complete in a week 2. if you are not familiar with golang 3. if you do not know how to modify open-source V2ray/Xray to be executed via command line or shell script on Android 8+ 3. if you want me to follow your way to submit project plan, I have described what I need and it is simple 4. if you require me to tell you every details of why I need this and how I will use it and .... I am seeking the skills of an experienced golang developer to modify the open-source V2ray/Xray client for command line execution on Android OS. KEY DETAILS: - **Operating System:** The modified client must function seamlessly on Android platforms, from Android 8. - **Interface:** This project will be focused solely on command line or shell script execution modifications. A GUI interface is not needed. You just need to provide a version that I can trigger via command line, such as: Start: v2ray connect server.json(or server.txt) which .json / .txt file will contain the parameters and server details Stop: v2ray disconnect - **Functionality:** The task will involve modifying an existing app which can be launched via command line. I assume the native tun2socks in the open-source will remain unchanged - Scripting: Shell Script Compatibility - This application should permit scripts to be run from the command line. This requires your android development skills to be coupled with a good understanding of shell scripting. IDEAL SKILLS & EXPERIENCE: The successful freelancer should demonstrate a strong background in software development, specifically in dealing with open-source clients. Proficiency in golang and in working with Android operating systems is a must, along with expertise in command line execution. Prior exposure with V2ray or Xray clients would be highly desirable.
a month ago4 proposalsRemoteopportunity
Tidy the server from X-ransom attack
Hello, Our Wordpress website was attacked by x-ransom. We have a backup of the WP and the database dump. We have detected some corrupted files there but it seems that there are still some left that were not detected. It has to be tidy after the attack. It’s an internet shop with uploads files of around 100GB. It’s stored on a private hosting in LV. What is done do far: 1. Update WordPress Version 2. Use z’d updateSecure WP-Admin Login Credentials 3. Set Up Safelist and Blocklist for the Admin Page 4. Use Trusted WordPress Themes 5. Install SSL Certificate 6. Remove Unused WordPress Plugins and Themes 1. Enable Two-Factor Authentication for WP-Admin 2. Back Up WordPress 3. Limit Login Attempts 4. Change the WordPress Login Page URL 5. Log Idle Users Out Automatically 6. Monitor User Activity 7. Check for Malware - found several none-Wordpress specious files and plugins. Deleted them. 1. Disable PHP Error Reporting 3. Turn File Editing Off 4. Restrict Access Using the .htaccess File 5. Change the Default WordPress Database Prefix - not done 6. Disable XML-RPC 7. Hide the WordPress Version 8. Block Hotlinking - not done 9. Manage File Permissions not done After making the list, we received another x-ransome attack. I suspect he has a server level access not only wp level. If you apply, you need to be a server security and a Wordpress specialist. Please, quote for the job.
3 months ago19 proposalsRemoteopportunity
Do SEO on one blog post
I need SEO for one blog post on a property website. Scope of Work: I am seeking a qualified SEO expert to optimize one specific blog post on a property website. The chosen blog post will be provided to you upon acceptance of the proposal. The optimization process should include the following tasks: 1. Keyword Research: Conduct comprehensive keyword research to identify relevant and high-performing keywords related to the content of the blog post. 2. On-Page Optimization: Implement on-page SEO techniques, including optimizing meta tags, headings, images, and internal links to improve the post's visibility and search engine ranking. 3. Content Enhancement: Review and enhance the content of the blog post to ensure it is engaging, informative, and relevant to our target audience. 4. Off-Page Optimization: Develop a strategy for off-page optimization, such as link building and outreach, to improve the post's authority and credibility and provide a cost for implementation. 5. Performance Tracking: Monitor and track the performance of the optimized blog post using relevant SEO tools and web server log files but excluding GA. Deliverables: Upon completion of the optimization process, the following deliverables are expected: 1. Detailed SEO Audit Report: Provide a comprehensive SEO audit report outlining the current status of the blog post and recommended optimization strategies. 2. Keyword Analysis: Present a list of targeted keywords along with their search volume, competition level, and potential ranking opportunities. 3. On-Page Optimization : Implement a detailed plan for on-page optimization, including for meta tags, headings, and content enhancements. 4. Off-Page Optimization Strategy: Implement a customized strategy for off-page optimization, including link building and outreach. 5. Performance Metrics: Provide regular reports on the performance of the optimized blog post, including key metrics such as organic traffic, keyword rankings, and page authority. Measurement of Results: The success of the SEO optimization will be measured based on the following key performance indicators (KPIs): 1. Improved Search Engine Ranking: Monitor the blog post's ranking on relevant search engine results pages (SERPs) for targeted keywords. 2. Increased Organic Traffic: Track the volume of organic traffic to the optimized blog post over time. 3. Enhanced User Engagement: Evaluate user engagement metrics such as time on page, bounce rate, and click-through rate (CTR) excluding GA. 4. Improved PA. Measure the Page Authority as per MOZ.
a month ago68 proposalsRemote