Real-Time OLTP Data Engineer (SQL Server)

Anblicks Inc.; Dallas (TX); Hybrid; USD 110,000 - 140,000; Full time

Job summary

Anblicks Inc. is hiring a Mid-Level Data Engineer to design and build OLTP systems and pipelines focusing on transactional integrity and low-latency data handling. The role emphasizes API-driven data flows and real-time operations.

You will design SQL Server schemas, optimize queries, ensure ACID compliance, and collaborate with backend engineers. Proficiency with Azure services (Azure SQL Database, API Management) and SSIS is expected, along with strong debugging and documentation skills.

Qualifications

• Bachelor's degree in CS or related field (or equivalent practical experience).
• 7–10 years of experience in SQL Server and OLTP relational DB design.
• Solid experience building or consuming REST APIs for data read/write operations.
• Working knowledge of Azure services: Azure SQL Database, API Management, Azure Blob Storage.
• Experience with transactional data in high-concurrency environments.
• Experience writing and optimizing SQL stored procedures for transactional systems.
• Hands-on experience with SSIS or similar data migration/integration tools.
• Knowledge of ETL development for batch sync or migration tasks.

Responsibilities

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

Skills

SQL Server

REST APIs

Azure

ETL development

Education

Bachelor's degree

Tools

SSIS

Azure SQL Database

API Management

Job description

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

• 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.
• 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.

Requirements

• Bachelor's degree in Computer Science, Information Technology, or a related field (or equivalent practical experience).
• 7–10 years of experience in SQL Server and relational database design for OLTP systems — normalization, indexing, transactions, isolation levels.
• Solid experience building or consuming APIs (REST) for data read/write operations.
• Working knowledge of Azure services: Azure SQL Database, API Management,, Azure Blob Storage.
• Experience working with transactional data in high-concurrency, production environments.
• Experience writing and optimizing SQL stored procedures for transactional systems.
• Hands-on experience with SSIS or similar tools for data migration/integration tasks.
• Working knowledge of ETL development for occasional batch sync or migration needs.
• Understanding of system design fundamentals: concurrency, caching, request handling, and service scalability.
• Experience collaborating with backend/application engineers to integrate data layers into services.
• Strong analytical, troubleshooting, and communication skills.