Full Stack: Fix Pagination + Long Term next.js C# .NET API Optimize cache/redis and paginate C#, web api, SQL + Long term next.js -- 2

PRIORITY IS TO HAVE A DEVELOPER ON OUR TEAM (LONG TERM) THAT CAN WORK WEEKENDS!! 1st task (IMMEDIATE): Fix pagination -> our webapp uses an api endpoint to load data from stored procedure that takes 30 seconds to run. Pagination + cache was implemented but the pagination was implements AFTER the api runs (30 second wait) and should be executed inside the stored procedure to start sending data to the front end immediately, after it has the first 30-50 records instead of waiting to receive the entire 6000+ current records. We implemented cache but would like developer to evaluate the possibility of using redis to improve performance. If you are awarded the task we expect you to accept IMMEDIATELY and if the project is not accepted immediatly we will award it to another developer. This task should be delivered in 1 day and if it is successfully completed we would like to keep the developer long term with 20-40 hours a week working on converting our angular.js to [login to view URL] (we have already converted 50-60% to [login to view URL]) and also transfering our .NET to .NET CORE and our MS SQL to PostgreSQL Details of our current project STACK can be seen here -> [login to view URL] Prerequisites: For this optimization task you can bid your normal hourly rate but for the long term project the starting wage will be as stated below. 1) Accept initial hourly rate of U$5.00 2) Accept and start work immediatly 3) Have 20+ hours a week for long term ongoing support and development. 4) If you are awarded the project accept IMMEDIATELY 5) Work hours: predominantly 20:00 to 03:00 (UTC -3 Brazil TIME) 6) Be available to work on weekends. Our projects use: GITLAB -> [login to view URL], ag-grid, C#, .NET API, MS SQL 2017 , WooCommerce digital product sales This is for ongoing long term development and we will start with some short sprints to be delivered in 1-2 days and then start gradually adding larger sprints for more improvements to our webapp.