Snowflake DBA

TalentOla; Indiana; Remote; USD 150,000 - 230,000; Full time

Job summary

Talentola is seeking a highly skilled Snowflake DBA to manage and optimize Snowflake environments across enterprise data platforms. The role demands hands-on Snowflake administration, SQL proficiency, and experience with data replication and ingestion pipelines.

The ideal candidate will collaborate with data engineers, DevOps, and business teams to ensure high availability, security, and performance while supporting multi-cloud architecture and governance practices.

Qualifications

• 8–10 years total experience with at least 5 years as Snowflake DBA.
• Deep Snowflake administration, including warehouses, clustering, caching, storage, and security.
• Experience with Oracle or PostgreSQL and strong SQL proficiency.

Responsibilities

• Administer, monitor, and optimize Snowflake environments, including security and resource management.
• Own end-to-end performance optimization and query tuning for Snowflake workloads.
• Design data replication and ingestion strategies using CDC tools like GoldenGate, HVR, or Fivetran.
• Collaborate with Data Engineers, DevOps, and business teams to ensure high availability and cost efficiency.

Skills

Snowflake DBA

Query optimization

RBAC security

SQL proficiency

Data integration

CDC tools

Cloud platforms

Python scripting

Data warehousing

HA/DR backup

DevOps practices

Databricks

Data governance

Multi-cloud

Client-facing

Ownership

Education

Bachelor's degree

Tools

GoldenGate

HVR

Fivetran

Oracle

PostgreSQL

Job description

Location: Preferred in Chicago, Remote in US anywhere would be fine

CST work shift, 12pm to 10pm

Interviews: 1 internal, 2 client

Job Description:

Snowflake DBA

We are seeking a highly skilled Snowflake DBA with strong expertise in cloud data platforms, database administration, and performance optimization. The ideal candidate will bring deep hands-on experience in managing Snowflake environments at scale, along with a strong foundation in traditional RDBMS systems (Oracle / PostgreSQL) and modern data integration tools.

This role requires a proactive mindset, strong problem-solving skills, and the ability to collaborate with data engineering, DevOps, and business teams to ensure high availability, security, and performance of enterprise data platforms.

Required skills & Qualifications:

• Overall experience of 8 to 10 years, with at least 5 years exclusively as a Snowflake DBA
• Core Technical Skills

• Snowflake Expertise Strong hands-on experience in Snowflake administration, including:

• • Virtual warehouses, clustering, caching, and storage management
  • Query performance tuning and workload optimization
  • Security (RBAC, masking policies, encryption)

• Database Administration Experience with Oracle, PostgreSQL, or similar RDBMS platforms
• SQL Proficiency Advanced SQL skills including query optimization and performance tuning
• Data Integration & Replication Experience with:

• • CDC tools such as GoldenGate, HVR, Fivetran
  • Real-time and batch data ingestion pipelines

• Cloud Platforms Hands-on experience with at least one cloud provider (Azure, AWS, or OCI)
• Automation & Scripting Proficiency in Python/Shell scripting for automation

• Platform & Architecture Knowledge

• Strong understanding of data warehousing concepts and modern data architectures
• Experience supporting large-scale, enterprise-grade data platforms
• Knowledge of high availability, disaster recovery, and backup strategies
• Exposure to DevOps practices, CI/CD, and infrastructure automation

• Experience with Databricks or Spark-based processing
• Knowledge of data governance and compliance frameworks
• Familiarity with FinOps practices for cloud cost optimization
• Experience in financial services domain (banking, asset management, risk, etc.)
• Exposure to multi-cloud architectures

• Strong communication and stakeholder management skills
• Ability to work in a client-facing environment and manage production-critical systems
• Self-driven with a strong sense of ownership and accountability

Key Responsibilities

• Administer, monitor, and optimize Snowflake environments, including warehouses, storage, security, and resource management
• Implement and manage role-based access control (RBAC), data security policies, and compliance standards
• Own and drive end-to-end performance optimization of the Snowflake platform, including query tuning, workload management, and cost optimization
• Design and implement data replication and ingestion strategies, including CDC pipelines using tools like HVR, Fivetran, or similar
• Manage high availability, backup, and disaster recovery strategies for Snowflake and associated data platforms
• Support database migration initiatives from legacy systems (Oracle/PostgreSQL) to Snowflake
• Collaborate with Data Engineers to optimize ELT pipelines and data models for performance and scalability
• Automate operational tasks using scripting (Python/Shell) and infrastructure-as-code approaches
• Monitor system health, troubleshoot issues, and provide L2/L3 production support for critical data platforms
• Work with cloud platforms (Azure/AWS/OCI) to ensure seamless integration and performance
• Establish and enforce best practices for database governance, security, and cost optimization
• Provide technical leadership and mentorship to junior DBAs and engineers

Education Background

• Bachelor's degree in computer science, Information Technology, or a related field with OR equivalent professional experience.

Work Timings:

• US Central Time 12 PM to 10 PM