SQL SERVER DATABASE DEVELOPER / DATA ENGINEER

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

Job summary

VSolvit, LLC is seeking a Senior Technical Lead to oversee SQL Server database development and ETL initiatives in Norco, CA. The ideal candidate will have extensive experience in database design, data integration, and performance tuning, along with strong technical documentation skills.

Key responsibilities include collaborating with cross-functional teams and ensuring data quality across various systems. US Citizenship is required for this position.

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.
• Understanding of dimensional modeling and schema design.
• US Citizenship required.

Responsibilities

• Design, develop, and maintain SQL Server databases.
• Create, optimize, and troubleshoot complex T-SQL queries.
• Develop ETL/ELT processes for data integration.
• Support migration activities between relational database platforms.
• Participate in Agile/Scrum ceremonies.

Skills

Microsoft SQL Server database development

T-SQL development

Database performance tuning

Data Warehouse development

ETL/ELT processes

Dimensional modeling

Database security best practices

Technical documentation

Agile/Scrum methodologies

Git and CI/CD pipelines

Tools

SQL Server Integration Services (SSIS)

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.