SQL Server Developer

Job Description for SQL Server Developer:

Job Location: Hyderabad

Need Experience: 8 + Years only

Education: Bachelor’s Degree( B.Tech – M.Tech)

We are looking for a Senior MS SQL developer (T-SQL) who will be responsible for designing databases and ensuring their stability, reliability, and performance. You will also work other developers optimizing in-application SQL statements as necessary, and establishing best practices. You will help solve all database usage issues and come up with ideas and advice that can help avoid such problems in the future.

Responsibilities

· Help write and optimize in-application SQL statements

· Ensure performance, security, and availability of databases

· Prepare documentations and specifications

· Handle common database procedures such as upgrade, backup, recovery, migration, etc.

· Profile server resource usage, and optimize and tweak as necessary

· Collaborate with other team members and stakeholders

· Work with JSON (search , update ) data

Skills and Qualifications

· Strong proficiency with SQL 2019 and its variation among popular databases

· Capable of troubleshooting common database issues and Skilled at optimizing large complicated SQL procedures and functions

· Working experience in Azure SQL databases is preferred.

· SSIS and SSRS knowledge preferred.

· Ability to plan resource requirements from high level specifications.

· Familiar with tools that can aid with profiling server resource usage and optimizing it

· Proficient understanding of code versioning tools such as {{Git /TFS/ SVN}}

· Database analysis: Identify opportunities for performance and functional improvement to maximize data security and application scalability

· Solve deadlock and bottlenecks with SQL indexes and partitions

· Develops validation/qualification deliverables such as Validation Plans, Requirements Specifications, Traceability Matrices, Summary Reports, Change Controls.

· Completes all calibration, qualification and validation documentation with accuracy, completeness, and compliance to standards.

· Proficient in OLTP, OLAP and Data Warehousing Design concepts

· Knowledge of CI/CD and DevOps is a plus.

Job Type: Full-time

Pay: ₹276,654.75 - ₹1,328,724.06 per year

Work Location: In person