Data Engineer with OLTP MS SQL Server w2 only

Plano, TX

Full-time

9 days ago

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.

Numbers & Facts

Location	Plano, TX
Job Type	Full-time

Skills

Application Programming Interface (API)unmatched
Best Practicesunmatched
Business Solutionsunmatched
Communication Skillsunmatched
Computer Scienceunmatched
Cross-Functionalunmatched
Data Qualityunmatched
Database Designunmatched
Database Programmingunmatched
Database Technologyunmatched
Database Triggersunmatched
Information Technology & Information Systemsunmatched
Information/Data Security (InfoSec)unmatched
Microsoft SQL Serverunmatched
Microsoft Transact-SQL (T-SQL)unmatched
Performance Managementunmatched
Performance Tuning/Optimizationunmatched
Process Improvementunmatched
Query Optimizationunmatched
REST (Representational State Transfer)unmatched
Relational Databases (RDBMS)unmatched
Requirements Managementunmatched
Scalable System Developmentunmatched
Software Designunmatched
Software Developmentunmatched
Software Engineeringunmatched
Stored Proceduresunmatched
Team Playerunmatched
Transaction Processing/Managementunmatched

Level up your application

Professional resume templates

Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

Free resume templates

Resume Builder

Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

Resume Builder