1 Opening(s)
6.0 Year(s) To 10.0 Year(s)
24.00 LPA TO 28.00 LPA
JD
SQL Server architecture (memory management, IO, Backup-Restore mechanisms, High Availability options)
DB physical design structures: Table design, data types, Index design, Columnstore Index internals (mandatory!), functions, procedures, table partitioning and partition management
Locking mechanisms
Query Performance Tuning: familiarity with Extended Events, Query Execution Plans, Query Store and ability to use those to check ...
10 Opening(s)
3.0 Year(s) To 6.0 Year(s)
10.00 LPA TO 15.00 LPA
Proficiency in advanced PL/SQL scripting: stored procedures, functions, packages, triggers, and dynamic SQL.
Ability to design modular PL/SQL code that is reusable, efficient, and optimized for performance and scalability.
Experience in bulk data processing and using PL/SQL techniques such as BULK COLLECT and FORALL.
Strong experience in designing normalized and optimized database schemas ...