Senior Oracle Cloud PLM Architect & Data Migration Lead

Smart IT Frame LLC; Pittsburgh (Allegheny County); On-site; USD 120,000 - 170,000; Full time

Job summary

Smart IT Frame LLC in Pittsburgh, PA is seeking an experienced Oracle Cloud PLM Techno-Functional Consultant to lead configuration and integration efforts for PD and PDH modules.

You will develop SQL/PLSQL, create Oracle APEX solutions, manage data migration, and collaborate with business and technical teams to deliver scalable PLM solutions on schedule.

The role emphasizes strong stakeholder communication, production support, and optimization in a manufacturing or supply chain context.

Qualifications

• Strong knowledge of PD, PDH, Oracle SQL/PLSQL, and APEX.
• Experience in data migration, integrations, and system optimization.
• Excellent stakeholder management and communication skills.

Responsibilities

• Gather and analyze business requirements.
• Configure, customize, and support Oracle Cloud PLM (PD & PDH).
• Lead data migration and conversion activities.
• Develop SQL, PL/SQL, stored procedures, and Oracle APEX solutions.
• Collaborate with business and technical teams to deliver scalable solutions.
• Provide production support, troubleshooting, and performance optimization.

Skills

PD/PDH domain knowledge

Oracle Cloud PLM

Oracle SQL/PLSQL

Oracle APEX

Stakeholder management

Tools

Oracle SQL/PLSQL

Oracle APEX

Data migration tools

Job description

Smart IT Frame LLC in Pittsburgh, PA is seeking an experienced Oracle Cloud PLM Techno-Functional Consultant to lead configuration and integration efforts for PD and PDH modules.

You will develop SQL/PLSQL, create Oracle APEX solutions, manage data migration, and collaborate with business and technical teams to deliver scalable PLM solutions on schedule.

The role emphasizes strong stakeholder communication, production support, and optimization in a manufacturing or supply chain context.