Database Engineer

Overview

Job Summary:

We are looking for a skilled and detail-oriented Database Engineer to join our team. The ideal candidate will have a strong background in SQL Server and performance tuning, with the ability to analyze, optimize, and document complex stored procedures. This role involves close collaboration with the IAM Engineering team to support ongoing system enhancements and migrations.

Key Responsibilities:

• Review, optimize, and refactor complex SQL queries and stored procedures to improve performance and maintainability
• Analyze database performance issues using tools such as SQL Server Profiler and Extended Events
• Monitor and interpret SQL Profiler traces to identify slow-running queries, blocking, deadlocks, and other performance bottlenecks
• Analyze, simplify and document the flow from stored procedures into Word document for IAM engineering team to understand and help in migrating the flow

Job Types: Full-time, Contractual / Temporary
Contract length: 6 weeks

Pay: ₹1,200.00 - ₹1,500.89 per hour

Benefits:

• Work from home

Schedule:

• Monday to Friday

Application Question(s):

• Have you worked on optimizing complex SQL queries and stored procedures?
• Which tools have you used to analyze SQL Server performance issues?
• Do you have experience interpreting SQL Profiler traces?
• Are you familiar with database performance tuning best practices?
• Do you have experience working with IAM or security-related systems?

Experience:

• Total: 4 years (Required)
• MS-SQL Database: 2 years (Required)

Work Location: Remote