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 optimized SQL queries for 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 functions using 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 like Tables , Stored Procedures , Views , Indexes and User Defined Functions consumed at various stages of Migration process, Reports or Data Validation .