IT - Database Engineer IV

Job Requirements home, NC Top Secret Polygraph Unspecified Career Level not specified Salary not specified Join Premium to unlock estimated salaries

Job Description Job Title:

IT•

Database Engineer IV Location:

Remote Security Clearance:

Top Secret (Required)

Duration:

6

• 12 Months and Possible Extension.

Pay Range :

$45

• $55/hr on W2 without benefits

Description:

This Database Engineer role focuses on designing, developing, and optimizing database solutions, ETL pipelines, and reporting frameworks to support mission-critical applications. The ideal candidate will have deep expertise in Microsoft SQL Server and a strong background in data integration, performance tuning, and governance.

Responsibilities:

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

Required Qualifications:

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

group id:

artech Apply now