SENIOR SQL SERVER Database Developer​/Data Engineer Security Clearance

Position: SENIOR SQL SERVER DATABASE DEVELOPER / DATA ENGINEER with Security Clearance
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 Postgre

SQL, 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 Postgre

SQL databases to SQL Server.
* Knowledge of data governance, role-based access controls, and database security best practices.
* 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 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.