SENIOR SQL SERVER DATABASE DEVELOPER / DATA ENGINEER

VSolvit; Norco (CA); On-site; USD 120,000 - 150,000; Full time

Job summary

VSolvit in Norco, CA is seeking a Senior SQL Server Database Developer to lead database development and data integration initiatives. The role requires expertise in SQL Server and T-SQL, focusing on data warehouse architecture and optimization of database performance.

A successful candidate will have a minimum of 8 years of experience in SQL Server development and strong skills in ETL processes, as well as a solid understanding of data governance. The position is 100% onsite daily.

Qualifications

• Minimum 8 years of Microsoft SQL Server database development experience.
• Minimum 5 years of advanced T‑SQL development experience.
• Experience with OLTP database design and normalization principles.

Responsibilities

• Design, develop, and maintain SQL Server databases and data models.
• Create, optimize, and troubleshoot complex T-SQL queries.
• Develop ETL/ELT processes for data integration solutions.

Skills

Microsoft SQL Server database development

T-SQL development

Database performance tuning

ETL/ELT processes

Data Warehouse development

Agile methodologies

Technical documentation production

Data governance and security

Tools

SQL Server Integration Services (SSIS)

Git

Azure Data Factory

Job description

POSITION IS 100% ONSITE DAILY IN NORCO, CA

Job Summary

The SQL Server Database Developer 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 8 years of Microsoft SQL Server database development experience.
• Minimum 5 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.
• 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 Microsoft Fabric, Azure Data Factory, or similar data integration platforms.
• 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.