Production Engineer (Oracle/Snowflake/Python)

Toyota North America • Plano, TX

23h

About The Position

The Toyota Financial Services Site Reliability Engineering team is seeking a passionate and highly motivated Production Engineer. This role is crucial for troubleshooting and resolving complex technical issues within financial software and systems. The engineer will serve as an escalation point for frontline support and collaborate with product and engineering teams to enhance the product. Additionally, this position involves close collaboration with the Major Incident Management team to address and resolve production environmental issues.

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