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.

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