||Experience: 3-6 yearsLocation: Techno park, Trivandrum
Minimum Qualification: BE/BTech, MSc/MCA, PGDCA or any equivalent degree
Technical Skills: MS SQL Server 2005/2008
- Creating/tuning/optimizing indexes, stored procedures, Views ,Triggers and Functions
- Implement logical and physical data models at the project level.
- Coordinating DDL changes; QA support; and the production implementation of all DB changes.
- Estimation and Capacity Planning for database growth
- Trace Analysis
- Query Optimization and Query Execution plan Analysis
- Database parameters tuning
- SQL Login, database user creation and granting access
- Schema creation and granting access
- Update Statistics
- Shrink Database
- DMV’s and DBCC Commands
- Troubleshooting deadlock and blocking issues.
- Proficiency in Transact-SQL (TSQL)