This ad is expired.

Senior Product Software Engineer - Remote

Key Responsibilities:

Conduct code reviews for complex SQL scripts that are thousands of lines long
Employ SQL Schema compare technologies (SSDT dacpacs, Red-Gate, Apex-Sql) to detect schema drift & generate schema delta scripts
Maintain database build scripts; responsible for SQL Deployment process using Azure DevOps pipelines
Leverage an in depth understanding of MS SQL Server query plans to identify bottlenecks and recommend indexes/appropriate code changes
Maintain both Azure SQL Databases (SaaS) and Azure VMs running Microsoft SQL Server Developer & Enterprise Editions (PaaS)
Restore databases, run SQL and/or Powershell scripts against them
Employ solid knowledge of PowerShell that interface with Modules like 'DbaTools' or 'SqlServer' to make improvements to the deployment script generation process
Utilize advanced Git commands - in order to pull metadata from the Log History
Create and merge Git pull requests
Provide Deployment Support during Production Deployments; could be on weekends / off hours

Key Requirements

Show initiative and motivation to solve problems, adapt to changes, and follow through on tasks
Minimum of 5-7 years of experience - Microsoft SQL Server / T-SQL coding experience
Knowledge of SQL Window functions such as ROW_NUMBER(), PERCENTILE_CONT(), and NTILE()
Understand which situations are most appropriate to employing these functions
SQL query optimization - 3 months experience - indexing and performance tuning, including knowledge of when to recommend table re-design
Able to describe individual query plan operators and implications
Good communication and documentation skills
Experienced at using SQL Server Data Tools (SSDT) (i.e. Visual Studio Database Projects, particular with a view towards deployments)
Solid understanding of Schema Comparison Tools (Red-Gate, Apex Sql, or SSDT)
PowerShell scripting knowledge, or willingness to become proficient
Expert "Git" knowledge, or willingness to become that expert; 3 years' experience using at least one kind of source code control systems (ex. TFS, Git, SVN/Subversion, Rational, Visual Source Safe or the like)
Ability to maintain a task list and shift to focusing on whatever's most important, when priorities change or one avenue of approach becomes blocked
Ability and grit to work independently with minimal direction
Understand the use of technology and how its implementation affects strategic business goals.
Bachelors in Computer Science or related.

Nice to Have

Azure DevOps Pipelines build/setup
Microsoft SQL Server 2019 version-specific experience
R or Python experience (for data science)
Power BI experience or other reporting tools
One or more years of experience of Microsoft Visual C#.NET
Familiarity with Azure Virtual Networks/Azure Configuration
Microsoft SQL Server Query Store experience
Visual Studio 2019 experience
Microsoft Windows Presentation Foundation (WPF) development experience
Entity Framework or Dapper experience
Docker virtualization experience
Develop the occasional application utility using C# and maintain existing utilities that employ WPF. We wish to utilize docker virtualization technologies in the future and will want to automate that in this type of utility.

To apply, visit https://wk.wd3.myworkdayjobs.com/en-US/external/job/USA---Coppell-TX/Senior-Product-Software-Engineer_R0029967-1?source=witi

jeid-5028b910be9caf409467115e13297c48

Job Details