SQL Developer

Location: Boston, MA, us

Company Description

Boston Technology Corporation (BTC), based in Marlborough, MA, is a leading Enterprise Mobility and Software services provider. Our clients range from Fortune 500 companies to innovative startups. From cutting edge enterprise mobility solutions to robust web applications, we have enabled them to leverage the power of technology.

Job Description

• 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.

Additional Information

All your information will be kept confidential according to EEO guidelines.