SQL Developer

PradeepIT Consulting Services Pvt Ltd; Hyderabad; On-site; INR 1,000,000 - 1,500,000; Full time

Job summary

A technology consulting firm in Hyderabad is seeking an experienced Database Developer. The ideal candidate will analyze, implement, and optimize database strategies, focusing on performance and scalability. Candidates should possess over 5 years of experience in SQL Server and demonstrate strong analytical skills. This role offers an opportunity to work on optimizing complex queries and ensuring database integrity and availability.

Qualifications

• 5+ years of experience in SQL Server with focus on performance tuning.
• Strong understanding of database indexing and normalization.
• Hands-on experience with SQL Server monitoring and diagnostic tools.

Responsibilities

• Analyze, design, and implement indexing strategies across database tables.
• Optimize complex SQL queries for performance and scalability.
• Ensure database security, integrity, and availability.

Skills

Performance tuning

SQL optimization

Database indexing

Analytical skills

Education

Bachelor's degree in Computer Science or related field

Tools

SQL Server Profiler

Entity Framework

Azure SQL Database

Job description

Responsibilities

• 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.

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).
• 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.