Database Administration, Senior Advisor
$135,000–$216,000 year
RemoteUnited States
Job Summary
Design, develop, and optimize data pipelines while managing Snowflake administration tasks including RBAC, cost optimization, and backup recovery. Lead virtual warehouse optimization, complex schema management, and disaster recovery strategies using advanced SQL, Python, and shell scripting. Collaborate with Product Owners, Architects, and Agile teams to align platform performance with security and delivery standards. Requires 7+ years of Snowflake/Java/Python experience and 2+ years of admin work. US Citizen or Green Card holder with Public Trust clearance eligibility. Peraton delivers trusted IT solutions to government agencies and U.S. armed forces.
Required Qualifications
- Minimum of 12 years with BS/BA
- Minimum of 10 years with MS/MA
- Minimum of 7 years with Ph.D.
- 7+ years of overall tech experience as Snowflake/Java/Python/ETL Developer
- 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)
- US Citizen or Green Card
- Ability to obtain a Public Trust clearance
Desired 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
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.