Senior Snowflake DBA

Career Area: Technology, Digital and Data Job Description: Your Work Shapes the World at Caterpillar Inc. When you join Caterpillar, you're joining a global team who cares not just about the work we do but also about each other. We are the makers, problem solvers, and future world builders who are creating stronger, more sustainable communities. We don't just talk about progress and innovation here we make it happen, with our customers, where we work and live. Together, we are building a better world, so we can all enjoy living in it. Job Summary: The Senior Snowflake DBA is responsible for the end-to-end design, implementation, administration, and optimization of enterprise Snowflake cloud data platform environments. This role serves as the technical authority on Snowflake architecture, security, performance tuning, and operational excellence across the organization. The individual will lead strategic initiatives to modernize data infrastructure, establish governance frameworks, and ensure high availability and disaster recovery for mission-critical data workloads. Acting as a bridge between business stakeholders and technical teams, this role translates complex data requirements into scalable, cost-effective Snowflake solutions that support analytics, machine learning, and real-time data processing needs. The individual will also drive innovation by evaluating emerging Snowflake capabilities, establishing best practices and standards, mentoring cross-functional teams, and ensuring the platform evolves to meet growing organizational demands while maintaining strict security, compliance, and cost governance. What You Will Do: Architecture & Design: Design and implement scalable Snowflake data architectures supporting enterprise analytics, data science, and operational workloadsDefine multi-account strategies, database structures, schema designs, and data sharing topologiesEstablish architectural standards for data modeling, storage optimization, and compute resource allocationEvaluate and implement features such as Iceberg tables, dynamic tables, hybrid tables, and SnowparkDatabase Administration: Manage Snowflake account configurations, warehouse sizing, and resource monitorsImplement and maintain data replication, failover, and disaster recovery strategiesMonitor and optimize query performance, clustering keys, materialized views, and search optimizationManage data lifecycle including Time Travel, Fail-safe, storage lifecycle policies, and data retentionSecurity & Governance: Design and enforce RBAC models, network policies, and authentication mechanisms (SSO, MFA, key-pair)Implement data governance using masking policies, row access policies, object tagging, and classificationConduct access reviews, privilege audits, and compliance reportingManage Tri-Secret Secure, customer-managed keys, and encryption standardsOperations & Cost Management:Establish monitoring, alerting, and incident response proceduresOptimize credit consumption through warehouse scheduling, auto-suspend tuning, and workload analysisImplement resource monitors, budgets, and chargeback modelsAutomate administrative tasks using Snowflake Tasks, Streams, and stored proceduresCollaboration & Leadership: Partner with data engineering, analytics, and application teams on Snowflake best practicesMentor junior DBAs and engineers on Snowflake capabilities and patternsEvaluate new Snowflake features and drive adoption where beneficialMaintain documentation for architecture decisions, runbooks, and operational procedures Qlik Replicate: Design and implement CDC and full-load replication tasks using Qlik Replicate to ingest data from diverse source systems into SnowflakeConfigure and optimize Qlik Replicate endpoints, including source (Oracle, SQL Server, PostgreSQL, mainframe) and target (Snowflake) connectionsMonitor replication task health, latency, and throughput; resolve errors related to DDL changes, LOB handling, and network interruptionsManage transformation rules, table filters, and column mappings within Qlik Replicate to align source data with Snowflake target schemasCoordinate with source system teams to assess replication impact and implement log-based CDC with minimal overheadAutomate Qlik Replicate task orchestration and integrate with broader ETL/ELT workflows and scheduling systems Technical Environment Snowflake (Enterprise or Business Critical edition)Qlik ReplicateETL/ELT tools (dbt, Matillion, Snaplogic)Monitoring (Snowflake Account Usage, Query History, third-party observability)Version control and CI/CD (Git, GitHub Actions, Azure DevOps) What You Have: Required Qualifications: 8+ years of database administration experience, with 4+ years focused on SnowflakeDeep expertise in Snowflake architecture (micro-partitions, virtual warehouses, metadata layer, services layer)Strong SQL proficiency and experience with query optimizationExperience with infrastructure-as-code (Terraform, Schema change Car