SQL SERVER DATABASE DEVELOPER/ DATA ENGINEER II

VSolvit
Norco, CA, United States
28 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Experienced
Experience required
4 years minimum
Working hours
Regular working hours

Tech stack

Information Systems Databases Data Integration Extract Transform Load (ETL) Data Mart Data Warehousing Relational Databases Database Development Database Storage Structures Dimensional Modeling PostgreSQL Microsoft SQL Server
+13 more
Online Transaction Processing Query Optimization Release Management Power BI SQL Stored Procedures SQL Server Integration Services Systems Integration Transact-SQL Database Optimization Git Information Technology Tools for Reporting Data Pipelines

Job description

The SQL Server Database Developer / Data Engineer II independently designs, develops, and maintains enterprise SQL Server database solutions supporting mission-critical applications and reporting platforms. This role is responsible for developing ETL/ELT processes, optimizing database performance, supporting data warehouse initiatives, and contributing to database architecture and system integration efforts., * Design and develop SQL Server database objects, including stored procedures, functions, triggers, views, and indexes.

  • Design and optimize OLTP database structures.
  • Develop ETL/ELT pipelines and automated data integration processes.
  • Support Data Warehouse and Data Mart development utilizing dimensional modeling.
  • Perform advanced query optimization and database performance tuning.
  • Develop source-to-target mapping documentation and ERDs.
  • Support PostgreSQL-to-SQL Server migration efforts.
  • Create curated reporting datasets supporting Power BI and enterprise analytics.
  • Participate in database release management and deployment activities.
  • Collaborate with software developers, business analysts, and stakeholders to design scalable data solutions.
  • Mentor junior developers on SQL development best practices.

Requirements

  • Bachelor’s degree in Computer Science, Information Systems, or related field (or equivalent experience).
  • 4-7 years of SQL Server database development experience.
  • Strong T-SQL development experience.
  • Experience with SQL Server Integration Services (SSIS).
  • Experience with ETL/ELT development.
  • Experience designing relational databases and dimensional models.
  • Experience with database performance tuning.
  • Familiarity with Git and CI/CD deployment processes.
  • 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

About the company

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.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.clearancejobs.com

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

3:09 min

Balancing data science skillings alongside systems engineering rigor

Nico Schmidt · LIVE

3:04 min

Database evolution and the funding behind vector databases

Erik Bamberg · LIVE

1:24 min

Moving the semantic layer upstream to avoid vendor lock-in

Piotr Menclewicz Piotr Menclewicz · Europe 2026 Virtual

6:21 min

Investigating push inefficiencies with upstream Git experts

Jonathan Creamer · Coffee With Developers

2:40 min

Evolving through early developer roles and technology stacks

Liam Hurrel +1 · WWC 2021

4:01 min

Managing application isolation via pluggable database models

Wei Hu Wei Hu · WWC 2022

Videos

See all

Related articles

See all