Senior Microsoft SQL Developer

Altair

(Michigan, United States)
Full Time
Job Posting Details
About Altair

Altair is focused on the development and broad application of simulation technology to synthesize and optimize designs, processes and decisions for improved business performance.

Responsibilities
  • Enhance and maintain the evolution of our data.
  • Code stored procedures, constraints, indexes, and triggers of high complexity to meet product requirements.
  • Conduct index and performance analysis to ensure products provide optimal performance, throughput, and scalability.
  • Ensure normalization or denormalization of database structures to support transactional and decision support workloads.
  • Define and keep up to date database architecture and development best practices.
  • Maintain database designs and models.
  • Facilitate discussions among database developers to exchange ideas and introduce new database technologies.
  • Build design consensus amongst different teams working on software development projects.
  • Participate in peer code reviews to ensure database standards and development best practices are being followed.
Ideal Candidate

Competencies, Knowledge, Skills:

  • Demonstrates expert knowledge of database design.
  • Demonstrates expert knowledge of T-SQL programming.
  • Demonstrates expert knowledge of performance tuning.
  • Demonstrates expert knowledge of extract, transform, and load (ETL) to generate data sets.
  • Demonstrates proficient knowledge of message queuing technologies.
  • Demonstrates proficient knowledge with XML and JSON formats.
  • Understands complex database concepts as well as implications of different database designs on performance, throughput, scalability, and maintainability.
  • Ability to effectively communicate requirements & design specifications within & across teams.
  • Understands and actively participates in the Software Development Life Cycle.
  • Performs continuous refactoring of database design and/or code to accommodate changing requirements, technologies, and design.

Technologies:

  • Microsoft Visual Studio 2013 & 2015
  • Microsoft SQL Data Tools (SSDT)
  • Microsoft SQL Server Management Studio 2012 (SSMS)
  • Microsoft Release Management 2015 Update 1 (RM)
  • Microsoft Team Foundation Server 2015 Update 1 (TFS)
  • Microsoft SQL Reporting Services (SSRS)
  • Microsoft SQL Analysis Services (SSAS)
  • Microsoft SQL Integration Services (SSIS)

Questions

There are no answered questions, sign up or login to ask a question

sign up or login to save this job and more
Michigan, United States
Skills Desired
Sign up or login to see how your skills match up.
  • Database Design
  • Software Development
  • XML
  • JSON
  • Microsoft SQL SSAS
  • Microsoft SQL SSRS
  • SQL Server Integration Services (SSIS)
  • Team Foundation Server
  • ETL
  • T-SQL
  • Release Management
  • SQL Server Management Studio
  • SQL Server Data Tools (SSDT)
  • Microsoft Visual Studio 2013
  • Microsoft Visual Studio 2015

Want to see jobs that are matched to you?

DreamHire recommends you jobs that fit your
skills, experiences, career goals, and more.