at Caterpillar, Inc. in East Peoria, Illinois, United States
Job Description
Career Area:
Business Technologies, 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.
What does it mean to live the Caterpillar Experience?
It means you play a part in building a better world. You contribute to a winning culture-a spirit of accountability-that has driven change on every continent for more than 90 years. To work with us is a commitment to improve sustainability, invent for the digital age and innovate in order to bring solutions to millions of people. Sure, you work for Caterpillar. But more importantly, you work for the good of your career, your family, your community, and your world.
Job Summary:
The snowflake system DBA has primary responsibility to manage and optimize Snowflake databases. This includes monitoring, optimizing, disaster recovery strategies, Level 4 user support, and ensuring the proper security controls are in place.
What You Will Do:
Provide technical leadership for all aspects of environment management such as database lifecycle management, monitoring, support, disaster recovery, compliance, and standards.
- Research new Snowflake features, tools, and technologies with an Enterprise perspective to meet customer needs while maintaining a secure Snowflake environment.
- Research, benchmark, and suggest improvements to database support processes, customer experience (CX) improvements, and compliance requirements.
- Provide 3rd and 4th level support for complex issues.
- Participate in and manage Snowflake related projects, audits, and compliance reviews and testing.
- Develop new and update existing Snowflake technology related documentation as needed.
- Coach and communicate information to Caterpillar’s application support teams and peers across the enterprise on Snowflake technology changes, new features, key projects, and customer experience improvements.
What You Have: Format: 4-5 bullets related to skills and experience
+ Bachelor’s Degree and IT related experience* – 1-2 years experience in Snowflake System Administration* – Detailed driven, analytical with problem-solving skills* – Strong skills in communication and collaboration* – Basic understanding of data pipeline engineering and ETL / ELT tools*- Strong programming skills and working knowledge of Java script, procedural SQL, and Python* – Intermediate skills in database performance and SQL query tuning – Database design and management experience – Basic networking experience – Knowledge of data warehousing principles* – Experience with Data Visualization tools (PowerBI, Tableau, Thoughtspot)
+ Technical Excellence: Knowledge of a given technology and various application methods; ability to develop and provide solutions to significant technical challenges.Level Working Knowledge: – Provides effective technical solutions to routine functional challenges via sound technical competence, effectively examining implications of events and issues.- Effectively performs the technical job aspects, continuously building knowledge and keeping up-to-date on technical and procedural job components.- Applies technical operating and project standards based on achieving excellence in delivered products, technologies and services.- Applies current procedures and technologies to help resolve technical issues in one’s general area of technical competence.- Helps others solve technical or procedural problems or issues.
+ Preferred: – SnowPro Certification – AWS and Azure experience – Experience in implementing machine learning models for data analysis, prediction, and optimization.- Familiarity with popular AI framework and libraries- Project Management skills – IT Service Management (ITSM) process and Root Cause Analysis (RCA)
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 an hourly wage, because we value your performance, we offer a total rewards package that provides day one benefits (medical, dental, vision, RX, and 401K) along with the potential of an annual bonus.
Additional benefits include paid vacation days and paid holidays (prorated based upon hire date).
Additional Info :
+ The primary locations for this position are: East Peoria, IL, Nashville TN or Dallas, TX
+ This position may require 10% travel.
+ Sponsorship is not available.
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:
July 1, 2024 – July 14, 2024
Any offer of employment is conditioned upon the successful completion of a drug screen.
EEO/AA Employer. All qualified individuals – Including minorities, females, veterans and individuals with disabilities – are encouraged to apply.
Not ready to apply? Join our Talent Community (http://flows.beamery.com/caterpillarinc/talcom) .