Career Area: Technology, Digital and Data
:
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:
This position works directly with application architects to tune infrastructure performance, review and execute architecture changes, and maintain data quality through export, ETL, and data modeling standards.
What You Will Do:
Daily monitoring of Production Databases (Oracle Enterprise Manager) and Oracle infrastructure / OS level (Nagios, etc)
Identification and optimization of long running queries
Analysis of Journal Logs utilizing Siemens Journal Workbench
Collaboration with Architects/Support on changes
Review prior to making changes
Tracking of impact to ongoing production performance metrics post changes
Tuning / Engagement for development environments
Development and optimization of custom python scripts to ingest data into Snowflake
Data modeling and data transformation using SQL inside of Snowflake
Lead an agency staff to execute data lake projects using engineering and compliance data
What You Have:
Core Application Systems: Knowledge of major production application systems used for delivery of services to internal and external clients; ability to leverage major production application systems in diverse situations.
Level Extensive Experience:
Manages application-related issues, implications, and approaches with clients.
Evaluates key interfaces and interdependencies among core applications systems.
Explains features and benefits of core applications for consideration by business units.
Implements existing and planned application enhancements in major business units.
Tracks data flow between own applications and core applications in other business areas.
Plans enhancement, conversion, and retirement strategies for core applications.
Problem Solving: Knowledge of approaches, tools, techniques for recognizing, anticipating, and resolving organizational, operational or process problems; ability to apply knowledge of problem solving appropriately to diverse situations.
Level Extensive Experience:
Ensures capture of lessons to be learned from a problem-solving effort.
Organizes potential problem solvers and leads problem resolution efforts.
Uses varying problem-solving approaches and techniques as appropriate.
Contributes to standard practices for problem-solving approaches, tools, and processes.
MNCJobz.com will not be responsible for any payment made to a third-party. All Terms of Use are applicable.