Snowflake DBA

形容

Career Area:

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:

Responsible for administering, maintaining, and optimizing Snowflake cloud data platform environments. Works alongside senior DBAs and data engineers to ensure availability, security, and performance of Snowflake databases across development, QA, and production tires.

What You Will Do:

• Monitor and maintain Snowflake databases, schemas, warehouses, and account-level objects across multiple environments (DEV, QA, PROD).
• Manage role-based access control (RBAC): create/alter roles, grant database roles, and troubleshoot privilege issues.
• Perform object migrations between environments — DDL deployments, grants replication, and semantic view promotions.
• Investigate and resolve query performance issues using Query Profile, ACCOUNT_USAGE views, and warehouse metrics.
• Manage Snowflake tasks, streams, dynamic tables, and scheduled pipelines.
• Assist with Streamlit app deployments, Cortex AI feature enablement (semantic views, Cortex Analyst), and Native App support.
• Implement and maintain network policies, MFA enforcement, and key rotation procedures.
• Write and maintain migration scripts (GRANT statements, DDL changes, environment parity checks).
• Participate in on-call rotation for production incident response.

What You Have

Required Qualifications:

• 4+ years experience with Snowflake Data Warehouse.
• Working knowledge of SQL including stored procedures, UDFs, and DDL management.
• Familiarity with Snowflake RBAC model (account roles, database roles, ownership, future grants).
• Understanding of warehouse configuration, credit consumption, and cost management basics.
• Experience with at least one scripting language (Python, Bash, PowerShell) for automation.
• Basic understanding of CI/CD pipelines and version-controlled database migrations.

Preferred Qualifications:

• SnowPro Core certification.
• Experience with Snowflake features: dynamic tables, tasks, Snowpark.
• Familiarity with Cortex AI services (semantic views, Cortex Analyst, Cortex Search).
• Experience supporting Streamlit-in-Snowflake or Native App deployments.
• Knowledge of data governance concepts (masking policies, row access policies, tagging).
• Good to have knowledge on Qlik Replicate

Soft Skills

• Strong attention to detail when managing cross-environment grants and migrations.
• Clear written communication for runbooks, incident postmortems, and change requests.
• Ability to work across time zones with distributed engineering teams.
• Willingness to learn and adapt to rapid platform feature releases.

Caterpillar is not currently hiring individuals for this position who now or in the future require sponsorship for employment visa status; however, as a global company, Caterpillar offers many job opportunities outside of India which can be found through our employment website at www.caterpillar.com/careers.

What You Will Get:

Our goal at Caterpillar is for you to have a rewarding career. Our teams are critical to the success of our customers who build a better world. Here you earn more than just wage, because we value your performance, we offer a total rewards package that provides day one benefits along with the potential of a variable bonus. Additional benefits include paid annual leave, flexi leave, medical and insurance (prorated based upon hire date).

Final Details:

Please frequently check the email associated with your application, including the junk/spam folder, as this is the primary correspondence method. If you wish to know the status of your application – please use the candidate log-in on our career website as it will reflect any updates to your status.

If you are interested in joining our team, please apply using an English version of your CV. We look forward to meeting you!

This Job Description is intended as a general guide to the job duties for this position and is intended for the purpose of establishing the specific salary grade. It is not designed to contain or be interpreted as an exhaustive summary of all responsibilities, duties and effort required of employees assigned to this job. At the discretion of management, this description may be changed at any time to address the evolving needs of the organization.

About Caterpillar

Caterpillar Inc. is the world’s leading manufacturer of construction and mining equipment, off-highway diesel and natural gas engines, industrial gas turbines and diesel-electric locomotives. For nearly 100 years, we’ve been helping customers build a better, more sustainable world and are committed and contributing to a reduced-carbon future. Our innovative products and services, backed by our global dealer network, provide exceptional value that helps customers succeed.

Posting Dates:

Caterpillar is an Equal Opportunity Employer. Qualified applicants of any age are encouraged to apply

Not ready to apply? Join our Talent Community.