SQL Developer

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

Job role: SQL Developer

Duration: long term Contract

Location: Ventura, CA

Job Description

• Analyze the existing Oracle database supporting the CATS application
• Review database objects including tables, columns, keys, indexes, views, sequences, stored procedures, functions, triggers, and constraints
• Identify relationships, dependencies, and business rules embedded in the legacy database
• Assess source data quality, including duplicates, inconsistencies, and missing data
• Document source database structures and migration dependencies

Oracle to SQL Server Migration

• Develop source-to-target mappings for migration to SQL Server 2025
• Translate Oracle database structures and logic into SQL Server-compatible objects
• Convert Oracle data types, sequences, procedures, triggers, and related objects
• Build migration scripts, transformation logic, and ETL/ELT processes
• Identify and resolve cross-platform compatibility issues
• Validate migrated data for completeness, accuracy, integrity, and consistency
• Support multiple migration cycles and incremental loads as needed

SQL Server Development

• Design, develop, and maintain SQL Server database components, including:
  • Tables
  • Relational structures
  • Primary and foreign keys
  • Constraints
  • Indexes
  • Views
  • Stored procedures
  • Functions
  • Triggers
  • Sequences
• Write advanced SQL Server code to support application and migration requirements
• Troubleshoot data integrity and performance issues
• Support testing and validation activities across the migration lifecycle

Required Skills and Experience

• Strong experience as a SQL Server Developer
• Deep hands‑on expertise with Microsoft SQL Server and T‑SQL
• Experience writing stored procedures, triggers, functions, and advanced SQL queries
• Strong understanding of relational database design
• Experience with data migration, data transformation, and data validation
• Strong troubleshooting skills related to data integrity, testing, and migration issues
• Experience with database performance tuning and query optimization
• Ability to work with technical teams, analysts, QA resources, and business stakeholders

Preferred Skills

• Experience analyzing or working with Oracle databases
• Prior experience supporting Oracle-to-SQL Server migrations
• Experience with repeatable migration cycles and large data sets