SQL Developer

Boston Technology; Boston (MA); On-site; USD 70,000 - 100,000; Full time

Job summary

Boston Technology in Boston, MA, is seeking a skilled database developer to create and maintain database objects and ensure code integrity against SQL Injection and other vulnerabilities. The ideal candidate will design ER diagrams, develop SQL Server Reporting Services reports, and participate in the development of data warehouses.

The position requires strong skills in SQL Server and SSIS Packages, working closely with teams to meet application requirements effectively. All information is handled confidentially according to EEO guidelines.

Responsibilities

• Create Entity Relationship (ER) Diagrams to the proposed database.
• Create database objects such as tables, views, stored procedures, triggers.
• Maintain referential integrity and avoid SQL Injection issues.
• Develop reports in SQL Server Reporting Services.
• Design, Develop, and Deploy SSIS Packages.
• Participate in discussions involving application creation.

Job 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 toleverage 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.