I have experience with Azure and MS SQL Server (Transact SQL, SSAS, SSIS and SSRS), MS Access, Oracle's Server (PL/SQL), and mySQL, and familiarity with other DBMSs. I also have expertise in the development of desktop/web applications and services with the .net/.net core frameworks (C# and VB), including MVC/MVVM (WPF and UWP) models (for web/desktop/mobile applications), REST (Web API), ORM frameworks (EF, XPO), and interfacing with third-party APIs such as Google Places/Maps/Firebase, Foursquare, Twilio, AWS/S3, Office365, etc. I have familiarity with autofac (dependency injection) and automapper (object mapping). I'm comfortable with several front-end frameworks (Bootstrap, Angular, etc.) I'm also familiar with Azure and Google cloud-based functions, scheduled jobs, messaging frameworks, etc. I can setup/handle pipelines with TFS and DevOps (Azure), Git-based repos, and Jira boards.
Your problem can be easily solved using sockets (on both, the sever and the client) that would allow for direct communication between both server and client. You client app registers with the server app as a listener, then the sever sends the message to the client when the conditions to do this apply. There are other possible approaches too, but we'll need to discuss the particulars of your case. Just write me a not and we can discuss this.
Please note that I barely use this website, but I can point you to other wesbites where I'm ranked at the top 3% freelancers.