Cloud SQLServer Data Analyst

Our body-worn video solutions are more than just technology; they\’re a testament to our commitment to safety, innovation and change. Rooted in the UK, we\’ve become a trusted ally for many police forces, local authorities, retailers and private organisations; helping to pioneer and drive the application of body-worn video in settings and geographies where we can see exciting potential. To manage and monitor our Azure-based SaaS solution in order to ensure system reliability and a high standard of customer service at all times. To use data to build historical trend analyses and provide reporting. Monitoring & Incident Detection Implement and manage Azure Monitor, Application Insights, and Log Analytics to track system performance. Set up automated alerts for App Service, SQL Database, and Blob Storage to detect anomalies. Create and maintain synthetic monitoring for proactive issue detection. Escalate detected incidents immediately to appropriate teams. Data Analysis & Reporting Build historical trend reports beyond Azure’s 90-day retention, storing logs for long-term analysis. Analyse logs and performance metrics to identify recurring issues. Provide insights into system downtime, performance trends, and customer impact. Develop scripts and queries (Kusto Query Language – KQL, PowerShell, Python) for log analysis. Recommend improvements to architecture based on performance data. Work closely with engineering, DevOps, and customer support teams to resolve incidents as fast as possible. Document best practices for monitoring, alerting, and reporting. 3+ years’ experience in cloud monitoring, data analysis, or DevOps support. ~ Strong knowledge of Microsoft Azure services (App Service, SQL Database, Blob Storage, Azure Monitor, Application Insights, Log Analytics). ~ Proficiency in KQL (Kusto Query Language) for log analysis. ~ Experience with automation scripting (PowerShell, Python, or Azure Functions). Microsoft Certified: Microsoft Certified: Azure Solutions Architect Expert (AZ-305) Microsoft Certified: Azure Security Engineer Associate (AZ-500) Strong analytical mindset and ability to translate data into actionable insights. Here, every challenge becomes an exciting project, every solution a collective win. And with an array of benefits tailored to your wellbeing and development, we ensure that while you\’re taking care of our mission, we\’re taking care of you. Private Medical Insurance : Your health matters, and we\’ve got you covered. Birthday Off : Celebrate your day your way – it’s on us. Holiday Purchase : Need more downtime? Purchase up to an additional 5 days of holiday. Employee Assistance Programme: Confidential 24/7 helpline and support for you and your immediate family. We embrace hybrid working and, where it is operationally practicable, we support employees splitting their working time between the office and home. Pension: Plan for tomorrow with our pension scheme via NEST. As a result, we have set ourselves the ambitious goal of reducing our energy, carbon, and waste footprint to zero. We continuously review our operations against our sustainability goals and all our company cars are electric. We are committed to embracing diversity and building an inclusive culture where all employees are valued, respected and listened to. All applicants to Reveal will receive equal treatment regardless of age, disability, gender identity or expression, marital or civil partner status, pregnancy or maternity, race, colour, nationality, ethnic or national origin, religion or belief, sex or sexual orientation.