Application Support Analyst (L2/L3) - SQL & Powershell - Banking
Rothstein Recruitment
Greater London, UK
7 days ago
- Discuss this with your agent
- Open in Claude
- Open in ChatGPT
Apply on www.collegerecruiter.com
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Role details
Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Job source
Tech stack
Microsoft Windows
CA Workload Automation Ae
Bash Shell
Batch Processing
Data Warehousing
Database Queries
Software Debugging
Linux
Monitoring of Systems
Python (Programming Language)
Windows PowerShell
SQL Stored Procedures
+11 more
PL-SQL
SQL Databases
Data Streaming
Transact-SQL
Scripting
Sql Optimization
Reliability of Systems
Splunk
Data Pipelines
Dynatrace
Control M
Job description
Overview
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.
This is not a monitoring or ticket-routing role. 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
- 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
Requirements
- 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
- 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
Apply for this position
This job is hosted externally. Click below to view the full posting and apply.
Apply on www.collegerecruiter.com
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Good distractions
Talks and stories from around this role — technically off-topic, practically not.
Moments
Explore playlistsVideos
See allRelated articles
See all
EM
Eli McGarvie
about 3 years ago
LM
Luis Minvielle
The Most Popular IT Jobs on the Market
over 2 years ago
EM
Eli McGarvie
Software Engineer Salary London
about 3 years ago
EM
Eli McGarvie
Data Engineer Salary UK
about 3 years ago
EM
Eli McGarvie
Data Analyst Salary in Switzerland
about 3 years ago
EM
Eli McGarvie
Best Companies to work for in London: Top 25 Companies in 2023
over 3 years ago