Senior SQL Server Database Developer Data Engineer

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

• Bachelors degree in Computer Science Information Systems or related field (or equivalent experience).

• 812 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

• Experience supporting DoD Navy or Federal Government systems.

• Experience with Microsoft Fabric Azure Data Factory or cloud-based data integration platforms.
• Experience with Azure DevOps or Git-based source control.
• Knowledge of database security role-based access controls and data governance.
• Experience with Agile/Scrum methodologies.

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.