Position: Sr SQL Developer
Location: Noida
Employment Type: Full-time
Shifts: 01:00 PM - 10:00 PM
About Us: Vensure Employer Solutions company, We are the largest privately held, full-service HR technology and solutions provider. Vensure proudly serves more than 3 million worksite employees and 90,000 small and mid-sized businesses (SMBs) across America and around the globe. Founded in 2004, VensureHR is a leading provider of HR services and technology.
Responsibilities:
- Experience in analyzing and debugging execution plans.
- Experience in creating and managing indexes based on development cycles.
- Strong development experience, preferably on web based applications, however a mix of desktop and web based applications is also acceptable.
- Strong hands on skills on SQL Server 2012/2016/2019, including use of analyzing and debugging tools, query optimization, transaction handling, stored procedures, functions, triggers and views.
- Experience in designing and implementing highly optimized queries for consistent response time, under a highly variable and fluctuating processing load.
- Experience in converting raw data into usable formats, for reporting and business analytics.
- Experience in optimizing queries and database objects.
- Experience in Troubleshooting and resolving performance issues
- Exposure and practical experience on SQL Server Reporting Services will be an considered an advantage.
- Exposure to at least one NoSQL database such as Cosmos DB will be considered an advantage.- (Not mandatory)