SQL Developer

PGC Digital; Hyderabad; On-site; INR 1,000,000 - 1,500,000; Full time

Job summary

A tech company in Hyderabad is looking for a Database Performance Engineer with over 5 years of SQL Server experience. Responsibilities include analyzing and optimizing database performance, implementing indexing strategies, and collaborating with application developers on ORM efficiency. The ideal candidate will possess strong analytical and problem-solving skills, a solid understanding of database management, and a Bachelor's degree in a relevant field. This role offers an opportunity to work in a dynamic environment focused on enhancing database capabilities.

Qualifications

• 5+ years of experience in SQL Server (2016+ preferred) with a strong focus on performance tuning and optimization.
• Strong understanding of database indexing, normalization, and denormalization strategies.
• Hands-on experience with monitoring and diagnostic tools for SQL Server performance.

Responsibilities

• Analyze, design, and implement indexing strategies across key database tables.
• Optimize complex SQL queries, views, and stored procedures for performance and scalability.
• Conduct regular performance tuning reviews and provide recommendations.

Skills

Performance tuning and optimization

Database indexing

Analytical skills

Problem-solving skills

Collaboration with developers

Education

Bachelor's degree in Computer Science, Information Systems, or related field

Tools

SQL Server Profiler

Entity Framework

Azure SQL Database

Job description

• Analyze, design, and implement indexing strategies across key database tables.
• Optimize complex SQL queries, views, and stored procedures for performance and scalability.
• Identify and resolve database performance bottlenecks.
• Monitor database health using tools like SQL Server Profiler, Extended Events, Query Store, and third-party performance monitoring tools.
• Collaborate with application developers to review data access patterns and improve ORM efficiency (e.g., Entity Framework).
• Conduct regular performance tuning reviews and provide recommendations.
• Design and implement database maintenance plans (backups, indexing, statistics updates, etc.).
• Develop and maintain documentation related to database design and optimization strategies.
• Ensure database security, integrity, and availability in production environments.
• 5+ years of experience in SQL Server (2016+ preferred) with a strong focus on performance tuning and optimization.
• Strong understanding of database indexing, normalization, and denormalization strategies.
• Experience in optimizing large and complex stored procedures and SQL queries.
• Hands-on experience with monitoring and diagnostic tools for SQL Server performance.
• Familiarity with .NET-based applications and ORM frameworks like Entity Framework.
• Experience in scaling SaaS applications is a strong plus.
• Strong analytical and problem-solving skills.
• Bachelor's degree in Computer Science, Information Systems, or a related field (or equivalent experience).
• Experience with Azure SQL Database or other cloud-based databases.
• Exposure to NoSQL or hybrid database architectures.
• Familiarity with CI/CD pipelines and DevOps practices related to DB changes.
• Qualifications:
  5+ years of experience in SQL Server (2016+ preferred) with a strong focus on performance tuning and optimization.
  Strong understanding of database indexing, normalization, and denormalization strategies.
  Experience in optimizing large and complex stored procedures and SQL queries.
  Hands-on experience with monitoring and diagnostic tools for SQL Server performance.
  Familiarity with .NET-based applications and ORM frameworks like Entity Framework.
  Experience in scaling SaaS applications is a strong plus.
  Strong analytical and problem-solving skills.
  Bachelor's degree in Computer Science, Information Systems, or a related field (or equivalent experience).