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.