Lead Database Engineer

Company : Verisk
Job Description
Job Description:
- You will learn and understand the existing Product architecture and database design of AIR products
- Contribute to the architect, design & development of various backend features on SQL Server and other related Database tools.
- You will develop unit tests for newly implemented components.
- Proactively contribute to software performance optimizations and continuous improvements to code quality, robustness, and development processes
- Develop data models and stored procedures by following best practices in view of performance, scalability and security
- Create database objects such as tables, views, stored procedures, UDFs etc.
- Prepare documentations and specifications
- Collaborate with other team members and stakeholders
- Primary responsibility is to work on SQL server database intensively but not limited to. Candidate will be provided opportunity to work on application development using .NET as and when it is required.

Must Have:
- 7-12 years of experience in developing commercial-grade applications using with SQL server as the data base with C# coding as added advantage.
- Strong working experience and knowledge of SQL Server 2014 or above
- Should have good understanding of RDBMS Concepts
- Should have good experience on T-SQL Development with Database and table designs
- Should have good knowledge on best practices for writing Stored Procedures, Views and Triggers
- Proficiency in performance tuning, troubleshooting and writing T-SQL in an application centric environment
- Strong proficiency with SQL and it is good to know its variation among popular databases
- Skilled at writing and optimizing large complicated stored procedures
- Strong understanding on SQL Server concepts, Execution Plans & SQL Profiler etc. Working experience on dynamic SQL.
- Be aware of potential blocking, deadlocking and write code to avoid those situations.
- Code reviews, pair programming, good troubleshooting and debugging skills
- Feature development leading capabilities.
- Should be familiar with version controlling packages like TFS/VSS
- Should possess excellent verbal and written communication skills

- AWS DB Developer certifications.
- Knowledge or Hands on work experience with C# on WCF/WPF
- Knowledge or Hands on work experience with LINQ & Entity Framework
- Microsoft BI stack - SSIS/SSAS/SSRS
- Infragistics controls experience
- Agile/Scrum methodologies