SQL Server Developer

Nastech Global, Inc.

United States

about 2 months ago

Role details

Contract type

Temporary contract

Employment type

Full-time (> 32 hours)

Experience level

Experienced

Experience required

3 years minimum

Compensation

$93,600.0

Working hours

Regular working hours

Job source

clearancejobs.com

Tech stack

Sql Server Data Tools (SSDT) Amazon Web Services Microsoft Azure Databases Data Integrity Extract Transform Load (ETL) Relational Databases Database Development Microsoft Visual Studio Microsoft SQL Server Online Transaction Processing Performance Tuning

+11 more

SQL Stored Procedures SQL Server Reporting Services SQL Server Integration Services Transact-SQL Delivery Pipeline Software Troubleshooting Database Performance Data Lineage SolarWinds (Software) SQL Server Management Studio (SSMS) Software Version Control

Job description

Design and implement relational database schemas and data models for OLTP and reporting systems.
Develop advanced T-SQL queries, stored procedures, functions, views, and triggers.
Build and maintain ETL pipelines using SSIS, ensuring robust error handling and performance optimization.
Support reporting and analytics through SSRS development and dataset design.
Enforce data integrity, validation, and governance standards across systems.
Conduct proactive performance tuning and database performance analysis using tools like SolarWinds DPA.
Collaborate with developers, analysts, and operations teams to translate business requirements into scalable database solutions.
Document processes, data lineage, and technical specifications for transparency and compliance.

Requirements

U.S. Citizenship required.
Must possess and maintain a T5/SSBI federally adjudicated clearance
Minimum of 8 years with BS/BA; Minimum of 6 years with MS/MA; Minimum of 3 years with PhD
Microsoft SQL Server expertise (on-prem and/or AWS, Azure).
Advanced T-SQL development and complex query design (CTEs, window functions, temp tables).
Experience with Visual Studio / SSDT and source control-driven database development.
Strong background in ETL design and maintenance using SSIS, including incremental loads and CDC patterns.
Proficiency in SSRS report development, parameterized reports, and performance troubleshooting.
Knowledge of data integrity enforcement, transaction management, and metadata documentation.
Hands-on experience with performance tuning, execution plan analysis, index optimization, and resource contention resolution.
Familiarity with SQL Server Management Studio (SSMS) and release/deployment workflows.
Excellent analytical, troubleshooting, and communication skills., * Ability to translate business needs into performant database solutions.
Strong collaboration skills across technical and non-technical teams.
Clear documentation and communication in fast-paced environments.