Our client seeks an
Snowflake DBA for a
Long Term Project in
Chicago, IL . Below is the detailed requirement
Job Title: Snowflake DBA Work location : Chicago, IL (Remote)Duration: 12 Months Job Description:Snowflake DBAWe 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.
Job Description: - Bachelor's degree preferably in Computer Science, Information technology, Computer Engineering, or related IT discipline or equivalent experience with 12+ Minimum Experience
- 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 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