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

Remote

Skills

Access Control, Amazon Web Services (AWS), Asset Management, Automation, Bank Management, Best Practices, Caching, Centers for Disease Control and Prevention (CDC), Cloud Architecture, Cloud Computing, Communication Skills, Computer Science, Continuous Deployment/Delivery, Continuous Integration, Cost Control, Cryptography, Customer Relations, Data Management, Data Modeling, Data Recovery, Data Warehousing, Database Administration, Database Replication, DevOps, Disaster Recovery, Financial Services, High Availability, Identify Issues, Information Technology & Information Systems, Information/Data Security (InfoSec), Mentoring, Microsoft Windows Azure, Oracle Applications, Oracle DBA (Database Administrator), Performance Modeling, Performance Tuning/Optimization, PostgreSQL, Problem Solving Skills, Production Management, Production Support, Production Systems, Python Programming/Scripting Language, Query Optimization, Regulatory Compliance, Relational Databases (RDBMS), Resource Management, Risk, SQL (Structured Query Language), Scripting (Scripting Languages), Snowflake Schema, System Migration, Systems Administration/Management, Team Player, Technical Leadership, Unix Shell Programming, Warehousing

About the Company

Damco Solutions Inc