ETL Oracle PL/SQL Developer (Oracle Commerce Cloud Support Engineer)

Job Description Job Summary: We are seeking a skilled Oracle Commerce Cloud Support Engineer with strong expertise in ETL, databases, and production support. The ideal candidate will have experience in SQL, PL/SQL programming, Linux shell scripting, and data analysis, ensuring seamless data processing and integration across multiple database environments., * Provide on-call production support, promptly identifying and resolving defects while maintaining SLA commitments.

• Monitor and analyze job logs and performance metrics to detect trends and proactively address potential issues.
• Troubleshoot production issues by reviewing logs, implementing design changes, and following established change management procedures.
• Develop and maintain documentation for troubleshooting procedures, system configurations, and best practices.
• Manage and resolve data load delays and database server downtimes, ensuring minimal disruption to operations.
• Collaborate with stakeholders to understand business requirements and optimize data processing workflows.
• Work on database integrations between Oracle, SQL Server, and Teradata.

• 4-7 years of experience in SaaS Oracle Commerce Cloud.
• Strong knowledge of ETL and database technologies (Oracle, Teradata, SQL Server).
• Proficiency in SQL (minimum intermediate level).
• Expertise in Linux shell scripting (file manipulation, file transfers, automation).
• Solid understanding of Oracle Database (Multi-Tenant architecture, schemas, roles, grants).
• Advanced PL/SQL programming (Packages, Procedures, Functions, Triggers, anonymous scripts).
• GIT configuration control experience.
• Strong data analysis skills, including data flow, integration, and data preparation for consumers.

General Skills:

• Strong troubleshooting and problem-solving abilities.
• Ability to manage multiple stakeholders effectively.
• Excellent communication and analytical skills.

Education & Qualifications:

• Bachelor’s Degree in Computer Science, Information Technology, or a related field.