Microsoft Developer with Linux ,DevOps, TFS, VSTS and DBA/SQL Server

Job Title: Senior Microsoft Developer

Job type- 6 months C2H

Location- Hyderabad

Job Description

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

Linux We develop using Visual Studio to support multiple business functions. 25% of these solutions write files to Linux servers and we often need to troubleshoot issues within those filesystems/permissions. This is why we have Linux under “Preferred technical skills”.

DevOps, TFS, VSTS The DevOps arena is only about 10 years old, prior to that this was called TFS and VSTS. Because our solutions, codes base is all Microsoft based using Visual Studio as a tool, these are some technical soft skills and tools that the candidate will have experience working with. Within our packages, we primarily have C#, Bash and T-SQL embedded. For administrative automation, we use PowerShell for many processes globally. It’s not unusual for my team to not only have to create new tasks/steps using these languages, but also troubleshooting logic or functional anomalies.

DBA/SQL Server Administration

This position roles under the Database Manager and is composed of two other MS SQL DBAs. Any developer of 10+ years within a MS space will have some DBA skills, whether its simply performing backups and restores, performance tuning or or hopefully a deeper level DBA technical skill. This position will share Visual Studio related tasks with me. We are hoping that this position can crossover and share some of our more core DBA workload too.

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