26 Oct
|
Esyasoft Technologies Private
|
India
26 Oct
Esyasoft Technologies Private
India
Position: SSE Education Qualification: Graduate (BE/B.
Tech/B.
Sc/M.
Tech/MCA/BCA) Minimum Years of
Experience:
2+ Years Key
Skills:
MS SQL Server Requirement: Immediate or Max 15 days 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. Requirements
• 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.
• Robust analytical, multi-tasking and problem-solving skills.
📌 Senior Software Engineer (India)
🏢 Esyasoft Technologies Private
📍 India