Senior Snowflake DBA & Data Pipeline Orchestrator

TechDigital Group; Chicago (IL); On-site; USD 110,000 - 150,000; Full time

Job summary

TechDigital Group in Chicago seeks a hands-on Snowflake Administrator to manage Snowflake databases and support real-time, near real-time, and end-of-day data loads for UI and API applications. You will ensure platform stability, resilience, and data governance while applying modern engineering practices.

You may participate in on-call rotations and weekend support as needed. Responsibilities include deploying Snowflake environments, optimizing performance, integrating with AWS services, and

Qualifications

• 6+ years of proven experience as a database administrator with Snowflake.
• 5+ years of Strong understanding of SQL and database concepts
• 5+ years of deployments and on-call support activities
• 5+ years of experience in supporting and troubleshooting batch, streaming and real time data loads.
• 4+ years of experience in Snowflake applications (big data cloud database), writing efficient queries, as well as reading and understanding the query plans and writing stored procedures and functions
• 4+ years of experience in cloud native technologies including AWS

Responsibilities

• Deploy, configure, and administer Snowflake environments.
• Monitor performance, storage, and query execution.
• Automate maintenance tasks using SQL, Python, or Shell scripting.
• Integrate Snowflake with AWS services like S3, Glue, Lambda, Airflow, DBT and other cloud services.
• Manage external stages and storage integrations for seamless data movement.
• Monitor security logs and implement audit controls for data protection.
• Identify and resolve performance bottlenecks, query performance, and connectivity issues.
• Establish monitoring, alerts, and proactive issue resolution strategies.
• Create, manage, and maintain Snowflake databases, warehouses, and roles.
• Implement and enforce data governance policies and procedures.
• Monitor database performance and identify optimization opportunities.
• Perform regular database backups and recoveries.
• On-call rotation duties and weekend support activities where needed.
• Participate in CICD deployments and other planned activities where needed.

Job description

TechDigital Group in Chicago seeks a hands-on Snowflake Administrator to manage Snowflake databases and support real-time, near real-time, and end-of-day data loads for UI and API applications. You will ensure platform stability, resilience, and data governance while applying modern engineering practices.

You may participate in on-call rotations and weekend support as needed. Responsibilities include deploying Snowflake environments, optimizing performance, integrating with AWS services, and