SQL Server Developer: Oracle-to-SQL Migration

VDart Inc; Ventura (CA); On-site; USD 83,000 - 152,000; Full time

Job summary

VDart Inc in Ventura, CA is seeking an experienced SQL Developer to lead Oracle-to-SQL Server migrations and ongoing SQL Server development. You will analyze legacy databases, design robust schemas, and implement reliable ETL/ELT processes to support the migration and application needs.

The role requires deep T-SQL expertise, stored procedures, triggers, and data validation, plus collaboration with analysts, QA, and business stakeholders to ensure data integrity and performance throughout

Qualifications

• Requires strong experience as SQL Server Developer.
• Proficient with Microsoft SQL Server and T-SQL.
• Experience writing stored procedures, triggers, and functions.
• Knowledge of relational database design.
• Experience with data migration, data transformation, and data validation.
• Strong debugging and performance tuning skills.
• Ability to work with cross-functional teams.

Responsibilities

• Analyze Oracle database and migration to SQL Server.
• Develop source-to-target mappings for migration to SQL Server 2025.
• Translate Oracle structures to SQL Server objects and logic.
• Build migration scripts and ETL/ELT processes.
• Validate migrated data for completeness, accuracy, integrity.
• Support multiple migration cycles and incremental loads.
• Design, develop, and maintain SQL Server components (tables, relations, keys, constraints, indexes, views, procedures, functions, triggers, sequences).
• Write and optimize advanced SQL queries, troubleshoot data issues, support testing and validation.

Skills

SQL Server

T-SQL

Stored procedures

Triggers

Functions

Data migration

Data validation

Data integrity

Performance tuning

Team collaboration

Job description

VDart Inc in Ventura, CA is seeking an experienced SQL Developer to lead Oracle-to-SQL Server migrations and ongoing SQL Server development. You will analyze legacy databases, design robust schemas, and implement reliable ETL/ELT processes to support the migration and application needs.

The role requires deep T-SQL expertise, stored procedures, triggers, and data validation, plus collaboration with analysts, QA, and business stakeholders to ensure data integrity and performance throughout