Snowflake DBA

Dice is the leading career destination for tech experts at every stage of their careers. Our client, Damco Solutions Inc., is seeking the following. Apply via Dice today!

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