Sql Server Saudi Arabia Projects
Looking for freelance Sql Server Saudi Arabia jobs and project work? PeoplePerHour has you covered.
PHP SQL - Linux Debian SSH - DevOp Server Code Maintainer
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 SQL for our applications and Google Sheet. 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. Php & 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 ------ I'm looking for a skilled DevOps professional who can help in maintaining my server code. As the DevOps server code maintainer for this project, you will be responsible for: - Server Configuration and Setup: Ensuring the smooth operation of our Linux Debian SSH server. - Code Deployment and Version Control: Managing our PHP and SQL code deployments, including version control. - Monitoring and Troubleshooting: Monitoring the server's performance, and troubleshooting any issues that may arise. The ideal candidate should have experience with PHP, SQL, Linux Debian SSH, and possess sufficient DevOps expertise to effectively maintain and optimize our server.
4 days ago14 proposalsRemoteopportunity
User portal
We sell a device which uploads data via cell network. We want to develop a user portal that provides access to the data. Preferably the database would be SQL Server on an AWS platform in USA. We have users that require data security. Phase 1 is replicating an existing platform. This is a new project, we do not wish to reuse existing code. Phase 2 is a series of functionality improvements. Phase 3 is providing insight/AI across the data. The data will be viewed via a web portal. We may consider an app at a later date.
4 days ago57 proposalsRemoteopportunity
MySQL Query Optimization for Charity Website
We are seeking an experienced MySQL developer to analyse and optimise slow SQL queries for our website hosted on a shared server environment. Our monitoring has identified a significant number of slow queries that are adversely affecting server performance and website loading speeds. Background: During routine server monitoring, we discovered that our website is generating slow MySQL queries that are consuming extensive CPU and memory resources, leading to a degradation in performance. Scope of Work: Analysis of Slow Queries: Review the log file located at (****) containing 1,181 slow queries. Identify key factors contributing to the slow performance. Optimise the top 10 slowest queries, which have execution times ranging from 29.1 to 44.1 seconds. Implement query restructuring and indexing strategies to reduce execution time. Testing and Validation: Test the optimised queries to ensure they meet performance improvements. Validate that changes do not negatively impact the functionality of the website. Reporting: Provide a comprehensive report detailing changes made, before and after execution times, and any recommendations for further improvements. Deliverables: A detailed report of analysis and optimisations performed. Implementation of query optimisations in the live environment. Final validation report showing performance improvements. Timeframe: The project needs to be completed within three days of commencement. Selection Criteria: Proven experience in MySQL and database performance tuning. Ability to work efficiently under tight deadlines. Previous experience with high-traffic websites on shared servers is preferable.
12 days ago35 proposalsRemoteQAD MFG PRO Programmer
I seek a highly skilled QAD MFG PRO programmer with extensive experience developing business applications and maintaining the .NET version environment. The ideal candidate will possess a deep understanding of QAD's architecture and capabilities. This intermittent work involves creating solutions to streamline operations and improve workflow efficiencies. Past projects include developing an inventory management module to optimize production planning and building an order tracking system to enhance customer service. The programmer should be well-versed in QAD's development tools like MFG/PRO IDE, SQL Server. Responsibilities writing code, testing, debugging, and documenting. The ability to troubleshoot complex issues independently and find innovative solutions is important. Experience working with multinational clients and handling varied timelines and priorities is preferred. This is a flexible role where the selected programmer will work remotely on an as-needed basis. The goal is to leverage your expertise to help changing business needs through customized QAD solutions. If you have a proven track record of delivering high-quality work on schedule, please indicate your hourly rate and availability. I look forward to reviewing your qualifications and experience.
a day ago7 proposalsRemoteopportunity
Database Administrator / Back-end Developer Required
Hi, I am looking for a Database Administrator / Back-end Developer to complete the given below requirements: Scenario: 1. The store is based on Magento 2.4.6-p3 with all necessary server requirements such as Nginx 1.22, MariaDb 10.6, Varnish cache 7.3, php 8.1, Composer 2.2, Elasticsearch 8.5, MySQL 10.6, RabbitMQ 3.11, Redis 7, etc. 2. The website is hosted on CCX53 on Hetzner Cloud: 32 CPU, 128 GB RAM (dedicated resources) Here are the details of the products present in the database: 1. The store has 320 million products in 411 GB database. There are no product attributes, or variables. Just simple products. 2. There are no product images 3. Each product is a company information page i.e. the products are digital and it provides information on companies globally. I will share the sample product page link once you submit your proposal. Magento Modules Installed and configured: 1. Amasty Elasticsearch: https://amasty.com/elasticsearch-for-magento-2.html 2. Amasty Google Speed Optimiser Pro: https://amasty.com/google-page-speed-optimizer-for-magento-2.html 3. Amasty Varnish Full Page Cache Warmer: https://amasty.com/full-page-cache-warmer-for-magento-2.html Requirements: 1. Import the product database of 411 GB database. I will provide the database in SQL format. 2. Optimise the Elasticsearch and page load 3. We expect 100 concurrent users anytime throughout the day 4. Elasticsearch should index all the products 5. Optimize website performance. Current score on Google page speed insight is 47 on mobile and 83 on Desktop. 6. Product search result should be less than 3 seconds 7. Suggest if the job requires server change
10 days ago24 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.
25 days ago23 proposalsRemote
Past "Sql-server-saudi-arabia" Projects
Host Equipment in Saudi Arabia
You must live in Saudi Arabia Your responsibilities for this project, once the equipment is set up, will be very minimal (e.g. carrying out small tasks like resetting our phones and purchasing sims, making sure the phone is online for us to connect remotely etc.) It's a great way to earn some passive income. We pay a monthly fee of 100 USD. You would be hosting 1 android phone. We work alongside a compliance company that monitors mobile ads around the world for mobile operators (like Orange, Tigo, Express, Zain, etc.) and content providers, in other words, we check ads on phones and make sure they are compliant. We make sure that our clients are following the correct norms and regulations in the countries they publish their ads. We achieve this by connecting remotely to phones located where our clients are publishing their ads in this case in Saudi Arabia. If you would like to join our growing community of equipment minders fill the following form and let us know. https://forms.gle/PTrmJnJxygLwt6Yv5 (We are preferably looking for staff who have a Samsung phone that they are not using, as we need these devices for our work operations. However, if you don't have one we can provide you with a device)
featuredopportunity
I need an Argo Workflow template
I need someone that can create an argo workflow template in YAML format to call a bunch of SQL Stored Procedures in parallel and some sequential. The DB user credentials should be parsed as a secret in the template. First Step is a schedule to check if its end of day ie time of day, timzone, 7 days of the week. if time is correct, proceed to the second step else stop Second Step stop services - argo command to call sql stored procedure services stopped ? yes continue else fail Third Step take backup - argo command to call sql stored procedure. (run parallel, 2 sql servers) stored procedure completed OK ? yes continue NO fail Fourth Step indexing -argo command to call sql stored procedure (run parallel, 2 sql servers) did indexing complete OK ? yes continue NO fail Fifth Step Start services - argo command to call sql stored procedure did services start OK ? yes End else fail This template should be parametized so i can add in the actual Stored Procedure Names, timezone format etc. PAYMENT: 50% UPFRONT NO PAYMENT DURING TESTING 50% UPON COMPLETION AND FINAL TESTING BY ME Duration: 1 - 2Days Any questions, please let me know. thanks
5171 error on a SQL database MDF
Need specialist help in recovering a damaged MDF sql server database file reports following error:- Msg 5120, Level 16, State 101, Line 1 Unable to open the physical file "C:\sqldata\centralnew". Operating system error 2: "2(The system cannot find the file specified.)". Msg 1802, Level 16, State 7, Line 1 CREATE DATABASE failed. Some file names listed could not be created. Check related errors. Msg 824, Level 24, State 6, Line 1 SQL Server detected a logical consistency-based I/O error: incorrect checksum (expected: 0x8102d26d; actual: 0x5ac8c0d8). It occurred during a read of page (0:0) in database ID 0 at offset 0000000000000000 in file 'C:\temp\centralnew.mdf'. Additional messages in the SQL Server error log or operating system error log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online. Completion time: 2024-05-14T10:29:33.7523353+01:00
Re-write my CV and provide cover letter. Construction industry.
Re-write my CV and provide cover letter. Need within a few days if possible. For Director level role in the construction industry. I'm applying for jobs in Saudi Arabia, in roles such as Managing Director. Project Director or other similar roles.
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.
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.
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.
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
Website 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
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.
wholesale suppliers jewelry accessories in Saudi Arabia
I need to search for wholesale suppliers of China jewelry accessories in Saudi Arabia As long as it is wholesale price and available in Saudi Arabia in quantities above 100 pieces per model, As long as it's a necklace, bracelet, ring... and costs less than 15 SAR including the box Better if you can add me to the supplier's telegram or whatssapp group to easily view the products, thank you please share 1 sample with your proposal
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