Apply Now

SQL Server Data Engineer

Dallas, TX, US • Posted 9 hours ago • Updated 9 hours ago

Contract Independent

Contract W2

12 Months

No Travel Required

On-site

Depends on Experience

Fitment

Dice Job Match Score™

To see how well you match this job, please log in or create an account.

Once logged in, be sure to complete your profile to get the most accurate match score.

🔢 Crunching numbers...

Job Details

Skills

SQL
OLTP
Extract, Transform, Load
Data Processing
SQL Azure
Stored Procedures
Database
Microsoft Azure

Summary

Experience: 7–10 years in SQL Server and relational database design for OLTP

JD:

Design SQL Server transactional data systems and real-time or near-real-time pipelines. Build API-driven data flows, optimize schemas and stored procedures, preserve transactional integrity, troubleshoot concurrency issues and support Azure-based data services and occasional integrations.

Key Responsibilities

- Design, build, and maintain OLTP pipelines for real-time or near-real-time transactional data processing.
- Build and consume APIs to handle data ingestion, updates, and retrieval from operational systems.
- Design SQL Server database schemas optimized for transactional workloads — normalization, indexing, concurrency control, and locking behavior.
- Write and optimize SQL queries, stored procedures, and transaction logic for high-throughput, low-latency operations.
- Ensure data consistency, atomicity, and integrity (ACID compliance) across services.
- Develop ETL processes as needed to support data migration, system integration, or occasional batch sync between transactional systems.
- Handle API request/response cycles: validation, error handling, retries, and rate limiting on data-write operations.
- Monitor system performance, diagnose issues (deadlocks, query latency, contention), and tune for scale.
- Deploy and manage data services using Azure (Azure SQL Database, API Management, Azure Blob).
- Use SSIS (SQL Server Integration Services) for occasional data migration or integration tasks.
- Collaborate with backend engineers to integrate data layers into application services.
- Implement validation, idempotency checks, and integrity constraints at the transactional level.
- Create and maintain documentation for system architecture, API contracts, and database schemas.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

Dice Id: RTX1e861f
Position Id: 9109016
Posted 9 hours ago

Contact the job poster

Chakradhar Bommi

Recruiter @ Optimuss Inc.

View Profile

Create job alert

Never miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

SQL Server Data Engineer

Hybrid in Dallas, Texas

•

2d ago

Job Title: SQL Server Data Engineer Location: Dallas, TX Job Overview We are hiring a Mid-Level Data Engineer to design and build OLTP (Online Transaction Processing) systems and pipelines. This role focuses on transactional system design, API-driven data flows, and building reliable, high-performance data services. The ideal candidate thinks in terms of system architecture, transactional integrity, and low-latency data handling rather than scheduled data warehouse loads. Key Responsibilities De

Easy Apply

Contract

Depends on Experience

SQL Server Data Engineer - Hybrid

Remote or Dallas, Texas

•

Today

Job Role: SQL Server Data Engineer - Hybrid Location: Dallas, TX Duration: Long Term Contract No C2C only W2 Job Description: Design SQL Server transactional data systems and real-time or near-real-time pipelines. Build API-driven data flows, optimize schemas and stored procedures, preserve transactional integrity, troubleshoot concurrency issues, and support Azure-based data services and occasional integrations. Important Skills to Cover: 1.SQL Server / OLTP: Relational design, normalizati

Contract

$DOE

SQL Server Data Engineer - Dallas, TX

Dallas, Texas

•

Today

Job Role: SQL Server Data Engineer Location: Dallas, TX Experience: 7 10 years in SQL Server and relational database design for OLTP No C2C only W2 Job Description: Design SQL Server transactional data systems and real-time or near-real-time pipelines. Build API-driven data flows, optimize schemas and stored procedures, preserve transactional integrity, troubleshoot concurrency issues, and support Azure-based data services and occasional integrations. Important Skills to Cover: 1.SQL Server

Contract

$DOE

Senior Database Engineer II

Remote or Dallas, Texas

•

Today

Job Overview: We are seeking a Senior Database Engineer to join our dynamic team of 100+ software engineers, designers, project managers, and specialists who are passionate about building innovative, high-quality solutions. Our work spans a wide range of impactful and forward-thinking technologies, including: Advanced algorithms for computer-adaptive testingHighly scalable, high-performance distributed systemsComprehensive learning management systemsUniversally accessible user interfacesAI-driv

Full-time

Search all similar jobs

More jobs at Optimuss Inc. in Dallas, TX