Haystack
← Back to Jobs
Technology

Senior SQL Server Developer

TechVirtue LLCWashington, DC🇺🇸United StatesPosted 20 Jul 2026

Quick Overview

Work Type
Hybrid
Level
Mid Senior

Job Description

Perform all aspect of database development under the direction of the DBA manager including:

  • Thorough code review of current and past development efforts
  • Code optimization and performance tuning
  • Design, develop, enhance and support database applications
  • Development of complex SQL Code (stored procedures, triggers, views and functions)
  • Security assessment and compliance
  • Through understanding of indexing (Clustered/Non-Clustered)
  • Modify/Create/maintain and optimize ETL processes using SSIS
  • Create Data extraction and Import programs using SSIS
  • Conduct research on emerging database and data warehouse technologies
  • Interact with all stake holders not limiting to the IT to ensure accurate and comprehensive understanding of business requirements
  • Liaise with network administrators, systems analysts, and software engineers to assist in resolving problems and provide issue escalation in a timely fashion
  • Other duties as needed

 

Required Qualifications:

  • Bachelor’s degree in Information Systems/Technology, Computer Science, or a related field.
  • 4+ years of experience working with databases preferably SQL Server.
  • 4+ years of experience in developing ETL Processes including the use of SSIS packages in a Microsoft SQL Server database environment.
  • Hands-on experience with Microsoft Fabric.
  • 4+ years of extensive experience working in the MS SQL Server 2005 and 2008, 2008 R2 environments.
  • Understanding and knowledge of Data Warehousing (Inmon & Kimball) and Business Intelligence.
  • Working technical knowledge in Relational and Dimensional Database design.
  • Understanding of database security and knowledge of applicable data privacy practices and laws.
  • Understanding and experience in Database/Metadata analysis and design.
  • Strong written and oral communication skills.
  • Strong interpersonal skills.
  • Self-directed and proactive; thinks beyond the immediate problem.
  • Flexibility, ability to change priorities quickly, and capacity to handle multiple tasks.
  • Work directly with both internal and external resources to insure timely completion of assigned deliverables.
  • Ability to effectively prioritize and execute tasks in a high-pressure environment. Keen attention to detail.
  • Proven analytical and problem-solving abilities.
  • Experience working both independently and, in a team,-oriented, collaborative environment.

 

Desired Qualifications:

  • Good understanding of Database Administration fundamentals and core concepts including:
    • Backup, Recovery & Recovery Models
    • Database Security (Users, Roles, Schemas, Orphaned Users)
    • Database Storage Fundamentals (Pages, Extents, etc.)
  • Working knowledge of SQL Server High Availability and Disaster Recovery including:
    • SQL Server and Windows clustering
    • Database Mirroring and Log Shipping
    • Transactional Replication
  • Understanding of Data Modeling (both physical and logical).
  • Understanding of new Developer/DBA features for SQL Server 2012 and experience with using it even in the capacity of development or R&D.
  • Understanding of SSRS, SSAS, IBM Cognos or other Reporting platforms.
  • Experience in Healthcare IT or Support environment a plus.

Skills

SQL
SQL Server
ETL

Similar jobs