Senior Snowflake Database Administrator

Senior Snowflake Database AdministratorLocation: Cincinnati, OH (Onsite)Key ResponsibilitiesSnowflake AdministrationManage 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 OptimizationOptimize 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 ComplianceImplement 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 SupportWork 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 & TroubleshootingMonitor Snowflake Account Usage for performance & operational issues.Analyze and resolve:Concurrency/queuing issuesWarehouse consumption spikesStorage anomaliesTask failuresMaterialized view refresh issuesCloud Deployment & ArchitectureCollaborate 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 & CommunicationWork closely with Data Engineers, BI teams, Information Security, Compliance, and Business Stakeholders.Provide documentation, runbooks, and technical guidance.