> Markdown version of [/jobs/ext/4565470-data-engineer-with-oltp-ms-sql-server-w2-only](https://www.wearedevelopers.com/jobs/ext/4565470-data-engineer-with-oltp-ms-sql-server-w2-only). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Data Engineer with OLTP MS SQL Server w2 only - **Company:** Ensisinfo Inc. - **Location:** Plano, TX, United States - **Salary:** $114,400 - $135,200 - **Contract:** Permanent contract - **Skills:** Business Systems, Information Systems, Databases, Data Architecture, Data Infrastructure, Data Integration, Data Integrity, Data Systems, Relational Databases, Database Design, Microsoft SQL Server, Online Transaction Processing, Performance Tuning, Query Optimization, Software Engineering, SQL Stored Procedures, Systems Integration, Transact-SQL, Database Optimization, Database Performance, Indexer, Information Technology, Restful APIs - **Published:** November 4, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=0c893a3aa6d764f0 ## About the Role * 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 ## Description * 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