SQL Developer
Job role: SQL DeveloperDuration: long term ContractLocation: Ventura, CAJob DescriptionAnalyze the existing Oracle database supporting the CATS applicationReview database objects including tables, columns, keys, indexes, views, sequences, stored procedures, functions, triggers, and constraintsIdentify relationships, dependencies, and business rules embedded in the legacy databaseAssess source data quality, including duplicates, inconsistencies, and missing dataDocument source database structures and migration dependenciesOracle to SQL Server MigrationDevelop source-to-target mappings for migration to SQL Server 2025Translate Oracle database structures and logic into SQL Server-compatible objectsConvert Oracle data types, sequences, procedures, triggers, and related objectsBuild migration scripts, transformation logic, and ETL/ELT processesIdentify and resolve cross-platform compatibility issuesValidate migrated data for completeness, accuracy, integrity, and consistencySupport multiple migration cycles and incremental loads as neededSQL Server DevelopmentDesign, develop, and maintain SQL Server database components, including:TablesRelational structuresPrimary and foreign keysConstraintsIndexesViewsStored proceduresFunctionsTriggersSequencesWrite advanced SQL Server code to support application and migration requirementsTroubleshoot data integrity and performance issuesSupport testing and validation activities across the migration lifecycleRequired Skills and ExperienceStrong experience as a SQL Server DeveloperDeep hands-on expertise with Microsoft SQL Server and T-SQLExperience writing stored procedures, triggers, functions, and advanced SQL queriesStrong understanding of relational database designExperience with data migration, data transformation, and data validationStrong troubleshooting skills related to data integrity, testing, and migration issuesExperience with database performance tuning and query optimizationAbility to work with technical teams, analysts, QA resources, and business stakeholdersPreferred SkillsExperience analyzing or working with Oracle databasesPrior experience supporting Oracle-to-SQL Server migrationsExperience with repeatable migration cycles and large data sets