Description

 Job Description

  • Writing queries, stored procedures used for front-end applications
  • Designing database tables and other DB objects
  •  Taking DB backups and restore the same
  • Ability to work on large scale database
  • Strong proficiency in MS SQL Server and prior experience in MS SQL Server performance tuning
  • Advanced knowledge of T-SQL, including transactions, error handling, CTEs, Row_Number/Over, hierarchical data sets.
  • Excellent understanding of indexes, locks, execution plans and file stats
  • Experience in analyzing and optimizing I\O and CPU bottlenecks
  • Familiar with tools that can aid with profiling server resource usage and optimizing it
  • Should have a working knowledge about load balancing.
  • Excellent Knowledge in SQL programming, debugging, developing stored procedures, UDF (user defined Functions), Triggers

Education

Any Graduate