SQL Developer - Data Warehousing, SSIS/SSAS, BI Reports

Mass Digital Health

Boston (MA)

On-site

Full time

14 days+

Get more replies from employers

Send a job-specific resume in minutes.

Responsibilities

  • 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 using 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 blocking, deadlocking and write code to avoid those situations.
  • Ensure code 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 best possible code in case of new deployments or when rewriting code when migrating to newer versions of SQL Server.
  • Participate in discussions involving application creation, understand requirements, and provide backend functionality for applications.
  • Participate in development and creation of data warehouses.
  • Create cubes in SQL Server Analysis Services.

Job description

Responsibilities
  • 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 using 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 blocking, deadlocking and write code to avoid those situations.
  • Ensure code 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 best possible code in case of new deployments or when rewriting code when migrating to newer versions of SQL Server.
  • Participate in discussions involving application creation, understand requirements, and provide backend functionality for 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.

Get your free, confidential resume review.
or drag and drop your file here.
Similar jobs

Similar jobs worth comparing

SQL Developer
SQL Developer

Mass Digital Health • Boston (MA)

On-site
SQL Developer - ER Diagrams, SSIS/SSRS/SSAS Expert
SQL Developer - ER Diagrams, SSIS/SSRS/SSAS Expert

Boston Technology • Boston (MA)

On-site
USD 70,000 - 100,000
SQL Developer
SQL Developer

Conglomerate IT, LLC • Dallas (TX)

On-site
USD 80,000 - 100,000
SQL Developer
SQL Developer

Boston Technology • Boston (MA)

On-site
USD 70,000 - 100,000
SQL Developer
SQL Developer

Veriipro • Toledo (OH)

On-site
USD 70,000 - 90,000
Sr Database Admin
Sr Database Admin

MidFirst Business Credit, Inc. • Oklahoma City (OK)

On-site
USD 70,000 - 90,000
Software Developer
Software Developer

Sumas Corporation Inc • San Francisco (CA)

On-site
USD 80,000 - 110,000
SQL SME Developer (Subject Matter expert)
SQL SME Developer (Subject Matter expert)

TechDigital Group • Maryland

Hybrid
USD 120,000 - 180,000
SQL/SSIS Developer
SQL/SSIS Developer

Intone • New York (NY)

On-site
USD 85,000 - 120,000
Software Developer
Software Developer

Praise Tech Solutions • Northern (KY)

Hybrid
USD 90,000 - 130,000