Browse job offers by Category or Location
Analyze and optimize SQL Server queries, procedures, and indexes to improve overall database performance. Identify and resolve performance bottlenecks, query inefficiencies, and database performance issues. Collaborate with development teams to design and implement efficient database structures and query optimization techniques. Create and maintain SQL queries for generating reports and extracting data. Monitor and analyze database performance metrics to identify areas for improvement. Perform database tuning activities, including index creation, index optimization, and query plan analysis. Troubleshoot and resolve database-related issues, including performance degradation and data integrity problems. Stay up-to-date with the latest trends and best practices in SQL Server performance tuning and optimization.CompetenciesStrong experience in SQL Server performance tuning and query optimization.Proficiency in writing complex SQL queries, stored procedures, and functions.In-depth knowledge of indexing strategies and techniques.Familiarity with query execution plans and performance monitoring tools.Experience in creating and optimizing queries for reporting purposes.Skill SetStrong problem-solving and analytical skills.Excellent communication and collaboration skills.Ability to work independently and prioritize tasks effectively.LanguagesEnglish (avanced)Portuguese