SQL Developer

VDart Inc

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 2 days ago

Similar jobs that could be interesting for youBased on the SQL Developer in Ventura, CA vacancy

SQL Server Developer
...border: 1px solid #e6e6e6; } tr th { background-color: #f5f5f5; } Requirements ~6 or more years of experience as a SQL Server Developer with deep hands-on T-SQL expertise. ~ Proficiency in writing stored procedures, triggers, functions, and advanced SQL queries...
Suggested
RESOURCESOFT, INC.
Ventura, CA
2 days ago
Database Developer
We are looking for a Database Developer to join a team in Ventura, California on a Long-term Contract assignment. This role is ideal for someone with strong experience building and optimizing SQL Server database solutions, supporting data integration processes, and developing...
Suggested
Long term contract
Robert Half
Ventura, CA
1 day ago
MAXIMO SOFTWARE ENGINEER
...applications to meet business process and application requirements ~ Develop and modify Oracle database objects - Packages, Procedures,... ...Outbound Interfaces ~3+ years database programming including SQL Queries, Oracle Procedural Language PL/SQL and very conversant with...
Suggested
Temporary work
Flexible hours
VSolvit
Ventura, CA
a month ago
SOFTWARE ENGINEER
...implementing solutions, and optimizing performance. This is a hands-on developer role with the opportunity to grow one’s software developer... ...packages/procedures for Java facing applications Write SQL queries, database triggers, PL/SQL, and packages according to the...
Suggested
Temporary work
Work at office
Remote work
Flexible hours
VSolvit
Ventura, CA
23 days ago
Software Engineer II
$151.4k - $227k
...from The Trade Desk, Inc. office in Bellevue, WA. Job Duties:Develop new features for and improve the quality of The Trade Desk's real... ...memory dumps to optimize latency sensitive systems; and using SQL Server, Postgres, MySQL, or a similar RDBMS in a performance-sensitive...
Suggested
Full time
Temporary work
Work at office
Remote work
Worldwide
The Trade Desk
Ventura, CA
2 days ago
Lead I - Software Engineering
...Key Responsibilities Development • Develop responsive web applications using Angular and .NET Framework • Build feature-rich frontends... ...Proficiency with Angular CLI, RxJS, and component libraries • SQL Server database knowledge • RESTful API development skills •...
Work at office
Tranzeal
Ventura, CA
3 days ago
Software Engineer I
$95.2k - $123.76k
...legislative changes. Performing quality assurance to ensure applications meet user needs and requirements. Create and modify reports. Developing SQL scripts to research and identify appropriate methods of resolving applications and database problems. Develop data models,...
Full time
Part time
Work experience placement
Work at office
Flexible hours
California Correctional Health Care Services
Ventura, CA
2 days ago
Software Engineer - Maritime Autonomy (AUV/UUV)
$150k - $170k
...experienced, motivated mid-level Software Engineer to join our innovative engineering team in Ventura, CA. This is an opportunity to develop and test systems for our groundbreaking Autonomous Undersea Vehicle (AUV) Family of Systems and advanced navigation technology. You...
Contract work
Immediate start
GRVTY
Ventura, CA
a month ago
Mid -Level Civil Engineer
$100k - $115k
Job Description Job Description Description: Sustainment & Restoration Services (SRS) is a Small Business firm that provides engineering, science, construction, munitions, and specialized professional services solutions for customers nationwide. SRS delivers full...
Full time
For contractors
For subcontractor
Work at office
Local area
Immediate start
Worldwide
Monday to Friday
SRS
Ventura, CA
a month ago
Mid-Level Mechanical Engineer
$150k - $170k
...development of our Autonomous Underwater Vehicle (AUV) family of vehicles and advanced navigation products. In this role you will develop mechanical solutions for enclosures, sensors, payloads, and structural elements. This role works within a multidisciplinary team developing...
Full time
Contract work
Work at office
Immediate start
Monday to Friday
GRVTY
Ventura, CA
a month ago
Staff Software Engineer
$206.09k - $302.2k
...permitted: work may be performed within normal commuting distance from The Trade Desk, Inc. office in Bellevue, WA. Job Duties: Design, develop, and maintain scalable backend data pipelines for processing large-scale content catalog and metadata using distributed data...
Full time
Temporary work
Work at office
Remote work
Worldwide
The Trade Desk
Ventura, CA
4 days ago
AI Deployment Engineer
$115k - $145k
...Title AI Deployment Engineer The AI Deployment Engineer will support the AI and automation strategy of CoorsTek by designing, developing, deploying, and supporting production software solutions that incorporate AI and automation capabilities. This is a hands-on...
Permanent employment
Work experience placement
Remote work
CoorsTek
Ventura, CA
4 days ago
FP&A Director
...ambiguous environment ~ Experience working cross‑functionally in a high‑growth startup or similar environment Bonus points for SQL proficiency and the ability to pull and manipulate data directly from source systems Experience in a venture‑backed startup or...
Remote work
Curri
Ventura, CA
2 days ago
Software Developer
$110k - $140k
...Level II Required This position is contingent on contract award Overview Resource Management Concepts (RMC) is seeking a Software Developer to support mission-critical Department of Defense (DoD) systems in Port Hueneme, California. This role supports the design, development...
Contract work
Resource Management Concepts
Port Hueneme, CA
4 days ago
Software Engineering - Contractor
$106.08k - $128.96k
...support services to Range Systems Department (RS) at NSWC Corona Division in Norco CA including maintaining and modifying government developed software creating and updating hardware interfaces for government developed software maintaining and updating government software...
Full time
For contractors
JSL Technologies Incorporated
Port Hueneme, CA
2 days ago
Information Technology Systems Integrator
$140k - $200k
...API gateway patterns. We seek familiarity with ETL patterns, SQL querying, and relational database design. We require strong written... ...agents. You will connect LLMs to our internal data, develop RAG pipelines, assess models and hosting approaches, refine prompts...
Full time
Work at office
Flexible hours
Elite Metal Finishing, LLC
Oxnard, CA
2 days ago
Integration Engineer
...DO: Work closely with business stakeholders and other developers to gather, document, and analyze integration needs across departments... ...via middleware, API gateways, or ETLpipelines using Python, SQL, PHP, and other relevant technologies. Ensure...
City of Oxnard
Oxnard, CA
21 hours ago
Software Systems Engineering
$140k - $200k
Swarm Aero is redefining air power, building the largest swarming UAV and the most versatile swarming aircraft network in the world. The company is moving quickly to launch the first aircraft designed specifically for swarming, as well as the Command & Control software...
Permanent employment
Full time
Work at office
Swarm Aero
Oxnard, CA
2 days ago
SMT Programmer/Operator
Job Description Job Description Setup, Programming and Operation of Surface Mount Pick-and-Place machines, including tending to machines swiftly and efficiently to setup and program new job orders, replenish components on feeders, adjust machine parameters, respond...
Permanent employment
Shift work
Weekend work
Vast Circuits
Ventura, CA
5 days ago
Senior Technical Account Manager
$80.8k - $90.9k
...knowledge of accounting principles. Technical fluency in Microsoft operating and network system operation, relational databases, and SQL/Oracle language. Proven project and customer relationship management skills. Demonstrated ability to positively influence clients, peers...
Flexible hours
Yardi Systems, Inc.
Oxnard, CA
3 days ago
Head of Finance - Startup
...partnering with or reporting to a CEO or CFO directlyNice to Have• Prior exposure to fundraising processes or investor relations• MBA or CFA• SQL or data analytics skills• Prior experience building a finance function from scratchWho You Are• Carries a Playbook: You've seen...
Permanent employment
Live in
Work at office
Swarm Aero
Oxnard, CA
2 days ago
HR Data Analyst
$60k - $70k
...that provide workforce insights to leadership and HR teams. Develop Power Apps solutions to improve HR processes such as onboarding... ...Office Suite, Microsoft Teams, Power BI, Power Apps, Power Automate, SQL, and SharePoint. The compensation range for this position:...
Civilian Contractor
Temporary work
Work at office
DT Professional Services
Port Hueneme, CA
4 days ago
#2650 Software Engineer (SW30) Port Hueneme, CA
$93k - $110k
...Duties include dedicated support for software development of new functionalities, system updates, debugging, user support, and developing technical documentation. The position is located onsite at NSWC PHD in Port Hueneme, CA. Position Duties: • Either...
Full time
ADVANTEDGE TECHNOLOGY, INC.
Port Hueneme, CA
22 days ago
CyberSecurity/SysAdmin
$105k - $110k
...to ensure reliable system functionality and interoperability. Develop and maintain system documentation, network diagrams, standard... ...administering SharePoint and Microsoft Teams. Familiarity with Microsoft SQL Server fundamentals. Experience with VMware Horizon virtual...
Sellers & Associates
Port Hueneme, CA
a month ago
Sr. Data Architect
...Description Job Description SUMMARY: Responsible for designing, developing and maintaining data business solutions. Collaborates with key... ...technologies such as PowerBI, SplashBI, Oracle and MS SQL. ~ Bachelor's Degree (B.A. or B.S.) from four-year college or...
Casual work
Work at office
PTI Technologies
Oxnard, CA
18 days ago
MANAGEMENT ANALYST I
...development of reports, data analysis and data visualizations. Develop and support Power Apps, such as Power BI, Power Automate, etc.,... ...and Power Automate along with use of tools such as Tableau and SQL. Strong organizational and planning skills, documentation, and data...
Temporary work
Work at office
Flexible hours
VSolvit
Port Hueneme, CA
1 day ago
MANAGEMENT ANALYST II
...demand for briefs, reports, and metrics for Command leadership Develop weekly briefs and weekly reports to Command leadership and Program... ...and Power Automate along with use of tools such as Tableau and SQL If applicable: If you are or have been recently employed by the...
Temporary work
Work at office
Flexible hours
VSolvit
Port Hueneme, CA
2 days ago
Maximo (MAS) Administrator
...procedures, and changes in accordance with organizational standards Database Administration and Maintenance on Oracle 19c and Postgres SQL databases including Monitoring, maintaining, and optimizing Maximo and asset management system databases Maintain disaster...
Temporary work
Work experience placement
Remote work
Flexible hours
VSolvit
Ventura, CA
21 days ago
#2660 Logistician (LG30) Port Hueneme, CA NSWC-PHD
$27 - $33 per hour
...Description Role and Responsibilities: Full-Time Logistician, developing accurate Logistics Assessment Data Package services in... ...Office tools (Excel, Access, PowerPoint) and programming languages (SQL, VBA). These tools will support complex logistics data...
Full time
For contractors
Work at office
ADVANTEDGE TECHNOLOGY, INC.
Port Hueneme, CA
4 days ago
#2639 Test Engineer (TE30)- Part -Time
$40 - $50 per hour
...understand English and able to write clear, detailed technical monthly reports. Preferred Skills: • Knowledge of Oracle and MS SQL databases, and storage technologies, such as EMC SAN/NAS or NetApp. • Experience with electronics fundamentals, circuit repair, and...
Hourly pay
Part time
ADVANTEDGE TECHNOLOGY, INC.
Port Hueneme, CA
5 days ago

Do you want to receive more vacancies?

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