Microsoft Sql Server Administration Projects
Looking for freelance Microsoft Sql Server Administration jobs and project work? PeoplePerHour has you covered.
opportunity
IoT Data Sharing & Module Management
I need a system for an IoT-based project in which a WiFi module will share data to an SQL server. This needs to function within a SAAS environment with subscription per device. Main features include: - Admin and User Modules - Managed subscriptions per device - Real-time data alerts In the Admin Module, the following functionalities should be available: - User Management: Admin can manage and monitor users - Device Permissions: Admin can determine how much data a user can view - Monitor Device Data: Admin can view data from all devices - Payment Module: Ability to process transactions For the User Module, users should be able to: - View specific device data as permitted by the administrator - Receive alerts via data changes - Make payments for their subscriptions The ideal freelancer would have experience with IoT systems, SQL databases, and User Management design. They should also be well-versed with SAAS environments and have handled projects which required real-time data alerts in the past. A strong background in payment gateway integration will also be a major plus.
4 hours ago3 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.
a day ago32 proposalsRemoteJoint / Guided AZURE Server Deployment
I need to set up a simple enterprise AZURE server to host a server-side Google Tag Manager (GTM), and need someone who is an absolute "boss level" Azure admin to help me with this. Experts with Microsoft Azure enterprise development required. You must be very conversant with Azure, have set up server instances with scaling, security, health checks etc. for large enterprises with complicated security requirements, and ideally know how to write up detailed requirements specifications and plan server architecture. IMPORTANT NOTE: You will not be given any access. All work will be done by me, with you on a Teams call with sharing screens, where you will guide me. First part of the project will be to write up the detailed spec and setup plan. Second part will be the actual setup. Work will be done side-by-side, with you assisting me with setup and testing environments. This will be a one-off project, but will most likely lead to an on-going programme over a number of months, with the right person. You will not be given direct access to the Azure environment, but will view my screen and tell me how to set up. This is very important. The average time for the first part is expected to be around 20 hours, and the expected on-going monthly project time requirement will average 2 hours per month.
9 days ago15 proposalsRemoteCanva Xibo AWS Integration
I have an existing Canva account and am looking to seamlessly integrate it with my Xibo digital signage system. My primary goal is to have the Canva designs automatically update in Xibo, ensuring that the latest content is consistently displayed on the screens. Key requirements: - Integration between Canva and Xibo: The freelancer should be able to connect Canva with Xibo, allowing for an automated update process. - AWS and Linux server management: Experience in managing AWS and Linux servers is a plus, as the Xibo system is self-hosted on an AWS Ubuntu server. We are getting this error when try to integrate: {“error”:0,“message”:“API configuration problem, consult your administrator”} We need the solution to be documanted and step by step to resovle it in future. Ideal skills and experience: - Proficiency in Canva and Xibo: The freelancer should have a deep understanding of both platforms to facilitate a smooth integration. - Experience in API integration: Knowledge of APIs is crucial for creating a connection between Canva and Xibo, allowing for real-time updates. - AWS and Linux server management: While not mentioned in the initial questionnaire, experience in managing AWS and Linux servers will be beneficial for ensuring the integration runs smoothly. The project entails creating a robust connection between two platforms and ensuring that the integration is set up for automated updates. A freelancer with a keen eye for design, strong technical skills, and experience in API integration would be ideal for this project.
14 days ago13 proposalsRemoteEXECUTIVE IT SUPPORT
The Executive Support Engineer will be responsible for supporting the Executive team with their current technology needs, in addition to identifying and implementing new technologies to support their productivity and efficiency. The successful candidate will possess a combination of interpersonal and communication skills and an aptitude for working with applications, systems, and hardware to find resolution for executive user problems. This role will also be responsible for training and creating executive-style documentation. Participation in projects and proof of concepts will be required to ensure executive business requirements are properly met. Responsibilities Provides technology support for executives and their administrative staff. Educates executives on the efficient use of their technology. Monitor and perform IT equipment refreshes for executives using standard refresh and build processes. Provides executive video conferencing assistance. Coordinates with Enterprise IT on new application training when necessary. Maintains device spares and/or parts as required (phones, chargers, etc.). Coordinates spare equipment alternatives for traveling executives. Create and maintain system documentation, user guides, standard operating procedures. Coordinates support escalations to 2nd and 3rd tier technical teams. Assists company leaders with technical needs in preparation for executive meetings. Other Duties Provides scheduled on-call 24x7 system and executive support as required. Performs other duties and/or projects as assigned. Knowledge, Skills and Abilities Exceptional customer service skills. Excellent communication and interpersonal skills. Ability to work independently as well as in a team environment. Ability to work in a fast-paced environment. Positive, flexible, and self-motivated attitude. Detail-oriented with excellent follow-up skills. Excellent organizational skills with the ability to manage time and multiple priorities. Strong analytical and problem-solving skills. Ability to maintain confidentiality of highly sensitive information and materials. Ability to understand new materials quickly and apply new information, concepts, and procedures in a constructive manner. Ability to effectively manage high stress, demanding situations. Knowledge of hardware and software platforms, including: Desktops, laptops, printers, peripherals, Windows 10, Active Directory, Microsoft Office 365 and mobile devices (iPhone/iPad, Android). Demonstrated proficiency in using the Microsoft Office suite of applications including Microsoft Project, Visio, PowerPoint, Word, Outlook, and Excel Qualifications Bachelor's Degree or equivalent experience and/or education required. 2+ years experience in an IT support role supporting senior-level executives required. 3+ years broad experience working with a variety of different technology platforms, inclusive of hardware, software, desktop and networks required. Experience supporting a wide-variety of hardware and software platforms, including: Desktops, laptops, printers, peripherals, Windows 10, Mac OS, Active Directory, Office 365 and mobile devices (iPhone/iPad, Android) required.
3 hours ago7 proposalsRemoteOnline Administrative Assistant
We seek an experienced online administrative professional to seamlessly support our virtual business operations. Remote collaboration and multitasking acumen are necessities for managing communications across channels, compiling research, entering financial data, creating presentations and spreadsheets, scheduling conferences, assisting customers, and performing general tasks as assigned. An organized self-starter proficient in Microsoft and Google Suites who reliably meets deadlines is ideal. Applicants should demonstrate proven experience in virtual roles with strong communications and organization/time management capabilities. Bachelor's degree or comparable experience preferred. Prioritization of client service and digital literacy are highly valued.
19 days ago49 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
24 days ago23 proposalsRemoteEXECUTIVE TECHNICAL SUPPORT ANALYST
The Executive Technical Support Analyst is responsible for providing technical on-site and remote support to the Executive Leadership Team and their Executive Assistants. The ideal candidate is a self-starter with exceptional problem-solving skills, able to implement solutions with little or no guidance, and can maintain composure in high-stress situations while delivering extraordinary customer service. Essential Duties Include, but are not limited to, the following: Deliver technical “White Glove” response to Executives and their assistants to ensure all their IT needs are addressed in a timely manner. Provide a high level of support through problem solving, listening, and having an exceedingly high level of customer service. Deliver tailored solution engineering to all requests made by Executives and their assistants. Make house calls to assist Executives with home office, networking, AV implementation, and other technical setups. Work with Executive Assistants to support IT initiatives for Executive needs, including travel and other offsite engagement. Provide A/V Support for Executive meetings, including presentation setup and video conferencing. Proactively manage new deployments and technology to the Executives, ensuring little to no disruption. Interact with IT functional groups and establish relationships cross-functionally to drive escalations to closure. Generate weekly and monthly reports for Executive Leadership liaisons regarding customer support issues. Maintain confidentiality and privacy in all dealings with Executives and their data. Assist with coordination of vendors and external repair/service technicians. Be present and available during work hours in professional attire with a manner and attitude acceptable to Executives. Uphold company mission and values through accountability, innovation, integrity, quality, and teamwork. Support and comply with the company’s Quality Management System policies and procedures. Maintain regular and reliable attendance. Ability to act with an inclusion mindset and model these behaviors for the organization. Ability to perform duties after hours via an on-call basis Ability to work designated schedule. Ability to work nights and/or weekends as needed. Ability to work overtime, as needed. Ability to work on a mobile device, tablet, or in front of a computer screen and/or perform typing for approximately 90% of a typical working day. Ability to work on a computer and phone simultaneously. Ability to use a telephone through a headset. Ability to work seated for approximately 80% of a typical working day. Ability to work standing for approximately 20% of a typical working day. Minimum Qualifications Bachelor’s degree in a field as outlined in the essential duties; High School Diploma or General Education Degree (GED) and 4 years of experience in a related field; or Associates Degree and 2 years of experience in a related field. 4+ years of overall IT experience, including direct support with c-suite level leaders, senior leadership, or other high level decision makers. Excellent verbal and written communication skills. Advanced proficiency with Windows, MacOS, iOS, and Zoom videoconferencing in a business environment. Demonstrated ability to navigate stressful situations with tact and poise. Demonstrated ability to present ideas in user-friendly, business-friendly, and technical language. 2+ years of experience using and troubleshooting Outlook within a network environment (i.e., permissions, calendar sharing, delegation, etc.). 2+ years of Incident Management experience; including business expectations and company- communications. 2+ years of experience working with Microsoft based operating systems, with emphasis on Windows 10 and O365 suite of applications. 1+ year of experience with OKTA end-user administration or relevant technology. Professional working knowledge of active directory, creating user accounts, resetting passwords, creating groups, and security group administration. Proficient with Audio/Video technologies. Strong grasp of basic security principles and practices as it pertains to a business environment. Demonstrated ability to perform the essential duties of the position with or without accommodation. Authorization to work in the United States without sponsorship. Preferred Qualifications Apple, Microsoft Certified Professional, Microsoft Technology Specialist or equivalent technical certification. ITIL V3 or V4 Foundation certification or equivalent experience. HDI training and certification. Experience using ServiceNow for IT Service Management. Experience supporting remote employees. Experience in healthcare or biotechnology. Microsoft SCCM and Windows 10 expertise.
3 hours ago9 proposalsRemoteEducation Admin support
We are a small team of Healthcare Professionals offering a 1-yr Certificate Programme in Psychedelic Practice. This is aimed at Healthcare Professionals worldwide. We will likely be expanding to offer other courses over the coming years(s) Website: https://www.psyedu.co.uk/ Our current Education Admin Lead is leaving in May. We need someone to work flexibly around 3-6 hrs a week (10-20hrs per month) doing basic administrative tasks for our Education Organisation. It will be very busy between June and September (more like 6hrs per week) then will calm down a bit at other times in the year. We are a small start-up in our second year, just beginning to settle into our rhythm and we now need reliable low-level input which will likely slowly increase in workload over the next 3-5yrs. Job Description Skills/knowledge: MUST HAVE: Excellent written and spoken English, Organisational Skills +++, Microsoft office, excellent written and spoken communication skills, an understanding of the course we offer or a willingness to learn about it DESIRABLE: some knowledge of healthcare and how psychedelic practice is starting to be used in healthcare Qualities: flexibility Experience: any role which demonstrates the capacities outlined below Hours: 10-20hrs per month, ideally 1-2hrs on Mon, Wed and Fri each week Job Description: Key Responsibilities: 1. Communication Management: o Serve as a primary point of contact for internal and external communications. o Handle incoming emails, and redirect them as appropriate. o Draft and distribute notices, tutorials, open events and announcements. 2. Administrative Support: o Assist in scheduling appointments, and meetings for management and staff. o Maintain and update company databases, records, and filing systems. o Prepare and distribute documents as required. o Liaising with different organisations 3. Documentation and Recordkeeping: o Ensure accuracy and completeness of documents, contracts, and agreements. o Maintain confidentiality of sensitive information and handle it with discretion. o Organize and archive records in accordance with company policies and regulatory requirements. 4. Team Collaboration: o Collaborate with colleagues and departments to support cross-functional projects and initiatives. o Provide administrative assistance to various teams as needed. o Foster a positive and cooperative work environment through effective communication and teamwork. o Attending meetings once every two weeks 5. Problem Solving and Decision Making: o Identify issues or challenges in administrative processes and propose solutions for improvement. o Prioritize tasks and manage time effectively to meet deadlines and goals. Qualifications and Skills: · Proven experience as an Administrator or similar role. · Proficiency in office software applications, including word processing, spreadsheets, and presentation software. · Strong organizational and multitasking skills with attention to detail. · Excellent verbal and written communication abilities. · Ability to work independently and collaboratively in a fast-paced environment. · Discretion and professionalism when handling confidential information. · Problem-solving and decision-making skills. · Flexibility and adaptability to changing priorities and tasks.
25 days ago47 proposalsRemoteADMIN ASSISTANT REQUIRED IN LONDON
Job Description: As the Admin Assistant, you will be responsible for coordinating and managing some aspects of the leasing process for our properties. This includes advertising available units, conducting property tours, screening potential tenants, and managing move-in and move-out processes. Key Responsibilities: Conduct property tours for potential tenants and provide information on the property and its amenities Communicate with tenants to address any questions or concerns they may have during the leasing process Screen potential tenants by conducting background and credit checks Ensure all necessary documents are completed accurately and in a timely manner Coordinate move-in and move-out processes, including conducting unit inspections and managing security deposits Maintain accurate and up-to-date records of all leasing activities Advertise available units through various channels, such as online listings and local publications Stay up-to-date on local rental market trends and adjust rental rates accordingly Assist with other administrative tasks as needed Requirements: Previous experience in leasing or property management is highly desirable Strong organizational and time-management skills Excellent communication and interpersonal skills Proficiency in Microsoft Office and property management software Ability to work independently and as part of a team Knowledge of local rental market Attention to detail and ability to multitask in a fast-paced environment. P.S. Only Freelancers within the UK should apply
23 days ago8 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.
15 days ago22 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
24 days ago30 proposalsRemoteAmazon Account Manager (WORK EXPERIENCE WITH AMAZON REQUIRED)
Company Overview ChannelClan is a dynamic and rapidly growing e-commerce company specializing in Amazon sales. We pride ourselves on delivering high-quality products and exceptional customer service to our clients. As we continue to expand our online presence, we are seeking a dedicated and experienced Amazon Account Manager to join our team. Job Description The Amazon Account Manager will be responsible for overseeing and optimizing our presence on the Amazon platform. This individual will play a critical role in driving sales, managing inventory, and enhancing our brand visibility on Amazon. The ideal candidate will have a strong understanding of e-commerce best practices, excellent communication skills, and a proven track record of success in managing Amazon accounts. Key Responsibilities - Manage all aspects of our Amazon seller account, including product listings, inventory management, pricing strategies, and promotions. - Monitor and analyze sales performance, traffic metrics, and customer feedback to identify opportunities for growth and improvement. - Keen eye for administrative processes, e.g., inventory management and reimbursement management of lost and damaged FBA stock. - Co-develop and implement strategies to increase product visibility, drive traffic, and improve conversion rates on Amazon. - Assist optimizing product listings with compelling copy, high-quality images, and relevant keywords to enhance search visibility and attract customers. - Stay up-to-date on Amazon’s policies, guidelines, and algorithms to ensure compliance and maximize performance. - Collaborate with cross-functional teams, including marketing, sales, and operations, to align Amazon strategies with overall business objectives. - Respond promptly to customer inquiries, feedback, and reviews on Amazon to maintain a positive brand image and customer satisfaction. - Conduct competitive analysis and market research to identify trends, opportunities, and potential threats in the e-commerce landscape. - Work closely with third-party vendors, suppliers, and logistics partners to ensure smooth operations and timely fulfillment of orders. - Generate regular reports and insights on Amazon performance, including sales trends, inventory levels, and key metrics, to senior management. Qualifications - Bachelor’s degree in business, marketing, e-commerce, or related field. - Proven experience managing Amazon seller accounts and driving sales growth in an e-commerce environment. - Strong analytical skills with the ability to interpret data, identify trends, and make data-driven decisions. - Excellent written and verbal communication skills, with the ability to effectively communicate with internal teams and external partners. - Detail-oriented with strong organizational and project management skills. - Proficiency in Microsoft Excel and other data analysis tools. - Knowledge of Amazon Seller Central and e-commerce analytics tools (e.g., Helium10) is required. - Knowledge of Amazon Vendor Central is a plus, or willingness to learn to use this platform. - Ability to thrive in a fast-paced, entrepreneurial environment and adapt to changing priorities.
a month ago24 proposalsRemote
Past "Microsoft-sql-server-administration" Projects
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.
Web Application Deployment in the Azure Cloud
(Microsoft Azure) Web application deployment in the Azure cloud using different service (IaaS, PaaS and FaaS) models 1.1 IaaS service model: Deploying an ASP.NET web application on Azure virtual machines. 1.2 PaaS Service Model: Deploying an ASP.NET web application to Azure App Service using Azure SQL Database. 1.3 FaaS Service Model: Deploy serverless APIs with Azure Functions, Logic Apps, and Azure SQL Database Objective: To test and compare the implementation of a web application in the Azure cloud using IaaS and PaaS service models.
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.
Website migration and updates
This project involves migrating an existing website from its current hosting platform to a new host, Web Central. The site transfer will require uploading all website files to the new host's server. Once transferred, the main navigation menu will need to be updated to reflect any structural or page changes. Additionally, an online booking module must be developed and integrated onto the site to allow customers to make reservations directly through the website. It seems the current host may have been compromised, redirecting visitors to an incorrect domain. Therefore, the secure and stable hosting provided by Web Central will resolve this issue. Familiarity with server administration, common web programming languages like HTML, CSS, PHP, and databases like MySQL is preferable to complete this project smoothly. The goal is to have the new site launched on the new host within two weeks with the updated menu and functional booking system in place.
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