Database Engineering Advisor

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.

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

Preferred Qualifications

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

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

Peraton is a next-generation national security company that drives missions of consequence spanning the globe and extending to the farthest reaches of the galaxy. As the world's leading mission capability integrator and transformative enterprise IT provider, we deliver trusted, highly differentiated solutions and technologies to protect our nation and allies. Peraton operates at the critical nexus between traditional and nontraditional threats across all domains: land, sea, space, air, and cyberspace. The company serves as a valued partner to essential government agencies and supports every branch of the U.S. armed forces. Each day, our employees do the can't be done by solving the most daunting challenges facing our customers. Visit peraton.com to learn how we're keeping people around the world safe and secure.