Experience: 10-12 Years
The candidate should have 10 – 12 years of experience with at least 3 years of experience in Team Leader position in support project.
Good to have someone from SCL / with WMS knowledge.
- Rotational Shifts/Night Shifts : Yes/No – Specifics of shift timings : 06:30 to 15:30 and 13:30 to 22:30
- WFH till December 2021/WFO from day 1 of employment with Cybage : WFO from day 1
Technical Requirements :
To be the right fit, you will need:
- Primary and Foreign Key relationship
- UNION and UNION ALL and its difference
- DML Statement. Check with few examples.
- String Functions, Date time Functions and Constraints
- How to debug SP / functions
- Joins and its types
- Stored procedure. Why we use stored procedures. How to fix issue when stored procedure suddenly is slow/timing out.
- what is Output parameter in stored procedure and how to use it. Check with Ex.
- Sub query and its types
- Indexes. How clustered and non-clustered indexes work.
- knowledge of Triggers and how they work
- What is transaction and how it works
- What is deadlock and how to fix it
- Difference between deadlock and blocking
- Knowledge of SQL server profiler is advantage
- Should know how to update data using joins