Alpha Net
Location
Chandigarh | India
Job description
Job Description :We are seeking a skilled SQL Server Database Developer to join our dynamic team. The SQL Server Database Developer will play a crucial role in designing, implementing, and maintaining database solutions to support our organization's data needs. The ideal candidate will have a strong understanding of database development principles, excellent SQL programming skills, and a passion for optimizing database performance.Responsibilities : - Analyze existing stored procedures and queries to identify areas for optimization and improvement. Provide input and recommendations to enhance performance, scalability, and maintainability. - Lead efforts to re-architect multiple databases into a single consolidated database using partitioning techniques, such as table partitioning and partitioned views. - Collaborate with stakeholders to define partitioning strategies and implement solutions that streamline data management and improve overall system efficiency. - Design and develop scalable and efficient database solutions using Microsoft SQL Server. - Collaborate with cross-functional teams to gather requirements and translate them into database designs. - Create and maintain database schemas, tables, indexes, and views to support application development. - Write complex SQL queries, stored procedures, functions, and triggers to meet business requirements. - Optimize database performance through query optimization, indexing strategies, and performance tuning. - Implement and maintain data integrity and security measures, including access controls and encryption. - Troubleshoot and resolve database-related issues in a timely manner, including data corruption, performance bottlenecks, and connectivity problems. - Develop and maintain documentation related to database design, implementation, and best practices. (ref:hirist.tech)
Job tags
Salary
