MS SQL Data Engineer: OLTP & API-Driven Solutions

Ensisinfo Inc; Plano (TX); On-site; USD 95,000 - 130,000; Full time

Job summary

Ensisinfo Inc in Plano, TX is seeking a Data Engineer to design robust data architectures and optimize MS SQL Server workloads. You will build scalable data integrations that power critical business systems and collaborate with cross-functional teams to translate requirements into reliable database solutions.

The role emphasizes performance, security, and data integrity in a fast-moving environment. A bachelor's degree is preferred, and strong problem-solving skills are essential for success.

Qualifications

• Hands-on MS SQL Server experience
• OLTP database design and normalization fundamentals
• Experience designing/building REST APIs
• Proficient in T-SQL, procedures, functions and performance tuning
• Strong understanding of indexing and schema design principles
• Ability to communicate effectively with cross-functional teams
• Bachelor's degree preferred

Responsibilities

• Design, develop, and optimize OLTP MS SQL Server databases for high-performance transactional workloads
• Architect and implement relational database schemas following RDBMS best practices
• Build, maintain, and consume REST APIs to enable seamless data integration across systems
• Write and tune complex T-SQL queries, stored procedures, views, and triggers
• Monitor and improve database performance through indexing strategies and query optimization
• Collaborate with software engineers and business stakeholders to translate requirements into data solutions
• Ensure data integrity, security, and availability across all database environments

Skills

MS SQL Server

OLTP DB design

REST APIs

T-SQL

Indexing

Schema design

Communication

Education

Bachelor's degree in Computer Science, Information Systems, or related field

Job description

Ensisinfo Inc in Plano, TX is seeking a Data Engineer to design robust data architectures and optimize MS SQL Server workloads. You will build scalable data integrations that power critical business systems and collaborate with cross-functional teams to translate requirements into reliable database solutions.

The role emphasizes performance, security, and data integrity in a fast-moving environment. A bachelor's degree is preferred, and strong problem-solving skills are essential for success.