Create database objects such as tables, views, stored procedures, Triggers etc
Create functions to provide custom functionality as per the requirements
Required Skills
Ability to create/interpret an Entity Relationship Diagram
Understanding primary and foreign key relations
Understanding of how Joining Tables
Understanding of normalization
Ability to create stored procedures and views
Ability to process multiple records in a loop as individual transactions
Knowledge of SQL transaction processing
Knowledge of exception handling
Knowledge of how to use aggregates
Good in performance tuning especially tuning complex queries, procedure and indexing strategies
Hands on SQL/T-SQL Programming in SQL server 2008 R2
Able to write stored procedures for highly transactional systems and data modelling
Provide solutions, able to write complex stored procedures, triggers etc
Able to create entity relationship diagram
Microsoft SQL server 2008 R2
Hard core SQL/T-SQL Programming
Strong analytical ability to analyze requirements or design to create a solution with minimal guidance
Strong communication skills, able to express code and design decisions to other technical staff and business analysts
Efficient time management skills and used to delivering solutions in a fast pace environment
Ability to create technical documentation to explain the solution that was implemented
Proficiency at creating optimized SQL statements that are scalable
Required Experience
Experience in Data Modeling, Database design and well versed with SQL Server best practices
7+ years of Microsoft SQL Developer experience working as part of a team developing SQL server based applications with the following responsibilities and skills
