18+ years of experience working with Microsoft SQL Server, MS SQL
10+ years of strong hands on background as a SQL developer
Excellent knowledge on writing complex SQL stored procedures in an application development environment.
Design database tables, views, indexes, functions and develop the various reports using SQL and Stored Procedures.
Work with other front-end developers in completing the database modules end to end Query optimization for performance improvement.
Should be proficient in creating database triggers Create / Modify and optimize database schemas, stored procedures and SQL queries.
Analysing, troubleshooting, and resolving data issues.
Understanding of 3rd party software APIs in order to integrate them with your solutions.
Working closely with business stakeholders and assist with data analysis with regard to SQL.
Preparing the mapping documents for the existing stored procedures.
Should be able to perform SQL profiling
Analyse the performance issues of existing stored procedure and fine tune performance of the system
Identifies and proposes database system improvements and changes.
Builds and executes data queries for business partners.
Implements systems changes, upgrades, and modifications according to business needs.
Maintain active relationships with stakeholders to understand business requirements, lead requirement gathering meetings and review designs with the stake holders
Perform technical design reviews and code reviews
Perform peer reviews on source code to ensure reuse, scalability and the use of best practices
Participate in collaborative technical discussions that focus on design, architecture, and development
Identify opportunities that can improve efficiency of business processes
Troubleshoot software application and technical issues - identify modifications needed in existing applications to meet changing user requirements
Should prefer knowledge working in US Healthcare Payer domain
Skills
product architecture,sql queries,performance tuning,microsoft sql server,sql development,database design,