Data Engineer with OLTP MS SQL Server w2 only

Ensisinfo Inc.
Plano, TX, United States
13 days ago
Apply on www.indeed.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Compensation
$114,400 - $135,200
Working hours
Regular working hours
Job source

Tech stack

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
+11 more
Performance Tuning Query Optimization Software Engineering SQL Stored Procedures Systems Integration Transact-SQL Database Optimization Database Performance Indexer Information Technology Restful APIs

Job 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

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 the company

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.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.indeed.com
Prepare application

Good distractions

Loading talks and stories from around this role…