Sql Server New York City Projects
Looking for freelance Sql Server New York City jobs and project work? PeoplePerHour has you covered.
opportunity
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 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.
2 days ago37 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
5 days ago22 proposalsRemote
Past "Sql-server-new-york-city" Projects
SQL Server Database Migration
I'm in need of an experienced professional who can assist me in transferring a large-scale database. Key requirements include: - Proficiency in handling and transferring databases, specifically SQL Server. - Experience in migrating large databases, in this case, exceeding 10GB. - Demonstrated knowledge in handling data and ensuring its integrity. - Ability to ensure smooth transfer with minimal downtime. Your role will involve transferring selected data safely, efficiently and without data loss. Prior experience with similar projects is highly advantageous.
Create 3 Concepts for Combining 2 Side-by-Side NYC Apartments
I am combining two side-by-side apartments in Manhattan, New York City. I need an architect and/or interior designer to create 3 different floor plan concepts/options for the new, combined floor plan. I have attached the as-built/existing 2D floor plans which include a prioritized list of improvements (from most to least important) and list of constraints. The core deliverable should consist of 3 different 2D floor plans that achieve the improvements while working around the constraints. I'm looking for multiple ideas so I can focus on the elements that really matter to me. In a future phase, we'll pick one concept and develop it further. I support the work of experienced architects and designers. ** AI-created deliverables will NOT be accepted or approved. ** 3D views are not required but are a plus and I can provide a rough Matterport-like video of the existing spaces for reference.
Compile NYC Art Dealer List + Format for Mailing Labels
We are seeking a diligent and detail-oriented individual to compile a comprehensive list of art galleries and dealers located in New York City. The chosen candidate will be responsible for conducting thorough online research to identify galleries and dealers, collecting pertinent information such as addresses, contact details, and any additional relevant data, and organizing this information into a structured spreadsheet. Key Responsibilities: 1. Conduct extensive online research to identify art galleries and dealers in New York City. 2. Gather accurate and up-to-date information including addresses, phone numbers, email addresses, and contact names (if available). 3. Enter collected data into a spreadsheet with meticulous attention to detail and consistency. 4. Ensure the accuracy and completeness of the compiled list. 5. Format the collected data for mailing labels in accordance with provided instructions. Requirements: 1. Demonstrated proficiency in online research methods. 2. Strong data entry skills with a keen eye for accuracy. 3. Excellent organizational abilities to manage and categorize gathered information effectively. 4. Proficiency in Microsoft Excel or Google Sheets. 5. Effective communication skills to clarify any requirements and provide regular updates on progress. 6. Ability to work independently and meet strict deadlines. This project must be completed within one week from the start date. The successful candidate will have the opportunity to contribute to a key aspect of our marketing efforts and play a vital role in our outreach to art galleries and dealers in New York City.
Wordpress Plugin Errors
I recently upgraded the PHP on my server and now a couple of plugins have errors. I'm looking for someone with experience working with Wordpress plugins, PHP, sql and databases.
Data Scraping
I need an Excel file of the website URLs of all test preparation companies, listed in Yelp for the 387 metropolitan areas listed under the Rankings heading at https://en.wikipedia.org/wiki/Metropolitan_statistical_area. For example, in the St. Louis metropolitan area, Yelp lists 52 companies at https://www.yelp.com/search?find_desc=Test+Preparation&find_loc=Saint+Louis%2C+MO&start=50. You will need to click the "Test Preparation" button that appears just below the company name to filter the list to only companies that offer that service. You will need to click the company name and then copy the company website link on the right side. I don't know how many websites there are for all 387 metropolitan areas so I will pay $25 for each set of 1,500 URLS. When you have finished with the first set, I will contract with you for another set and so forth until all the URLs have been listed. Please start at the top of the list of metropolitan areas with New York-Newark-Jersey City and work down the list from there.
opportunity
Datatables.net (server-side), ASP.NET, VB, MS SQL
I have a requirement for a "simplified" version of an ASP.NET in VB page (default.aspx, default.vb) that: 1. Uses DATATABLES.NET with a repeater as the container for the data 2. Uses SERVER-SIDE processing in datatables.net with pagination, search, and sorting 3. Uses SQL Server to store the data (can use Northwind data as sample) 4. Uses (assuming) an .ashx Handler to manage/call/retrieve data from SQL in JSON
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
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
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.
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
Need help exporting database from sql server in windows
I am in need of assistance with exporting a MySQL database from SQL Server in a Windows environment. I am looking for a skilled freelancer who has experience with database management and SQL Server. Skills and experience required for this project: - Proficiency in SQL Server and MySQL - Knowledge of database export and import processes - Familiarity with Windows operating system - Experience with SQL Dump file format Project requirements: - Export the entire MySQL database from SQL Server - Ensure all tables and data are included in the export - Use the SQL Dump file format for the exported database Please note that I do not have any specific tables or data that need to be included in the export. The freelancer will be responsible for exporting all tables and data from the MySQL database. If you have the necessary skills and experience for this project, please submit your proposal. Thank you
Fare Calculator
Platforms: Asp.net, JavaScript, MS SqlServer, Google Services (required for the project). Develop a web application to calculate fares between pickup and drop-off locations using ASP.NET, JavaScript, MS SQL Server and Google services. The application will have three views using a MultiView control. The first view allows users to search for a pickup address using Google Autocomplete and verify the address. The second view searches for a drop-off address. The third view displays the pickup, drop off, total distance, estimated journey time and calculated fare. Fare calculation will be based on distance and a predefined rate structure. Both addresses will be searched and verified using Google Autocomplete restricted to UK addresses. The application aims to provide users with a simple and accurate way to obtain fare estimates for trips within the UK. The project will be assigned to the lowest quotation offered.
opportunity
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 and criteria : 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. 4. Agile, fast delivery, and responsive 5. Integrity, Honesty, Independently initiative, responsible, straight forward, loyal, modest, discipline, emphatically fair, hard worker. 6. No toxic working environment. We will pay $20-50/countries (negotiable) but we may fund more milestones for some few extra works. Possibly to double or tripple payments as bonus for urgent 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. SKILL : Google App Engine Google APIs Google Apps Scripts Google Systems
Cold Calling & Follow-up Data Entry
We are looking for a motivated individual with excellent communication skills and a knack for research to join our team as a Construction Project Lead Researcher. In this role, you will be responsible for conducting cold calls to a list of construction projects in New York City and Birmingham to collect information on the name and contact person of the individual or company to whom a project has been awarded. This data will be crucial for our sales team to follow up and capitalize on potential business opportunities. Key Responsibilities: Conduct cold calls to construction projects in New York City/ Birmingham to gather information on project leads. Identify and document the name and contact details of the individual or company awarded the project. Maintain accurate and up-to-date records of all leads and project information in our database. Collaborate with the sales team to ensure seamless follow-up and engagement with prospective clients. Provide regular updates and reports on lead generation activities and progress. Qualifications: Previous experience in cold calling or lead generation preferred. Strong communication and interpersonal skills. Excellent attention to detail and ability to gather accurate information. Ability to work independently and efficiently manage time and tasks. Familiarity with the construction industry and project management processes is a plus. Proficiency in Microsoft Office and CRM software. Benefits: Competitive salary with performance-based incentives. Flexible remote work options, MUST BE AVAILBLE TO WORK EST USA TIME ZONE/ UNITED KINGDOM Opportunity for growth and advancement within the company. Comprehensive training and support provided. How to Apply: If you are a proactive and results-driven individual looking to join a dynamic team in the construction industry, we want to hear from you! Please submit your resume and cover letter outlining your relevant experience and why you are the ideal candidate for this position to [contact email or link to application portal]. Empire Fire Alarm Specialist is an equal opportunity employer and values diversity in the workplace. We encourage individuals from all backgrounds to apply.
I need over 2500 email addresses
I need over 1000 email addresses of Art Gallerys based in the uk 500 new york city please 1000 in European cities thanks karl
London eBook - Freelancer Required
Who we are We are TheSqua.re Serviced Apartments, a marketplace of global accommodation that has been operating for 10+ years. With over 500,000 apartments listed, we offer premium serviced apartments in economic hubs like London, Paris, New York, Tokyo, San Francisco, Singapore, Hong Kong, Zurich, Amsterdam, Frankfurt and many more. But what is a serviced apartment? When renting a serviced apartment, you get the entire apartment space. This means more space, more privacy and a more comfortable accommodation experience. Throughout our history, we have won several awards for innovation in technology and product. About the Project We are looking for an experienced content writer to work with on a project by project basis. This particular project will be to work collaboratively to create a stunning, engaging and well crafted multimedia eBook. The project will encompass a broad range of topics that are designed to give people relocating to London knowledge of the city before they arrive in the city. The candidate will be writing content only. Requirements: Must have experience living in London Experience interviewing different people. 4+ years content writing experience Worked on publishing books is desirable, but not necessary Knowledge of SEO Attention to detail Creative and Innovative Strong research skills
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.