Description

You will own data analysis, SQL optimization, and configuration for Oracle Agile PLM and Windchill environments.

This role is on-site.

Responsibilities

• Write, optimize, and troubleshoot complex SQL queries for efficient data processing and retrieval.
• Perform advanced data analysis and extraction from large databases to support business requirements.
• Interpret Explain Plans using indexes and apply ANSI/non-ANSI SQL coding techniques.
• Configure and support Oracle Agile PLM and Windchill CAD applications, including UI, backend models, and workflows.
• Create technical documentation and collaborate with cross-functional teams on product integrations.

Required Skills

• 8+ years of hands-on SQL experience with Oracle SQL and Oracle PL/SQL.
• Deep expertise in tables, indexes, stored procedures, and functions.
• Strong ability to interpret Explain Plans and optimize query performance.
• Experience with Oracle Agile PLM and Windchill environments.
• Proficiency in data analysis and database management.
• Ability to translate business requirements into technical solutions.

Preferred Skills

• Experience with Google BigQuery Studio and Google Cloud Storage buckets.
• Knowledge of MS SQL Server and custom PLM extensions.

Key Skills

Education

Any Graduate