Database Lead - Performance Tuning (9-16 yrs)

Primary Skills-MS SQL Server Developer , Database design, Performance Tuning, Stored procedures, SQL

Job Description as per SF:

Must-Have:

- Design and develop new database schema objects such as tables, indexes, views, stored procedures, functions, triggers, jobs, while supporting legacy database schema currently supporting production environment

- Solve database performance issues and diagnose malfunctions

- Ensure performance, security, and availability of databases

- Handle common database procedures such as upgrade, backup, recovery, migration, etc.

- Profile server resource usage, and optimize and tweak as necessary

- 9+ years' experience in database programming

- Good data analytical and data modelling skills

- Expert in DB profiling & SQL performance tuning

- Skilled at optimizing large, complicated SQL statements

- Capable of configuring popular database engines and orchestrating clusters as necessary

- Ability to plan resource requirements from high level specifications

- Prepare documentations and specifications.