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.
#J-18808-Ljbffr
