SQL Developer

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 for the proposed database.
• Create database objects such as tables, views, stored procedures, triggers, etc.
• Maintain referential integrity, domain integrity, and column integrity by using available options such as constraints.
• Identify columns for primary keys in all tables at design time and create them.
• Create functions to provide custom functionality as per the requirements.
• Be aware of potential blocking and deadlocking and write code to avoid those situations.
• Ensure that the code is written with security issues such as SQL Injection in mind.
• Develop reports in SQL Server Reporting Services.
• Design, develop, and deploy SSIS packages.
• Identify and write the best possible code for new deployments or when rewriting code when migrating to newer versions of SQL Server.
• Participate in discussions involving application creation, understand the requirements, and provide back-end functionality for the applications.
• Participate in the 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.