Senior/Lead SQL Production Support Engineer
Core
Investigate data discrepancies, troubleshoot database incidents, and ensure stability of business-critical applications and databases for an investment management client.
Role type
Senior/Lead SQL Production Support Engineer
Builds
Stable production environments for investment management business and reporting cycles
Domain
Financial Services / Investment Management
Required skills
Advanced SQL (complex queries, CTEs, window functions), Root cause analysis, Database performance tuning, Stored procedures/Triggers/Views, Incident management, ETL monitoring
Preferred skills
Asset Management experience, Informatica/SSIS/dbt, Autosys/Control-M, Unix/Linux, Python, ServiceNow, Splunk
Technologies
MS SQL Server, Oracle, PostgreSQL, Sybase, Informatica, SSIS, dbt, Autosys, Control-M, HCL Workload Automation, Unix, Linux, Python, ServiceNow, Splunk, AppDynamics
Responsibilities
Write and troubleshoot complex SQL queries to analyze data discrepancies and validate data integrity. Investigate database failures and perform root cause analysis. Monitor ETL processes and batch jobs. Optimize slow-running queries via execution plan analysis. Develop and maintain stored procedures, functions, and triggers. Handle major incident calls and defect resolution.
Seniority
Senior, hands-on IC