POSITION IS 100% ONSITE DAILY IN NORCO, CA
Job Summary
The Senior SQL Server Database Developer / Data Engineer serves as the technical lead for enterprise database architecture, SQL Server development, data warehousing, and data engineering initiatives supporting Department of Defense mission systems. This position provides technical leadership for database modernization efforts, enterprise data integration, performance optimization, and complex database migrations while mentoring development teams and establishing database engineering standards.
Responsibilities
Lead the design and architecture of enterprise SQL Server database solutions
Design and maintain highly available, scalable database environments
Lead Data Warehouse and Data Mart architecture using dimensional modeling and star schema design
Develop and optimize complex T-SQL solutions supporting enterprise applications
Architect ETL/ELT pipelines integrating data from APIs, files, cloud platforms, and enterprise systems
Lead PostgreSQL-to-SQL Server migration initiatives
Perform enterprise-level database performance tuning and optimization
Establish database development standards, coding practices, and governance
Lead technical design reviews and database architecture discussions
Mentor database developers and provide technical leadership across Agile teams
Support production deployments and resolve complex database issues
Develop technical documentation including ERDs, source-to-target mappings, and database standards
Collaborate with software architects, infrastructure teams, cybersecurity personnel, and government stakeholders
Required Qualifications
Bachelor's degree in Computer Science, Information Systems, or related field (or equivalent experience).
8–12+ years of SQL Server database development experience.
5+ years of advanced T-SQL development.
Extensive experience with Data Warehousing, Data Marts, ETL/ELT, and SSIS.
Experience designing enterprise-scale OLTP and analytical databases.
Experience with PostgreSQL migration strategies.
Expertise in database performance tuning and optimization.
Experience with Git, CI/CD pipelines, and database deployment automation.
Strong leadership, mentoring, and solution architecture experience.
U.S. Citizenship.
Active DoD Secret Clearance or higher (or ability to obtain if permitted by contract).
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 is offered
Desired Qualifications
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.
Company Summary
Join the VSolvit Team! Founded in 2006, VSolvit (pronounced 'We Solve It') is a technology services provider that specializes in cybersecurity, cloud computing, geographic information systems (GIS), business intelligence (BI) systems, data warehousing, engineering services, and custom database and application development. VSolvit is an award winning WOSB, CA CDB, MBE, WBE, and CMMI Level 3 certified company. We offer a customizable health benefits program that best meets the needs of its employees. Offering may include: medical, dental, and vision insurance, life insurance, long and short-term disability and other insurance products, Health Savings Account, Flexible Spending Account, 401K Retirement Plan options, Tuition Reimbursement, and assorted voluntary benefits. Our goal is to grow together and enjoy the work that we do as a team.
VSolvit LLC is an Equal Opportunity/Affirmative Action employer and will consider all qualified applicants for employment without regard to race, color, religion, sex, national origin, protected veteran status, or disability status.