Sql Server Los Angeles Projects
Looking for freelance Sql Server Los Angeles 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
6 days ago23 proposalsRemote
Past "Sql-server-los-angeles" Projects
SEO Expert - 2 Projects - Cleaning Business and Nanny Business
Hello, I am looking for an SEO Expert for 2 projects - This will be long-term, this is a startup, and there will be growth. You must have real experience in ranking google local listings, and local keywords. 1. Residential/Commercial Cleaning Business - Site is almost done, but keywords will be targeting in cities of San Diego, and San Jose area. Best residential cleaners CITY, Commercial cleaning CITY, etc Competitors: www.elitecleaningservicesgroup.com https://www.myacleaningservice.com/ https://www.losangeleshousecleaners.net/ 2. Nanny Business - Site is live Areas, san diego, and all of southern california such as los angeles, orange county, etc Competitors https://sandiegonannyagency.com/ https://www.lovingnannies.com/ https://seasidestaffingcompany.com/
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.
GoDaddy Website
Hello my name is Wilm from Los Angeles US. I need a website for my wife . She is a Hair Stylist. I order already the Domain Name TheHavenAtelier.com. In the past I designed already some website but I like to try something NEW. For content I need just upload video and social medias An online store will be nice with payment solution. Not big maybe 100 items. Perhaps a space where I could upload some Promotion Flyer . She has not many time for working on the website. So I have to do that ! But I want put some new staff inside that it. Very clean, fancy, classy style without big issues. Please let me know if you have time and what will be the cost for the design. If you have some example what you already created as example it would be wonderful. Thank you so much Best, Wilm
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)
Replication DB
I am looking for a freelancer to assist me with a replication database project. The purpose of the replication database is to enable synchronization across multiple databases. I prefer the replication to be done using SQL Server as the database management system, and the size of the database will exceed 10GB. The successful candidate will need to be experienced in working with databases of this size and in using the specified systems. The ultimate goal is the creation of a reliable, secure database that is able to store and protect the data I provide – and keep them up to date across all databases.
Guest Post Or PR Publication on High END websites
I am looking for a Guest Post or PR Publication on High-End Websites. Could you share the sample of the following sites: 1- BusinessInsider.com 2- CNN, 3- Times Magazine 4- INC 5- Huffington Post 6- Entrepreneur, 7- NY Times 8- Los Angeles Times 9- Yahoo Finance 10- Bloomberg 11- Fox 12- NBC Please feel free to suggest your websites too. I am also open to all high-end websites. Warm Regards, Muteeb
Database analyst
We are currently recruiting for an experienced Database Analyst. As a successful candidate, you will be responsible for database support and analytics, integration management and creating & maintaining dashboards. You have in-depth experience with database management Systems, BI software, SQL Server, and solid ability in integrating, analyzing, interpreting, reporting, and disseminating data. This role is located in Edmonton, AB., and does have hybrid working permissions (work form office/work from home) for eligible candidates.
opportunity
Create front end from a SQL database which sits on our server
Hi. We currently have an access database thats split into a front end and a back end. I've migrated the back end to SQL 2019 so its more stable and easier to backup. The project is the creation of a very simple front end that's usable. This could be hosted on browser or desktop.
Manage SQL Server databases
I am looking for a professional with experience in managing SQL Server databases. The ideal candidate should have the following skills and experience: - Proficiency in SQL Server 2019 - Expertise in both database development and administration - Experience working with databases ranging in size from 1-5GB The main responsibilities of this project include: - Monitoring and maintaining the SQL Server databases - Implementing database changes and optimizations - Troubleshooting and resolving database issues - Ensuring data integrity and security - Collaborating with other team members to develop and deploy database solutions If you have the necessary skills and experience, please submit your proposal.
Senior PowerBI developer with Azure
I am in need of a skilled developer who has experience working with Microsoft technologies, specifically SQL Server analytical services, DAX queries, and PowerBI. The project is of advanced complexity, so I require someone with expertise in handling complex tasks. Additionally, the developer should be proficient in resolving issues in complex queries. Ideal skills for this job include: - Strong knowledge of SQL Server analytical services - Proficiency in writing and optimizing DAX queries - Expertise in PowerBI and its various functionalities - Experience in resolving issues in complex queries - Familiarity with Azure functions and pipelines would be a plus. We can offer longterm contract based on the skillset and experience --- People from Visakhapatnam are given first preference
Help moving a Python/Flask web application from PC onto a Server
Can you help us? We have developed a Python/Flask website application on our PC and it is working. We are now trying to install it on a server. On our shared servers, we have hit and issue related to the database script timing out and not being allowed to change it. So unless the sql database is refreshed every 60 seconds the data doesn’t appear on the page. We have been advised that we needed a VPS/dedicated server. So we got one. We could then change the timeout but the Cpanel was completely different and we were told that instead of using the pythonapp we needed to use the command prompt. The support then went down the drain taking 48-72 hours to come back and say “No”. Can you help us get this application onto a server and up and running? David