09 Aug
|
Sourcebae
|
Bihar
Job Title: Sr. Engineer / Lead
Experience: 6–10 Years
Location: Kolkata
Job Type: Full-Time - On - Site
Joining Time: 15–30 Days
Budget: 22–28 LPA
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
- Strong 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.
- Strong analytical and problem-solving skills.
Good-to-Have Skills
- Databricks Architecture
- AWS Ecosystem
📌 Software Engineer (Bihar)
🏢 Sourcebae
📍 Bihar