**About the Company** Are you looking to be part of a leading, innovative, inclusive, and collaborative company that allows you to grow while maintaining a balance between your personal and professional life? If so, congratulations! **DEINTEC** is the right place for you. We are a 100% Mexican consulting firm specialized in Information Technology, working with diverse clients across various sectors (such as pharmaceutical, metallurgical, technology, gases, etc.), and we are currently seeking passionate IT professionals. Discover below the job opportunity we have for you! **Senior SQL Server Performance Analyst** **Requirements** * **Education:** Bachelor's degree in Computer Science, Information Technology, Business Administration, or related fields * **Language:** Technical English * **Experience:** +5 years in similar roles * **Work Mode:** On-site **Experience** * Advanced T-SQL * Execution Plan Analysis * Native Diagnostic Tools: * Dynamic Management Views (DMVs) and Functions (DMFs) * SQL Server Extended Events * Query Store * SQL Server Profiler / SQL Trace **Main Responsibilities:** * **Query Analysis and Optimization (Query Tuning):** Identify long-running or resource-intensive SQL queries. Analyze execution plans, rewrite complex queries, and propose creating or modifying indexes to improve efficiency. * **Performance Issue Diagnosis:** Investigate and resolve performance issues such as blocking, deadlocks, excessive waits, and resource contention. * **Load Analysis and Stress Testing:** Plan and execute load tests to simulate demand peaks, identify breaking points, and ensure system scalability. * **Reporting and Documentation:** Generate detailed reports on performance status, improvements made, and future recommendations. Document best practices and findings for the development and operations teams. **We Offer:** * Competitive salary based on experience * Statutory benefits (IMSS + Christmas bonus + Vacation + Vacation premium) * Working Monday through Friday **If you meet the profile and are interested in joining our team, apply now and become part of Deintec to keep growing together!** Job type: Full-time, Temporary project-based or fixed-term contract Contract duration: 3 months Salary: $14,629.59 - $29,035.90 per month Work location: On-site position