Lead Snowflake DevOps DBA
Capital Rx
full-time
Posted on:
Location Type: Remote
Location: Remote • Colorado • 🇺🇸 United States
Visit company websiteSalary
💰 $130,000 - $160,000 per year
Job Level
Senior
Tech Stack
AWSCloudPythonTerraform
About the role
- Act as subject matter expert for all things Snowflake.
- Act as final escalation point for platform issue for team.
- Assist partner teams strategically in adapting their processes, methodologies, and code to suit operational needs, for long-term supportability and stability.
- Assist partner teams tactically in refining their data intake tasks, via query optimization, by creating stored procedures, etc., as needed, to optimize platform utilization and drive process efficiency, on a day-to-day level.
- Collaborate with partner support teams to remediate production issues with high urgency.
- Collaborate with the IT Security and Engineering teams to audit, document, and support RBAC on the platform.
- Cross-train team members on routine Snowflake operational activities as needed for collaborative projects, integration work, and operational support coverage.
- Drive cost and performance optimization on the Snowflake platform.
- Partner with Analytics and Development teams to manage platform lifecycle and ensure process and procedure alignment across the organization.
- Partner with the DevOps team on overlapping areas of responsibility, care/feeding of integration touchpoints, and for initial platform handoff.
- Responsible for adherence to the Capital Rx Code of Conduct, including reporting of noncompliance.
Requirements
- Current experience managing Snowflake.
- 6+ years of experience in a DevOps or similar role.
- 4+ years of experience supporting AWS or other Cloud environments.
- 4+ years of DBA experience, or 3+ years of extensive DB or query optimization experience in a DevOps or Developer role.
- 4+ years of experience using Python in a DevOps or similar role.
- 3+ years of experience with Terraform.
- Experience with Agile methodologies.
- Ability to work in cross-functional teams.
- Extreme attention to detail and highly organized.
- Strong written and verbal communication skills.
- Preference for those who have worked in the health care industry with a strong preference for Pharmacy Benefit Management expertise.
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
SnowflakeAWSDBAquery optimizationPythonTerraformAgile methodologiescost optimizationperformance optimizationRBAC
Soft skills
cross-functional teamworkattention to detailorganizational skillswritten communicationverbal communication