Job Description for SQL Server Developer :
Job Location : Hyderabad
Need Experience : 8 + Years only
Education : Bachelors 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 databasesCapable of troubleshooting common database issues and Skilled at optimizing large complicated SQL procedures and functionsWorking 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 itProficient 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 scalabilitySolve deadlock and bottlenecks with SQL indexes and partitionsDevelops 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 conceptsKnowledge of CI / CD and DevOps is a plus.(ref : hirist.tech)