Must-Have Skills
MySQL
AWS Redshift
Advanced SQL (DDL, DML, CTEs, Window Functions)
Query Performance Tuning
Python
Shell Scripting
Design, develop, and optimize database solutions using MySQL and AWS Redshift.
Write and optimize advanced SQL using DDL, DML, Common Table Expressions (CTEs), analytical window functions, and complex set-based logic.
Analyze execution plans and perform query performance tuning.
Resolve concurrency issues, including deadlocks, and optimize database performance.
Debug data anomalies and support healthcare risk modelling platforms.
Develop automation scripts using Python and Shell scripting.
Collaborate with US stakeholders to ensure high availability and seamless execution of the Risk & Analytics module.
Act as a technical anchor for the team by establishing engineering best practices and mentoring mid-level engineers.
Required Skills
Solid experience with MySQL or AWS Redshift.
Expertise in advanced SQL programming and database optimization.
Robust query performance tuning and execution plan analysis.
Experience with Python scripting.
Knowledge of Shell scripting.
Solid analytical and problem-solving skills.