Database Administration, Senior Advisor

Peraton; Reston (VA); On-site; USD 135,000 - 216,000; Full time

Job summary

Peraton is seeking a Senior Snowflake Data Engineer to design, develop, deploy, and optimize data pipelines in Snowflake while serving as a backup Snowflake administrator. You will collaborate with cross‑functional teams to meet security, performance, and architectural requirements.

The role requires extensive Snowflake experience, strong SQL, Python/Java, and AWS skills, plus ability to work independently and obtain Public Trust if needed. US citizenship or GC is required.

Qualifications

• 7+ years of Snowflake/Java/Python/ETL development with 2+ years Snowflake administration.
• Ability to work independently with minimal supervision.
• Snowflake platform administration and development incl. virtual warehouses, RBAC, data modeling, and schema management.
• Deep understanding of Snowflake architecture (Storage, Compute, Time Travel, Fail‑safe, Zero‑Copy Cloning).
• Hands‑on experience with Snowflake features: Snowpipe, Streams, Tasks, Stored Procedures (SQL/Python/Java).
• Advanced SQL skills for complex analytics, data transformations, performance tuning, and query profiling.
• Python or shell scripting to automate DB admin and data engineering workflows.
• AWS experience (IAM roles, security policies, S3 external stages).
• Team player with strong communication; US Citizen or Green Card; ability to obtain Public Trust clearance.

Responsibilities

• Design, develop, deploy, and optimize data pipelines in Snowflake.
• Serve as backup Snowflake administrator with RBAC and cost optimization.
• Collaborate with Product Owners, Data Engineers, Architects, and Agile teams.
• Ensure platform performance, security requirements, and architectural alignment.

Skills

Snowflake Administration

SQL

Python

Java

ETL Development

AWS

RBAC Design

Data Modeling

Stored Procedures

Shell Scripting

SAFe

Disaster Recovery

Snowflake Certifications

Terraform

IaC

Linux CLI

FinOps

CMS Data Experience

Education

BS/BA in Computer Science or related field

MS/MA in Computer Science or related field

PhD in a relevant field

Tools

Terraform

Schemachange

Snowflake

Job description

Database Administration, Senior Advisor

Job Locations: US

Requisition ID: 2026-169213

Position Category: Information Technology

Clearance: Public Trust

Responsibilities

In this role you will:

The Senior Snowflake Data Engineer with Administration Experience will be responsible for the design, development, deployment and optimization of data pipelines and will also play the role of backup Snowflake admin.

The Senior Snowflake Data Engineer will split responsibilities between hands‑on data engineering (pipeline development, data modeling, performance tuning) and backup platform administration (RBAC, cost optimization, backup recovery).

They will work closely with Product Owners, Data Engineers, Architects, and Scrum/Kanban teams to ensure alignment with platform performance standards, security requirements, architectural designs, and Agile delivery expectations.

Qualifications

Minimum of 12 years with BS/BA; Minimum of 10 years with MS/MA; Minimum of 7 years with Ph.D.

Required Qualifications:

• 7+ years of overall tech experience as Snowflake/Java/Python/ETL Developer and 2+ year of Snowflake Administration
• Ability to work independently and effectively with little to no supervision.
• Strong Snowflake Platform Administration and Development experience, including virtual warehouse optimization, complex RBAC design, data modeling, and schema management.
• Deep understanding of Snowflake architecture (Storage, Compute, Cloud Services, Time Travel, Fail‑safe, and Zero‑Copy Cloning).
• Hands‑on experience developing efficient data pipelines, utilizing Snowflake features like Snowpipe, Streams, Tasks, and Stored Procedures (SQL/Python/Java).
• Must have advanced SQL skills for writing complex analytical queries, data transformation, performance tuning, and query profiling.
• Demonstrated ability to use Python or shell scripting to automate database administration and data engineering workflows.
• AWS experience (managing IAM roles, security policies, and S3 external stages).
• Team player with excellent executive function and communication skills.
• US Citizen or Green Card. Ability to obtain a Public Trust clearance.

Preferred qualifications:

• Prior Java, Python, or other object‑oriented software development experience.
• Experience designing and implementing disaster recovery, data replication, and backup/failover strategies in Snowflake across regions or cloud providers.
• Scaled Agile Framework (SAFe) experience; certification preferred.
• Snowflake certifications (SnowPro Core, Advanced Administrator, or Advanced Data Engineer).
• Infrastructure as Code (IaC) experience using Terraform or Schemachange for Snowflake object and pipeline provisioning.
• CLI Linux experience and automation of cloud‑native data architectures.
• FinOps and cost‑optimization experience (implementing resource monitors, credit alerts, and optimizing warehouse compute efficiency for incremental loads).
• Experience working with Centers for Medicare and Medicaid (CMS) information systems.
• CMS/Medicare or Medicaid claims data experience.

Peraton Overview

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.

Target Salary Range

$135,000 - $216,000. This represents the typical salary range for this position. Salary is determined by various factors, including but not limited to, the scope and responsibilities of the position, the individual's experience, education, knowledge, skills, and competencies, as well as geographic location and business and contract considerations. Depending on the position, employees may be eligible for overtime, shift differential, and a discretionary bonus in addition to base pay.

EEO

EEO: Equal opportunity employer, including disability and protected veterans, or other characteristics protected by law.