Application Support Engineer
Current● Primary duty was to react to tickets raised by the customer’s operations team and investigate the raised issue. This typically involved using SQL Select queries commonly joining many tables and using nested and other advanced query methods. Then log analysis which would use Python and Shell commands like Grep, Awk, and Sed due to some files being multiple gigabits in size. We would then attempt to reproduce this issue on a test system commonly using Virtual Machines and also test our proposed solutions. Then communicate our findings and recommendations through the ticketing system and on calls with our customers.● As our customer’s began to move to our new cloud SaaS product we began hosting legacy software for them in our environment, my team was tasked with monitoring the health of these servers. This took about an hour twice a week and involved checking various logs, Task manager and SQL jobs, as well as things like disk space. I created a series of Powershell and Bash scripts that would collect the information, perform a basic analysis to determine if it was in a good or bad state and send an email to our team daily. These scripts were applied to the QA and production environments and resulted in the task now taking approximately 5 minutes and allowed us to