Database Engineering Advisor

Peraton

11d • $80,000 - $128,000 • Remote

About The Position

Peraton is hiring a full-time Database Engineer to support critical missions within Peraton's Risk Decision Group.
This 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. This position will be 100% remote.

Requirements

• U.S. Citizenship required.
• Must be able to obtain 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.

Nice To Haves

• DBA skills: SQL Server installation, configuration, backup/recovery strategies, HA/DR concepts, and security management.
• Experience with Enterprise Data Warehousing (EDW).
• Familiarity with Python, especially for ETL workflows.
• Scripting skills (PowerShell) for automation.
• Knowledge of CI/CD pipelines for database deployment.
• 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.

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.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level