More jobs:
SQL Developer
Job in
Ventura, Ventura County, California, 93006, USA
Listed on 2026-10-13
Listing for:
VDart Inc
Full Time
position Listed on 2026-10-13
Job specializations:
-
IT/Tech
Database Administrator, Data Engineering, IT Consultant
Job Description & How to Apply Below
Job role: SQL Developer
Duration: long term Contract
Location:
Ventura, CA
- 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
- 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
- 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
- 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
- Experience analyzing or working with Oracle databases
- Prior experience supporting Oracle-to-SQL Server migrations
- Experience with repeatable migration cycles and large data sets
To View & Apply for jobs on this site that accept applications from your location or country, tap the button below to make a Search.
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
Search for further Jobs Here:
×