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

Macpower Digital Assets Edge Private Limited

New York, NY

Apply

JOB DETAILS

SALARY

$55–$55 Per Hour

SKILLS

Analysis Skills, Automation, Best Practices, Change Control, Change Management, Cloud Computing, Communication Skills, Computer Science, Data Analysis, Data Management, Data Processing, Database Extract Transform and Load (ETL), Database Technology, Documentation, Git, Identify Issues, Information Technology & Information Systems, Linux Operating System, Linux Programming, Microsoft SQL Server, NCR Teradata, On Call, Oracle, Oracle Database, Oracle PL-SQL, Performance Metrics, Problem Solving Skills, Procedure Development, Process Improvement, Production Support, SQL (Structured Query Language), Scripting (Scripting Languages), Service Level Agreement (SLA), Software Engineering, Software as a Service (SaaS), Systems Administration/Management, Technical Support, Testing, Unix Shell Programming

LOCATION

New York, NY

POSTED

9 days ago

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).
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.

About the Company

Macpower Digital Assets Edge Private Limited

Resume Resources

Free Resume Templates Free Resume Builder