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 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 KnowledgeStrong 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 Experience: 8 years required