Snowflake DBA

Snowflake DBA
Location: Preferred in Chicago, Remote in US anywhere would be fine
( CST work shift, 12pm to 10pm)
Interviews: 1 internal, 2 client round

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 experienc e 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