Senior MS SQL Developer

Position: SQL Developer

Location: Ahmedabad

SQL Developer Job Profile:

SQL Developers are responsible for developing SQL databases and writing applications to interface with SQL databases. Development often consists of designing tables, storing procedures, views, and functions.

SQL Developer Job Description:

We are looking for a SQL developer to develop MS-SQL queries and procedures, create custom reports, and modify ERP user forms to enhance organizational productivity. You will be responsible for designing databases and ensuring their stability, reliability, and performance.

SQL Developer Duties and Responsibilities:
• Development of high-quality database solutions
• Develop, implement, and optimize stored procedures and functions using T-SQL
• Review and interpret ongoing business report requirements.
• Research required data.
• Build appropriate and useful reporting deliverables.
• Analyze existing SQL queries for performance improvements.
• Suggest new queries.
• Develop procedures and scripts for data migration.
• Provide timely scheduled management reporting.
• Investigate exceptions regarding asset movements.

Qualifications

Skills:
• Proficiency in MS SQL Server, including query optimization, stored procedures, triggers, and indexing.
• Strong understanding of relational database design principles.
• Experience with database performance tuning and optimization.
• Knowledge of data integration and ETL (Extract, Transform, Load) processes.
• Familiarity with database administration tasks, such as backup and recovery, security, and user management.
• Ability to write efficient and reliable database scripts and queries.
• Knowledge of database development tools, such as SQL Server Management Studio (SSMS) or Azure Data Studio.
• Understanding of database development best practices and version control systems

Education:
• A bachelor's or master's degree in computer science, information technology, or a related field is typically required. However, relevant work experience can sometimes compensate for formal education.
• Experience:
• Proven experience as an MS SQL developer, with a focus on developing and maintaining complex database systems.
• Demonstrated ability to design and implement database solutions based on business requirements.
• Experience in troubleshooting and resolving database-related issues.
• Knowledge of data warehousing concepts and practices.
• Experience in performance optimization and tuning of database systems.
• Familiarity with data modeling tools and techniques.
• Experience with integration of SQL Server with other technologies, such as .NET, Java, or web services.

Certifications:
• Microsoft Certified: Azure Database Administrator Associate or Microsoft Certified: Data Engineer Associate can demonstrate expertise in MS SQL Server and related technologies.
• Other relevant certifications, such as Microsoft Certified: SQL Server Developer or Microsoft Certified: Database Administrator, can also be beneficial.

Soft Skills:
• Excellent verbal and written communication skills to effectively collaborate with team members and stakeholders.
• Strong problem-solving and analytical skills.
• Attention to detail and ability to work with complex datasets.
• Ability to work independently and in a team environment.
• Strong organizational and time management skills