Role : Senior Snowflake Database Administrator
Location : Cincinnati , OH (Onsite)
Key Responsibilities
Snowflake Administration
- Manage and administer Snowflake environments across DEV / QA / UAT / PROD.
- Configure Warehouses, Databases, Schemas, Roles, Resource Monitors, and Storage Integrations.
- Set up and manage Snowpipes, Streams, Tasks, and Time Travel policies.
- Monitor and optimize compute usage, credits, warehouse performance, and cost allocation.
Database Administration (Traditional SQL DBs)
Manage and optimize Oracle, SQL Server, PostgreSQL, or DB2 environments.Perform performance tuning, indexing strategy, query optimization, and schema management.Oversee patching, upgrades, backups, recovery, and high availability.Performance Optimization
Optimize Snowflake queries using micro-partition pruning, clustering, warehouse scaling, and caching.Troubleshoot slow-running queries and ingestion pipelines using Query Profile & Account Usage views.Improve workload isolation using multi-cluster warehouses and workload segmentation.Security, Governance, and Compliance
Implement RBAC, dynamic data masking, row-level security, and column-level protection.Manage access control for users, roles, service accounts, and integrations.Ensure compliance with SOX, PCI, FFIEC, and bank security standards.Support data retention, masking, encryption, lineage, audit logs, and data governance rules.Data Integration & Pipeline Support
Work with data engineering teams to troubleshoot ingestion failures and transformation issues.Support ETL / ELT pipelines built using Snowflake, Informatica, DBT, Python, Kafka, Azure Data Factory, or similar tools.Review ingestion patterns, troubleshoot Snowpipe failures, and optimize ELT workflows.Monitoring & Troubleshooting
Monitor Snowflake Account Usage for performance & operational issues.Analyze and resolve :o Concurrency / queuing issues
o Warehouse consumption spikes
o Storage anomalies
o Task failures
o Materialized view refresh issues
Cloud Deployment & Architecture
Collaborate with Cloud and Data Architects to refine Snowflake architecture, security design, and integration patterns.Support migrations from on-prem databases to Snowflake.Design best practices for storage, compute, cost optimization, and workload management.Collaboration & Communication
Work closely with Data Engineers, BI teams, Information Security, Compliance, and Business Stakeholders.Provide documentation, runbooks, and technical guidance.Participate in on-call rotations for critical systems