Data Engineer with OLTP MS SQL Server w2 only
Ensisinfo Inc · Posted Nov 3, 2026
- Plano, Texas, United States
- On-site
- Full-time · Associate
Design, develop, and optimize OLTP MS SQL Server databases, architect relational schemas, build REST APIs, and tune T‑SQL queries to support high‑performance transactional workloads.
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
Requirements
- Bachelor's degree in Computer Science, Information Systems, or a related field