Responsibilities:
SQL Server Developers are responsible for developing SQL databases and writing applications to interface with SQL databases.
Development consists of
- Building databases and validating their stability and efficiency.
- SQL Server Management Studio, Query Analyzer, SQL Profiler, Toad.
- Creating views, functions and stored procedures and views and triggers.
- Writing optimizedSQL queriesfor integration with other applications.
- Designing database tables.
- Performance tuning.
- Developing job scripts and triggers.
- Maintaining data quality and backups and overseeing database security.
Role:
- Develop, implement and optimize stored procedures and functionsusing T-SQL.
- Review and interpret ongoing business report requirements
Build appropriate and useful reporting deliverables.
- Tuned and Optimized SQL Queries using Execution Plan and SQL Profiler. Suggest new queries.
- Good Experience in creating database objects likeTables,Stored Procedures,Views,IndexesandUser Defined Functionsconsumed at various stages ofMigrationprocess,ReportsorData Validation.
