SQL SERVER DATABASE DEVELOPER / DATA ENGINEER

VSolvit; Norco (CA); On-site; USD 90,000 - 130,000; Full time

Job summary

VSolvit in Norco, CA, is seeking a Senior Technical Lead specializing in SQL Server database development and data migration. You will oversee the design, development, and maintenance of SQL Server databases, focusing on ETL/ELT initiatives to support Navy mission systems.

The ideal candidate must have at least 3 years of SQL Server development experience, strong analytical skills, and familiarity with data warehousing. Position is 100% onsite in Norco.

Qualifications

• Minimum 3 years of SQL Server database development experience.
• Minimum 2 years of T-SQL development experience.
• Experience designing production database solutions.

Responsibilities

• Design, develop, and maintain SQL Server databases.
• Create and maintain tables, views, and stored procedures.
• Develop ETL/ELT processes and data integration solutions.

Skills

Microsoft SQL Server development

T-SQL development

Database performance tuning

Data integration

Data Warehouse development

Tools

SQL Server Integration Services (SSIS)

Git

Job description

POSITION IS 100% ONSITE DAILY IN NORCO, CA.

Job Summary

The contractor shall serve as the senior technical lead for SQL Server database development, data migration, data warehouse/data mart architecture, and ETL/ELT initiatives supporting Navy mission systems and enterprise data platforms.

Responsibilities

• Design, develop, and maintain SQL Server databases, tables, views, stored procedures, functions, triggers, and indexes.
• Support OLTP database design including normalization, constraints, keys, and referential integrity.
• Develop and maintain Data Warehouse and Data Mart solutions utilizing dimensional modeling and star schema design.
• Create, optimize, and troubleshoot complex T‑SQL queries and stored procedures.
• Develop ETL/ELT processes and data integration solutions for loading data from files, APIs, staging environments, and external systems.
• Perform data validation, reconciliation, and data quality assessments.
• Support migration activities between PostgreSQL, SQL Server, and other relational database platforms.
• Create and maintain database documentation including ERDs, data dictionaries, source-to-target mappings, and technical design documentation.
• Develop reporting views and curated datasets to support analytics and business intelligence initiatives.
• Analyze execution plans and perform query tuning, indexing optimization, and database performance improvements.
• Support software releases, deployments, testing, and environment promotion activities across Development, Test, Staging, and Production environments.
• Participate in Agile/Scrum ceremonies and collaborate with developers, analysts, and stakeholders.

Required Qualifications

• Minimum 3 years of Microsoft SQL Server database development experience.
• Minimum 2 years of advanced T‑SQL development experience.
• Experience designing and developing production database solutions.
• Experience creating and maintaining tables, views, stored procedures, functions, triggers, and indexes.
• Experience with database performance tuning and query optimization.
• Experience with OLTP database design and normalization principles.
• Experience with Data Warehouse and Data Mart development.
• Experience with ETL/ELT processes and data integration.
• Understanding of dimensional modeling, star schema design, fact tables, and dimension tables.
• Strong analytical, troubleshooting, and problem‑solving skills.
• Experience producing technical documentation and database designs.
• Experience with SQL Server Integration Services (SSIS).
• Experience migrating PostgreSQL databases to SQL Server.
• Knowledge of data governance, role-based access controls, and database security best practices.
• US Citizenship.
• If applicable: If you are or have been recently employed by the U.S. Government, a post‑employment ethics letter will be required if employment with VSolvit is offered.

Desired Qualifications

• Experience with Git, CI/CD pipelines, and database deployment processes.
• Experience supporting Department of Defense (DoD) systems and secure environments.
• Experience with Agile/Scrum development methodologies.
• Active Secret Clearance.

Expected Deliverables

• SQL Server database schema designs.
• Database tables, views, stored procedures, functions, triggers, and indexes.
• ETL/ELT pipelines and data integration solutions.
• Data warehouse and data mart models.
• Source‑to‑target mapping documents.
• Entity Relationship Diagrams (ERDs).
• Data dictionaries and technical documentation.
• Data quality assessment and validation reports.
• Deployment and implementation documentation.