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)