Position: Team Lead
Education Qualification: Any Graduate
Minimum Years of Experience: 4+ Years
Key Skills: MS SQL Server
Type of Employment: Permanent
Requirement: Immediate or Max 15 days
Location : Bangalore
Job Responsibilities:
- Responsible to work with development team to develop, implement, and manage data base
- models for core product development.
- Responsible to write SQL database views, tables, and stored procedures to
- support engineering product development.
- Responsible for designing and maintaining SSIS, T-SQL, and SQL jobs.
- Responsible for developing and maintaining complex stored procedures for loading data into
- staging tables from OLTP, and other intermediary systems.
- Responsible for analysis, design specifications, development, implementation, and
- maintenance of DB.
- Responsible for designing partitioning of DB for Archive data.
- Responsible to ensure that the best practices and standards established for the use of tools
- like SQL Server, SSIS, SSRS, Excel Power Pivot/View/Map are incorporated in Data Analytics
- solutions design.
- Responsible for documenting complex processes, business requirements and specifications.
Technical Skills:
- Experience in database design, normalization, query design, performance tuning
- Proficient in writing complex Transact SQL code.
- Proficient in MS SQL Server query tuning.
- Experience in writing stored procedures, functions, views and triggers.
- Experience in Indexes, column store index, SQL server column storage, Query execution plan.
- Provide authentication and authorizations for Database.
- Develop best practices for database design and development activities.
- Experience in database migration activities.
- Strong analytical, multi-tasking and problem-solving skills.
