Application Support Engineer

LTM; Chennai; Hybrid; INR 1,200,000 - 1,800,000; Full time

Job summary

LTM is seeking an experienced technologist to support production releases, handle incident management and root cause analyses, and coordinate with offshore and onshore teams to drive project deliveries. The role requires hands-on experience with Oracle/ SQL Server/ PostgreSQL and strong Python development skills.

Ideal candidates will have expertise in SQL optimization, data modeling, scripting, and batch scheduling, along with leadership capabilities to mentor junior developers in an

Qualifications

• Hands-on experience with Oracle Database, Microsoft SQL Server and PostgreSQL.
• Strong SQL query writing and optimization skills.
• Experience with stored procedures, functions, triggers, and indexing for performance.
• Proficient in Python development and scripting for automation.
• Experience with Splunk and Dynatrace for monitoring and analytics.
• Knowledge of data integration concepts and APIs.
• Proficient in Linux/Unix administration and shell scripting.
• Familiar with batch scheduling and job monitoring.
• Experience leading teams and managing stakeholders in Agile/Scrum.
• Domain expertise in Asset Management, Capital Markets, Investment Management, OMS, PMS.

Responsibilities

• Support production releases, incident management and root cause analysis.
• Coordinate with offshore/onshore teams and drive project deliveries.
• Ensure adherence to coding standards, security and best practices.

Skills

Python development

SQL optimization

Data modeling

Scripting

Agile/Scrum

Code reviews

Mentoring

Problem solving

Batch scheduling

Stakeholder management

Tools

Oracle Database

Microsoft SQL Server

PostgreSQL

Splunk

Dynatrace

Kafka

Unix

Job description

Role & responsibilities

• Support production releases incident management and root cause analysis.
• Coordinate with offshore onshore teams and drive project deliveries
• Ensure adherence to coding standards security and best practices

Preferred candidate profile:

• Strong handson experience with
• Oracle Database
• Microsoft SQL Server
• PostgreSQL
• Expertise in
• SQL Query Writing Optimization
• Stored Procedures
• Functions
• Triggers
• Indexing Performance Tuning
• Database Design Data Modelling
• Programming
• Strong Python development experience
• Experience with scripting automation and data processing frameworks
• Good understanding of APIs and data integration concepts
• Scripting Operating Systems
• Working knowledge of PERL scripting
• Strong Linux Unix administration and shell scripting knowledge
• Experience in batch scheduling and job monitoring
• Domain Expertise Preferred
• Asset Management
• Capital Markets
• Investment Management
• Order Management Systems OMS
• Portfolio Management Systems PMS
• Trade Lifecycle
• Securities Equities Fixed Income Mutual Funds
• Leadership Soft Skills
• Experience leading teams of 510 members
• Strong stakeholder management and client communication skills
• Ability to perform code reviews and mentor junior developers
• Experience in AgileScrum delivery models
• Strong analytical and problemsolving skills

Hands on experience with Splunk/dynatrace

Hands on experience with L2 Application Support with Python+unix+Kafka