SQL Server Data Engineer

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.

#J-18808-Ljbffr