- Create Entity Relationship (ER) Diagrams to the proposed database
- Create database objects such as tables, views, stored procedures, Triggers etc.
- Maintain referential integrity, domain integrity and column integrity by using the available options such as constraints etc.
- Identify columns for Primary Keys in all the tables at the design time and create them.
- Create functions to provide custom functionality as per the requirements.
- Be aware of potential blocking, deadlocking and write code to avoid those situations.
- Endure that the code is written keeping in mind any security issues such as SQL Injection.
- Develop reports in SQL Server Reporting Services.
- Design, Develop and Deploy SSIS Packages.
- Identify and write best possible code in case of new deployments or when rewriting code when migrating to newer version of SQL Server.
- participate in discussions involving the application creation and understand the requirements and provide the back-end functionality for the applications.
- Participate in development and creation of Data warehouses.
- Create cubes in SQL Server Analysis Services.
All your information will be kept confidential according to EEO guidelines.