Sql Developer

Shasta Tek Solutions is actively seeking an experienced SQL Developer to join our dynamic team in Chennai. This is an excellent opportunity for professionals with a strong background in database development, performance tuning, and SQL Server technologies to contribute to major program changes and deliver significant business benefits. The ideal SQL Developer will possess robust analytical skills and a commitment to excellence in database design and optimization.

Key Responsibilities

• Design robust table structures and develop complex stored procedures and functions tailored to business requirements.
• Collaborate within a professional, dynamic, and creative development team to support the delivery of critical program changes.
• Facilitate seamless delivery to end-users, dependent applications, and ensure smooth support processes including deployment, build, backup, and database restoration.
• Prepare comprehensive database design documents that adhere to industry best practices and internal standards.
• Continuously improve query and overall database performance through expert tuning and optimization techniques.
• Work closely with other team members on the design of software systems and provide essential support to the development team.

Requirements

• 2 to 7 years of hands-on experience as a SQL Developer.
• Proficiency in MS SQL, SSIS, SSRS, and Power BI.
• Extensive experience with SQL queries and T-SQL for MS-SQL server, including Stored Procedures, Views, Functions, and CTEs.
• Demonstrated expertise in database design and MS SQL Performance tuning.
• Comfortable creating and maintaining complex SQL stored procedures and packages.
• Good understanding of the entire Software Development Life Cycle (SDLC).
• Ability to generate and analyze query plans to identify deficiencies in query execution and implement performance enhancements.
• Familiarity with RDBMS principles, database design, and normalization.
• Excellent academic background coupled with strong analytical, problem-solving, organizational, communication, and interpersonal skills.

What We Offer

• An opportunity to work on challenging and impactful projects with a professional development team.
• A collaborative and creative work environment focused on innovation.
• The chance to significantly improve database and query performance for critical business applications.