Data Engineer with OLTP MS SQL Server w2 only
Ensisinfo Inc.
Plano, TX, United States
13 days ago
- Discuss this with your agent
- Open in Claude
- Open in ChatGPT
Apply on www.indeed.com
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
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
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Good distractions
Loading talks and stories from around this roleβ¦