SQL Server Database Developer Data Engineer
Job Summary
POSITION IS 100% ONSITE DAILY IN NORCO CA
Job Summary
The SQL Server Database Developer / Data Engineer I supports the design development implementation and maintenance of Microsoft SQL Server databases and data integration solutions supporting enterprise applications and Department of Defense (DoD) mission systems. Working under the guidance of senior engineers this role develops database objects assists with ETL/ELT processes performs data validation and contributes to database performance improvements while building expertise in enterprise data management.
Responsibilities
Develop and maintain SQL Server database tables views stored procedures functions and indexes
Write troubleshoot and optimize T-SQL queries
Support OLTP database development and normalization efforts
Assist in developing ETL/ELT processes using SSIS or comparable technologies
Perform data validation reconciliation and quality assurance activities
Create reporting views and datasets supporting business intelligence initiatives
Participate in database testing deployments and production support
Assist with technical documentation ERDs and data dictionaries
Participate in Agile/Scrum ceremonies and sprint activities
Troubleshoot database issues under the guidance of senior developers
Required Qualifications
- Bachelors degree in Computer Science Information Systems or related field (or equivalent experience).
- 24 years of SQL Server database development experience.
- Experience with T-SQL development.
- Knowledge of relational database design principles.
- Basic understanding of ETL/ELT concepts.
- Experience with SQL Server Management Studio (SSMS).
- Strong analytical and problem-solving skills.
- U.S. Citizenship.
- Active DoD Secret Clearance or the ability to obtain one.
- 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.
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.
Required Experience:
IC
About Company
VSolvit | VSolvit supports federal missions through secure, scalable technology services that drive efficiency and deliver real-world results. With a strong track record supporting national agencies, we specialize in systems delivery, secure application management, and enterprise supp ... View more