SQL Developer

AI overview

Analyze and optimize SQL queries and database schemas, while enhancing performance for production OLTP systems in a dynamic tech environment.

Trinetix is looking for an experienced SQL Developer with deep, practical expertise in MS SQL Server, with a focus on query optimization, performance tuning, and the design of efficient database schemas. A key part of this role is reviewing, analyzing, and improving existing SQL and schema structures in production OLTP systems, as well as building new schemas from scratch based on business requirements.

Key Responsibilities

  • Analyze and optimize slow SQL queries in MS SQL Server (joins, subqueries, window functions, etc.).
  • Review and improve existing database schemas used in production systems.
  • Design and build new database schemas from scratch, ensuring performance and scalability.
  • Work with execution plans, indexes, statistics, and partitioning to enhance performance.
  • Diagnose bottlenecks and issues in production OLTP systems using monitoring and profiling tools.
  • Collaborate with developers to ensure efficient SQL and schema use across the platform.
  • Propose structural, architectural, and performance-oriented improvements.

Required Experience

  • 3+ years of hands-on experience with MS SQL Server as a SQL Developer.
  • Demonstrated practical experience in SQL query optimization in production environments.
  • Strong skills in analyzing execution plans, designing indexing strategies, and tuning performance.
  • Experience building new, production-ready database schemas from scratch.
  • Solid knowledge of OLTP database design principles and best practices.
  • Ability to present real examples of performance improvements or schema redesigns you have implemented.

Nice to Have

  • Familiarity with SQL Server tools for performance monitoring (SQL Profiler, Extended Events, DMVs, etc.).

What we offer   

  • Continuous learning and career growth opportunities 
  • Professional training and English/Spanish language classes   
  • Comprehensive medical insurance 
  • Mental health support 
  • Specialized benefits program with compensation for fitness activities, hobbies, pet care, and more 
  • Flexible working hours 
  • Inclusive and supportive culture  

About Us 

Established in 2011, Trinetix is a dynamic tech service provider supporting enterprise clients around the world. 

Headquartered in Nashville, Tennessee, we have a global team of over 1,000 professionals and delivery centers across Europe, the United States, and Argentina. We partner with leading global brands, delivering innovative digital solutions across Fintech, Professional Services, Logistics, Healthcare, and Agriculture. 

Our operations are driven by a strong business vision, a people-first culture, and a commitment to responsible growth. We actively give back to the community through various CSR activities and adhere to international principles for sustainable development and business ethics. 

To learn more about how we collect, process, and store your personal data, please review our Privacy Notice: https://www.trinetix.com/corporate-policies/privacy-notice 

Perks & Benefits Extracted with AI

  • Education Stipend: Professional training and English/Spanish language classes
  • Flexible Work Hours: Flexible working hours
  • Health Insurance: Comprehensive medical insurance
  • Specialized benefits program: Specialized benefits program with compensation for fitness activities, hobbies, pet care, and more
Get hired quicker

Be the first to apply. Receive an email whenever similar jobs are posted.

Ace your job interview

Understand the required skills and qualifications, anticipate the questions you may be asked, and study well-prepared answers using our sample responses.

SQL Developer Q&A's
Report this job
Apply for this job