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
