IT - Database Engineer IV

Artech LLC

Home, NC(remote)

Apply

JOB DETAILS

SALARY

$45–$55 Per Hour

SKILLS

Adjudication, Amazon Web Services (AWS), Analysis Skills, Centers for Disease Control and Prevention (CDC), Communication Skills, Data Modeling, Data Processing, Data Quality, Data Sets, Database Analysis, Database Design, Database Extract Transform and Load (ETL), Database Optimization, Database Programming, Database Technology, Database Triggers, Documentation, Error Handling, Identify Issues, Information Technology & Information Systems, Metadata, Microsoft SQL Server, Microsoft Transact-SQL (T-SQL), Microsoft Visual Studio, Microsoft Windows Azure, Operational Audit, Performance Analysis, Performance Tuning/Optimization, Relational Databases (RDBMS), Requirements Management, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Single Scope Background Investigation (SSBI), Source Code/Configuration Management (SCM), Stored Procedures, Systems Administration/Management, Transaction Processing/Management, United States Citizen

LOCATION

Home, NC

POSTED

30+ days ago

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.

About the Company

Artech LLC

Resume Resources

Free Resume Templates Free Resume Builder