Senior Microsoft SQL Developer

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

* 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.

**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)