SQL SERVER DATABASE DEVELOPER / DATA ENGINEER

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.