Senior Software Engineer - SQL Server

2 - 5 years

2 - 5 Lacs

Posted:9 hours ago| Platform: Foundit logo

Apply

Skills Required

excel power pivot/

Work Mode

On-site

Job Type

Full Time

Job Description

  • Responsibilities

  • Collaborate with the development team to develop, implement, and manage database models for core product development.
  • Write SQL database views, tables, and stored procedures to support engineering product development.
  • Design and maintain SSIS packages, T-SQL scripts, and SQL Server Agent jobs.
  • Develop and maintain complex stored procedures for loading data into staging tables from OLTP and other intermediary systems.
  • Perform analysis, design specifications, development, implementation, and maintenance of databases.
  • Design database partitioning strategies for archiving data.
  • Ensure best practices and standards for tools like SQL Server, SSIS, SSRS, Excel Power Pivot/View/Map are incorporated into data analytics solution design.
  • Document complex processes, business requirements, and technical specifications.
  • Technical Skills

  • Experience in database design, normalization, query design, and performance tuning.
  • Proficient in writing complex Transact-SQL (T-SQL) code.
  • Skilled in MS SQL Server query tuning.
  • Experience writing stored procedures, functions, views, and triggers.
  • Knowledge of indexes, columnstore indexes, SQL Server column storage, and query execution plans.
  • Experience providing authentication and authorization for databases.
  • Ability to develop best practices for database design and development activities.
  • Experience in database migration activities.
  • Strong analytical, multitasking, and problem-solving skills.

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now
Maimsd Technology logo
Maimsd Technology

Technology / Software

Silicon Valley

RecommendedJobs for You