Open app
Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

SQL Developer

VDart

Ventura, CA
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
Apply
Vacancy posted more than 2 months ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to SQL Developer. Be the first to apply!

Related searches