Senior Product Software Engineer

Dallas-Fort Worth Texas Metroplex Remote HybridWolters Kluwer is a global leader in professional information services. Professionals in the areas of legal, business, tax, accounting, finance, audit, risk, compliance and healthcare rely on Wolters Kluwer's market leading information-enabled tools and software solutions to manage their business efficiently, deliver results to their clients, and succeed in an ever more dynamic world. Wolters Kluwer combines deep domain knowledge with specialized technology. Our portfolio offers software tools coupled with content and services that customers need to make decisions with confidence. Every day, our customers make critical decisions to help save lives, improve the way we do business, build better judicial and regulatory systems. We help them get it right.Key ResponsibilitiesConduct 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 ‘DBA Tools’ or ‘SQL Server’ to make improvements to the deployment script generation process

Utilize advanced Git commands – in order to pull metadata from the Log History

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.

Provide Deployment Support during Production Deployments; could be on weekends / off hours

Key RequirementsMinimum of three years of experience - Microsoft SQL Server / T-SQL coding experience

Knowledge of SQL Window functions

Minimum three months experience – specific to SQL query optimization, 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; three 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 is most important, when priorities change or one avenue of approach becomes blocked

Ability and grit to work independently with minimal direction

Nice To Have (Optional)· One or more years of experience of Microsoft Visual C#.NET· Azure DevOps Pipelines build/setup· Familiarity with Azure Virtual Networks/Azure Configuration· Microsoft SQL Server Query Store experience· Microsoft SQL Server 2019 version-specific experience· Visual Studio 2019 experience· Microsoft Windows Presentation Foundation (WPF) development· ASP.NET experienceEQUAL EMPLOYMENT OPPORTUNITYWolters Kluwer U. S. Corporation and all of its subsidiaries, divisions and customer/business units is an Equal Opportunity / Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or protected veteran status.