- Design, develop, and optimize stored procedures, functions, views, and scripts for SQL Server
- Implement and manage database indexing and partitioning strategies to enhance performance
- Monitor and troubleshoot SQL Server performance issues, including query optimization and deadlock resolution.
- Work with product team to review existing or new stored procedures and provide feedback
- Collaborate with onshore and offshore developers to create and maintain product features
- Provide technical leadership and guidance to less experienced or less knowledgeable members of the team
- Participate in code reviews and contribute to team knowledge sharing
- Write clean, maintainable, and efficient code that adheres to best practices
- Troubleshoot and debug existing applications to resolve issues promptly.
- Participate in daily stand-ups, sprint planning sessions, and other scrum ceremonies
- Perform additional duties as assigned
Requirements
- 9+ years of experience
- Develop and maintain a legacy Windows desktop application using C# .NET Framework 4.7.2
- Strong development experience on SQL, Database programming and stored procedures
- Primary skills (required):
SQL Server - Extensive knowledge and experience
C# .NET Framework (Expert)
MFC - Secondary skills
WPF
.NET Core
SQL database projects
Primary skills (required):
- SQL Server - Extensive knowledge and experience
- C# .NET Framework (Expert)
- Windows C++/MFC
Secondary skills
- WPF
- .NET Core
- SQL database projects
Optional skills
- Develop and maintain a legacy Windows desktop application using C++/MFC, NET Framework 4.7.2
- Knowledge of C++ is a nice to have