MS SQL server database developer

Job description
Role: MS SQL Database Developer. Experience: 5+ Years Location: Chennai JD: SUMMARY: Responsible for performance, integrity and security of the database, hands on experience in T-SQL programming. RESPONSIBILITIES · Writing T-SQL Queries using joins and Sub queries in MS SQL Server. · T-SQL development skills to write complex queries involving multiple tables, Joins. · Experience in Extracting, Transforming and Loading (ETL) data from Excel Flat file to MS SQL Server. · Creating primary objects (tables, views, indexes) · Generating various reports by querying from database as per need. · Customer support for environmental issues and maintenance · Data conversions from different sources Additional role requirements are likely to include planning, development and troubleshooting. Responsible for maintaining the consistency of data across database, maintains data integrity and data security. Also plan, design and developing database maintenance procedures and also help the development team to design the database based on business requirements. ADDITIONAL RESPONSIBILITY: · SQL knowledge (query performance tuning, index maintenance, etc.) as well as an understanding of database structure · Knowledge of data modelling principles · Design, implement, and continuously expand data pipelines by performing extraction, transformation, and loading activities · Be responsible for the development of the conceptual, logical, and physical data models, the implementation of RDBMS, operational data store (ODS), data marts, and data lakes on target platforms (SQL). · Oversee and govern the expansion of existing data architecture and the optimization of data query performance via best practices. The candidate must be able to work independently and collaboratively. · Maintain and improve already existing processes