Sql Server New York City Projects
Looking for freelance Sql Server New York City jobs and project work? PeoplePerHour has you covered.
Scrape emails address
Can you scrape email addresses from HR managers in the following cities: Barcelona, Berlijn, Parijs, New York, Londen, Dubai en Hong Kong? As many as possible
6 days ago60 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.
a month ago27 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.
7 days ago19 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
17 days ago26 proposalsRemote
Past "Sql-server-new-york-city" Projects
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.
Full Stack Web Developer
Proficient in HTML, CSS, JavaScript, and a server-side language (e.g., Node.js, Python, Ruby) Experience with front-end frameworks like React, Angular, or Vue.js Knowledge of back-end frameworks such as Express.js, Django, or Ruby on Rails Familiarity with databases and query languages (e.g., SQL, MongoDB) Experience with RESTful API development and integration Strong problem-solving and debugging skills Version control system proficiency, preferably Git Understanding of cloud platforms like AWS, Azure, or Google Cloud Excellent communication and collaboration abilities Job Description: We are seeking a skilled full stack web developer to join our team and contribute to the development of a WhatsApp Web application using the "whatsapp-web.js" library. As a full stack developer, you will be responsible for handling both the front-end and back-end aspects of the application, ensuring seamless integration and optimal performance. Responsibilities: Develop and maintain front-end components using HTML, CSS, and JavaScript frameworks. Design and implement server-side logic and APIs using a server-side language and framework. Integrate front-end components with the back-end using RESTful APIs. Create and maintain databases, ensuring efficient data storage and retrieval. Optimize the application for maximum speed, scalability, and security. Debug and resolve any issues reported by users or QA testers. Collaborate with the team to brainstorm and implement new features and functionalities. Stay updated with emerging technologies and industry trends in web development. Requirements: Proven experience as a full stack web developer or similar role. Proficiency in front-end technologies such as HTML, CSS, JavaScript, and front-end frameworks. Strong knowledge of a server-side language and framework for back-end development. Experience with databases and query languages. Familiarity with RESTful API development and integration. Proficiency in version control systems, preferably Git. Understanding of cloud platforms and deployment processes. Excellent problem-solving and debugging skills. Strong communication and collaboration abilities. Ability to work independently and meet project deadlines. If you are a passionate full stack developer who enjoys working on diverse projects, collaborating with multidisciplinary teams, and delivering high-quality applications, we would love to hear from you. Please provide examples of your previous work and any relevant links or portfolios when applying for this position.
Web developer/designer for website enhancement
**Title:** Seeking Expert Web Agency or Freelancer for Comprehensive Website Management and Enhancement **Description:** We are the team behind www.greix.de, a dynamic website specializing in data visualization and urban data analysis. We're seeking a skilled web agency or freelancer to take on the management and improvement of our website. **Key Responsibilities:** 1. **Data Visualization Enhancement**: Manage and improve our existing graphs and maps, ensuring data is presented in an engaging and user-friendly manner. 2. **Content Management System (CMS) Optimization**: Our website currently operates on a CMS, which needs regular management and enhancements for better performance and functionality. 3. **Data Expansion**: Regularly add new cities to our database, ensuring the information is accurate and up-to-date. 4. **Upload Tool Management**: Oversee and refine our data upload tool for efficiency and ease of use. 5. **API Integration and Download Section Improvement**: Implement an API for better data interaction and revamp our download section to make it more accessible to the public. 6. **Server Management**: Manage our hosting server, including transitioning to a European server for improved performance and compliance. 7. **Analytics Tool Implementation**: Integrate a new analytics tool that complies with European law (e.g., Matomo), to monitor website traffic and user engagement. 8. **Routine Website Checks**: Conduct regular checks to ensure the website's optimal performance at all times. 9. **High Traffic Management**: Provide closer monitoring and support during peak periods, especially when new data is published, to prevent any downtime. **Requirements:** - Proven experience in web development and management, particularly with data-intensive websites. - Expertise in data visualization tools and techniques. - Strong understanding of CMS, API integration, and server management. - Ability to handle high-traffic website scenarios and ensure uptime during critical periods. **Offer:** Please provide us with a detailed offer that includes: - Maintenance and security plan. - Estimated 16-20 service hours per month. - Your proposed monthly or hourly rate for this. We look forward to a proposal that will outline how you can help us achieve our website goals, with a focus on reliability, user engagement, and data accuracy.
Simple web app - React + azure functions
I'm looking for a developer with React and Azure functions and Azure SQL experience to build a simple web app. The react web app will employ the SurveyJS library. It will: 1. Query Azure Functions backend to request latest survey definition file location and a response (session) id. 2. Fetch survey definition via CDN and initialise presentation using SurveyJS. 3. Fire and forget minimal post updates to backend reporting survey progress. 4. At defined moments (after key questions) POST the full (interim) survey response to backend. 5. At survey end POST final survey response. SurveyJS will handle all survey routing and presentation. Backend (Azure functions) will: 1. Ensure credibility of all requests (cors and/or other measures). 2. Query Azure SQL database to retrieve survey definition file location, initialise a response row in database and return id to client as requested. 3. Receive and update response status (last question completed) as notified by client. 4. Receive and update survey response data (JSON) directly to database when received from client. Additional client notes: The survey definition file may be of a significant size due to the size of the survey and number of language translations included (tbc). Therefore an unacceptable initial load time is anticipated, and an initial fast loading welcome page may be required while resources are loaded in the background. IP locale detection and locale/language switching on demand would be required for the welcome page. Locale/language setting would then be passed into SurveyJS for the actual delivery of the survey. It will handle all language and locale switching once the survey is running. Additional server side notes: A number of the survey questions will need to load their response options dynamically via REST API call. SurveyJS handles this itself on the client side. However the server-side endpoint will need to be implemented. This should be very simple as the SQL to fetch required data is already wrapped in stored procs on the DB. You will just need to validate the request and pass parameters supplied to the stored proc then return the results in the format required. All development will need to sit in our Git repo and be fully and automatically deployable to Azure.
Google app script - Google Sheets Automation
Google app script expert needed for stock price and data for world wide countries. Basically we have done for few countries we need you to replicate for more different countries, each country will consists about 8 google sheet types and some types may have dozen or up to few hundreds google sheets. Then some of the data needs be transferred and stored to SQL and taken from SQL by API also. This is team work, you will be working with bunch of server guys and python guys. So you need to possess these abilities : 1. Able to make google sheets fast, make editor for the GS fast and send all of the Google sheets ownership to me. 2. Able to work on SQL and API. 3. Able to collaborate as a team. We strive for succeed, so you need to able to be fast delivery, agile, and be responsible but also you must maintain a good working non toxic environment. We will pay $12/countries but we may fund more milestones for some few extra works. Each country is the same, you just need to replicate the codes which are already done but modifying some things like extensive stock according to set trigger for every country and also, check symbols are different in scrapped sources.
opportunity
Transferring of data from old to new website
I need someone to help us migrate date from one website to another and develop a user-friendly CMS to manipulate data. Old website www.universalvisas.com, new website www.visagroupltd.com, The new website is built on WordPress. we want to transfer all the visa requirements (countries, nationalities and visa information) from the old website to the new one). I have access to the plesk control panel, where the data is stored on a sql database on our dedicated server.
GPRC API programming
I need to get data from a server server via a gRPC API and store this data in a SQL Server hosted on Azure, where I can use this data in Power BI dashboards. I have the full documents and examples from the company who runs the server, I need a programmer to write the API and get it running and working for me.
Paid Social Media Audit
Hello, I'm interested in a paid social media audit for an existing client. Their budget is small so looking for ways to be smart about how to spend effectively. They are a online cake shop based in New York City.
Urgent Website Fix & SQL Server Update
About the Website: www.traduzz.com, built on the WordPress platform, requires urgent troubleshooting and maintenance. The website is facing issues with its WordPress template and requires an SQL server update. Scope of Work: WordPress Template Issue: a. Diagnose and rectify problems with the current template. b. Ensure smooth functionality across all web pages. c. Test and confirm resolution of all template-related issues. SQL Server Update: a. Safely back up the currently active SQL server. b. Create a new SQL server and import the previously backed-up database. c. Ensure the new server integrates smoothly with the website without causing any disruptions or loss of data. Requirements: Proven experience in troubleshooting and rectifying WordPress template issues. Hands-on experience with SQL server updates and database migrations. Must have prior experience working on similar projects and be able to provide references or case studies. Excellent communication skills and the ability to report progress regularly. Must be available for any follow-ups or potential issues post-completion of the project.
Experienced Python Developer Needed
We are currently seeking a highly skilled Python developer to assist in building the backend for our web application. The ideal candidate should have an in-depth understanding of Python, with experience in web application development. Key Responsibilities: - Develop and maintain the Python backend for our web application. Work with Python packaging and server packages, especially asyncio and Flask. - Implement asynchronous and multithreaded programming techniques to optimize performance. Required Skills: - Profound knowledge in Python programming. - Familiarity with Python packaging and server frameworks, particularly asyncio and Flask. - Expertise in asynchronous and multithreaded programming. - Ability to write clean, maintainable, and efficient code. - Experience in integrating backend services with front-end demands. Additional Skills (Preferred, Not Mandatory): - Knowledge of database systems and SQL. - Understanding of front-end technologies (e.g., HTML, CSS, JavaScript) is a bonus. - Experience with cloud services and server management. To apply, please submit your application with a brief introduction, your resume, and a portfolio showcasing relevant projects. As a special note, include the word "Bubble" in your application to confirm that you've read and understood the job post fully.
Migrating website from Windows Plesk server to Linux server
I urgently need someone with strong experience to help me migrate my website from the old host to my new godaddy hosting account. Unfortunately the website is currently down and showing a 403 error, however, I have already downloaded the website backup and SQL database files. I have tried myself but cannot do it because godaddy have stopped offering a shared windows server and I cannot seem to migrate the website from a windows plesk server to a cpanel linux one. The godaddy team advised me they are not compatible. I have tried to convert the files but was not successful.
DevOp SQL - Linux Debian SSH
We are building a financial application whereas you can put money hence our AI works on it through big data and automation. The project is about algorithmic auto-investing trading on world wide's financial market. Fixed Rate Job Paid based on success delivery per country. $10/country. Make about 5-10 API/country for installing python, setting API, SQL for our applications and Google Sheet. You may be given similar code to replicate so you can simply just change some links and few lines. For each country may need API for such as : 1. Historical Data 2. Financial Scrapped Source 3. Financial Summary Scrapped Source 4. Interest rate 5. Some More Required Skill & Experience : 1. DevOps & SQL 2. Familiar with python installing & setting up environments 3. Experienced in Linux Debian & LNMP server by SSH 4. You need to know on how to run python scripts on debian by ssh, and setup cron task on debian, and debugging etc Personality's Criteria : 1. No toxic working environment 2. Agile, Responsive, and Fast Delivery 3. Collaborative as a team 4. Responsible, Credible, Reliable and Integrity person 5. No agency, only direct hiring --- You will be asked to answer the following questions when submitting a proposal: 1. How familiar are you with DevOps, SQL & PHP ? 2. How familiar are you with stock trading and/or financial markets ?
Creating Pivot Table queries and displaying in a grid
I need help with creating Pivot Queries in SQL Server.
Looking to start building an APP with SQL intergration
We are looking to create an electronic Patient Care for app for our ambulance service. Access permissions to the app would need to be managed (9so the log on to it) This would be a multipage form which can then be customised for different locations. The information should then be stored locally for 12 hours before auto erasing (the info should be sent permanently to a secure SQL server which would also require setup.
API Integration with SQL Server. SQL to Sharepoint & Woocommerce
Wondertech is actively seeking a seasoned integration specialist with deep expertise in Microsoft technologies and e-commerce platforms. Our mission is to craft a resilient conduit between a supplier's API (boasting a vast product catalog) and a variety of platforms. We'll initiate with WooCommerce and SharePoint, but our vision encompasses marketplaces like Linio, MercadoLibre, and vTex in the foreseeable future. Key Responsibilities: Design and implement a solution centered around SQL Server to act as the core bridge between the supplier API and diverse platforms. Integrate the SQL Server with the supplier API to ensure real-time data flow and synchronization. Use appropriate tools or scripts (potentially Python) to achieve seamless integration between SQL Server and WooCommerce. Utilize Power Automate to ensure that the API writes to a SharePoint list, capturing the entire inventory and consistently updating it with the current stock levels. Future-proof the platform to accommodate upcoming expansions, notably integrations with marketplaces such as Linio, MercadoLibre, and vTex. Embed robust error-detection, logging mechanisms, and recovery strategies. Undertake rigorous testing to ascertain data accuracy and security across all integrations. Deliver comprehensive documentation detailing the integrations and any bespoke code. Essential Qualifications: Proven track record in integrations leveraging Microsoft technologies, especially SQL Server. Mastery in crafting and tailoring solutions tailored for WooCommerce and SharePoint. Acquaintance with APIs, especially those utilizing token-based authentication mechanisms. Previous experience with marketplace platform integrations is highly regarded. Stellar programming and software development prowess, with proficiency in languages such as Python. Exceptional communication skills paired with a proactive mindset. A meticulous eye for detail and a knack for problem-solving. Application Process: Showcase instances of integrations you've championed, especially those involving SQL Server and E-commerce API (specifically WooCommerce). Narrate a challenge you encountered during a previous integration endeavor and elucidate your strategy to overcome it. Offer a tentative timeline for the integration, grounded in the details provided. Initiate your application with the phrase 'TechBridge' to confirm your thorough perusal of this job description.
Occational wordpress updates - UI Design - Back end development
I am looking for someone I can use occasionally for our increasingly busy web team for some of the design and update work. And also some more complex Back end stuff as listed below Ideally you will have: A firm understanging of PHP and able to code. PHP (Intermediate) Understanding of the WP API (Programatic and Rest state) Wordpress Security (Permissions / Firewalling / Roles) Elementor (Use and develop - with theme Builder knowledge) Basic understand of SMTP for configuring WP to forward Mail (Mandrill) Firm Undertanding of Navigating SQL and MySql Databases and Servers Understand and able to troubleshoot Nginx and Apache issues (Server side)