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 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 requirements.
• Be aware of potential blocking and deadlocking, and write code to avoid those situations.
• Ensure that the code is written with security issues in mind, such as SQL Injection.
• 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 requirements, and provide back-end functionality for 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.