Peraton · 8 hours ago
Database Engineering Advisor
United States
Full-time
Remote
Senior Level, Lead/Staff
$80K/yr - $128K/yr
8+ years expPeraton is a next-generation national security company that drives missions of consequence spanning the globe. The Database Engineering Advisor role focuses on designing, developing, and optimizing database solutions and ETL pipelines to support mission-critical applications.
RoboticsInformation Technology
No H1B
Security Clearance RequiredU.S. Citizen Only
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
Qualification
Required
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
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
Benefits
Medical
Dental
Vision
Life
Health savings account
Short/long term disability
EAP
Parental leave
401(k)
Paid time off (PTO) for vacation
Company paid holidays
Company
Peraton
Peraton Fearlessly solving the toughest national security challenges.
10001+ employees
Funding
Current Stage
Late StageLeadership Team
Thomas Terjesen
Chief Information Officer
Recent News
Washington Technology
2026-01-22
2025-09-25
Company data provided by crunchbase