ETL Oracle PL/SQL Developer (Oracle Commerce Cloud Support Engineer) Job at Macpower Digital Assets Edge, New York, NY

YVIwMFBOdEQ4UlN4aVJvOG1UV3lWVHR1ZUE9PQ==
  • Macpower Digital Assets Edge
  • New York, NY

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.

Key Responsibilities:

  • 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 .
Technical Skills Required:
  • 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).
  • dvanced 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 .
  • bility to manage multiple stakeholders effectively.
  • Excellent communication and analytical skills .
Education & Qualifications:
  • Bachelor's Degree in Computer Science, Information Technology, or a related field.

Job Tags

Similar Jobs

Macquarie Bank Limited

Junior Delta One Swaps Trader Job at Macquarie Bank Limited

 ...Equity Finance team in NewYork as a Junior Delta1 Swaps Trader. This is an exciting...  ...trading positions. Youll gain experience working with delta1 equity total return swaps and...  ...dependent on roleReimbursement for workfromhome equipmentAbout Commodities and Global... 

HEI Hotels

Reservations Agent Job at HEI Hotels

Reservations Agent page is loaded## Reservations Agentremote type: On-Sitelocations: Westin Grand Central - New York, NYtime type: Full timeposted...  ...where youre given a choice to not just get up and go to work, but rise. To feel empowered by career growth opportunities... 

Thorium Digital LLC

Senior Front End Web Developer - Contract Job at Thorium Digital LLC

 ...plenty of opportunities to learn and grow with us. The Senior Front End Web Developer must have a strong technical foundation as well as a full...  ...development. This individual must have senior and lead level developer experience. The Senior Front End Web Developer... 

Santa Rita Transportation

Diesel Truck Mechanic and Truck Rebuilder Job at Santa Rita Transportation

 ...Job Description Job Description Truck Rebuilder Experienced! or Diesel Truck Mechanic Primary focus will be on completely rebuilding 6-8 year old Class 8 Freightliner, International, and Peterbilt trucks Lessor responsibilities will be overseeing PM maintenance... 

Aveanna Healthcare

Home Care Nurse (LPN) Job at Aveanna Healthcare

 ...Job Description Job Description Join a Company That Puts People First! Licensed Practical / Vocational Nurse LPN/LVN We are one of the largest private duty nursing companies in the nation and growing! At Aveanna, were proud to foster a workplace culture that...