Technical Application Service Specialist

Job Description

6-13 years of experience L2 Production Support SRE MS/SQL Server (ok if candidate has SQL,PL/SQL knowledge and has not directly worked on MS SQL) Cloud Dynatrace (or similar alerting and monitoring tools) Job Description What you d be doing in this role supporting the set of applications in Finance Platform Working as Technical Application Service Specialist (TASS), focusing on alerting, monitoring and observability. Ensuring that applications are up and running. Taking preventive actions to avoid incidents/application downtimes. Observability, investigating & fixing service performance issues, with an engineering mentality - resolving via code changes and implementing improvements to prevent repeat issues. Implementing further automation and reducing toil, by utilising existing tooling or implementing new technologies Communicate with Business to understand requirements, socialise ideas amongst peers, respond to user queries. Assess query performance and actively contribute to optimising the code Managing the resolution of issues in Production promptly and effectively Identifying opportunities to make improvements Working closely with the Lab team to understand their backlog changes that will be coming through to RTB Support. Support internal audit by submitting required evidence What you ll need: 7+ years working exp in an Enterprise environment (Financial organisation preferred). Experience with SQL queries, stored procedures, database design and performance tuning (MS SQL Server, Entity Framework, Dapper). Proficient in Transact SQL (T-SQL), SQL Server Integration Services (SSIS) & SQL Server Reporting Services (SSRS). Table/index design and Query Optimisation experience. Hands-on working experience of ETL tools like DataStage, Informatica. Good understanding on DevOps, including experience of Infrastructure as Code and CI/CD pipelines, such as Terraform, Spinnaker and Jenkins Well versed using GIT as Source Control Management tool. Good understanding of Event-driven architecture and Cloud system architectures. Hands-on experience of debugging C# code in SSIS Script components. Basic understanding of .Net Framework. Be proficient in the monitoring tooling such as Dynatrace, Stack Driver/Cloud Operations Suite Highly developed problem-solving skills with minimal supervision. Excellent written and verbal communication skills in English Out of hours On-Call support is required for our applications, and will be managed via a Rota or Shift pattern