Role: MS SQL Database Engineer (SSMS)
Industry Type: IT Services & Consulting
Department: Engineering - Software & QA
Employment Type: Full Time, Permanent
Role Category: Software Development
UG: Any Graduate
Job title: MS SQL Database Engineer
Primary Skill: SSMS, SSIS, SQL Server
Location: Pune
Must have Skills:
- Strong hands-on Microsoft SQL Server experience
- MS SQL database design, data modeling and development
- T-SQL development (stored procedures, functions, views, triggers)
- MS SQL performance tuning and query optimization
- SQL scripting and automation
- Proficiency with SQL Server Management Studio (SSMS)
Nice to Have:
- .NET API development & integration
- C# development
- REST API design and integration
- Microsoft Internet Information Services (IIS) administration
- VBScript (maintaining/automating legacy scripts)
Responsibilities:
- Design, develop and maintain MS SQL Server database objects (schemas, tables, stored procedures, functions, views)
- Build and optimize complex T-SQL queries and scripts
- Perform performance tuning, indexing and query optimization
- Develop SQL scripting and automation for data processing and operational tasks
- Collaborate with application development teams on database design and integration
- Support data integration between SQL Server and.NET / REST-based applications
- Ensure data quality, integrity and adherence to the bank's standards and controls