Position: SE/ SSE
Education Qualification: Any Graduate
Minimum Years of Experience: 2 Years
Key Skills: MS SQL Server
Type of Employment: Permanent
Location : Any where in India
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 TSQL 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 plan.
Provide authentication and authorizations for Database.
Develop best practices for database design and development activities.
Experience in database migration activities.
Strong analytical multitasking and problemsolving skills.
About:
EsyaSoft Technologies is a pioneer in Technology & Analytics solutions that enables the modernization of power water and gas distribution networks and help energy companies to reduce costs improve network efficiency and increase revenues. We collaborate with leading Energy Utilities Government Agencies OEMs and System Integrators to provide technology & analytics solutions products and services.
stored procedures,ms sql server,ssrs,t-sql,excel power pivot/view/map,database design,ssis,transact sql,sql,sql server
SQL Server Developer - Vizag
