DS
Snowflake DBA
Damco Solutions Inc
🇺🇸 United States
Remote
Manager or above
5 months ago
- Snowflake
- Oracle
- PostgreSQL
- Devops
- RBAC
- SQL
- Fivetran
- Azure
- AWS
- OCI
- Python
- Disaster Recovery
- CI/CD
- Databricks
- FinOps
- ELT
- IaC
5 months ago
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 yearsexclusively 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
-
- 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
Snowflake DBA · Damco Solutions Inc