Production Engineer; Oracle​/Snowflake​/Python

Position: Production Engineer (Oracle/Snowflake/Python)
Overview

Who we are

Collaborative. Respectful. A place to dream and do. These are just a few words that describe what life is like  one of the world's most admired brands, Toyota is growing and leading the future of mobility through innovative, high-quality solutions designed to enhance lives and delight those we serve. We're looking for talented team members who want to Dream. Do. Grow.

with us.

An important part of the Toyota family is Toyota Financial Services (TFS), the finance and insurance brand for Toyota and Lexus in North America. While TFS is a separate business entity, it is an essential part of this world-changing company- delivering on Toyota's vision to move people beyond what's possible. At TFS, you will help create best-in-class customer experience in an innovative, collaborative environment.

T o save time applying, Toyota does not offer sponsorship of job applicants for employment-based visas or any other work authorization for this position currently.

Who we're looking for

The Toyota Financial Services Site Reliability Engineering is looking for a passionate and highly motivated Production Engineer. Reporting to the Manager of Production Engineering, the individual in this role will play a pivotal role in troubleshooting and resolving complex technical issues for financial software and systems, acts as an escalation point for frontline support, and collaborates with product and engineering teams to improve the product.

Additionally, the engineer will collaborate closely with the Major Incident Management team to address and resolve production environmental issues

What you'll be doing

• Act as the primary point of contact for production support, managing and resolving tickets across various business units.
• Triage and prioritize support tickets based on urgency and impact.
• Conduct root cause analysis and apply critical thinking to solve complex problems.
• Analyze trends in support tickets to proactively identify recurring issues and implement long-term solutions.
• Collaborate closely with business users, analysts, and developers to understand issues and enhancements.
• Ensure timely and effective resolution of issues while maintaining a high level of customer satisfaction.
• Follow best practices for security, scalability, and performance.
• Document processes, resolutions, and recurring issues for knowledge management and training purposes.
• Suggest and implement improvements to processes to reduce ticket volume and enhance efficiency.
• Monitor system performance and proactively address potential issues.

• Promptly address and resolve technical issues to maintain the smooth and efficient functioning of applications
• Collaborate with the Major Incident Management team to address and resolve critical issues in the production environment.

What you bring

• Bachelor's degree in information technology or related field.
• 4+ years of experience troubleshooting enterprise web applications, including configuration issues
• 4+ years of experience writing and optimizing advanced SQL and PL/SQL queries and stored procedures for efficient data processing and transformation.
• 4+ years of experience Developing, maintaining, and optimizing data pipelines and workflows using Snowflake and Oracle databases to ensure reliable data availability in production.
• 4+ years of Experience with Snowflake (Warehouse monitoring, table locks, load history)
• 3+ years of experience automating data ingestion, validation, and monitoring tasks using Python scripting and orchestration tools like Apache Airflow or Prefect.
• 3+ years of experience monitoring database health, query performance, and resource utilization using Snowflake Resource Monitors, Oracle Enterprise Manager, and cloud monitoring tools.
• 3+ years of experience troubleshooting and resolving production incidents related to data inconsistencies, pipeline failures, or performance degradation.
• 2+ years of experience implementing security best practices including role-based access control, data masking, and encryption in Snowflake and Oracle environments.
• 2+ years of experience collaborating with Dev Ops teams to integrate database changes into CI/CD pipelines using Git, Jenkins, or Azure Dev Ops.
• 4+ years of experience performing root cause analysis for recurring issues and implementing automation to reduce manual intervention.
• 1+ years of experience managing cloud resource costs by tuning Snowflake warehouse sizes and Oracle instance configurations.
• 4+ years of experience documenting operational procedures, runbooks, and system architecture for knowledge sharing and compliance.
• 3+ years of Experience with cloud platforms (AWS, Azure, Google Cloud Platform).
• Excellent troubleshooting and problem-solving skills.
• Strong communication and collaboration skills.

Added bonus if you have

• 3+ years of experience and exposure to monitoring tools like Splunk, App Dynamics, or Dynatrace
• Knowledge of networking and security principles.
• Ability to navigate through UI and understand end to end process
• Experience successfully analyzing and…