SQL Developer

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