Production Engineer (Oracle/Snowflake/Python)

Toyota North America • Plano, TX

1d

About The Position

Overview Who we are Collaborative. Respectful. A place to dream and do. These are just a few words that describe what life is like at Toyota. As 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. To 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.

Requirements

• 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 DevOps teams to integrate database changes into CI/CD pipelines using Git, Jenkins, or Azure DevOps.
• 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, GCP).
• Excellent troubleshooting and problem-solving skills.
• Strong communication and collaboration skills.

Nice To Haves

• 3+ years of experience and exposure to monitoring tools like Splunk, AppDynamics, or Dynatrace
• Knowledge of networking and security principles.
• Ability to navigate through UI and understand end to end process
• Experience successfully analyzing and documenting complex business processes
• Knowledge of Agile/Lean framework and methodology

Responsibilities

• 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.

Benefits

• A work environment built on teamwork, flexibility, and respect
• Professional growth and development programs to help advance your career, as well as tuition reimbursement
• Team Member Vehicle Purchase Discount
• Toyota Team Member Lease Vehicle Program (if applicable)
• Comprehensive health care and wellness plans for your entire family
• Toyota 401(k) Savings Plan featuring a company match, as well as an annual retirement contribution from Toyota regardless of whether you contribute
• Paid holidays and paid time off
• Referral services related to prenatal services, adoption, childcare, schools and more
• Relocation assistance (if applicable)

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level