Application Support Analyst (L2/L3) - SQL & Powershell - Banking
Posted 1 day ago by Rothstein Recruitment Ltd
Negotiable
Undetermined
Undetermined
London, UK
Summary: The Application Support Analyst (L2/L3) role focuses on providing production support for critical financial systems, emphasizing data investigation, SQL troubleshooting, and scripting. The position requires hands-on involvement in resolving complex production issues and improving system reliability. Candidates should possess strong technical skills in SQL and scripting languages, particularly PowerShell. This role is integral to maintaining the operational integrity of business-critical applications in a banking environment.
Key Responsibilities:
- Provide L2/L3 production support for core applications and data flows
- Investigate data and processing issues using advanced SQL (T-SQL/PL/SQL)
- Perform data fixes, validation, reconciliations and performance analysis
- Debug batch and Real Time processes across Linux and Windows environments
- Develop and maintain automation and tooling using PowerShell, Bash and/or Python
- Investigate failed or delayed batch jobs and end-to-end processing chains
- Work with developers and infrastructure teams on root cause and permanent fixes
- Support releases, deployments and controlled changes into production
- Participate in incident, problem and DR processes, including RCA
Key Skills:
- Strong, hands-on SQL experience (complex queries, joins, stored procedures, data investigation)
- Strong Scripting skills in PowerShell, Bash, Python or similar
- Experience supporting production financial systems in an L2/L3 capacity
- Comfortable working directly on Servers (Linux/Windows) to diagnose issues
- Experience with batch processing and scheduled workloads (Control-M, Tidal, Autosys or similar is a plus)
- Experience troubleshooting data pipelines, interfaces and downstream impacts
- Proven ability to work independently and own issues through to resolution
Salary (Rate): undetermined
City: London
Country: UK
Working Arrangements: undetermined
IR35 Status: undetermined
Seniority Level: undetermined
Industry: IT
Application Support Analyst (L2/L3) - SQL & Powershell - Banking
We are seeking a technically strong Application Support Analyst to join a production support team responsible for business-critical financial systems. This is a hands-on L2/L3 role focused on data investigation, SQL troubleshooting, Scripting and automation, and resolving complex production issues at root-cause level.
You will be expected to analyse problems, write scripts, fix data and processes, and improve system reliability.
Key Responsibilities
- Provide L2/L3 production support for core applications and data flows
- Investigate data and processing issues using advanced SQL (T-SQL/PL/SQL)
- Perform data fixes, validation, reconciliations and performance analysis
- Debug batch and Real Time processes across Linux and Windows environments
- Develop and maintain automation and tooling using PowerShell, Bash and/or Python
- Investigate failed or delayed batch jobs and end-to-end processing chains
- Work with developers and infrastructure teams on root cause and permanent fixes
- Support releases, deployments and controlled changes into production
- Participate in incident, problem and DR processes, including RCA
Essential Skills and Experience
- Strong, hands-on SQL experience (complex queries, joins, stored procedures, data investigation)
- Strong Scripting skills in PowerShell, Bash, Python or similar
- Experience supporting production financial systems in an L2/L3 capacity
- Comfortable working directly on Servers (Linux/Windows) to diagnose issues
- Experience with batch processing and scheduled workloads (Control-M, Tidal, Autosys or similar is a plus)
- Experience troubleshooting data pipelines, interfaces and downstream impacts
- Proven ability to work independently and own issues through to resolution
Desirable
- Experience in asset management, custody, banking or trading environments
- Exposure to data warehouses, regulatory reporting or valuation processing
- Experience with monitoring tools (Splunk, Geneos, Dynatrace, etc.)
- Understanding of MQ or message-based integrations