SQL Developer (OLTP) at Trinetix

Lisbon, , Portugal -

Full Time

Start Date

Immediate

Expiry Date

22 Mar, 26

Salary

0.0

Posted On

22 Dec, 25

Experience

2 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

SQL Development, Query Optimization, Performance Tuning, Database Schema Design, Execution Plans, Indexing Strategies, OLTP Systems, Monitoring Tools, Collaboration, Performance Improvements

Industry

IT Services and IT Consulting

Description

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

Responsibilities

The SQL Developer will analyze and optimize slow SQL queries and improve existing database schemas in production OLTP systems. They will also design and build new database schemas based on business requirements.