SQL Server Database Engineer

VettedBench; United States; Remote; USD 120,000 - 160,000; Full time

Job summary

VettedBench is seeking a data/ETL engineer to design and implement SQL Server database-per-tenant schemas and lead the migration of historical data into a new target environment.

The role emphasizes automated data migration, performance tuning, and automated validation across migrated datasets to ensure data integrity and accuracy in a scalable, automated workflow.

Qualifications

• Experience with SQL Server and TS QL optimization and performance tuning.
• Hands-on data migration and ETL scripting for large datasets.
• Designing scalable, tenant-isolated database architectures.

Responsibilities

• Design target SQL Server database-per-tenant schemas.
• Develop automated historical data migration and transformation ETL scripts.
• Optimize stored procedures and indexes for performance.
• Build automated reconciliation tooling to validate data integrity.

Skills

SQL Server

T-SQL

Database-per-Tenant Schema Design

Data Migration & ETL Scripting

Query Performance Tuning

Data Integrity & Reconciliation Tool**

Job description

Position Overview:

This role focuses on designing and implementing SQL Server database-per-tenant schemas and managing

the migration of historical data into the new target environment. The engineer will develop automated data

migration and transformation ETL scripts, optimize stored procedures and indexes for performance, and

build automated reconciliation tooling to validate data integrity across the migrated datasets. The role

requires strong expertise in SQL Server and T-SQL, with an emphasis on performance tuning, data

accuracy, and automation.

Key Responsibilities:

• Design target SQL Server database-per-tenant schemas
• Develop automated historical data migration and transformation ETL scripts
• Optimize stored procedures and indexes
• Build automated reconciliation tooling to validate data integrity

Required Skills:

• SQL Server
• T-SQL
• Database-per-Tenant Schema Design
• Data Migration & ETL Scripting
• Query Performance Tuning
• Data Integrity & Reconciliation Tooling