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

T1l0cU9ocmpBUnE4b3hPRWZEV3E5SC9VcEE9PQ==
  • 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

The Forehand Agency

Telesales and Service Agent - Work from Home Job at The Forehand Agency

 ...CRM software and other sales tools is preferred. Ability to work independently and collaboratively within a team in a fast-...  ...adapt to changing priorities and customer needs. Life and health insurance license, or the ability to obtain one. Benefits: Opportunity... 

CertaPro Painters

Painters and Carpenters Job at CertaPro Painters

 ...Painters- Professional painters and subcontractors needed in Capital Area for residential and commercial projects. We are looking for...  ...installation, deck construction, basic plumbing and electric, drywall, painting, door replacement, finish carpentry, etc. if this sounds like... 

Virginia Department of Human Resource Management

Housekeeping Workers - Nightshift and Evening Shift Job at Virginia Department of Human Resource Management

 ...Housekeeping Workers - Nightshift and Evening Shift James Madison University Facilities...  ...applications for full-time evening and night shift housekeeping workers. Applicants will...  ...: Perform regular and special cleaning of assigned areas using manual tools and... 

Whip

Front Desk Customer Service Advisor Job at Whip

 ...Burnie, MD DriveWhip is a mobility provider in the Washington, DC area, with offices in multiple cities that leases/rents vehicles to Uber, Lyft and other on-demand or rideshare drivers. As a ground floor member of an exciting new company all associates will be tasked... 

IQVIA

Oncology Hybrid Sales Specialist (Remote/Field) Job at IQVIA

 ...based in the United States is seeking a qualified Oncology Hybrid Sales Specialist. The role involves collaborating with Johnson and...  ...candidate will have at least 3 years of sales experience in pharmaceuticals and substantial abilities to communicate with key stakeholders...