Senior SQL DB Engineer — Remote, High‑IO & TSQL

Amtex Systems Inc; Houston (TX); Remote; USD 90,000 - 120,000; Full time

Job summary

A technology consulting firm is seeking a Mid-Senior level Database Developer focusing on SQL Server technologies. The role involves working with high IO SQL Server database systems, requiring experience with system-versioned and memory-optimized tables, partitioning, performance tuning, and TSQL development. Candidates with knowledge in Azure databases will have an advantage. This position is remote and offers full-time employment.

Qualifications

• Experience with high IO SQL Server database systems (100,000+ transactions a second).
• System-Versioned tables experience is required.
• Memory Optimized tables experience is required.
• Experience with Partitioning - Partition swapping, dynamically adding/removing partitions is required.
• TSQL development skills, including complex stored procedures for integrate data flow requirements.
• Experience with performance tuning.

Skills

SQL Server technologies

TSQL development

Performance tuning

Experience with Azure databases

Tools

Visual Studio Database Projects

DACPAC

Job description

A technology consulting firm is seeking a Mid-Senior level Database Developer focusing on SQL Server technologies. The role involves working with high IO SQL Server database systems, requiring experience with system-versioned and memory-optimized tables, partitioning, performance tuning, and TSQL development. Candidates with knowledge in Azure databases will have an advantage. This position is remote and offers full-time employment.