Position Requirements

• 12+ years development experience within the Microsoft landscape (Visual Studio 20XX/2019/2022) as this role plays a pivotal role in the architect, design, and implementation stages for all Visual Studio solutions (SSIS ETL, ASP.net, Administrative Automation, Data Analysis, Data Warehousing, etc.).
• 10+ years working experience with version control methodologies supporting Microsoft centric solutions (SSIS ETL, ASP.net, Administrative Automation).
• 10+ years designing and building DevOps functionality/processes, building continuous integration, continuous development, and constant deployment pipeline (CI/CD Pipeline) – striving to follow best practice methodologies.  
• Expert level Visual Studio, Azure DevOps, Azure Data Factory, Azure SQL Database, MS SQL Server
• 10+ years developing, supporting and performance tuning T-SQL Code (stored procs, functions, tables, views, triggers, indexes, constraints).  Performance tuning tools include but are not limited to query analyzer, performance monitor, SQL profiler, Execution Plan, etc.
• 10+ years developing, supporting, and troubleshooting C# & Powershell code base solutions (administrative automation, SSIS, ASP.net, etc.).
• Proficient experience performing Database Administrator (DBA) tasks, supporting MS SQL Server environments (On-Prem VM/Azure VM & Azure SQL)
• Proficient experience supporting the development & promotions of SSRS reports & SSAS cubes.
• Proficient experience designing database/schema to support Data warehousing and OLAP requirements.
• Experience in Azure DevOps Agile/Kanban practice.
• Good documentation habits/skills for solutions definitions, pipeline and build diagrams, database structures, runbooks, automation procedures, etc.
• Good communication skills and the ability to work as part of a team are essential.
• Good time-management skills.
• Must have good “Attention to Detail”, leaving nothing to chance.  Check, double-check, and triple-check before making any implementations.

Required Technical Experience

• 12+ years using Visual Studio Development Environment
• 10+ years Microsoft DBMS (On-Prem, Managed Instance MS SQL Server, Azure SQL Database)
• 10+ years Azure DevOps (formerly known as TFS & VSTS), Azure Data Factory
• Proficiency with Git and GitHub
• Proficiency with PowerShell, C#, VB.NET, Bash, T-SQL
• Ability to troubleshoot issues outside of middleware spaces (OS, Network, Database)

Preferred Technical Experience

• Experience with setting up sprints with board, project management and workflow tools such as Agile, Jira, Azure DevOps, etc.
• Encouraging and building automated processes wherever possible
• SQL Data Sync (legacy/unsupported)
• Experience with Linux servers.
• Monitoring and Logging Solutions