SQL Developer @ Saffronbizz Solutions

Job Description

Skills : Proficiency in writing and optimizing T-SQL queries, stored procedures, functions, and triggers. Strong understanding of database design principles, normalization, and denormalization. Ability to optimize database performance by analyzing query execution plans, indexing, and other performance tuning techniques. Skill in creating and optimizing stored procedures for data manipulation and retrieval. Knowledge of techniques for optimizing SQL queries to improve efficiency and performance. Familiarity with different types of indexes and their appropriate use to enhance database performance. Basic knowledge of database administration tasks, such as backups, restores, and security management. Understanding when and how to normalize or denormalize database structures based on application requirements. Knowledge of database security principles and the ability to implement security measures, including user roles and permissions. Familiarity with ETL processes for. data integration and migration. Experience with SQL Server Reporting Services (SSRS) for creating and managing reports. Understanding of SQL Server Integration Services (SSIS) for ETL processes and data transformation. Familiarity with SQL Server Analysis Services (SSAS) for data analysis and multidimensional modeling. Ability to troubleshoot and resolve database-related issues. Responsibilities : Design, develop, and implement database solutions based on application requirements. Optimize SQL queries and stored procedures for better performance. Perform routine database maintenance tasks, including backups, restores, and data integrity checks. Work on designing and implementing database schemas and data models. Implement and manage database security, including user access and permissions. Implement security measures within the application, including authentication and authorization. Develop and maintain ETL processes for data integration and migration. Create and manage reports using SSRS and perform data analysis using SSAS. Collaborate with application developers, system administrators, and other stakeholders to ensure seamless integration and optimal database performance. Provide support for troubleshooting and resolving database-related issues. Monitor and analyze database performance, making recommendations for improvements. Follow best practices and industry standards for database development and administration. Qualification : Any Graduate with relevant experience. work place : Nashik Salary : 3.2LPA to 4.2LPA

Employement Category:

Employement Type: Full time
Industry: Others
Role Category: Graphic Design
Functional Area: Not Applicable
Role/Responsibilies: SQL Developer

+ View Contact

Keyskills:   TSQL database design query optimization stored procedures indexing database administration troubleshooting ETL processes SQL Server Reporting Services SSRS SQL Server Integration Services SSIS SQL Server Analysis Services SSAS