Data Engineer with OLTP MS SQL Server w2 only

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

About the Role:

Ensisinfo Inc is looking for a talented Data Engineer to join our growing team in Plano, TX! In this role, you'll work at the intersection of data architecture and application development, designing robust database solutions and integrations that power critical business systems. If you're passionate about building scalable, high-performance data infrastructure, we want to hear from you.

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 and normalization standards
• 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

Requirements:

• Proven experience as a Data Engineer or Database Developer with hands-on MS SQL Server expertise
• Strong proficiency in OLTP database design and relational database management systems (RDBMS)
• Experience designing, building, and integrating REST APIs
• Solid command of T-SQL including stored procedures, functions, and performance tuning
• Deep understanding of database normalization, indexing, and schema design principles
• Ability to work independently and communicate effectively with cross-functional teams
• Bachelor's degree in Computer Science, Information Systems, or a related field preferred

About Us:

Ensisinfo Inc is a technology-driven company based in Plano, TX, dedicated to delivering innovative data and software solutions that help businesses operate smarter and more efficiently. Our team thrives on solving complex technical challenges in a collaborative, forward-thinking environment. We are committed to investing in our people and fostering a culture where great engineers can do their best work.